I have a SQL Server 2000 active/active cluster with Windows 2003 server. What would cause the binaries not to be pushed to the Node on a SQL Server 2000 virtual server installation? Thanks,...more >>

Hi, I'm having the same problem that was posted earlier this month. In the thread there was no resolution of how the issue was solved. Has the issue been solved? If so, how? Thanks...more >>

Is there a command or script I can run from query analyzer to export a database? Its a long story but I can only get to the database through query analyzer and there is one database I need to pull out to another machine. Thanks,...more >>

Am I correct in my assumption? If I am creating a two-node SQL Server 2000 active\active cluster configuration, (cluster will be built on Windows 2000) I can have a maximum of one virtual server name per node and up to 16 named instances per node if I do not use the Default Instance. Thanks ...more >>

Hi, I have set up an Active Directory, Certificate Services on Windows 2003 Server. I am running SQL 2000 Server. AD and Certificate Services were installed correctly. My goal is to be able to use SSL when connecting to SQL Server via Query Analyzer. I also want to keep the SQL Server insta...more >>

Hello all, We are planning to upgrade the drives which are currently being used for clustered SQL, Exchange 2003, DHCP and File and Print Services. We pan to do the following: 1) Add the bigger drives 2) Copy all the data from the existing drives to the new drives 3) Change the new drive ...more >>

just a quick background SQl 2000 running as a cluster. We started a merge replication and had problems so i removed it. we had probelems with the database after I removed it so a programmer suggested I run a fixrep.sql script to remove traces of replication. After I ran the script the ins...more >>

What is the Best Practices way and quickest way to move a SQL Server 2000 Virtual Server database to a new server. This a production server with numerous users and the server can be down for only several hours. The server has Windows 2000 Advanced Server with SQL Server 2000 (Active/Activ...more >>

Hello Everyone, I am very new to the forum so I need to put my question based on SQL query. Is it the right place or if anyone can give me the link, I will proceed!!! Thanks ...more >>

Hi all, Does anybody know if the XPSMTP extended procedure (or any mail sending functionality for that matter) works (safely) in a clustered (active-active) SQL 2000 environment running on 64-bit Windows 2003? I decided to ask before trying, because the 64-bit environment is said to be ver...more >>

I have a very basic question regarding nodes in MSCS running sqlserver2k. I'm trying to understand what it means to load-balance. I thought load-balancing meant that if I have 3 nodes in the MSCS & all running sqlserver2k, the nodes point to single database on a shared storage. Basically, lo...more >>

I have documentation for Win2K which says run comclust.exe to add MSDTC . Running the same brings up the Admin window. Please point me to some documentation which clearly describes on how to setup MSDTC on win3K cluster Thanks ...more >>

Hi I am getting the error message listed below while starting my SQL Server on a cluster node, the server is up and running just the sql server is not starting this is the error message which i get from event viewer [sqsrvres] checkODBCConnectError: sqlstate = 28000; native error = 4818...more >>

I received the following error when installing the SQL Server 2000 on a WIndows 2003 Server : Setup failed to perform required operations on the cluster nodes. You may also receive one of the following error messages in the SQLSTP or the SQLCLST log files: Process Exit Code: (2) The system...more >>

Hi I need to move the transaction logs for all the sql db's (including master, model and user db's etc) to a seperate drive. Does anyone have any experience doing this in a sql cluster? Thanks -- Parky...more >>

Hi, I have two identical servers. I want to put Win 2003 Enterprise and SQL Server Enterprise on both of them. The data will be written to and read from the database. Is it possible to build a cluster with two independent sets of hard drives on each server (Server1 with his own hard drives in...more >>

I am looking for the Microsoft instruction to install SQL Server 2000 on Cluster with Windows 2003 Server operating system. I start the uninstall of SQL Server 2000 with the following error. "Another Virtual Server of the same name exists on the network" Please help me with instructions...more >>

Hi, I have set up an Active Directory, Certificate Services on Windows 2003 Server. I am running SQL 2000 Server. AD and Certificate Services were installed correctly. My goal is to be able to use SSL when connecting to SQL Server via Query Analyzer. I also want to keep the SQL Server insta...more >>

We want to set up another office as an online disaster recovery site. Can I clister between two SQL servers over a T1?...more >>

I would like some advise on my plan to install an active/active sql cluster. The plan is to build 2 boxes with W2k3 server and SQL2003. I'll have 13 drives on a shared disk storage (two sets of mirrored drives) (two sets of Raid 5 [4 drives each]) (1 global hot spare). I'll create a 1 Gig l...more >>

Hi, I have to move an entire SQL Server system databases from current basic drive W: to new SAN drive H: in cluster server (current is one node with two instances). During the installation, I put Program files to C: drive and Data Files to W: drive. After move all dbs, we will get rid of dr...more >>

Hi, I am presently running Windows 2003 cluster with SQL Server 2000. My question is what is the correct way to apply Critical Updates to a SQL Cluster? Thank you in advance for tour assistance! Bob ...more >>

Hi! I have a server I am planning to cluster. I will be using the same SQL server name for this cluster. I have a large number of transactional replications to this server from a dozen of other servers. Will these replications work evenly after the clustering? (All my servers are MS SQL200...more >>

Where can I find a complete step-by-step article on installing SQL 2000 Enterprise Edt. in a Windows 2003 Enterprise Edt.Cluster? We have purchased 2 Dell 6550 servers and a EMC CX300 fiber channel array. Dell is going to setup the cluster but I have to install the SQL 2000 server softwa...more >>

I have W2KAS, SQL Server 2000 active/passive cluster with cluster MSDTC resources. I use NT Task to execute DTS package via DTSRUN and package requires transactions. If the task is run as administrator or a account with cluster administrive right, everything is fine. Otherwise, I will get the...more >>

Hi there, I have a two node cluster Win 2k with SP4 and SQL 2k with SP3. There are two instances of SQL. The primary instance comes up just fine. The secondary does not come up all of the disk, IP, and name resources load, but the SQL Server resource will not. I have been able to get it...more >>

Hi, We have one cluster with 2 virtual databases and name instances VDB01\DB1 and VDB02\DB2. They use different storage on a SAN. Machines are DL380s with 2 CPUs. OS: Windows 2003 Enterprise Server, SQL 2000SP3a. Now both of them have the same database Data1, Data2 and Data3 Existing scen...more >>

Hi! We are planning to replace our disk system in our SQL Server cluster environment. Our system consist of two cluster nodes and two SQL Server 2000 instances. There are only SQL Server database files including master database in this disk system we are replacing. Can we just shut down ...more >>

Is there a reason why the SQL 2000 installer would not be running on 2003 Web edition?...more >>

How does one use the SQL virtual device interface (vdi) in a SQL Server cluster? The VDI connection command only accepts a parameter for instance name, not server\instance name. Thanks in advance. Regards Ray...more >>

We have two active clustered sql servers and two separate IIS Load balanced servers. We can connect to both instances of sql server Enterprise manager and query analyzer (also tried an odbc connection) thru local pc's. I can get both IIS servers to connect to the default sql server instance us...more >>

Hi, In MS Clustering the failover happens only at hardware level or it can also happen at application level? I mean If I am running two nodes, node1 & node 2. both these servers hardware has no issues but SQL server on node1 has some problem, will it be able to use SQL server on node2? ...more >>

I have a Windows 2000 Advanced Server with SQL Server 2000 Cluster. There are only two nodes on this cluster. Two days ago I tried to move one of my resource groups to the other node. It failed each time I tried. I am presently in the WINNT\cluster.log file but there is only several ho...more >>

I'm not able to start the cluster service on the 2nd node of our cluster. O/S is 2003, with SQL 2000. The 2nd node is passive, and appears to join the cluster but then it terminates unexpectedly. We've tried using the Administrator account to start the server, but with the same results. ...more >>

Hi, I'm trying to install a 2nd instance on a cluster. We've setup two cluster groups C101TC001 and C101TC002, one for each instance. I've stopped all the services and managed to get the installation to run, but it won't allow me to apply the Service Pack (3a). It reports an error An er...more >>

Hello, I have an A/P W2K3 Cluster with SQL 2K-SP3. When I fail it over to the passive node, only the virtual server name is available, not the SQL IP Addr I have a A/P NT 4 Cluster with SQL 7 and the name and Addr fail over.. In the cluster Admin, both servers are listed unbder the SQLIP ...more >>

Hi, How can i upgrade sql 2000 64bit local default instance to clustered instance? i can't find "Upgrade your existing installation to a clustered installation" choice in sql setup. I can do new virtual instance but can't upgrade local instance. Any help? Regards, Petri...more >>

Everyone, I'm installing SQL Server 2000 SP2 virtual server onto a Windows 2003 Cluster. The install process seems to install sql server fine on both machines, however when the installer gets to creating the virtual resources the install fails after about 5 to 10 minutes. I've looked at the s...more >>

We just build our first 2 nodes cluster on Windows 2003 / SQL2000 SP3a + HF 818. Does anybody knows if there is any other HF need to be applied on Windows or SQL running cluster services before we go live? Thanks Ayad ...more >>

We have 2 SQL clusters where the SQL Server cluster resource fails but if you go to the SQL Manager, you can start the service and query the DB. Has anyone seen this before?...more >>

Proliant DL360 G3 w/hyper threading 2 physical CPU, 2 gigs of memory MSA 1000 Windows 2003 SQL 2000 SP3a Active/Passive failover clustering We are noticing the performance worsens over time in our SQL cluster. The performance happens across different stored procedures, so it ...more >>

I'm doing an investigation into moving our database server to a database cluster. One of the questions I haven't been able to answer is how are schema changes to database instances handled? Is there some magic involved in making schema changes and having them propagate to all the other nodes, ...more >>

Is it possible to change the current SQL virtual host name in Windows 2003? and How? I tried it by right click on the SQL Network name resource -> properties -> parameters -> change the name. Then search the registry and change it to a new name and reboot the node. It works but is there an eas...more >>

Hi everyone, We have a Windows 2003 Server NLB Cluster getting data from Windows 2003 Server SQL Cluster. Occasionally we get Connection Timeout Errors when trying to connect to the Virtual SQL Server. After restarting SQL Server from Cluster Administrator it gets back to normal. I am not s...more >>

hello everyone, i tried this question in olap room but there was no reply. i had a question regarding Expectation-Maximization algorithm used by microsoft for data mining in ole db. Does anyone know how good this algorithm is when compared to the latest clustering algorithms like chameleon, c...more >>

I have MS SQL 2000 Server SP3 cluster in active/active mode, windows 2003 with 4GB of RAM and 2 Intel Zeon CPU of 2.80 Ghz. In the SQL Server Logs appear a lot of messages like this... WARNING: Failed to reserve contiguous memory of Size= 65536. Buffer Distribution: Stolen=2570 Free...more >>

Hi all I have just installed a SQL2000 cluster on Win2000. The last thing I did was install sp3a from Node A (both Nodes were online) Checked the version by using @@version - both instances came back with sp3a. However, in EM, Node2 is showing in properties as RTM and Node 1 is showing ...more >>

Are there any 'gotchas' that one needs to consider before running this on a single node - anything different than a stand-alone server? Thanks! Darryl Pollock Squirrel Consulting ...more >>

Hi, I'm currently looking in the possiblities for a SQL server install. The web project needs a SQL database with a high availability. Speed and size are not that important as the load will be medium (especially for the new enterprise class servers), but it cannot eb offline for more then m...more >>

I need to change all of the ip's on my two node cluster including the nic cards and all of the virtual devices. What i am asking what is the best way to do this with out crashing the whole thing. Also i need to get this done today!!!!!...more >>