Garyon | SQLServerCentral

Garyon

Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

RE: Accidently Dropped SysAdmin accounts in SQL Express ... How do I get in now ...??

Joie Andrew (12/6/2009)
So what is the error message exactly that you are getting when you try and access the instance with the sa account? It could be that you are...

December 6, 2009 at 11:27 pm

#1088377
RE: Accidently Dropped SysAdmin accounts in SQL Express ... How do I get in now ...??

jymoorthy-1100764 (12/6/2009)
Did you try this to get sa account?
http://support.microsoft.com/kb/322336%5B/quote%5D
Yes ... the problem is that the SA is disabled and I don't know the password anyway. I think it...

December 6, 2009 at 4:40 pm

#1088306
RE: Accidently Dropped SysAdmin accounts in SQL Express ... How do I get in now ...??

homebrew01 (12/6/2009)
Are your databases backed up ?? You might have to re-install, or maybe you can recover them from your MASTER db backup ? Hold out for someone more...

December 6, 2009 at 10:13 am

#1088276
RE: Accidently Dropped SysAdmin accounts in SQL Express ... How do I get in now ...??

homebrew01 (12/6/2009)
Is the BUILTIN\Administrator login still there ? If so, and you are an admin, then you should be able to create new accounts and assign permissions.
Thank you for your...

December 6, 2009 at 9:50 am

#1088274

Viewing 4 posts - 1 through 4 (of 4 total)