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 |
|
pras2007
Posting Yak Master
216 Posts |
 Posted - 2008-12-20 : 09:59:55
|
| I installed SQL Server 2005 using Windows Authentication Mode (Windows Authentication)" How can I change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication)" after installation?I tried to change it but I’m getting this error:Operation is not valid due to the current state of the object. (SqlManagerUI)Does anyone know how to solve this problem? Please advice.Thanks. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-20 : 10:03:45
|
| Go to server property-security-mixed mode |
 |
|
|
pras2007
Posting Yak Master
216 Posts |
Posted - 2008-12-20 : 13:27:54
|
| thanks for the quick response sodeep, but that's is the step giving me the error mentioned eariler. Does anyone know how to resolve this issue? thanks. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
How to change The Authentication Mode of the SQL S