MSSQL: Enable Mixed Mode Authentication

Q. How do I enable mixed mode authentication under MS-SQL running on Microsoft Windows server 2003?

A. You can easily enable mixed mode authentication as follows:

First, login to your server (use Remote Desktop Connection for remote boxes)

Click on Start > Programs > Microsoft SQL Server 2005
Select "SQL Server Management Studio Express" / "SQL Server Management Studio", depending on your version of SQL Server.

Next, enter the requested information:
=> Server Type: select "Database Engine".
=> Server Name: Select default displayed values
=> Authentication: select "Windows Authentication".
Click "Connect".

Right click the server name and select "Properties".

Click "Security".

Under "Server authentication" select "SQL Server and Windows Authentication Mode".

Click "OK".

Right click the server name and select "Restart". Wait a few moments for the service to restart before proceeding.

• Tweet
• 
• 

You should follow me on twitter here or grab rss feed to keep track of new changes.

Featured Articles:

• 30 Handy Bash Shell Aliases For Linux / Unix / Mac OS X
• Top 30 Nmap Command Examples For Sys/Network Admins
• 25 PHP Security Best Practices For Sys Admins
• 20 Linux System Monitoring Tools Every SysAdmin Should Know
• 20 Linux Server Hardening Security Tips
• Linux: 20 Iptables Examples For New SysAdmins
• Top 20 OpenSSH Server Best Security Practices
• Top 20 Nginx WebServer Best Security Practices
• 20 Examples: Make Sure Unix / Linux Configuration Files Are Free From Syntax Errors
• 15 Greatest Open Source Terminal Applications Of 2012
• My 10 UNIX Command Line Mistakes
• Top 10 Open Source Web-Based Project Management Software
• Top 5 Email Client For Linux, Mac OS X, and Windows Users
• The Novice Guide To Buying A Linux Laptop