Hi everybody,
Recently I bought a notebook for developement purpose. I installed SQL Server 2000 as development database server. However, once I expand a database server, an error is reported - "Cannot open user default database. Login Failed.". How can I solve the problem without reinstalling the SQL server?
(Background: Initially there is no error. I created a new database and a new login in the beginning. Then I created a new user of this database and this login. However, when I assigned access rights of this database to this user, the system forced to change the user name as dbo instead of this user name. Then I removed this database and wanted to create this database again ... but this error occur at once.)
I need your help.
Regards.
Recently I bought a notebook for developement purpose. I installed SQL Server 2000 as development database server. However, once I expand a database server, an error is reported - "Cannot open user default database. Login Failed.". How can I solve the problem without reinstalling the SQL server?
(Background: Initially there is no error. I created a new database and a new login in the beginning. Then I created a new user of this database and this login. However, when I assigned access rights of this database to this user, the system forced to change the user name as dbo instead of this user name. Then I removed this database and wanted to create this database again ... but this error occur at once.)
I need your help.
Regards.