Solved

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

Posted on 2008-10-22
8
531 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:bhess1
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:
bhess1 earned 500 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
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Not selecting duplicate data 6 66
Move SQL 2005 Express to Server 2012R2 19 169
Strange msg in the SSMS pane 13 60
Need help debbuging stored procedure 21 48
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…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

730 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