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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

[amateur question] Why can't I use MSCS cluster ip address for SQL 2008 failover cluster?

Posted By:      Posted Date: September 16, 2010    Points: 0   Category :Sql Server
Good day! Recently, I was tasked to set up SQL 2008 failover cluster on both Windows 2003 Server (Enterprise ed). Everything was set up perfectly, failover work on both cluster nodes. Now the question is my boss asked me a very basic question on which I'm unable to give him a detailed explanation on why can't used only a single IP Address for both MSCS cluster and SQL failover cluster? I replied back him (amateurish) its because of the requirement stated on SQL 2008 failover cluster. I can't even be allowed to install when I keyed in the already used IP Address for MSCS. Can any folks enlighten me on these? Best Regards

View Complete Post

More Related Resource Links

SQL server 2008 failover cluster install

Hello all, Looking for the definitive answer with supporting documentation (link). Does a SQL server 2008 cluster have to be installed as or run as a domain service account or can local accounts be used?  I looked for a document that stated yes or no and could not find one. If anyone can provide info it would be much appreciated. Have all ready looked at these 2 links of interest. http://msdn.microsoft.com/en-us/library/ms143504.aspx#Service_SID http://technet.microsoft.com/en-us/library/cc731002(WS.10).aspx Thanks in advance,  

SQL server 2008R2 install on a server 2008 R2 failover cluster. Other resources won't failover to o

As the subject says, I've built a fresh install w2k8r2 and sql2k8r2 failover cluster. Sql works fine on the primary node, but when I test a failover it breaks. Specifically, if I were to stop the node1 cluster service (causing the cluster to switch to node2), windows changes the cluster DNS appropriatly and moves the shared storage just fine, but sql server doesn't failover.  Server Name, Disk Drives and Other Resources all go offline. I've verified that the advanced policies of the server name, IP, cluster drives all have both nodes checked as possible owners However, Other resources only lists node1 as a possible owner and there appears to be no way to add node2.  Under the Other resources, SQL Server and SQL Server Agent are listed. I'm sorta stumped, I've been combing the forums and have found similar issues, but nothing seems to explain why the two resources won't failover.

SQL Server 2008 A/P Cluster Does not Failover



I have a SQL Server 2008 Enterprise Edition A/P cluster Server on Windows 2008. Recently One of the Clustered Disks Went OFFLINE. The SQL Resource which has Dependency on the clustered Disk also went offline. Shouldnt a Failover of the resources be happening to the second node, if there is a failure in the first node? Are there any settings which need to altered?




Hi, I have successfully installed the slip stream SQL SERVER 2008 Enterprise  sp1  on the two node fail over cluster.Now i need to implement the 2 node failover cluster installation again with the standard  edition of SQL SERVER 2008 sp1.

My question is do i  need to go for a slipstream installation with  standard edition also?

Failover Cluster Install on Server 2008 R2 (RC)

Has anyone successfully installed a SQL Server 2008 Failover Cluster on Server 2008 R2 (RC)? I'm getting stuck at the Instance Configuration screen, i get an error when trying to detect the SQL Server Network Name, here is the error:

The given network name is unusable because there was a failure trying to determine if the network name is valid for use by the clustered SQL instance due to the following error: 'The network address is invalid.'

I've setup a 2008 SQL Failover Cluster in Server 2008 SP1 without a problem.

Installation problem with SQL 2005 on Windows 2008 R2 x64 Failover Cluster


I have built a Windows 2008 R2 x64 Failover Cluster and I need to install SQL 2005 Enterprise x64.

The SQL installation passes all checks and then fails as soon as it attempts to do the installation.

The error message in the Core(Local) log file is:

CSetupBootstrapWizard returned 1
<EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='0'>
Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.1399.0
<EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2010/0/8 1:6:26, returned true
Running: SetPackageInstallStateAction at: 2010/0/8 1:6:26
Complete: SetPackageInstallStateAction at: 2010/0/8 1:6:26, returned true
Running: DeterminePackageTransformsAction at: 2010/0/8 1:6:26
Complete: DeterminePackageTransformsAction at: 2010/0/8 1:6:26, returned true
Running: ValidateSetupPropertiesAction at: 2010/0/8 1:6:26
Complete: ValidateSetupPropertiesAction at: 2010/0/8 1:6:26, returned true
Running: OpenPipeAction at: 2010/0/8 1:6:26
Complete: OpenPipeAction at: 2010/0/8 1:6:26, returned false
Error: Action "OpenPipeAction" failed during execution.
Running: CreatePipeAction at: 2010/0/8 1:6:26
Complete: CreatePipeAction at: 2010/0/8 1:6:26, returned true
Running: R

Error Changing Default Backup and Log locations on 2 Node SQL 2008 Failover Cluster


My setup is a SAN providing iSCSI targets for a 2 node SQL 2008 Failover cluster on Windows Server 2008.  With the SAN volumes created, MPIO and iSCSI targets defined on each node, I installed the SQL Server cluster with a single iSCSI target, and therefore assigned database files, log files and backup files to be on that single volume.

I have since added a separate volume for both log files and backup files.  All 3 volumes are online in the SQL Resource Group of the cluster and active on the SQL Server active node of the cluster, and all the volumes are accessible from Windows Explorer on both cluster nodes.

Through SQL Mgmt Studio, I changed the default location of the log files, and I changed the default backup location in the registry for each node.

When I try to create a new database, I get an error saying I do not have permission to access the log file volume.  When I try to restore a database, I get the same error when SQL Mgmt Studio tries to access and display the specified backup volume. The text of the error in each case is:

"Cannot access the specified path or file on the server.  Verify that you have the necessary security privileges and that the path or file exists.

If you know that the services account can access a specified file, type in the full path for the file in the File Name con

Cluster Installation of SQL 2008 R2: IP Address x.x.x.x is already in use.


Installing a new SQL 2008 R2 cluster on Windows 2008 R2 boxes.  Installation goes through till the installation starts and then returns the following message.  The NIC I am using is on a separate VLAN for this SQL Server box and the IP address I am trying to add absolutely does NOT exist on the network already.

TITLE: SQL Server Setup failure.

SQL Server Setup has encountered the following error:

The IP Address '' is already in use. To continue, specify a different IP address.

Error code 0x84B40000.

question about applying 2008 SP1 on a active passive cluster


In the past (SS 2005), I was able to apply patches to to the virtual cluster host and it automatically detected both nodes and applied the patch.  This incurred downtime due to a reboot, but i did not care since this was a new cluster build.

Now, in 2008, the information I am finding implies that you should apply on passive node, perform a failover and then apply on other node.  

I am curious if it is still possible to apply the patch like i did for SS 2005, where I just run the install a single time from the virtual cluster host, thereby letting the installer figure out  it is a cluster and apply to both nodes?

single node SQL server 2008 R2 failover cluster is down

I install a single node SQL server 2008 R2 failover cluster (server 1) and add a node (server 2) on other server . Now , the first sql server (server 1) is down , server 2 still up so i have 1 server running When i install a new single node sql server cluster on a new server two error occur (failed) : - Microsoft Cluster service (MSCS) cluster verification errors. -Cluster shared disk available check Or can i change the server 2 to the single node sql server clutser to add new node ?

Failover Cluster Question about resource startup and shutdown order


Is there a way to change the order of how the Server name, Disk drives, and other Resources go offline to be moved to another node?


Server Name:

  • Name: TestSQL08PRD

Disk Drives:

  • Data_Drive
  • Logs_Drive
  • Backup_Drive

Other Resources:

  • GxClusPlugIn (TestSQL08PRD)(Instanace001)
  • SQL Server (TestSQL08INS)
  • SQL Server Agent (TestSQL08INS)

They go offline from bottom up.

SQLServer 2008 Tools and SQL 2005 Cluster

I recently built a SQL Server 2005 cluster on the o/s Windows Server 2008 R2.  I have been attempting to connect to the cluster from my Windows 7 dekstop with my SQL Server 2008 Tool set.  I have been unable to attach to this cluster since its creation. The firewall is temp off, remote connections in the surface area configuration is set to pipes and tcp/ip and the Browser surface is up and running. I ran Wireshark against the cluster and I could see that there was UDP conversations for ms-sql-m (SQL Port) but that was as far as it would get.  I am using a named instance so not using 1433, but I do see the cluster offering up high RPC ports but the client never responds after the initial UDP response. When I noticed that there was a two way conversation taking place, I went to a seperate machine and fired up SQL Server 2005 Tools and I was easily able to attach to the cluster.  So my question is - Are there any known incompatibilities between SQL Server 2005 cluster services and SQL Server 2008 Tool set?  I can use my 2008 tools to attach to a non-clustered SQL Server 2005 w/o issue.   Error when attempting to connect: A network-related or instance-specific error occured while establishing a connection to sql server.  The server was not found or was not accessible.  Verify that the instance name is correct and the SQL Server is con

Windows 2008 R2/SQL 2008 SP1 CU5 active/active cluster keeps failing

I have set up many of the same clusters in the last few months, but this cluster specifically has been having lots of problems lately.  OS: Windows Server 2008 R2 latest patches SQL: SQL Server 2008 SP1 CU5 (version: 10.0.2746) Disks: VMAX SAN In the very beginning when I set up the cluster, the cluster validation kept failing when I tried to add a node.  Turned out that we had to unjoin the servers from the domain and rejoin.  Right after that the cluster validation succeeded, the second node joined the cluster, and quorum was changed to "Node and Disk Majority".  SQL was installed and set up as active/active (one sql instance on each node).  No issues then until SQL server was actually in use.  Symptoms: SQL server has heavy ETL processing plus being a subscriber of a sql replication.  The following errors first started on 4/24 when I set up sql replication (these servers are replication subscribers): EventID: 1127, Source: FailoverCluster, Task Category: Network Manager Cluster network interface 'man1fscl01a - Hartbeat to man1fscl91b' for cluster node 'man1fscl01a' on network 'ClusterHeartBeat' failed. 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 adapter. Also check for failures in any other network comp

SQL 2008 Restore on a 2008 R2 Cluster

I've built a 2008 R2 Cluster running sql 2008 as a clustered application.  We do full backups with arcserve.  I'm trying to come up with a process to get the cluster back online for disaster recovery.  I can get the Windows cluster back online but when it comes to sql I get stuck.  Would I basically get the cluster back online than use the command - setup /action=rebuilddatabase /instancename=MSSQLServer /sqlsysadminaccounts=domain\username?  Than start the database in single user mode, install the arcserve sql agent and restore all the db's? When I try this I get the error element does not exist error.  Right, now I'm starting from scratch to see if I get the same result.  I just want to make sure I'm on the right track and not spinning my wheels trying something that won't work in a clustered application.   Thanks,   Matt

SQL Server 2008 R2 installation on a server which is in cluster

Hello, I want to install SQL Server 2008 R2 on a machine which is in a cluster. Is there any issue in doing this? Regards

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 2008 64 Bit 2 node cluster

I wanted to get some feedback on how much memory and CPUs I needed for each node in a 2 Node Cluster. The operating System will be Windows 2008 R2 64 bit Enterprise and the SQL version will be SQL 2008 R2 64 Bit. It will have a total of 8 instances of SQL Server. 2 of those instances will be SQL Server Reporting Services ( 1 SQL Native and the other SharePoint enabled). This cluster will have both nodes in a virtual enviroment. Any feedback would be greatly appreciated.
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