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 |
|
varalakshmi
Yak Posting Veteran
98 Posts |
 Posted - 2008-06-20 : 02:35:07
|
| Hi,I have created one login with windows authentication.after that i have deleted the built-in-administrator login.now i am not able to login thru windows authentication mode.how to rectify it..i have tried to create one new login with windows authentication mode..still i am not able to connect thru windows authentication. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-20 : 13:37:26
|
| When you created the account, did you grant it sysadmin?Have you tried logging in with the sa account? Or any other account that has sysadmin?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-20 : 16:48:20
|
| Do you SA's password or else did any windows a/c has SA permission on the server?ManojMCP, MCTS |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-20 : 16:49:29
|
| If you have SA password then Connect thru SA and grant windows login to SA permission and your are safe to go with your windows login.ManojMCP, MCTS |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-20 : 16:49:49
|
quote:
Originally posted by mdubey
Do you SA's password or else did any windows a/c has SA permission on the server?
Didn't I ask this already?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-20 : 17:03:39
|
mdubey has done this several times before. I think he just wants to bump his postcount.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Removing Built-in-Administrator