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 |
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2007-05-21 : 05:49:38
|
Hi,Assume that i lost my sa password and also i did'nt even turned on Windows Authentication.Then is there any way to access the databases on that server.Regards,frank |
|
X002548
Not Just a Number
15586 Posts |
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-21 : 10:26:26
|
Windows authentication is always on. |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-21 : 10:27:42
|
Login as another user who has an SA-equivalent role"i did'nt even turned on Windows Authentication"Does that matter? A Windows Administrator [on the Server itself] will still be able to get in to SQL Server - unless the Admin role has been explicitly deleted, won't they?Or Reinstall SQL Server, and restore the databases from backup (presumably NOT included MASTER!)That's presuming that this question isn't: And how would my friend automated this for ALL the web sites he "looks after" Kristen |
|
|
|
|
|