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 |
|
AnotherBob
Starting Member
2 Posts |
 Posted - 2007-12-21 : 15:50:39
|
| Hello,I am running SQL Server Express 2005 on Vista.I can currently log in through Management Studio using Windows Authentication. I want to login using my sa account (which exists) and a password, and eventually be able to do role based security for additional users.How can I set this up?Thanks,Bob |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-21 : 18:01:55
|
| Enable mixed authentication in server properties in ssmse. |
 |
|
|
AnotherBob
Starting Member
2 Posts |
Posted - 2007-12-21 : 22:23:40
|
| Sweet. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-21 : 22:58:12
|
| You shouldn't be using the sa account for anything for security reasons. Use your Windows account and make sure it has sysadmin so that you can perform sa stuff.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
SQL Server Authentication