-
Hello,
Please, anyone - I'm in deep #%^ here!!
I have a sql db which I had to backup and upload to my web hosts in order for them to restore. They said I should delete all my log-in's before I do the backup. Now, without looking(thinking!!!!) I deleted the SERVER logins instead of my specific DB's logins. Now I cannot access my db AT ALL. Neither can I create a new login or do anything for that matter!!!
So I open sql server, click on the SQL Server group node - it opens showing me all the registered servers, but when I click on my servers node I get the error..
"could not establish connection to TESTING - login failed for user tester.
Testing is my server I registered and tester is the login!!
Please!!!! I dont know what to do - I cannot lose all my data.
I did make a backup of my db. I tried restoring it in the hopes that my logins will be restored too - but nothing!!
T
-
You should be able to get in as sa system administrator. See you DB administrator to create a login for you so you can get back to your data.
Failing that (you are the DBA!), then I'd reinstall SQL server and create your own sa account.
:cool:Good luck:cool:
-
Thanks Jerry,
I'm going for the reinstal option!!
If this does not work....................then I dont know!!
T
