Hi, When I want to install MSCS on Windows 2000, the wizard asks a name for cluster name. In installation of SQL Server 2000, the wizard asks name of "new or existing Virtual SQL Server". 1) Should these two names be the same? What's the relation between them? 2) Which IP address should I as...more >>

Hallo My Sql server 2005 works in failover cluster (2 instances). Now it is one node cluster (I am on begin of migration proces) I change named pipe settings in configuration manager. But server dosn't start on new configuration. (Wrong pipe name...) I try go back, and change settings t...more >>

We are planning to implement a sql 2005 cluster. We have 2 servers and want to implement an active-passive cluster. We are getting a SAN very soon which will be used for the database storage or another words as the quorum disk. Before we use the SAN, we want to do a test SQL 2005 cluster ...more >>

SUMMARY When I try to add second node to a two node cluster I get this message: "0x00138f Cluster resource not found" SETUP Windows 2003 64-bit R2 // HP Proliant DL380 G4 cluster with MGSA 500 G2 storage // Smart Start 7.4 Documentation I used are: Doc1(overall document): http://msmvps.c...more >>

I am planning a SQL 2005 SP1 upgrade of my 2 node (active/active) cluster. I just need to confirm if the upgrade process will update both of the nodes automatically or do I have control over applying SP1 to one node versus the other? Can the cluster operate with one node at SP1 while the oth...more >>

I have a SQL cluster consisting of the following: 2 ea Dell PE-2850 servers, dual 3.2 GHz CPU, 4 GB RAM, 2-36 GB/RAID-1 for C:, same for D:, all drives U320/15K. running Win2K3EntSP1 and SQL2K5SP1. Connected to cluster with Dell PERC4/DC in each server 1 ea Dell PV-220 cabinet (up...more >>

Hi, I have a clustered SQL Server 2000 running on Win2K3 and SAN. We are planning to move this to a new SAN. Any step-by-step procedures to guide me? Do I just copy the MSCS and MSDTC folders to the new SAN?...more >>

We are running a Windows 2003 domain. I have a Windows 2003 member server running an app. and MSDE. I now have another app. that I would like to install on this same server. The new app. also needs MSDE. My question is can I install and run more then one copy of MSDE? Is there anything I...more >>

Does anyone have any good articles on SQL 2005 clustering ...more >>

We have clustering set up. Now I want to load SQL Server 2005 EE. Do I load it on both servers in my cluster? If I understand this correctly, I load the system db's on the shared disk array. When I load SQL server 2005 on the passive box, how do I configure the system db's on that server? ...more >>

Hi, We are consoldating a number of database servers onto a new cluster, and I just wanted to check wether an instance of SQL2K EE 32bit will run ok alongside an instance SQL2005 x64 on a Windows 2003 x64 2 node cluster? I know it would be better to move all databases to SQL2005 x64, but on...more >>

After reading Win2003 Ent & SQL 2005 Clustering, I think I am more confused than ever. Here is my scenario and I am trying to find the best layout to minimize (or eliminate) outages. Two identical servers attached to a common fiber channel array. The disk array is mounted on both servers....more >>

Gurus, How do you all configure Symantec AntiVirus on a Microsoft SQL Server that is in a two-node cluster? Do you install the antivirus on both physical nodes and exclude the MDF and LDF files from real-time scanning? And that's it? -- Spin ...more >>

Hello Does anyone know a link to a whitepaper which explains how to install SQL on a cluster? Thanks ...more >>

I'm running Windows 2000 Advanced Server (2 node cluster) with SQL 2000 = Sp3. I get the following errors, with keep writing to my Application = Event Log. 1.. MS SQL SNMP Extension Agent reconnecting. 2.. The data portion of event 19000 from MSSQLSERVER is invalid. 3.. ODBC error enco...more >>

Hello, Being a bit of a SQL Server novice, need some advice with the following situation. Server A and Server B have SQLServer 2000 based databases. The vendor of the application/system has implemented their own replication process to ensure the 2 databases are in sync. However, there is no...more >>

Just recently we setup an Active/Passive SQL Cluster running on Windows 2003 Enterprise Edition. We are currently receiving these messages on our servers but our DB seems to continue working correctly. Can anyone tell me what this error means? Event Type: Error Event Source: WinMgmt Event...more >>

Hello I'm getting ready to install another instance of SQL 2000 in our windows 2003 cluster environment. My question is, Do I need to install SQL SP4 again on the new SQL instance or no? Thanks...more >>

Hi, i am pretty new to all of this so explinations in relatively easy to understand terminology would be appreciated. Basically i would like to know how Clustering works. As i currently understand it, you need 2 indentical servers, 2 identical versions of SQL Server, and 2 identical databas...more >>

Hi guys, what am I doing wrong with this? Please note these are all problems from 'clean installs'. (INTRO/WHAT I DID/ERROR MESSAGES) INTRO: ====== I have Compaq Proliant DL380 G4 with MGSA 500 G2 cluster. My O/S is Windows 2003 64-bit R2. My compaq SmartStart is version 7.40. Documentati...more >>

So i have an Active/Passive cluster and it will randomly hiccup giving the errors [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure [sqsrvres] OnlineThread: QP is not online. [sqsrvres] printODBCError: sqlstate...more >>

Hi all, is it possible to assign for each CPU a different process within one SQL Server 2005? I got 2 servers (each 4 CPUs; 64 bit system) which should be able to failover, but on the other hand there are reporting/analysing applications and totally different sharepoint/other applicat...more >>

Hello group. Recently I had installed a Active/PasiveSql Server cluster solution. All iy's OK except for the Enterprise Manager. This console only is installed in the first node. For administrative purposes is necesary install this application in the second node. When I try with the Sql Srver ...more >>

I'm trying to install a 3+1 - SQL2005 x64 Cluster configuration on 4 nodes of my Win2003 Server x64 ENT DL585s. When I load the SQL2K5 installer it loads the SCC...... The SCC consistently comes back saying that 2 nodes of my cluster are "unavailable". The message reads something along th...more >>

Prior to SP1 I was able to easily switch from High safety(sync) to High Perf(async) by clicking the radio button in the Mirror... dialog. Am I missing something obvious or has something changed between RTM and SP1? My new environment is mirroring to two instances on same server with a seco...more >>

I'm new to clustering and need to setup a linked server to a Progress Database via ODBC. This will require installing the Progress ODBC Drivers. My question is what is the process for installing ODBC drivers (or non-cluster aware software) on a clustered instance? Is it just a matter of ins...more >>

Hi, Does anyone know if I install SQL Server 2005 (EE) on cluster server with out Notification Services, the Database Mail will be working or not? Regards, -Chen ...more >>

My understanding of sql2k is as such: You can install only 1 sql server instance per virtual server. If that is the case then when connecting to the instance on the virtual server why do you need to connect using a sql client alias use the notation virtual_servername\instance_name? Or can you...more >>

Does anyone know if you can set up a failover cluster to failover (1 way only) from a 2005 Standard edition to a 2005 Enterprise edition server? I know you could not go the other way, but we are looking to be able to failover the DBs on our Standard box to the Enterprise box. Thanks for any h...more >>

I found that my contractor really fowled things up on a test server. He started the cluster service on his login. He is no longer an issue. So how do I drop all references to clustering on this server? The cluster service will not start currently. From event log: MS DTC has determined ...more >>

We are looking to give a cluster 2 different names - I'm wondering, is there any documentation on this? Is it supported? Do I just create a second cluster name? Thanks ...more >>

We are planing to install SQL 2005 on 2 node cluster. We will use 2 instances, each using it's own resource group(virtual name , IP , disk) and running on two 2003 servers. I'm not sure about the names that clients will connect to. Will they connect to: VirtualSQL1 and VirtualSQL2 or Virtu...more >>

Hi, I just installed SQL Server 2005 (with SP1) to cluster server. Because I only installed SQL Server Engine, after install the Maintenance Plans Wizard is not working. The error said SQL Server 2005 Management Tools must be installing. My Question is: do I need de-install first than re-...more >>

Anyone having a clue to what can be wrong?? The installer returns the mesage: Setup failed to start on the remote machine. Check the task scheduler event log on the remote machine. executing schtasks /query /FO LIST gives the message: Task Name: SQL SErver Remote Setup status: Could not...more >>

I need to know the in's and out's of breaking a cluster. I need to move a cluster of servers from one location to another one. Is there a paper explaining the breaking of the cluster and then how to bring it back on line correct. Any help will be appreciated. Douglas ...more >>

Hi, We will install SQL Server 2005 to new box (64 bit) cluster. The thing is we don't need all the services that provide from 2005. My question is if I only need install Database Engine and using Maintenance Plan Wizard to backup databases, etc. I must install SQL Server Integration Service...more >>

2 Node Windows 2003 Ent SP1 cluster running default instance of SQL Server 2000 SP4 Virtual Server. Trying to install a second (named) instance on the existing Virtual Server. 1st problem... When running the autorun.exe, if I enter the name of the existing Virtual Server, the option to i...more >>

I am having trouble with doing an intsall for a SQL 2005 failover cluster. The Windows 2003 R2 cluster already has theCluster service intsalled and working. I can fail over the cluster with no problem. During the install for the SQL 2005 cluster I get an error message right at the end when the...more >>

Hello We have 2 servers running SQL 2000 Enterprise Edition SP3 in Active/Passive configuration with 12GB of memory. We have allocated 7GB using AWE enabled for sql with 5GB remaining for the OS and future instance. My question is, we are trying to move to an Active/Active multiple SQL ...more >>

My company is moving to SQL 2005 from an SQL 7.0 active/active cluster. The issue is this. In the SQL 7 active/active cluster, referencing data sources required only referring to the server name (ex. DBSERVER). With an SQL 2005 Multi-Instance cluster, the instance name must be specified for ...more >>

Hi, Can DAS be used as shared external storage for SQL Server clustering? Thanks in advance, Leila ...more >>

We run a clustered instance of SQLServer 2000. Seems to run great, fails over like it should, etc. I’ve been charged with the task of writing some software to create backups at regular intervals during the day and then ftp them offsite so that if anything ever happens here, we should have ...more >>

Why would one use Veritas Clustering over SQL Clustering ? Do let me know the pros and cons. Thanks ...more >>

When I try to start my mirror, I get the following error: My mirror server db changes from "restoring.." to "in recovery"... But thats about it. I have been following along, I restore the database, checked the proper restore mode. ideas? TITLE: Database Properties ---------------...more >>

Can the mirror server also host principal databases? So, two servers, mirroring to each other, but then if one fails, the other takes the full load and becomes the principal for all databases? Dennis ...more >>

We are interested in a clustered/high-availability SQL 2005 system. Basically, we have two physical servers we wish to dedicate to this. Each has their own drives, neither are fancy, (P4 3.0 gig with 2 gig RAM and SATA HDs), but we would like to prevent as much down time. We have two copi...more >>

sql 2005 sp1 has been released officially? ...more >>

Hi, I have a standard "3 Active + 1 Standby" SQL 2000 SP3a cluster configuration. There are three named instances on each node. The data and log files are on SAN storage. Lets say the setup is as follows: SQLP1, SQLP2, SQLP3 & SQLP4 are the physical nodes. SQLV1, SQLV2, SQLV3 are the virt...more >>

Hi, Is there anyone that has experience with AMD dual core on SQL 2005 cluster? Thanks ...more >>

I have recently setup an active/active SQL cluster and am wondering what is the best way to reboot the 2 node cluster. If I do a rolling reboot I will dissrupt the connection to the SQL server 2 times (once when the DB rolls off server A, and once when it rolls back onto server A), If I shut ...more >>