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 |
|
ann06
Posting Yak Master
171 Posts |
 Posted - 2008-06-04 : 08:33:37
|
| Hi there,i have a test sql server. personal Edition Sp2. i loggoed on with a domain account that is part of local admin group. i was surprised when i found that i don't have enough access to work on the database like create and restore databasesi tried to log on with sa but password not succeeded i don't remember that i had changed the password or put a difficult one.i also tried from the local administrator i also couldn't get the permission !!what could gone wrong ? thanks god its only a test server :S |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-04 : 13:26:27
|
| If you can't login with an account that has local administrator permissions, then someone must've removed the sysadmin role from the BUILTIN\Administrators group. If you can't get in with sa, then you are out of luck. I'd grab my backups and restore those after the reinstall.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-06-04 : 13:28:37
|
Which error did you get when trying to login with SA account?Have the mixed mode changed to authenticated users only?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-06-04 : 14:58:52
|
| is this SQL Server 2000 or SQL Server 2005?CODO ERGO SUM |
|
|
|
|
|
|
SA password is not working and local admin. can't