February 3, 2006 at 10:36 pm
i have installed ms sql server 2000, with mixed mode authentication, when i am restoring database its giving error
microsoft sql-dmo(odbc sqlstate:42000)
i will appreciate if someone can provide solution on this asap.
February 4, 2006 at 6:40 am
Are you restoring through the enterprise manager or query analyzer or ...?
Sql dmo errors can spring up when the servicepack level of the client tools mismatches the server servicepack level.
February 6, 2006 at 2:25 pm
Best bet is to try restoring the database in Query Analyzer:
RESTORE DATABASE <dbname> FROM FILE='<filename>'
This will give you the most detailed error message for troubleshooting.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply