Wednesday, 16 June 2010

SQL Server 2005 Error When Creating SQL Agent Job

I am running SQL Server 2005 Workgroup Edition, I get the following error when creating a SQL Server Agent Job:
Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)
Not good!
The error can have a number of causes. Solutions include:
  1. Installing SQL Server 2005 SP2 (claimed by a number of individuals to work).
  2. If you are accessing the SQL Server across a network, logon to the server using remote desktop or similar and attempt to create the job locally.

No comments: