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

analiafriAsked:
Who is Participating?
 
analiafriConnect With a Mentor Author Commented:
The solution was reinstalling the Sql Server 2005+SP2.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
do you try to operate from the server itself, or from a client station?
does the client station also have SP2 applied, in case?
0
 
analiafriAuthor Commented:
>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
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>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.
0
 
analiafriAuthor Commented:
I tried just now to create de job operating from de server itself and I received the same error message.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.