asked on

SQL2005 SP2 error when attempting to create a job

After installing SP2 on SQL Server 2005 I am getting this error when attempting to create a job for backing up the database, with management studio:

Unable to cast object of type
'Microsoft.SqlServer.Managment.smo.SimpleObjectKey' to type
'Microsoft.SqlServer.Managment.smo.Agent.JobObjectKey'. (Microsoft
SqlServer.smo)
Has anyone knows the solution or a workarround?
Tks,

Analía

Guy Hengel [angelIII / a3]

do you try to operate from the server itself, or from a client station?
does the client station also have SP2 applied, in case?

analiafri

ASKER

>do you try to operate from the server itself, or from a client station?
>does the client station also have SP2 applied, in case?

I'm trying to operate from the server via Terminal Server.

Analía

Guy Hengel [angelIII / a3]

>I'm trying to operate from the server via Terminal Server.
does that mean that the sql server IS also terminal server?
-> did you apply the sp2 being on a console session?
if not, do so

or does the terminal server have only the client tools?
-> if yes, apply the sp2 ALSO on the terminal server, and reboot the server.

analiafri

ASKER

I tried just now to create de job operating from de server itself and I received the same error message.

Guy Hengel [angelIII / a3]

Then, I do not know what the problem could be...
you might try to reapply the SP2 (btw, can you describe the steps you performed to apply SP2?)
otherwise, you will need to contact MS directly (in case you have a support contract)

ASKER CERTIFIED SOLUTION

analiafri

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial