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.

Solution-2

refer - http://support.microsoft.com/?id=307864