Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Cannot view Job properties in SQL 2005 Ent x64

Posted on 2011-02-23
12
Medium Priority
?
472 Views
Last Modified: 2012-05-11
For some reason, I can't view/modify the properties of the Jobs I have created.  I get the following error:  

TITLE: Microsoft SQL Server Management Studio
------------------------------

Enumerate target servers failed for Job 'DB Index - V2 - User - Tables'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Enumerate+target+servers+Job&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot perform this operation while SQLServerAgent is starting. Try again later. (Microsoft SQL Server, Error: 14258)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=14258&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


This server is in a clustered environment.  I have restarted the SQL Agent service, but that did not help.  The SQL Agent is started though.  Anyone have a good solution for this issue?  Or need more information?
0
Comment
Question by:Chicot_Parker
[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
  • 5
  • 2
12 Comments
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 34962518
1.) Using Cluster Administrator, change the SQL Network Name to the new name.

2.) Take the network name resource offline. This takes the SQL Server resource and other dependent resources offline as well.

3.) Bring the SQL Server resource back online.


with many thanks to -Tom Kretzmer

0
 

Author Comment

by:Chicot_Parker
ID: 34962551
What do you mean by "new name" in step 1?
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 34962609
change the virtual server name

Instructions are at http://msdn2.microsoft.com/en-us/library/ms178083.aspx
0
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.

 

Author Comment

by:Chicot_Parker
ID: 34962715
Not to discredit your possible solution, but how will renaming the virtual server name fix this issue?  Also, we are replicating the data via DoubleTake to the other server in the 2-node cluster.  Both of these nodes have their on SAN.  The link you provided states that this will not work if replicating.    
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 34962815
>>but how will renaming the virtual server name fix this issue?
Well your not the first with this problem.

>>The link you provided states that this will not work if replicating.
true , i didnt know your using replication BUT you can rebuiled the replication after the change.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34963351
>>Well your not the first with this problem.<<
No doubt.  That is why the author is posting the question in the first place.  But I suspect what they are asking for is a reason or even better some documentation to backup your solution.
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 34963575
you make me laugth :-)

read this thread
http://www.sqlservercentral.com/Forums/Topic364622-149-1.aspx
0
 

Author Comment

by:Chicot_Parker
ID: 34963640
Well your not the first with this problem.
You are correct about that, but I also know that there is probably another, less evasive, solution.

 
But I suspect what they are asking for is a reason or even better some documentation to backup your solution.

Correct.  

There is a business application that runs in the front end that depends on this cluster, and arbitrarily renaming clusters is really out of the question, unless, this is the ONLY way to fix this issue, my gut tells me it is not, in which case, I would like to know how you came to this assumption.
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 34963992
hi

ofcourse i understand your problem .

from reading other posts with a similar problem to yours.
i understand that taking other paths upto reinstalling sql server didnt work.

please let us know how you resulved this issue.
i wish you best of luck.
0
 

Accepted Solution

by:
Chicot_Parker earned 0 total points
ID: 34979326
Ok, I forgot to update this the other day.  It seems that the issue was caused by a database being in 'Recovery Mode'.  I can't necessarily confirm that was the cause, but coincidentally, soon after the database that was in Recovery Mode finished recovering, I was able to view/modify my jobs.  Now this database has been giving us problems, and had been in recovery mode before, and we haven't had issues with the jobs.  But for some reason, it decided to give us problems this time.  Maybe it can be explained, maybe not, but I'm able to view those jobs, and I got rid of the database that was in 'Recovery Mode'.

Thanks for all your suggestions.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 34985599
Excellent!  Please go ahead and close the question, by accepting your comment as the solution.
0
 

Author Closing Comment

by:Chicot_Parker
ID: 35015621
The issue resolved itself.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

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

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

721 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