New Job Sql Server Agent error *FIXED*

I am running SQL Server 2005 and recently installed Office Sharepoint Server 2007 on the same server. After the install I receive the following error message while trying to add a new 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)

Also when I right click on a job to view properties a new job window pops up instead.

I realised that Office Sharepoint Server 2007 installs SQL Server Express and might me causing my issues. I uninstalled Sharepoint however I am still having the same problem.

Can anyone shed some light or have any suggestions?

Installing SP2 solved the problem.|||

I am having the same error when trying to create a job in SQLServer using SSIS package. The SSIS package does a very simple two steps ftp tasks: delete the existing file on the ftp server and copy the new one. Can somebody also share experience or idea on my case as well please.

Thanks

|||

I am have the same issue as Htin. I have run all Windows updates and I am running office 2007.

TITLE: Microsoft SQL Server Management Studio

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

BUTTONS:

OK

|||This problem seems to have been resolved by running the SQL Server SP2.|||

Hi I got the same error but after I install SP 2 for SQL 2005

Any idea how to resolve this problem ?:-)

|||I have succeeded in getting a job deployed but I accessed the Management Studio whilst on the Server so it looks like it's the tools not the server itself where the problem lies.|||I have SQL SERVER 2005 (SP2). I'm having the same problem. I upgraded the server via command prompt (c:/>setup SKUUPGRADE = 1). Still I'm having the same problem. Can any one tell me how to resolve this problem.