July 28, 2008 at 8:54 am
I am using SQL Server 2005 SP2 on Windows Server 2003. Whenever I try and Create and then schedule a Maintenance Plan I get the follwoign error pop up.
"Method not found: 'Boolean Microsoft.SqlServer.Management.SqlMgmt.JobScheduleData.UpdateSourceSchedule()'."
If I try and create a Maintenance Plan via the Wizard I get. The Following Error Message.
Method not found: 'Void Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. (Microsoft.SqlServer.Management.MaintenancePlanWizard)
July 28, 2008 at 9:53 am
You'd have to use firewalls/routers to handle this at a network level. I'm not sure that SQL Server can do anything here. hostname/IP can be easily spoofed.
July 28, 2008 at 9:53 am
Please don't cross post.
Discussed here: http://www.sqlservercentral.com/Forums/Topic541955-146-1.aspx
July 28, 2008 at 10:54 am
SQL 2005 uses integration services in the background to perform these plans. This error is caused by an installation problem. You can check the install logs to see exactly where the problem was. For example C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\summary.txt or C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files. The problem could be in SSMS itself. Try running from a different machine to check. I hope this helps.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply