?
Solved

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

Posted on 2008-10-22
8
Medium Priority
?
537 Views
Last Modified: 2012-05-05
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
0
Comment
Question by:iaing1000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 2
8 Comments
 

Author Comment

by:iaing1000
ID: 22791780
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
 
LVL 32

Expert Comment

by:Brendt Hess
ID: 22838547
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
 
LVL 32

Accepted Solution

by:
Brendt Hess earned 2000 total points
ID: 22838554
Note that someone with essentially the same issue needed to reinstall SQL Server 2005:

http://www.sqlservercentral.com/Forums/Topic351861-149-1.aspx
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:iaing1000
ID: 22866711
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
 

Author Comment

by:iaing1000
ID: 22893509
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
 

Author Comment

by:iaing1000
ID: 22948230
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
 

Author Comment

by:iaing1000
ID: 23147566
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

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

762 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