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.


🐧 Get the latest tutorials on Linux, Open Source & DevOps via RSS feed or Weekly email newsletter.

🐧 0 comments... add one


CategoryList of Unix and Linux commands
Disk space analyzersdf duf ncdu pydf
File Managementcat cp mkdir tree
FirewallAlpine Awall CentOS 8 OpenSUSE RHEL 8 Ubuntu 16.04 Ubuntu 18.04 Ubuntu 20.04
Modern utilitiesbat exa
Network UtilitiesNetHogs dig host ip nmap
OpenVPNCentOS 7 CentOS 8 Debian 10 Debian 8/9 Ubuntu 18.04 Ubuntu 20.04
Package Managerapk apt
Processes Managementbg chroot cron disown fg glances gtop jobs killall kill pidof pstree pwdx time vtop
Searchingag grep whereis which
User Informationgroups id lastcomm last lid/libuser-lid logname members users whoami who w
WireGuard VPNAlpine CentOS 8 Debian 10 Firewall Ubuntu 20.04
0 comments… add one

Leave a Reply

Your email address will not be published.

Use HTML <pre>...</pre> for code samples. Still have questions? Post it on our forum