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 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy