April 6, 2010 at 5:42 pm
I installed SP3 for SQL2005 on a clients server and when I try to create maintenance plan through the wizard I get the following error "Could not load type 'Microsoft.Sqlserver.Management.SMO.Agent.JobBaseCollection' from assembly 'Microsoft.SqlServer.Smo,Version=9.0.242.0, Culture=neurtral, PublicKeyToken=89845dcd8080cc91'. (Microsoft.SqlServer.MaintenancePlanTasks).
From what I have seen, the version still says SQL Server 9.0.1399 under the Object Explorer.
Any help would be appreciated.
April 6, 2010 at 8:13 pm
If object explorer is showing you that version - and you have disconnected and reconnected, then you did not upgrade the server. You only upgraded the client components.
The server is at RTM version (9.00.1399) - and client tools that have been upgraded to any version after SP2 will not be able to edit maintenance plans on that version. There were significant changes made to maintenance plans in SP2.
You need to either upgrade the server to SP3 and verify the client tools are upgraded to that version, or remote into the server and use the client tools on the server.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
April 7, 2010 at 9:57 am
Thanks for the post. I will try that.
April 9, 2010 at 10:15 am
How do I update the client tools on sql server 2005? Would I need to run the SP3 again and just install that?
April 9, 2010 at 1:42 pm
Yes, that's all you should need to do.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply