Jul
7
2011

Editing Jobs / Maint plans not possible on SP2 tools if server name > 30 characters in length

Today, while doing some maintenance plan modification encountered a unique issue, recieved following error while modifying/opening any maintenance plan or job,

Error Screenshots:
Job error:

Maintenance Plan error:

Later on investigation found that this is a known bug with SQL Server 2005 SP2 that if SQL Server name exceeds 30 chars then this issue will occur, for e.g. if SQL server name is dazsqlmper234_1234\dbajsasalsa_456

Issue: SQL Agent Jobs and Maint plans are not editable when using SP2 tools against servers with a server name > 30 characters.

Symptoms:

You use Microsoft SQL Server Management Studio to connect to an instance of Microsoft SQL Server 2005. When you try to edit a SQL Server Agent job or a maintenance plan, you receive the following error message:

Error: 8152, Severity: 16, State: 13

Resolution: Following fix is provided by Microsoft link

The fix for this issue was first released in Cumulative Update 3


Users also reported this as bug, one such link: http://connect.microsoft.com/SQLServer/feedback/details/273298/editing-jobs-maint-plans-not-possible-on-sp2-tools-if-server-name-30-characters-in-length


Final Verdict: Keep your SQL server up to date wit latest SP or CU, anything can happen even a wrong choice of SQL server name 😉

Download PDF

Related Posts

About the Author: Nitin Garg

Indian born, trekker, biker, photographer, lover of monsoons... I love to blog the topics I research and find useful for self or online community to save time and energy :) Everything you read on my blog is my own personal opinion!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 174 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

May 2019
M T W T F S S
« Nov    
 12345
6789101112
13141516171819
20212223242526
2728293031  

View Post by Categories

%d bloggers like this: