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 |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2009-11-09 : 06:00:47
|
| when setting up my home developer edition. I choose windows authentication instead of mixed. So could someone tell if the SA login has a default password pleaseRegardsRobMCTS certified |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-09 : 06:49:21
|
Go to the PC where you have installed the developer edition.As an Admin on that PC connect to the SQL Server via Windows Authentication.Login as SA with Password is not possible in Windows Authentication and no - there is no default password.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2009-11-09 : 07:31:21
|
| are you sure you even entered a password or did you leave it blank-----------------------------------------------Learning something new on SQL Server everyday. |
|
|
|
masterdineen
Aged Yak Warrior
550 Posts |
Posted - 2009-11-09 : 10:05:27
|
| Well i have gone through all the passwords that i may of used. So i was just wondering that if there is a default sa password when changing back to mixed authentication. But i am going to reinstall a new instance as it is for learning purposes only. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-09 : 10:35:27
|
| look at WebFred's answer above. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2009-11-11 : 08:57:29
|
| HiFirst understand one thing. sa is sql user. you selected windows authentication mode. so you can not connect using SA.if you want to connect as SA, then go to server properties in SSMS, then right click, there change it to mixed mode, then provide SA password. then you will be all set.ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
sa login problem