SQL Server Agent throws an error when I try to view/edit a job just created
Posted on 2008-10-22
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.