.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

Sql server 2005 - rename cluster to an old cluster name

Posted By:      Posted Date: September 14, 2010    Points: 0   Category :Sql Server
We have a sql 2005 cluster on W2K8 cluster. It is a named instance say SRV1\A. Then I built a new W2K8 (with a diff cluster service name) but the same service account. Then I installed a new sql 2005 cluster say SRV2\A. Now when I bring down the sql server resources on SRV1 and try to rename SRV2\A to SRV1\A through the cluster admin, I get the error the network name already exists. I have tried bringing an old cluster and installing a new cluster with the same name and it works. Why am I not able to rename the name? Any advice would very helpful.Paul - SQL DBA

View Complete Post

More Related Resource Links

SQL Server 2005 - Installation in Cluster Environment - "Service SQL Server Browser (SQLBrowser) fai

Windows Server 2003 R2 Enterprise Edition SP2 32-bit All updates and patches installed Two-node cluster environment configured. Cluster functions perfectly. Trying to install SQL Server 2005 Enterprise Edition (32-bit) as a clustered application. Installation proceeds fine until it begins to install the SQL Server Database Services product. Status window says "Starting Services. Service: SQL Server Browser". Error message is presented: "Service 'SQL Server Browser' (SQLBrowser) failed to start. Verify that you have sufficient privileges to start system services". SQL Server Service Account is in the Administrators group on both local systems, and is a domain account. Account used for the installation is in the Administrators group on both local systems, and is a domain account. Have cancelled out of the install and rebooted both servers numerous times. Exact same error continues to occur. Cluster is active and all resources are owned by node #1 - the node where SQL Server Installation is being run. In the event viewer, I see: Event ID: 10 Description: The SQLBrowser service was unable to establish SQL instance and connectivity discovery". I am also seeing errors like: Source: SQLBrowser. The SQL configuration for SQL is inaccessible or invalid. Source: SQLBrowser. The Configuration of the AdminConnection\TCP protocol in the SQL instance xxxxxx i

Sql Server 2005 Cluster on EXS 4.0 VMWARE

Hi, I have this problem, i have sql server on Cluster with two nodes, the nodes are machine vmware, i was exs 3.5 and in december the esx was upgrade to version 4.  Of January the nodes present this problem:The node lost communication with cluster node 'SVRSQLN02' on network 'Servidores'.The node lost communication with cluster node 'SVRSQLN02' on network 'HeartBeat'.What can i do?

SQL Server 2005 Cluster failover issue

Hi All, I'm fequently experience Cluster failover issue. The cluster tries to failover and it fails back. Because of this the SQL server is getting restarted and this is a bugging issue during business hours. The following are the System event logs, Cluster resource 'SQL Server' in Resource Group 'Production' failed. The SQL Server Agent (MSSQLSERVER) service was successfully sent a stop control. The SQL Server Agent (MSSQLSERVER) service entered the stopped state. The SQL Server (MSSQLSERVER) service was successfully sent a stop control. The SQL Server (MSSQLSERVER) service entered the stopped state. The SQL Server (MSSQLSERVER) service was successfully sent a start control. The SQL Server (MSSQLSERVER) service entered the running state. The Cluster Service brought the Resource Group "Production" online.    The following are the application event logs, The client was unable to reuse a session with SPID 131, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message. [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0; message = [Microsoft][SQL Native Client]Query timeout expired [sqsrvres] OnlineThread: QP is not online. The client was unable

SQL Server 2005 installation on windows 2008 cluster error


I am trying to install SqlServer 2005 on windows 2008 cluster with domain controller. Installation fails on the second node while trying to set registry settings for server network libraries. Attached error message and output from error log. Can somebody suggest any solutions.



TITLE: Microsoft SQL Server 2005 Setup

Failed to set registry settings for server network libraries. The action is SetDefaults. The error is 11004 (The requested name is valid, but no data of the requested type was found.


Func Name='LaunchFunction'>
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_SetServerSSNLDefaults
PerfTime Start: Do_SetServerSSNLDefaults : Fri Sep 24 17:45:31 2010
<Func Name='Do_SetServerSSNLDefaults'>
Setting server network settings for instance name MSSQLSERVER, instance id MSSQL.1
Failed to set registry settings for server network libraries. The action: SetDefaults Error: 11004
        Error Code: 0x80072afc (11004)
Windows Error Text: The requested name is valid, but no data of the requested type was found.
  Source File Name: sqlca\nlregca.cpp
Compiler Ti

Substitute for Builtin\administrator....( SQL Server 2005 x86 on a cluster )


Hi Security Experts ,

Receintly , we had a situation where we were not able to login to SQL Server 2005 x86 on a cluster .The reason was that we had removed Builtin/Admin ....We had to add it back to bring the SQL Server resource up and running ...But due to Audit we cant keep Builtin\Admin and will have to remove it ...Is there a way to have a substitute for this ...I am sure there will be ..


Abhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/

cluster installation failed - sql server 2005


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


Note : when i install sql server agent is enable to select during setup..



SQL Server 2005 64bit -SP3 rollback process on A/P Cluster Environment


Hi all

Erlier I posted a questions Which I got Answer form Alberto Morillo & Siva...

See link http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/52bf813a-cd8b-4e40-a9a3-e80ceea0ee1b

in fact my question suppose to be  "SQL Server 2005 64bit -SP3 rollback process on A/P Cluster Environment"

Please some body guide rollBack process for given Rollout.

Pre-SQL Server SP3 Installation Steps. 

1. Prior to Installing the SP3,Take  the  Full Backup of All Database (System Databases, User Databases), Databases backup is required  for roll back process, If installation causes any Database Damages

2. Disconnect the all Application connects.

3. Announce the Down time for 60 minutes

SQL Server SP3 Installation Rollout Steps. 

1. Log into the server as an account that has privileges to install the service pack. On a failover
Cluster, this must be the cluster service account or a domain account that has ad-ministra

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



  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

SQL Server 2005 cluster install with SSRS and SSIS - best approach for installs and migration?


I just installed SQLServer 2005 STD edition SP3 on an active/passive 2 node cluster, Intended to replace a SQLServer 2005 sp3 EE install (not clustered) that is in production now using SSIS and SSRS.  I would need to migrate the databases, reporting, and Integration Services over to the new server cluster.  


1.    Does it make sense to run on a SQL Server 2005 on a cluster if SSIS and SSRS are not cluster aware? This is my 1st time adm

SQL server 2005 cluster - second node - sql service will not start - node is showing down in cluster


I am tryng to get the second node in a two node cluster to start sql services and come up in the cluster.  The second node was configured and running in a cluster when at some point, the sql service and/or cluster service went down.  Now the node will not start...as in SQL service fails and the system log error is:

"The disk associated with cluster disk resource 'Disk Q:' could not be found. The expected signature of the disk was BF17D33C. If the disk was removed from the server cluster, the resource should be deleted. If the disk was replaced, the resource must be deleted and created again in order to bring the disk online. If the disk has not been removed or replaced, it may be inaccessible at this time because it is reserved by another server cluster node."

and the Application log shows:

Error 2(The system cannot find the file specified.) occurred while opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf' to obtain configuration information at startup. An invalid startup option might have caused the error. Verify your startup options, and correct or remove them if necessary.

I had to edit the startup parameters on the second node because it appears it cannot "see" the original path, which was a network driv

Named Pipe on SQL Server 2005 Cluster


HI All,

We usually disable Named Pipe for all SQL instances. Recently we built a 4 node SQL cluter with 3 instances running on it. Can i disable Named Pipe for SQL instances in a clsutered environemt? is there any impact ?


SQL 2005/2008 on Windows Server 2008 R2 cluster - Service only starts when account is local admin


I have a single node Windows Server 2008 R2 cluster configured with SQL Server 2008 Enterprise Edition installed as a clustered instance.

I am having an issue where the SQL Server service will only start using TCP/IP when the service account is a member of the local admins group. To get SQL to install I had to add the sql server service account to the local admins group.

I have configured group policy with the permissions required for SQL Server 2008 and this is correctly applied to the node.

Errorlog shows the following...

Error: 26054, Severity: 16, State: 1.
2010-05-05 15:23:41.98 Server      Could not find any IP address that this SQL Server instance depends upon.  Make sure that the cluster service is running, that the dependency relationship between SQL Server and Network Name resources is correct, and that the IP addresses on which this SQL Server instance depends are available.  Error code: 0x5.

2010-05-05 15:23:41.98 Server      Error: 17182, Severity: 16, State: 1.
2010-05-05 15:23:41.98 Server      TDSSNIClient initialization failed with error 0x5, status code 0xa. Reason: Unable to initialize the TCP/IP listener. Access is denied.

2010-05-05 15:23:41.98 Server      Error: 17182, Severity: 16

install SQL server 2005 cluster in an exisiting two node SQL 2005 cluster

Hi.. i have an existing SQL Server 2005 instance already running in a two node cluster utilizing all the shared disk resources. I am now to install another SQL Server 2005 cluster in this same 2 node make it as active passive. Can you please let me know what are the pre requistes for it(like SQL Virtual ip, More shared disks.. ) for isntalling a new SQL instance in an existing two node clujster and what is the impact and how to proceed. Is it same way of installing a normal cluster or if differs. Thanks for your help in advance.

SSIS problem on sql server 2005 cluster


I have asked one question about the ssis service on sqlserver 2005 cluster.

the content is as belowing:

i installed ssis service on each node,and modify the ssis configuration file on each node also.
here is two format,but i don't know which one is right.\


<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    <Folder xsi:type="SqlServerFolder">
    <Folder xsi:type="FileSystemFolder">
      <Name>File System</Name>

Built For Speed: Develop Turbocharged Apps For Windows Compute Cluster Server


This article explores the services provided by Compute Cluster Server 2003 and the tools provided by Visual Studio 2005 that will help you develop High-Perfomance Computing applications.

Rich Ciapala

MSDN Magazine April 2006

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

Reinstalled SQL 2005 on cluster won't start.

OS: Windows Server 2003 32-bit. Cluster: 2-node Active/Passive We're working on upgrading from SQL 2005 to SQL 2008, and we're using this cluster to test the cluster upgrade/install procedures. So, updated the existing SQL 2005 instance to SQL 2008. This went fine. Added an additional SQL 2008 instance. This went fine. Uninstalled SQL 2008 (both instances) from both nodes. This went fine. Installed SQL 2005 (clustered setup). At the end of the install process, received a message about unable to do (something). However, the install reported successful. In the SQL0001_<computername>_Core(local) are these messages: Running: OpenPipeAction at: 2010/7/24 10:20:31 Complete: OpenPipeAction at: 2010/7/24 10:20:31, returned false Error: Action "OpenPipeAction" failed during execution. and much later: Error: Action "UninstallForRS2000Action" failed during execution.  Error information reported during run: Action: "UninstallForRS2000Action" will be marked as failed due to the following condition: In the SQL0001_<computername>_Core.log: Running: LaunchLocalBootstrapAction at: 2010/7/24 10:11:30 Error: Action "LaunchLocalBootstrapAction" threw an exception during execution.  Error information reported during run: "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\setup.exe" finished and returned: 0 Aborting que
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