SQL 2005 Server,SQL Server agent & SQL Analysis resources failing

SQL 2005 Server,SQL Server agent & SQL Analysis resources failing

Post by S2hhbGl » Sat, 18 Aug 2007 15:46:02


Hi.
I have installed an SQL 2005 Cluster on a Windows 2003 Two Node
Active/Passive Cluster.Below is the brief of my Netowrk

1.I have two Active directory domain controllers running Windows 2003 R2
Standard edition with SP2.

2.i have installed a Windows 2003 Two Node Active Passive Cluster as NODE1
and NODE2.

3.The Domain account used to install WIndows 2003 A/P Cluster is
Clusteradmin.This account is the member of Administartors on the Domain as
well as the Local Admin on NODE1 and NODE2.

4.SQL 2005 with SP2 is installed on both the Nodes as SQL 2005 Failover
Cluster.The account used to install SQL 2005 is sqadmin.This account is the
member of Administartors on the domain and the member of Local Admins on
NODE1 and NODE2.

5.SLQ 2005 has four domain groups for 4 SQL Services.The Services are SQL
Server,SQL Server Agent,SLQ Anaylisis Server and Full text Search.

6.Each of these servcie has a seperate service account created for them.All
these service accounts areb the members of domain admin and the member of
Local Admin on NODE1 and NODE2.

7.Each of these servcies is running under these servcie accounts in the
Servcies tab in NODE1 and NODE2.

8.If i fail the resources from NODE1 to NODEL2 ,The SQL Server,SQL Server
Agent and SQL Anaylisis resources are failing.On going to the service tab of
NODE2 I reset the password for these services,the services come online.

10.The Cluster resources and MSDTC Resources are Failing over
successfully.They are coming online successfully.

11,I have a problem with the SQL Server Resources.Even if i failback to
NODE1 from NODE2 the same resources are failing again.


Please Advice
Best Regards

Khalid
 
 
 

SQL 2005 Server,SQL Server agent & SQL Analysis resources failing

Post by Ayad Shamm » Wed, 22 Aug 2007 00:36:50

Hi Khalid,

Whart is the error message?

Just a note, use SQL Server Configuration Manager to manage services that
are related to SQL Server 2005. Although many of these tasks can be
accomplished using the Microsoft Windows Services dialog, it is important to
note that SQL Server Configuration Manager performs additional operations on
the services it manages, such as applying the correct permissions when the
service account is changed. Using the normal Windows Services dialog to
configure any of the SQL Server 2005 services may cause the service to
malfunction.

For security reason, non of the SQL service account needs to be a member of
Domain Amins group. Only make sure that all of the SQL related services has
enough rights in SQL.

Ayad Shammout