SQL Cluster Server Has Failed

Jul 25, 2001

Hi,

I have a problem with my SQL cluster server and the project is supposed to go live in 2days !! The setup is as follows:

- 2 x NT SP6a Compaq servers
- Microsoft cluster server v1.0 (active/passive)
- SQL7 SP2 installed on cluster
- IIS4 installed on cluster

I had the SQL server working fine in a clustered environment and managed to fail it over to the 'other' server no problem. I then had to reinstall SQL SP2 on the passive node so following Microsoft guidelines I ...

- Used Cluster Failover Wizard on Node1 to remove the virtual SQL server
- Tried to apply SQL SP2 to the second node (after failover) but setup said it could not find SQL server !!!
- Tried to recreate the SQL virtual server on Node1 by rerunning Cluster Failover Wizard but I get a error message on the Node2 sqlstp .log saying ...

"An active SQL Server cluster has been detected. Run the SQL Server Clustering Wizard on both nodes to disable the cluster before installing."

I'm stuck. Help ! I cannot seem to re-cluster my SQL server.

Tim :(

View 2 Replies


ADVERTISEMENT

Setup And Upgrade :: Cluster Installation Failed On Adding Node To Cluster

Oct 10, 2015

During the installation of Adding node to a SQL Server failover cluster(On passive node) getting error like.. The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start.We  run the below commands but didn’t get any resolution & got the same above error .
 
1<sup>st</sup> Method…

1. Open console command (Run->CMD with administrator privileges). 

2. net stop winmgmt 

3. Rename folder %windir%System32WbemRepository to other one, for backup purposes (for example _Repository). 

4. net start winmgmt

2<sup>nd</sup> Method..

1. Disable and stop the WMI service.

a) Command : - sc config winmgmt start= disabled

b. Command : -                 net stop winmgmt

2. Run the following commands.

a).  Command:  Winmgmt /salvagerepository %windir%System32wbem

b). Command:   Winmgmt /resetrepository %windir%System32wbem

3. Re-enable the WMI service

Command:          sc config winmgmt start= auto 

Last command to run after above steps

4. Command:     mofcomp "%programfiles(x86)%Microsoft SQL Server100Sharedsqlmgmproviderxpsp2up.mof"

File not found Error for above command.

View 3 Replies View Related

Install SQL Server 2005 Cluster Error - ParseBootstrapOptionsAction Failed

Apr 24, 2007

Hi,

When I tried to SQL Server 2005 (Standard) to two-node Windows 2003 servers, the Remote Setup task on the 2nd node hang. Here is the SQL Setup log. Please help figure out the cause of the problem. Thanks in advance.



Microsoft SQL Server 2005 Setup beginning at Tue Apr 24 16:17:14 2007
Process ID : 2864
\irv144C$SQL2005Std-x64disc1setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/3/24 16:17:14
Complete: LoadResourcesAction at: 2007/3/24 16:17:14, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/24 16:17:14
Loaded DLL:\irv144C$SQL2005Std-x64disc1xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/3/24 16:17:14, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2864"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/3/24 16:17:14
Complete: ValidateWinNTAction at: 2007/3/24 16:17:14, returned true
Running: ValidateMinOSAction at: 2007/3/24 16:17:14
Complete: ValidateMinOSAction at: 2007/3/24 16:17:14, returned true
Running: PerformSCCAction at: 2007/3/24 16:17:14
Complete: PerformSCCAction at: 2007/3/24 16:17:14, returned true
Running: ActivateLoggingAction at: 2007/3/24 16:17:14
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
0000000000EDAF90Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.

View 1 Replies View Related

Help Required To Find Out When A Cluster Has Failed Over.

Oct 1, 2001

I am writing a little systems monitoring application to send SMS
messages to my mobile phone. For example when disk space reaches a
certain maount my program will raise an alert that fires a VB app,
that sends a SMS message directly to my mobile.
We operate an active/active cluster (SQL7 NT4) and I want to be informed
when one of the clusters fails over.
I have managed to find out when the clusters are 'off-line' by reading
the 'PersistentState' variable from the registry as follows:

DECLARE @LIVE_REPonV1 varchar(8000)
EXEC master..xp_regread
@rootkey='HKEY_LOCAL_MACHINE',
@key='ClusterGroupsd42a2a2d-f6a5-11d4-a584-00508bdfa98a',
@value_name='PersistentState',
@value= @LIVE_REPonV1 OUTPUT
SELECT convert(varbinary,@LIVE_REPonV1)

this has a value of 0x01000000 for on-line and 0x00000000 for
off-line.

However, after scanning the registry I cannot find a registry variable
that resembles a 'failed-over' status.
Any help would be most appreciated.

View 1 Replies View Related

MS DTC Setup Failed To Populate The Shared Cluster

Mar 10, 2004

I appologize if I am posting this msg twice (newby), but I am getting this error msg in the app log.

MS DTC setup failed to populate the shared cluster
registry. The DTC resource will not be able to come
online.Error Specifics:
d:srv03rtmcomcomplusdtcsharedmtxclumtxcluse
tuphelper
.cpp:120, CmdLine: "C:WINDOWScluster
esrcmon.exe" -e
1208 -m 1212 -p 2132, Pid: 3636

Have anybody seen this msg and any ideas on what to do in this situation? Your timely assistance is much appreciated. Thanks,

View 5 Replies View Related

Setup And Upgrade :: Cluster Installation Failed

Oct 8, 2010

when i install sql server 2005 in cluster. I have error at Setup process screen --> the selected components are being configured.all the components are failed.I am using domain account with administrator account privilege on both server.OS : windows server 2008 on virtual machine..when i install sql server agent is enable to select during setup..

View 12 Replies View Related

DBCC CHECKDB FAILED On SQL2k5x64 Activepassive Cluster

Jun 8, 2007

When using an activepassive sqlserver 2005 cluster (standard edition) on MS Server 2003 R2 Enterprise x64 with SP2 and I run the DBCC CHECKDB commands on any of the system databases I receive this error:



Check Database Integrity (selio)
Check Database integrity on Target server connection
Databases: All system databases
Include indexes
Task start: 2007-06-06T16:50:38.
Task end: 2007-06-06T16:50:38.
Failed-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "The database could not be exclusively locked to perform the operation.
Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Command:USE [master]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [model]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [msdb]
GO
DBCC CHECKDB WITH NO_INFOMSGS

I don't receive this error when I run CHECKDB on the system databases on our test environment x64 box (same OS and hardware).





View 3 Replies View Related

How To Upgrade SQL Server 2000 Cluster To SQL Server 2005 Cluster(Database)

May 8, 2007

Hi



We are planning to upgrade the SQL Server in our production environment from SQL Server 2000 to SQL Server 2005. This is a 4 Node cluster environment with 3 Databases on 3 Virtual instances. The main requirement is to achieve this with no/minimal downtime.



Could you please suggest or direct me to any documentation for the best practices used to upgrade such an environment?



Thanks

Priyanka

View 2 Replies View Related

Recovery :: FCI Number Of Cluster Nodes Supported For Edition Failed

Nov 22, 2015

I have encountered issue by add a node to SQL cluster

Server 2012 R2 Datacenter version
SQL 2012 Enterprise edition

Error Status>
number of cluster nodes supported for edition - failed

I have failed to bypass with Setup /SkipRules=Cluster_VerifyForErrors /Action=AddNode

View 2 Replies View Related

Setup And Upgrade :: Not Clustered Or Cluster Service Is Up And Online - Failed

Feb 27, 2013

I installed a SQL server 2008 R2 on a 64 bit Stand alone system today morning

Now I am trying to apply SP1 on it. But it is not progressing further with the below. How to overcome this issue.

Note: Cluster services not installed on this server. Cluster service is not there in the services.msc as well.

View 10 Replies View Related

SQL2005 Cluster Setup Failed Due To Task Scheduler And Native Client

Nov 28, 2006

Hi all,
I am trying to setup the cluster SQL server, say ServerA and ServerB. While I start the setup in ServerA, it prompts,
'Setup failed to start on the remote machine. Check the Task scheduler event
log on the remote machine.'

But I found that there is no remote logon to both nodes and the service task scheduler is running in both node.

On the other hand, I try to install the SQL via ServerB, it prompts for valid Native client package 'sqlncli.msi' and caused the setup failed finally. However, the Native client was setup successfully as a prerequisite once starting the setup.

Any advise? Thanks in advance!!

View 5 Replies View Related

Recovery :: Cluster Failover - Failed To Bring Secondary Node Online?

Oct 19, 2010

Server : Windows server 2008
DB Server : SQL Server 2008 (SP1)
 
Here are the series of events which happened.

1.) Event ID: 1135
Cluster node 'XYZ' was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to the node having lost communication with other active nodes in the failover cluster. Run the Validate a Configuration wizard to check your network configuration. If the condition persists, check for hardware or software errors related to the network adapters on this node. Also check for failures in any other network components to which the node is connected such as hubs, switches, or bridges.

2.) Event ID: 1049
Cluster IP address resource 'SQL IP Address 1 (XYZ)' cannot be brought online because a duplicate IP address '10.9.8.113' was detected on the network.  Please ensure all IP addresses are unique.

3.) Event ID: 1069
Cluster resource 'SQL IP Address 1 (XYZ)' in clustered service or application 'SQL Server (MSSQLSERVER)' failed.

4.) Event ID: 1049
Cluster IP address resource 'Cluster IP Address' cannot be brought online because a duplicate IP address '10.9.8.112' was detected on the network.  Please ensure all IP addresses are unique.

5.) Event ID: 1069
Cluster resource 'Cluster IP Address' in clustered service or application 'Cluster Group' failed.

6.) Event ID: 1066
Cluster disk resource 'Cluster Disk 25' indicates corruption for volume '?Volume{88552e6f-aea2-11df-9790-0026b92fffa7}'. Chkdsk is being run to repair problems. The disk will be unavailable until Chkdsk completes. Chkdsk output will be logged to file 'C:WindowsClusterReportsChkDsk_ResCluster Disk 25_Disk16Part1.log'. Chkdsk may also write information to the Application Event Log.

7.) Event ID : 1066
Cluster disk resource 'Cluster Disk 26' indicates corruption for volume '?Volume{88552e05-aea2-11df-9790-0026b92fffa7}'. Chkdsk is being run to repair problems. The disk will be unavailable until Chkdsk completes. Chkdsk
output will be logged to file 'C:WindowsClusterReportsChkDsk_ResCluster Disk 26_Disk4Part1.log'. Chkdsk may also write information to the Application Event Log.

8.) Event ID: 1049
  (Same message as point 2)

9.) Event ID: 1069
     (Same message as point 3)

10.) Event ID : 1049
(same message as point 4)

11.) Event ID :1069 
(same message as point 5)

12.) Event ID :1205
The Cluster service failed to bring clustered service or application 'Cluster Group' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered service or application.

13.) Event ID: 1069
Cluster resource 'Cluster Disk 17' in clustered service or application 'SQL Server (MSSQLSERVER)' failed.

14.) Event D : 1049
(same message as point 2)

15.) Event ID: 1069
Cluster resource 'SQL IP Address 1 (XYZ)' in clustered service or application 'SQL Server (MSSQLSERVER)' failed.

16.) Event ID : 1205
 The Cluster service failed to bring clustered service or application 'SQL Server (MSSQLSERVER)' completely online or offline. One or more resources may be in a failed state. This may impact the availability of the clustered service or application.
 
first of all,I went through all the logs, and could not find the reason for fail-over initialization. There should be some thing logged why the failover happened? secondly after failover the service was not coming online due to duplicate IP address detection.

Later when we try  to manually bring the service online from cluster management it comes online successfully. I don't understand how would duplicate IP address get resolved when we start manually.

Lastly we see few errors related to physical disk resource between failover retries, is this could be the correlated to failover error ?

View 4 Replies View Related

SQL 2012 :: Server Cluster Without Windows Failover Cluster

Feb 18, 2014

I´ve been reading that SQL Server 2012 Always On is dependent on having a Windows Failover Cluster setup. Is that correct ?

View 6 Replies View Related

Upgrading A SQL Server 2000 Cluster To A SQL Server 2005 Cluster

Dec 28, 2007



We're upgrading a SQL Server 2000 cluster (Active/Passive) running on Windows 2000 Server to a SQL Server 2005 Cluster running on Windows Server 2003. We can't purchase new hardware and we have no spare hardware. We also need to move from Windows 2000 Server to Windows 2003 Server at the same time. We want to keep downtime to a bare minimum.

What we were thinking was the following steps... Anyone try this?

1. Break the link between the servers.

2. Install a fresh copy of windows 2003 server on one side along with SQL Server 2005. While this step is running, the active node would still be live on Windows 2000 Server and SQL Server 2000 serving our customers.

3. Restore a copy of a backup from the active production side to the node we're upgrading and at that point we would bring the active node down, switching the active node to be the newly upgraded server.

4. As a final step, the old active node would now have the link to it broken, we would install a fresh copy of windows 2003 server on it and sql server 2005. At this point we would bring it back into the cluster and the cluster would be complete again.

Thoughts?

View 2 Replies View Related

Upgrading SQL Server 2000 Cluster To SQL Server 2005 Cluster

May 14, 2008



Friends -

Need your help and guidence for doing upgrading SQL Server 2000 Cluster to SQL Server 2005 Cluster.

Let me explain my current environment.

1. Currently SQL Server 2000 Cluster environment is running on Windows 2000 Server we need to upgrade this to SQL Server 2005 on Windows 2003 Server. >>> Production environment.


My Plans:

1. On Testing Environment Install SQL Server 2000 cluster on Windows 2003 Server and do a restore of databases from the produciton environment.

2. Upgrade In-Place from SQL Server 2000 Cluster to SQL Server 2005 Cluster.

My doubts

1. Can i install SQL Server 2000 Cluster on Windows 2003 Server. Is it possible or not.

Please advise me and correct my steps.

Cheers
VSH

View 1 Replies View Related

SQL 6.5 Cluster Upgrade To SQL Server 7.0 Cluster

Jul 17, 2000

I am trying to upgrade a SQL Server 6.5(Cluster) to SQL Serevr 7.0 (Cluster)..I already have an intsllation of 7.0(On a Cluster),so this means that 6.5 and sql 7 are on seperate cluster's ,if i try to upgrade from 6.5 Cluster to 7.0 Cluster is asks me to uncluster 6.5 and 7.0 is this correct ,assume i cannot break the cluster then what???.. what is the best way i can achieve this functinality.....

thanks in advance

Jack

View 1 Replies View Related

Step By Step For Upgrading SQL Server 2000 Cluster To SQL Server 2005 Cluster

May 15, 2008



Friends -

Could any one of you provide steps for upgrading SQL Server 2000 cluster to SQL server 2005 cluster.

My environment is Windows 2003 server.

Appreciate your support.

Cheers
VSH

View 1 Replies View Related

Login Failed For User - Token Based Server Access Validation Failed With Infrastructure Error

Sep 9, 2015

Many a times see the below error in SQL Error log.

Login failed for user 'NT AUTHORITYANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ]

Is this something to do here?

Note: If I run the below statement I know that the SQL Error log entry will go off, but wanted to know the real significance of this error?

CREATE LOGIN [NT AUTHORITYANONYMOUS LOGON] FROM WINDOWS

View 1 Replies View Related

Maitenace Plan Check Database Integrity Task Fails With Failed:(0) Alter Failed For Server 'xyz'

Feb 21, 2008



Hi,



I am administering several SQL Servers running SQL Server 2005 SP2 Build 3042.
I have a common maintenance plan that runs on each of the servers. The maintenance plan runs
fine on all the servers except for one. On the one server the Database Integrity check fails with the following error:


Check Database integrity on Local server connection
Databases: <list of databases>
Include indexes
Task start: 2008-02-21T00:05:42.
Task end: 2008-02-21T00:05:46.
Failed0) Alter failed for Server €˜XYZ€™

I created a test maintenance plan to just do the integrity check and selected one database only and this also failed with the same error message. I ran this test maintenance plan and configured it for each of the databases in question and it failed each time.
If I run the DBCC manually against the databases they all report fine.


I read some of the post that talked about the €œAllow Updates€? being set incorrectly but that does not apply to my problem since my configured and run values are set to 0.

Does anyone know what the problem could be?

View 23 Replies View Related

Access Denied To Cluster Storage When Restoring 2005 Full Text DB To 2014 Cluster

Jun 10, 2015

I am in the process of moving databases from a SQL 2005 Standard version to a 2-node 2014 cluster.All of my 2005 databases back up successfully.They all restore without issue except for one database that has a full text catalog. I get this message

Msg 7610, Level 16, State 1, Line 2
Access is denied to "fileStoragedataMSSQLSERVERFullTextCatalog", or the path is invalid.
Msg 3156, Level 16, State 50, Line 2
File 'sysft_FTCatalog' cannot be restored to 'fileStoragedataMSSQLSERVERFullTextCatalog'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 2
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

[code]....

I went as far as giving the folder full access to everyone temporarily and received the same error.

View 1 Replies View Related

SQL 2012 :: Advanced Cluster Preparation For New Instance On Existing Cluster

Apr 10, 2014

I ran the Advanced cluster preparation for a new sql instance on an existing cluster.

Slq Server 2012.

After is completed, it was successful, I realized I specified the wrong Instance Root directory.

Is it possible to remove what the preparation installed? Or is it possible to change the root directory?

View 3 Replies View Related

Setup And Upgrade :: Can Build Cluster By Adding Cluster Service

Jul 6, 2015

Can I build a cluster by adding the cluster service, then the SQL instances, then add the other nodes and their passive SQL instances?I would lean to building the cluster first, the add the SQL instances.

View 4 Replies View Related

T-SQL (SS2K8) :: Convert Non-cluster Primary Key To Cluster Unique

Nov 6, 2014

I have following script which i am planning to run to drop all non-clustered primary keys on a database and then created as clustered. I am using someone else's script so don't know how to modify this. Some of primary key columns are used in references in other tables.

is there anyway i can drop the existing primary keys and using their original script then create again as clustered including restoring all foreign and reference keys and unique or no unique.

DECLARE @table NVARCHAR(512), @tablename NVARCHAR(512),
@sql NVARCHAR(MAX), @sql2 NVARCHAR(MAX), @sql3 NVARCHAR(MAX),
@column NVARCHAR(MAX);
DECLARE @indexname NVARCHAR(512);
SELECT name As 'Table'

[Code] ....

View 8 Replies View Related

Recovery :: Can Join A Node In Windows Cluster Which Is Already In Different Cluster

Oct 8, 2015

can we join a node in a windows cluster which is already in a different cluster?

We have this requirement as we need to setup readable secondary ( always on AG) on the third node.

View 2 Replies View Related

Recovery :: IP Change For Cluster / Nodes And Windows Cluster?

Jul 15, 2015

We are planning to change all IPs of PRODUCTION Failover Cluster Setup. In my cluster setup ... we have 2 Physical Nodes with windows-2008, Roles are MSDTC and SQL-2008R2.

IP change for:

1. Both Nodes(Physical)
2. MSDTC
3. SQL Server 
4. windows Cluster 

So Almost... All IPs are going to change.

Im DBA here, I need to take care of SQL cluster and MSDTC. But I haven't performed this activity before.So I'm worrying about Impacts and consequences of this change. steps how should I perform this activity.

View 9 Replies View Related

Script To Change Cluster Index To Non Cluster

May 20, 2003

Hi all,

We have many tables which have cluster index on column with datatype 'Char(200)'.
Does anyone have script to change cluster index to noncluster for all user tables which have clustered index on a column with 'char(200)' datatype.

Thanks,
Deepak

View 2 Replies View Related

Transact SQL :: Difference Between Cluster And Non-cluster Index

Jul 26, 2015

Wanted to know about difference between cluster and non cluster index with example.

When to use cluster index and non cluster index .

View 3 Replies View Related

DB Engine :: Why Cluster And Non-cluster Indexed Created On Same Key

Jun 10, 2015

CREATE TABLE [dbo].[Access](
 [AdminID] [int] NOT NULL,
 [FnID] [int] NOT NULL,
 CONSTRAINT [PK_AccessFn] PRIMARY KEY NONCLUSTERED

[Code] ....

why the cluster and non cluster indexed created on the same key?

View 3 Replies View Related

SQL Server Admin 2014 :: Change IP Address Of Server Which Is Locally Hosted And Is Not On Cluster?

Sep 3, 2014

I am asking about a virtual IP for SQL Server, is there a way we can assign a different IP to SQL Server other than the server's(host) IP address? like the same what we do in a clustered env.

View 3 Replies View Related

SQL Server Admin 2014 :: Unable To Add Server In Multi Subnet To Cluster

Oct 6, 2015

I am setting up SQL 2014 always on. I was able to set up the replicas between 2 servers in the same subnet.Their IP addresses are say like this:

100.20.200.200
100.20.200.201

When I am trying to introduce another node into the cluster which has IP address like 100.10.101.102, I am getting an error that the server isn't reachable.

View 5 Replies View Related

SQL Server,SQL Server Agent,SQL Analysis Resources Failing In SQL 2005 Cluster

Aug 17, 2007

Hi.
I have installed an SQL 2005 Failover Cluster on a Two Node Active Passive Windows 2003 Cluster.If i am trying to failover from the Active node to the passive Node,The Sql Server,Sql Server Agent and SQL Analysis resources fail,However if i reset the passowrd in the services tab of the above three services on the pasive node,the resources come online.
Below is the brief of my setup
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 NODE2 ,The SQL Server,SQL Server Agent and SQL Anaylisis resources are failing.on going to the service tab of NODE 2 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.

Plz Advice.
Regards
Khalid

View 1 Replies View Related

Cluster SQL Server

Nov 23, 1999

If anyone knows about cluster SQL server or where can i find the informations about that , would be great to hear!

View 2 Replies View Related

Cluster Server

Apr 19, 2000

I need to setup a cluster server for SQL server7.0.Can anyone advice the steps involved?Also any reading for that?
Thanks!

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved