Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vedjha
Posting Yak Master
228 Posts |
 Posted - 2009-02-07 : 03:54:03
|
| Hello all, i have install Sql in Windows AuthenticationHow can i Switch Windows Authentication to Sql AuthenticationVed Prakash Jha |
|
|
chandu123
Starting Member
11 Posts |
Posted - 2009-02-07 : 04:03:46
|
| Hi when u first open sql server you have two options like which type of authentication you can use you can choose between windows and sqlserver authentication.When you are installing sql server you must select the option like mixed mode. |
 |
|
|
vedjha
Posting Yak Master
228 Posts |
Posted - 2009-02-07 : 04:46:02
|
| I have installed sql2005 in Windows Authentication modeis there any way to enable my sql Authentication...Ved Prakash Jha |
|
|
|
chandu123
Starting Member
11 Posts |
Posted - 2009-02-07 : 05:22:13
|
| Ok then do this login with windows authentication mode and right click on the current server and go to properties click on security node modify server authentication and click ok hope this help. |
|
|
|
|
|
|
Windows Authentication to Sql Authentication