Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Cannot view Job properties in SQL 2005 Ent x64

Posted on 2011-02-23
12
Medium Priority
?
477 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
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 documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

927 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