Enable SQL authentication in SQL Server


 If u installed SQL Server with Window authentication and decided to change authentication method to SQL authentication or both.


Sql Server 2005,2008


1,Connect SQL Server by Windows Authentication method
2,On Object Explorer Click Security

3,Right Click on Login click new login
4,Enter Username & password

5,User Creation done,Enable SQL Authentication by Right click on SQL Instance

6,Select Security tab and select SQL Server and Windows authentication mode

7,Restart SQL Server service or restart computer to take effect

No comments:

^ Top