Enable SQL authentication in SQL Server

Case


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

Software


Sql Server 2005,2008

Tutorial


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