Thursday, September 3, 2009

Error message when you connect to an instance of SQL Server: "Cannot open user default database"

Solution : 1

1- Go to database server -> security->login->username
2- Go to user property page and assign respective database or go to user role tab and give sysadmin permission to the user.


refer -

No comments:

Shared Button