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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2007-11-14 : 10:34:48
|
| Change the Authentication Mode of the SQL server from "Windows Authentication Mode (Windows Authentication)" to "Mixed Mode (Windows Authentication and SQL Server Authentication)". How do I do this? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-14 : 11:09:27
|
Use SSMS? Maybe Properties fir the database, and then maybe Security tab?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-14 : 23:17:22
|
| With server properties in ssms. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-27 : 09:06:34
|
As PESO states it is in the security tab after you right click the server name and go to properties in SSMS. The actual field name is not mixed mode though, it is SQL Server and Windows authentication mode.
Future guru in the making. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-28 : 02:28:14
|
| Can modify registry as well. |
|
|
|
|
|
|
how do I change the authentication mode?