Configure MS SQL Server 2005 Remote Access ( mixed mode )

MS SQL Server 2005 remote access configuration is different from MS SQL Server 2000. Remote access to MS SQL Server 2005 with user and password is required and necessary for any database applications. If MS SQL Server 2005 is originally configured for windows authentication, configuration for remote access ( mixed mode or SQL Server authentication ) needs a little more extra work to get it done.

Here is how to get this done.

1. Configuration in SQL Server Management Studio

Click “All Programs” -> Click “Microsoft SQL Server 2005” -> click “Microsoft SQL Server Management Studio”

Log in to SQL Server 2005 with windows authentication or sa user;

Highlight the server and right click “Properties”;

Highlight “Security” -> Under “Server authentication”, choose “SQL Server and Windows authentication mode”;

Highlight “Connections” -> Under “Remote server connections”, choose “Allow remote connections to this server”;

Click OK to save the settings.

2. Configuration in SQL Server Surface Area Configuration

Click “All Programs” -> Click “Microsoft SQL Server 2005” -> click “Configuration Tools” -> click “SQL Server 2005 Surface Area Configuration”

Click “Surface Area Configuration for Services and Connections” -> click “MSSQLSERVER” -> click “Database engine” -> click “Remote connections ” -> Under “Local and remote connections”, choose “Using TCP/IP only” or other protocols.

Click “Apply” to save the settings.

3. Stop SQL server and restart SQL server

Use “SQL Server Management Studio” or Services in Control Panel to stop SQL Server and then restart the SQL Server. This process is used to initialize the change settings.

4. Test the changes

a. Create the user through “Security” -> “Logins” -> “New Logins…”

b. log in with the newly created user when “Authentication” is “SQL Server authentication” under local SQL server or under remote SQL server.

3 phản hồi to “Configure MS SQL Server 2005 Remote Access ( mixed mode )”

  1. Rahul Says:

    Excellent article. Very good knowledge sharing. Thanks for same.

  2. mikado Says:

    Bạn ơi muốn chỉnh password cho sql thì làm thế nào hả bạn


Gửi phản hồi

Mời bạn điền thông tin vào ô dưới đây hoặc kích vào một biểu tượng để đăng nhập:

WordPress.com Logo

Bạn đang bình luận bằng tài khoản WordPress.com Log Out / Thay đổi )

Twitter picture

Bạn đang bình luận bằng tài khoản Twitter Log Out / Thay đổi )

Facebook photo

Bạn đang bình luận bằng tài khoản Facebook Log Out / Thay đổi )

Google+ photo

Bạn đang bình luận bằng tài khoản Google+ Log Out / Thay đổi )

Connecting to %s

%d bloggers like this: