Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
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
?
539 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
7 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

581 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