June 22, 2002 at 2:35 pm
I was copying db from 7 to 2000 and have now lost my connection to my sql 7 server. The errors says it can't find the default db and connection failed. I've tried to edit the server registration, stopping and restarting services and creating a new registration - nothing is working.
Any other ideas? Please help.
thanks.
June 22, 2002 at 5:22 pm
If you're using the copy db wizard and it fails, you could have wound up with the db not being reattached. If you go to the actual server, can you connect to SQL there?
Andy
June 22, 2002 at 9:42 pm
No, I still can't connect at the server. I can see the db .mdf and .ldf files in the mssql\data folder so I think my db are still there but the one it is looking for to authenticate is missing or corrupt.
June 23, 2002 at 5:38 am
Couple more questions. The service is running without problem/error? You say you can see the mdf/ldf, but you can see the database listed in Enterprise Manager?
Andy
June 23, 2002 at 8:35 am
Well when I look through the explorer I can see the files listed. It's when I open up SQL and try to connect to the server that I get the error Cannot open user default database <ID>. Using master instead. And the connection fails.
June 23, 2002 at 9:18 am
Open it up in what though? If you're opening from an application and the db is not attached to SQL, you'll get the error - which makes sense since the login has a default db pointing to something that is missing.
Connect to SQL using Enterprise Manager with an account that has SysAdmin rights - if you don't see the db you are trying to use, you'll need to reattach it. Seeing it via Explorer means it's there, just have to get it attached.
Andy
June 23, 2002 at 10:04 am
My account is included as a sysadmin so I think I would be accessing the dbs. Would I need to restore the master?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply