SQL Server gurus - PLEASE!!! Big Trouble!!!!

[turfbult]

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

[Jerry Grant]

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:

[turfbult]

Thanks Jerry,

I'm going for the reinstal option!!

If this does not work....................then I dont know!!

T