September 25, 2007 at 1:33 pm
I successfully installed sql 2005 and restored my databases. My databases seem to be functioning just fine ( I use them with Microsoft Dynamics SL and am getting no errors). However when I try to create a maintenance plan (from scratch or using the wizard), I cannot see my databases. The only things that appear are Master, Model, MSDB, ReportServer$SQL2005, and ReportServer$SQL2005TempDB. I have tried detaching and attaching my db's. Uinstalled and reinstalled sql. Nothing seems to work. Can anyone help?
Ryan
Ryan Grant
Financial Systems Consultant
Elypsis, Inc
ryan@elypsis.com
September 25, 2007 at 2:15 pm
Can you see the databases in object explorer? Have you looked for orphaned users?
EXEC sp_change_users_login 'Report' --to check for orphaned users
September 25, 2007 at 2:21 pm
I got no results when I ran your script for all 3 of my databases. Yes I can see the databases in Object Explorer. I can run scripts or anything else I want to do...except for back them up with a maintenance plan. I can run a maual backup if I want to.
Ryan Grant
Financial Systems Consultant
Elypsis, Inc
ryan@elypsis.com
September 25, 2007 at 3:05 pm
I found my problem. My compatibility level was set to 70. I have corrected it and it works. Thanks for your help.
Ryan Grant
Financial Systems Consultant
Elypsis, Inc
ryan@elypsis.com
September 25, 2007 at 4:00 pm
Well, I can see where that would be an issue.
Any idea how the compat level got set to 70?
December 7, 2016 at 7:08 am
Old tip still valuable, thanks.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply