Posted by Erland Sommarskog on 08/21/06 22:10

microsoft . public . sqlserver (dpk.sinha@gmail.com) writes:
> I am using SQL server 7.0. After restoring all the databses (Except
> distribution) Everything seems to be working fine except the backup
> maintenance plan. I put following detail in the maintenance plan
>...
> Problem:
> My databases(mroduction as well as systems) sre not at all getting
> backed up according to above plan.
> Error Message in the Log Directory:
> "Microsoft (R) SQLMaint Utility (Unicode), Version [Microsoft SQL-DMO
> (ODBC SQLState: 42000)] Error 4062: [Microsoft][ODBC SQL Server
> Driver][SQL Server]Cannot open user default database '<ID>'. Using
> master database instead."
>
> In the SQL server registration properties the login through which
> getting logged into the EM for that, default database is "my production
> database".
>
> Is this problem because of the distribution db which I am not able to
> restore.

It's unclear what you restored from, but if the databases originates on
a different server, you typically have a matching problem between database
users and logins. The default for this login may be a database that exists,
but he may not be valid user of that database.

Running sp_helpuser in the database in question can show if you have
this problem. If username and logins are just randomly correlated,
then you need to remap with sp_change_users_login. See Books Online
for details.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]