Goto MS SQL Server Management Studio ->Connect Database -> Right click on Server Name choose Properties -> In the Server Properties screen ->Under Security Tab on left side -> select Radio Button SQL Server and Windows Authentication(Mixed Mode) -> Just Say OK. Like the below Screenshot. This allows to go for any of two authentications. 1)Windows Authentication. 2)SQL Server Authentication.
Sunday, December 5, 2010
SQL Server 2005 Mixed Authentication Enabling
At the time of MS SQL Server 2005 installation, if you forgot/not set mixed mode for the authentication. You can set it after completion of installation.
Goto MS SQL Server Management Studio ->Connect Database -> Right click on Server Name choose Properties -> In the Server Properties screen ->Under Security Tab on left side -> select Radio Button SQL Server and Windows Authentication(Mixed Mode) -> Just Say OK. Like the below Screenshot. This allows to go for any of two authentications. 1)Windows Authentication. 2)SQL Server Authentication.
Goto MS SQL Server Management Studio ->Connect Database -> Right click on Server Name choose Properties -> In the Server Properties screen ->Under Security Tab on left side -> select Radio Button SQL Server and Windows Authentication(Mixed Mode) -> Just Say OK. Like the below Screenshot. This allows to go for any of two authentications. 1)Windows Authentication. 2)SQL Server Authentication.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment