?
Solved

SQL2005 SP2 error when attempting to create a job

Posted on 2007-10-17
7
Medium Priority
?
286 Views
Last Modified: 2008-09-21
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

0
Comment
Question by:analiafri
  • 3
  • 3
6 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20098949
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
 

Author Comment

by:analiafri
ID: 20099475
>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
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20099578
>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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:analiafri
ID: 20100004
I tried just now to create de job operating from de server itself and I received the same error message.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20100634
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
 

Accepted Solution

by:
analiafri earned 0 total points
ID: 22488324
The solution was reinstalling the Sql Server 2005+SP2.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question