SQL Server Agent throws an error when I try to view/edit a job just created

Hi,

I've just installed SQL Server 2005 x64 bit on a W2K3 x64 bit server.

Some background: I had first installed the x32 bit version, but then removed it and reinstalled the x64 bit version. Along the way I had an insurmonutable problem of a complaint about the Microsoft.SQLServer.MSMQTask.dll which I eventually ignored before completing an otherwise trouble free install. Apparently, this file is related to Integration Services which we don't use anyway so assumed it was safe to ignore...

Anyway, everything is now running smoothly and the old databases are re-attached and all is fine. However, I just created a backup job and when I tried double clicking it in SQL Server Agent to have a look at what I'd done it came up with the following error:

-->Cannot show requested dialog. (SqlMgmt)
-->Enumerate Target Server Failed for Job 'Backup'. (Microsoft.SqlServer.Smo)
-->Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
-->An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
-->String or binary data would be truncated (Microsoft SQL Server, Error: 8152)

Any ideas? ....I'm told it isn't actually related to my earlier 'ignore' because this isn't related to Integration Servcies, but I've not seen this before.

Thanks loads
Iain
iaing1000Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

iaing1000Author Commented:
Just as an update...even though no-one has yet responded:

The scheduled job saved properly and is running properly, it is only the viewing of it through the SQL Server Agent in the Management Studio that is causing the problem.

Thanks
Iain
0
Brendt HessSenior DBACommented:
Does Event Viewer show any related entries?

Unfortunately, ignoring the MSMQ error was probably the wrong thing to do.  See the thread below for more information:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
0
Brendt HessSenior DBACommented:
Note that someone with essentially the same issue needed to reinstall SQL Server 2005:

http://www.sqlservercentral.com/Forums/Topic351861-149-1.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

iaing1000Author Commented:
Hi,

Just got back from holiday, so just looking at this again.

Weirdly the backups are still taking, so it's not a concern as yet, just puzzled really as to what exactly is going on...I imagine it's something to do with the front end in Management Studio (will try viewing the jobs remotely through a remotely installed Mgmt Studio to confirm this).

Will report back soon on the Event Viewer entries when I get a chance.

Thanks
Iain
0
iaing1000Author Commented:
Hi,

I've not yet been able to check whether or not it's the Management Studio that's causing the error. Will report back soon enough though,

Thanks
Iain
0
iaing1000Author Commented:
Hi,

I've still not yet had a chance to check whether or not it's the Management Studio that's causing the error.

Haven't forgotten and will hopefully return to it next week...you know how it is with moving from one project to the next!

Thanks
Iain
0
iaing1000Author Commented:
Hi,

Looks like I shan't be able to address this for the time being.  In that case I'll try and close it...if I ever pick all this stuff up again I'll put a post up with the question again.

Thanks to those who've already offered some help, of course.

Cheers
Iain
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.

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.