Click here to Skip to main content
13,832,393 members
Click here to Skip to main content
Add your own
alternative version


34 bookmarked
Posted 13 Oct 2006

Configure MS SQL Server 2005 Remote Access ( mixed mode )

, 13 Oct 2006
Rate this:
Please Sign up or sign in to vote.
Configure MS SQL Server 2005 Remote Access ( mixed mode )
<!-- Article Starts - DO NOT ADD HTML/BODY START TAGS-->

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.

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> 

1. Configuration in SQL Server Management Studio<o:p>


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<o:p>

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<o:p>

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<o:p>

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.


If you have any questions or suggestions, please email me at


Happy SQLing!


- Hongwei Li


This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here


About the Author
Software Developer (Senior)
United States United States
C# and .NET Core
Typescript, node.js, jQuery, jQuery Mobile
Web Api and MVC
Angular and AngularJS
Databases (SQL Server and Oracle) and No-SQL Databases
Agile and Waterfall

You may also be interested in...

Comments and Discussions

Generalthank you very much Pin
mike2rich21-Mar-09 0:37
membermike2rich21-Mar-09 0:37 
GeneralWorked for me as well Pin
wyzec7-May-08 2:41
memberwyzec7-May-08 2:41 
GeneralThank u very much... Pin
Member 39943614-May-08 5:03
memberMember 39943614-May-08 5:03 
GeneralThanks! Pin
UnRusoDeCaracas14-Feb-07 19:10
memberUnRusoDeCaracas14-Feb-07 19:10 
GeneralamGood tip Pin
harinath29-Nov-06 20:50
professionalharinath29-Nov-06 20:50 
Generalgr8 Pin
Vipin.d21-Nov-06 2:39
memberVipin.d21-Nov-06 2:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Cookies | Terms of Use | Mobile
Web05 | 2.8.190114.1 | Last Updated 13 Oct 2006
Article Copyright 2006 by
Everything else Copyright © CodeProject, 1999-2019
Layout: fixed | fluid