Solved

Cannot view Job properties in SQL 2005 Ent x64

Posted on 2011-02-23
12
444 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
  • 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
Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

 

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Convert formula to max at a specific date by month 18 22
How to share SSIS Package? 6 37
SQL view 2 27
access query to sql server 3 22
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

822 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