.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

Validating cluster resource: SQL Server and SQL Server Agent services

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
 
SQL Server 2008 R2 installed on a Windows Server 2008 R2 2-node cluster. Cluster validation wizard warns for SQL Server and SQL Server Agent services: This resource is configured to run in a separate monitor. By default, resources are configured to run in a shared monitor. This setting can be changed manually to keep it from affecting or being affected by other resources. It can also be set automatically by the failover cluster. If a resource fails it will be restarted in a separate monitor to try to reduce the impact on other resources if it fails again. This value can be changed by opening the resource properties and selecting the 'Advanced Policies' tab. There is a check-box 'run this resource in a separate Resource Monitor'. "Should" SQL Server and SQL Server Agent services run in shared (default) or separate monitors in this environment?


View Complete Post


More Related Resource Links

Validating cluster resource: SQL Server and SQL Server Agent services

  
SQL Server 2008 R2 installed on a Windows Server 2008 R2 2-node cluster. Cluster validation wizard warns for SQL Server and SQL Server Agent services: This resource is configured to run in a separate monitor. By default, resources are configured to run in a shared monitor. This setting can be changed manually to keep it from affecting or being affected by other resources. It can also be set automatically by the failover cluster. If a resource fails it will be restarted in a separate monitor to try to reduce the impact on other resources if it fails again. This value can be changed by opening the resource properties and selecting the 'Advanced Policies' tab. There is a check-box 'run this resource in a separate Resource Monitor'. "Should" SQL Server and SQL Server Agent services run in shared (default) or separate monitors in this environment?

SQL Server Agent not listed as cluster resource

  
Hello everyone, thanks for any help on this issue.  I have recently installed SQL 2008 R2 on a Server 2008 R2 machine cluster.  We ran the advanced cluster prep and completion.  I have SQL Server up and running properly and failing over between nodes.  In the failover cluster manager, when I select SQL Server, I do not have the SQL Server Agent listed under other resources.  When I try to start the Agent from the SQL Configuration Manager it fails with an event 103 and I've found several notes on this error but I am figuring the root issue is that there isn't a cluster resource for the Agent. Is it possible to create the resource for the Agent? I have run a repair and I have tried to use add a resource, generic service, sql agent but it fails when I attempt to bring it online. Thanks again for any help on this. Mike

SQL Server 2008 Agent Fails to start in a Win 2008 Cluster

  
When I try to bring SQLAGENT Online, I get the following errors: EventID:53 [sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service.  CurrentState: 1 [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435) [sqagtres] OnlineThread: Error 435 bringing resource online.   I just did a fresh SQL Cluster install as well.  When I installed the cluster, the service account was good to go.  I cant figure out what is going on.  SQL Server Engine starts fine.  Any ideas?

Sql Server Job Agent vs Web Services

  
I've been tasked with coming up with a way to query our RS6000 and using the results to update records in the SQL Server 2005 db. Our RS6000 vendor has created an xml query which we call from an url. We query a table, loop through the results and call the xml query for each record. Then we check for a certain status in the xml results and, if we find it, update the db record. My question is which route would be better; building a web service in .Net or running a vb script from the SQL Server Agent? I normally do such things from a Web Service or an .exe setup under scheduled tasks on the server, but someone suggested SQL job agent route and I was wondering which would be more effiecient?Thanks in advance.

The SQL Server failover cluster instance name 'Server02' already exists as a clustered resource. S

  
Hello, I have a node of 2 servers of Win 2008 R2 Enterprise and trying to install a 2nd instance in a SQL 2008 R2 Cluster. I had SQL_INSTANCE2 previously installed that I removed from the two nodes. Now when I attempt to install it again from scratch, in setup GUI where I specify the SQL Server Network Name and enter the previously entered name "Server02", I get a failure in the setup with the following error message: "The SQL Server failover cluster instance name 'Server02' already exists as a clustered resource. Specify a different failover cluster instance name." How do I fix this problem, I don't want to enter a new name like "Server03" in order to proceed with the setup, because when I do enter "Server03" the setup does continue without an error message. So what am I missing? Do I have to ask the DNS administrator to see if there's an A record for "Server03" and have him delete it so that the setup works? Or the fix is by doing something else? I would appreciate any help. Thank you  

resource type SQL Server & SQL Server Agent missing after setup

  

Hello,

after the SQL setup I noticed that the resource types "SQL Server" and "SQL Server Agent" were missing. (one node setup, 2nd node was joined later) Well I was able to manually create them but they won't start. The OS is Server2008 R2 and SQL is SQL 2008 - NON R2, yet.

The resource "SQL Server" is in a failed state (please find the error message right below)

(An error occurred while attempting to bring the resource 'SQL Server ('instanceName')' online.Error Code: 0x8007139a
The cluster resource could not be brought online by the resource monitor).

"SQL Server Agent" is offline due to its dependency, the resource "SQL Server".

I already tried to repair the installation,  compared the properties of the 2 resources with a a working SQL2k8 cluster but with no success.

Does anyone have any idea what I could try next?

Thank you in advance

Masl

 

 

 


resource type SQL Server & SQL Server Agent missing after setup

  

Hello,

after the SQL setup I noticed that the resource types "SQL Server" and "SQL Server Agent" were missing. (one node setup, 2nd node was joined later) Well I was able to manually create them but they won't start. The OS is Server2008 R2 and SQL is SQL 2008 - NON R2, yet.

The resource "SQL Server" is in a failed state (please find the error message right below)

(An error occurred while attempting to bring the resource 'SQL Server ('instanceName')' online.Error Code: 0x8007139a
The cluster resource could not be brought online by the resource monitor).

"SQL Server Agent" is offline due to its dependency, the resource "SQL Server".

I already tried to repair the installation,  compared the properties of the 2 resources with a a working SQL2k8 cluster but with no success.

Does anyone have any idea what I could try next?

Thank you in advance

Emeska

 

 

 


SQL Agent - Running SSIS Package - Windows Server 2008/Windows 7 - Messenger Services

  

We have tried to run a SQL job for SSIS Package. But it failed during the execution with the error "[364] The Messenger service has not been started - NetSend notifications will not be sent". But in the job, no notifications have been configured and in windows server 2008/Windows-7 there is no messenger service at all.

When we search for the the messenger service in windows 7/windows server 2008, we found that service is not in both the OS and it was replaced by msg.exe. 

Any help or workaround would be appreciated.

Thanks in advance.

PS: The normal SQL jobs other than SSIS are working fine without any error.


Vijay Pandurangan

SQL server 2008 cluster install error - The resource failed to come online due to the failure of o

  

Hi ,

I ran into the following error when trying to install sql server 2008 cluster (node 1) on windows 2008

The resource failed to come online due to the failure of one or more provider resources. (Exception from HRESULT: 0x80071736)

Any insight on this issue is greatly appreciated

 

Ping

 

 


SQL 2005 Cluster Error (SQL Server Cluster Resource Not Starting)

  

Hi,

  I have 4 node Cluster (3 Active 1 passive) my second node SQL Cluster resource is not starting.

 

i'm getting following errors. if anyone can please give me help.

 

Event Type:      Error

Event Source:   MSSQL$TLCSQLDBIN02

Event Category:            (3)

Event ID:          19019

Cannot start SQL Server Agent service on Cluster , 2008 R2

  

Hi,

I'm testing a two node cluster installation on windows 2008 r2 and sql server 2008 r2 both enterprise before a production deployment and my only issue so far is that the SQl Server Agent service cannot be started.

The failover works fine, the cluster and SQL services changes nodes without any problem but on both nodes i cannot start that service.

I'm using a domain user for the service, member of the local admin and sysadmin on the SQL server itself.

The error i get when i click on start from SQL management console is:

Unable to start service SQLAGENT$SQLTEST on server SERVERNAME. (mscorlib)

------------------------------
Program Location:


Server stack trace: 
 at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
 at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args,
 Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md,
 Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink
replySink) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.R

2 Node Clustered SQl 2008 Sql Server Agent & Analysis Services Fail on only one node

  

Hi,

Until recently this worked ok, however now on one of the 2 nodes if I fail over SQL all of the services start, on the other node, Sql Server Agent & Analysis Services will not come on line. I have checked some of the other links suggestiing fixes but they dont seem to apply. On the Node where it fails you get an error 53 for the server agent the Analysis Services fails with Generic service 'Analysis Services' could not be brought online (with error '1060') during an attempt to open the service.  Possible causes include: the service is either not installed or the specified service name is invalid.

attached is the details from the Sql Log

2011-04-06 13:13:32.05 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
 Apr  2 2010 15:48:46
 Copyright (c) Microsoft Corporation
 Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: )

2011-04-06 13:13:32.05 Server      (c) Microsoft Corporation.
2011-04-06 13:13:32.05 Server      All rights reserved.
2011-04-06 13:13:32.05 Server      Server process ID is 4744.
2011-04-06 13:13:32.05 Server      System Manufacturer: 'Dell Inc.', System Model: 'PowerEdge R610'.
2011-04-06 13:

OData and AtomPub: Building an AtomPub Server Using WCF Data Services

  

Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.

Chris Sells

MSDN Magazine August 2010


Office Services: Merging Word Documents on the Server Side with SharePoint 2010

  

Office 2010 and SharePoint 2010 include a new set of components called Application Services. These put a rich set of tools in a developer's bag for Office automation. We'll show you how to use Office OpenXML, Word Automation Services and SharePoint to build a simple application that merges separate status reports into a single document.

Manvir Singh, Ankush Bhatia

MSDN Magazine July 2010


Data Services: Develop Robust and Scalable Apps with SQL Server Data Services

  

Here the author introduces SQL Server Data Services, which exposes its functionality over standard Web service interfaces.

David Robinson

MSDN Magazine July 2008


SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services

  

Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend