Deleted user default database - SQL Server 2008
- by RadiantHex
Hi folks,
I cannot connect to the database anymore, I'm getting:
Cannot open user default database. Login failed.
I have deleted the database during a previous session and then tried to recreate it. But the recreate failed.
Now I am stuck with this error, what can I do?
Edit: I'm using Windows Authentication
Any ideas?
Fixed:
use the…