Friday, September 3, 2010

How to enable Sql server Authenticaton in Sql server

Usually, when you install SQL Server, select the option to use Windows Authentication mode to connect to SQL Server. But for some scenarios we need for a user authentication to access SQL Server databases. How to change? Here are the steps to enable SQL Server Authentication to SQL Server.
1 Log in to SQL Server using Windows authentication.
2. Right click on the server (name of your SQL server), select Properties.
3. In section, select a page, select Security and Authentication section select the
radio buttonserver SQL Server and Windows Authentication mode, and click OK.
4. After the changes saved, then go to security - users - add a user for SQL
5. He needs to reboot the server to reflect the changes.

No comments:

Post a Comment