I have SQL Server 2008 R2 running on a virtual machine (vmware, Windows Server 2008 R2). I was connected to the SQL Server from another virtual machine via SQL Server Management Studio, then a power failure occurred.
After powering everything back on, my problem is that now I can't connect to the SQL Server using the same account as before (from Management Studio), nor can I remote desktop/login to the VM using this account. I get "server not found/not accessible" error in SQL Server Management Studio, and if try to connect to the VM using remote desktop, the error displayed when trying to log in is:
"There are currently no logon servers available to service the logon request"
However, the VM/server is running (as indicated in the hyperv), I can connect (remote desktop) to it using another account and I can connect to the SQL Server using this account from Management Studio. Rebooting the VM, turning it off and on etc. doesn't help.
Any ideas what can be done would be appreciated.