Pages

Thursday, July 21, 2011

How to Change Login Mode In SQL Server 2005

Views

In Sql server you can login in two mode:
1. Windows Authentication
2. Sql Server Authentication
But you can only access SQL Server in both way by default if you only have selected both the login option when you install the SQL server.
But, If you forgot to select both the option while installing the SQL server, you can edit the option in following way:

1. Right Click on Server instances and view the Properties
image
2. Form the Property window and list at the left select the “Security” tab:
3. Select the option indicating both the login mode and Click OK.
4. Cheers!! :)
image

0 comments:

Post a Comment

 

Web Design Company karimnagar, Web Designing warangal, Logo Design Company nizamabad, Indian Website Design Company, maddysoft.co.in