Solved

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

Posted on 2008-10-22
8
529 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
  • 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to check data in sql table 11 47
SQL Agent Timeout 5 57
Upgrading SQL 2005 Express to 2008 R2 Express 31 86
Replace Dates in query 14 38
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
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.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now