Solved

Cannot view Job properties in SQL 2005 Ent x64

Posted on 2011-02-23
12
435 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
 

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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

914 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now