May 24, 2007 at 2:46 pm
Hi,
Lost all logins on a server and sa account is disabled on that database server. Is there a way to connect to this database server ?
The service account is able to start/run without any issues.
Any help is greatly appreciated.
Thanks.
May 24, 2007 at 3:08 pm
Does BUILTEN\Administrators still have access? If the service starts up OK under the service account can you RDP into the box under this account and connect?
Tommy
Follow @sqlscribeMay 24, 2007 at 3:21 pm
That was a scary moment. I was able to enable sa. The problem happened when I was trying to create a SSIS package that dropped all logins. Can someone point to a good SSIS basic tutorial.
Thank you all.
May 24, 2007 at 3:24 pm
Check out http://www.sqlis.com - they often have some good examples/tutorials.
Tommy
Follow @sqlscribeViewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply