All: Short of breaking out the cluster administator tool (GUI), given a serversnetbios or DNS name, how can I deduce the SQL server names (and instances) that may be present on that server. Ideally, I could pass something into a VBSCRIPT function, and get the desired information, but at th...more >>

I have a SQL Server 2000 Enterprise server with 16GB of RAM. I have installed SP4 and the AWE hotfix. I have 3 instances running on the box: If I have 1 instance using 7GB and the other 2 are using 4GB each, does AWE need to be enabled on the instancese which are set to 4GB? Thanks! ...more >>

Check out KB 244980. There appears to be an error near the bottom where it talks about changing the subnet mask. After step 10, it says "To make sure that the SQL server IP address is changed, follow these steps: a. Check the registry on both nodes for the key that is mentioned in step 11."...more >>

I have a SQL Server cluster with 4 Dual Core 3.0Ghz Processors and 8 GB of RAM. I have PAE and AWE enabled on the server, but I cannot get SQL Server to access more than 4GB of RAM (using perfmon- SQLServer:Memory Manager/Total Server Memory). I would like to allocate nearly all of the ava...more >>

I currently have a single node SQL 2000 cluster running on 2003 Server. I now want to add the second node, but want to make sure I fully understand the process. I run the SQL setup from the new node and select the advanced option for failover clustering. It all seems very straight forward, but...more >>

Hi there, I am installing SQL 2000 on a Microsoft Windows Server 2003 clustered environment. This is a two node active/passive setup. The servers and OS were setup/installed and are being housed by an external company. The setup is as follows: Groups - Cluster Group, GRP1, GRP2 (different n...more >>

When I try to connect via IP to a newly created Active Active cluster I have to add the port to the IP for it to work. An example is if my IP is 10.0.0.1 and I try to connect it times out. if I try 10.0.0.1,1433 then it works fine. Am I missing a setting somewhere to make this work just b...more >>

Iam planning to install multiple instances in active/active cluster.Will there be ant problem if I use the same name for virtual server and the instance name ?Any disadvantages? Thanks Ajuss...more >>

Hello, We are going to design our SQL Server databases on either Active/Active or Active/Passive of Windows 2003 clusters. Has any one seen real time risk and their real experiences of using Active/Active clusters? Thanks, John...more >>

I am installing an SQL Server 2000 Active Active cluster on a Windows 2003 cluster. I am unable to install the Virtual SQL Server as a Named Instance. I can succefully install SQL Server as a local or default named instance. I have added the client config utility to both nodes and created a n...more >>

Hi, I would like to rename a cluster name {network name} from INTSQL1 to lets say INTSQLVS whats the procedure ? ...more >>

Hello -- I hope this is the right group. I have a particular ecommerce application at work that currently runs on one IIS 6.0 and SQL Server 2000 box. The web application reads various "theme" data for out customers to display their particualr theme when they log on. It also stores session...more >>

Hello, Does anybody know how I can programmatically detect the name of the virtual server if sql 2005 is running on a cluster? In previous sql versions I looked up the following registry entries: Default instance: "HKLM\\SOFTWARE\\Microsoft\\MSSQLServer\\Cluster" REG_SZ "ClusterName" N...more >>

Hi I have installed SQL 2000 on a server 2003 cluster. The 2003 servers are able to access all the shared drives fine and I have tested reading and writing from both nodes. However when I install SQL 2000 I am only able to see 1 drive from within SQL. This is a problem as I want to split...more >>

I have recently taken over a SQL cluster, running 3 instances of SQL 2000 on Server 2003. The cluster and each of the SQL instances were setup to use the domain administrator account as the service account and we now have reason to believe that the DA password has been compromised, so I nee...more >>

Hi friends, maybe someone can help me...Anybody knows a site address or have documentation for SqlServer cluster installation under Windows 2000 Advance Server. I'm searching in diferent sites but only I have founded under Windows NT 4.0. Thanls a lot for help Regards, Rodrigo ...more >>

Hi, We have an active-active cluster where SQL server instances are created on node 1 and Analysis services are installed on node 2. We need to upgrade the H/W for both nodes? Can I do a rolling upgrade i.e. replacing one node at time in above configuration? If not then what are my opti...more >>

Hi All, Cluster Group is failing to come online due to cluster name. Unfortunately running MSCS on Win2k Adv Server so most of the help mentioned is towards Win2k3...Any luck guys...? Event ID: 1052 and 1069 TIA ...more >>

Right now I have a failover cluster running Windows 2003 Server Enterprise Edition x64 and SQL Server 2005 Enterprise Edition x64. Each node in the cluster is repsonsible for hosting a SQL Server instance. Everything appears to be functioning correctly. We are investigating adding a third no...more >>

I have a cluster with 3 nodes, under SYSTEM in the event viewer I receive those Warning message every 3 secondes. ID 1123:The node lost communication with cluster node 'NODE1' on network 'PublicA'. ID 1123:The node lost communication with cluster node 'NODE3' on network 'PublicA'. ...more >>

Has any1 done SQL Clustering on a virtual server 2k5? I am having a tough time going through it, will appreicate any feedbacks..I was succesful in setting up cluster with just the Quorum Disk on a shared SCSI Bus. So far the cluster svc is up and running with the Cluster Admin MMC. Now when ...more >>

Hello All, I am configuring 2 node failover (active/active) cluster running 2 instances of SQL 2000 EE (SP4 8.00.2040), on Windows 2003 Server (SP1). Each node is preferred owner of one of the two instances, i.e. under normal circumstances Instance1 is owned by Node1 and Instance2 is owned...more >>

Hi, I have a question that I hope someone can help me with (I've trawled the net...). I want to consolidate several SS 2K databases on to a new SS 2005 2 node cluster. I will use SS 2005 standard for the cluster. Is it possible to add a 2K instance to a 2005 cluster running with standard...more >>

I am kind of the defacto SQL DBA in our small company. We have installed Idera's SQL Diagnostic Manager to assist me in monitoring the SQL Servers. Yesterday I received the following email from our Net Admin. Evidently we had one of our clustered SQL Servers fail because it ran out of disk sp...more >>

I attempted to install SQL and get an error on installing SQLXML4 failed with error 128. This was on a cluster. Six modules are running. SQL, SQL ip address, SQL network name, SQL server, SQL server agent, and SQL server fulltext. I did not install IIS, but from the message it appeared s...more >>

We have a SQL Cluster box, passive/active. Recently, we plan to upgrade memory to 8G and enable AWE. What's the right procedure to enable AWE? Can I just run following scripts against virtual sever, and all change will be populate the each node SP_CONFIGURE 'show advanced options', 1 REC...more >>

A friend of mine runs QL 7 Stanad on a Compaq Cluster. I want him to upgrade to SQL 2005. I want to know how he can do the below with SQL 7? His message: That feature, available with the SQL Server7 Enterprise, would allow my passive node to startup the database without any DBA involvem...more >>

2 Nodes are Win 2003 SP1 all latest security updates. Locale (incl.default) is English UK Access to the shared disk resource is fine and failover works a dream. There are no mount drives. Installation is taking place as Administrator on the active node. Shared resource only contains the one dis...more >>

We have 4 systems that was initially planned to be joined into an Active/Active/Active/Passive cluster with SQL 2005. Can anyone offer a suggestion on the number of instances to install per node? Does each instance need seperate Disks for the Database, Logs and TempDB? If we stay with this ...more >>

Hi, I have installed a SQL2005 Cluster (Source from MSDN) on a new installed Test Cluster. The clustergroup is working fine on Node A, if I switch to node B the Ressource "SQL Server" could not start with failure. In Event Log i found the follwing messages, the ID couldn't found on MS ...more >>

I have a three node cluster that I have to move to a different subnet. Here is my plan 1) fail all resources over to third node in cluster 2) change IP's of the physical nics in the two nodes without resources 3) run SQL server setup on the third node to change the cluster IP and the virtu...more >>

I am installing SQL 2005 on a two node 2003 SP1 cluster and get an error after selecting components and I have narrowed it down to Shared Tools. The error is: "The drive specified cannot be used for program location. Program files must be installed on a valid local disk available on all c...more >>

In our environment we have a cluster active standby with a shared storage iscsi The two machines are Windows 2000 Advanced Server with Intel Xeon Single-Core 3.4Ghz with SQL Server 2000 Enterprise Edition. Now we want to sustitute these two with another two machines with Dual Intel Xeon ...more >>

I get alot of those warnings on my SQL Cluster servers. Please let me know how to resolve this issue. I could not find any matching hits in the TechNet KB. Event Type: Warning Event Source: ClusSvc Event Category: (8192) Event ID: 1137 Description: EventLog replication queue INQ ...more >>

I am struggling with an installation of SQL2005 on Windows Server 2003 SP1. I am trying to set up a 2 node cluster with a single instance of sql2005. I need to use mount points so I create a shared disk for the mount points and 2 disks which are mounted in there. The shared disk is called M: a...more >>

We have a cluster that has been running for a couple of years. It has MSDE running on one node of the cluster. This cluster only has one group on it and want to install SQL 2005. Would it install into this group? Is it possible to have more than one group on one device? I was able to ge...more >>