Is there anyway to get in the server and recreate them?
views:
332answers:
2
+3
A:
You'll have to reinstall the server as there is no "grip" available to run anything to restore the accounts or create new ones.
Since you can't backup your databases either (again, no way to get there from here) you'll want to stop the SQL Server service (MSSQLSERVER) in the Services panel so that it releases its exclusive lock on your database files. Next, navigate to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data and copy all of the MDF and LDF files to a safe spot.
Next, uninstall and re-install SQL Server (you may be able to just reinstall). Once you are up and running again, copy the MDF/LDF files back (NOT the model, msdb or master databases!! Just the ones that YOU have created) and "attach" them in a SQL window. You'll do all of this with the Windows integrated account.
Mark Brittingham
2009-06-10 01:59:37
will system restore be able to resolve it?
Shimmy
2009-06-10 02:04:31
Shimmy - I don't think so but, honestly, I wouldn't trust it. In fact, it is likely that system restore will be more trouble than the solution provided! Once you do it, I think you'll find it is pretty straightforward.
Mark Brittingham
2009-06-10 02:22:42
I think it should work and even trustable.In my particular nutcase, as I said above, I had to resinstall the entire OS.
Shimmy
2009-06-10 07:53:19
Good luck shimmy...I didn't realize that you had to reinstall the entire OS.
Mark Brittingham
2009-06-10 15:38:32
A:
Does the surface area configuration tool still work? If so you could attempt to use that to add another admin to the instance.
David McEwing
2009-06-10 02:03:55