|Subject:||SQL 2005 Server,SQL Server agent & SQL Analysis resources failing|
|Posted by:||Khalid (Khal…@discussions.microsoft.com)|
|Date:||Thu, 16 Aug 2007|
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
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.