Monday, March 19, 2012

cannot create jobs on x64

Hi all,
Just installed sql 2005 x64 (DB Server + Client Tools incl. management tools) on a win2003 x64 server and encountered the following problems:

1) Could not create jobs
Getting Error:

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

- Tried several different job types, always same result.
- Installing SP1 does not help.
- Installing with or without Integration Service does not help.

Any help is highly appreciated

TIA
Dan

Just as a checkup, have you installed SQLExpress before on thsi machine?

refer to KBA http://support.microsoft.com/kb/922214 for more information.

|||

No express installation before.

TIA
acki

|||

Just as a little add on.

I cannot create the jobs in management console.
If I create a job by script, job shows up under SQL Server Agent / Jobs but detail view of job contains no data (no jobsteps, no schedule, no name)

If I check jobdeails in detailed Activity Monitor view all looks fine ?

Please advice

acki

|||Check here http://connect.microsoft.com/ whether this has been reported, if not I suggest to report for a fix.|||Anyone learn anything on this? I have the same problems after installing the SQL Server 2005 Service Pack 2 for XP (SQLServer2005SP2-KB921896-x86-ENU.exe)?|||

gfay

I just got this realy helpful comment on a feedback I supplied to Microsoft:

"Thanks for letting us know about the problems you faced making agent jobs.

Because the problems are in the original setup, there is no way for us to address them in a service pack. I have, however, added this issue to the work items for our next major release. "

|||

Hi Guys

We succeded create job remotly (from another computer 32 bit SQL (x86))

but when you open it from x64 edition you cannot see the steps

|||Thanks (acki4711) for the info!
|||had same problem on x86 version. Reapplying SP2 to client tools on the server was the solution for me.|||

Make sure the client and server are up to date with all patches (especially if you're on SP2) and are at the same version level.

No comments:

Post a Comment