I have an Active/Active cluster with Windows 2003 with SQL Server 2000. I am trying to move the cluster disk T: owner to my other group. I keep receiving the following error: An error occurred attempting to change the group of the Disk T: to 'Other Resource' Group. The cluster node is no...more >>

Hi all, we have a w2k3ee server cluster running one instance of exchange as failover cluster. We now would like to use the passive node for a sql instance. A seperate drive has been installed and initialized. The cliconfg has been run and a named pipe alias is created. Running setup ends...more >>

Hello everyone... I'm trying to setup publishing on my 2 SQL servers for backup purposes. Main SQL server - (win2k)2 node clustered sql server with ip address of 192.168.0.245 Backup SQL server - (win2k)ip address of 192.168.1.2 I have a VPN connection set up between the two. I also ha...more >>

Hi all, I have a windows 2003 cluster with sql-server 2000 sp3 and a named instance. I wanted to installation the hotfix ..859, but the installation failed and I got the error: "The logged on account does not have administrator privileges on all possible owner nodes of the selected SQL Serv...more >>

Hello, I am not sure how to approach this problem. What I need to do is setup failover as well as data copying. I need to setup clustering on two nodes. If one node goes down then the other node should pick up the load. But the problem is that you need to have a shared SAN. Is the...more >>

Hi, I have a scenario which works fine on a non-clustered SQL server, and I now want to implement it on a clustered SQL server. In a stand-alone, non-clustered environment: - I have local Windows security groups on the machine; call the groups MyGroup1, MyGroup2. - I grant these groups log...more >>

Does anyone have a good diagram? I have seen for single instance cluster at microsoft site. Thanks...more >>

My friends: I need document information about the installation process of SQL in Cluster with two instances, both active, one in each Server. In summary I want to install a Cluster of SQL Active-Active, for take greater benefit of both Cluster nodes. Even though I have looked for in...more >>

Hi Guys, I AM USING DISTRIBUTED TRANSACTION WITH sql server 2000 on win2k working fine. but the same transaction not working in win2k3. i am getting the following error. Server: Msg 7391, Level 16, State 1, Procedure P2, Line 5 The operation could not be performed because the OLE DB p...more >>

I just set up a cluster attached to a SAN. I have had it where the cluster service on one of the nodes doesn't start up right away. I have checked the services to make sure that it is set to automatic which it is. Both nodes are current with the latest patches and security updates. I'm a l...more >>

Hi All, We have a critical 24x7 SQL cluster (W2K), which is a member of an NT 4 domain. As hardware is getting old, and NT4 domain is going to disappear in the near future, the cluster has to be re-newed. There is also a trusted Active Directory domain, which holds about all user accounts and ...more >>

We received the error listed below last month on our SQL Server 2000 cluster server with Windows 2003 server. Please help me resolve this error. Thanks, 2005-12-23 09:26:06.49 spid119 BPool::Map: no remappable address found. 2005-12-23 09:26:06.50 spid93 BPool::Map: no remappabl...more >>

Hello Everyone, Here is my situation: I have stand alone sql server 2000 and with 2 databases. Unfortunately that server, which was supposed to be able to handle the workload of both database and database apps, is not able to do so. So I am looking into setting up something to distribut...more >>

Looking to do a Windows Server 2003 build for Exchange \ SQL Server and been researching about the new Storport driver model as per link below. All sounds good, seems the best way to go but wondering if anyone here has real world experiences to share ? Number one concern is stability obviousl...more >>

Hello All Whats the recommendation for memory configuration on a single instance SQL2000 cluster running on Windows 2003. Each node has 8GB RAM. Do I still have to use the /PAE switch in Boot.ini to allow the OS to see 8GB or does 2003 see it all OK? Do I have to still enable AWE in SQL ? C...more >>

I have an (ex) active active SQL 2000 cluster on which one of the nodes has melted. I am going to need to replace the OS disks on the node and start from scratch with it. As my dbs are intact on the shared storage and the other original node is running ok, what is the best way to reinstall SQL o...more >>

Hi, Is it best practice to use SEM or the Services applet to stop SQL2000 on a failover cluster or is there a way in Cluster Admin? Thanks Chris Wood Alberta Department of Energy CANADA ...more >>

Hi all, I am new to server clustering and SQL Server, and have a client that needs his server to be up 24/7 (911 Dispatch center). We have proposed a Windows/SQL Cluster, but I'm having trouble finding good information on how to implement this. Currently, the client has one Windows Server 2...more >>

Hopefully someone out there maybe able to help on this one. We are having a great deal of difficulty installing SQL 2000 Enterprise onto a Windows 2000 Advanced Server Cluster (with SP4) using HP hardware (and a fibre attached shared disk array). We are just after a active/passive scenario. Af...more >>

Hello ! ^^ I'm Jae sik in South Korea I have win2003 (64 bit DataCent Ed) and sql 2000 64 bit Ed. and 1:1 Cluster I wants Confirming the Jobs on the sql server by use query How can i do this ? Thanks. ...more >>

Hello, We are planning to implement logshipping as a failover solution. I did the whole logshipping setup and also while setting it up i checked the radio button ASSUME PRIMARY ROLE. Now the question is assuming all the users have been setup correctly. What the correct steps to do in case of ...more >>

Hi, there are particular precautions about install Oracle 9.2 client software on a cluster running SQL 2000 (SP3) ? Can You tell me if there is doc. about? Thank You in advanced, Andrea...more >>

I have a 2 node cluster, we are getting rid of one of the servers and will not replace it. As of right now I have about 85 people across 3 sites who access to virtual server by name. I want to decomission the cluster node (I assume I can just uninstall the cluster service on node B which is...more >>

Hi, We have been looking at Stratus and Marathon Technologies for High Availability solutions for SQL Server. Zero time is a requirement as well as not having to make our application "cluster-aware". Microsoft Clustering requires application modifications and almost 2 minutes of downtime fo...more >>

I have two matched servers, one will be Active and one will be Passive. The servers have Windows 2000 Advanced Server and I have SQL Server 2000 Enterprise Edition. My question is, do I also need a box called a Shared Disk Array, or can I use another server I currently have that has lots of di...more >>

Hello, My database is 1gig big and it has so far one table with 1 melion records. Once I tried to create the primary key in this table but it was rejected by MS SQL since it was not unique. That's fine with me but I noticed that my database doubled in size to just over 2 gigs. Then I create...more >>

We consolidated sending SQL Server mail from one box in our enterprise, which has worked out well for us. Now we'd like to consolidate servers/databases and put it under a clustered environment. But how do we handle the mail ? Thanx. -Cqlboy...more >>

My current cluster configuration is Active/Passive, I'm exploring a change to Active/Active, but I haven't been able to find any informaon on how to do this, has anyone ever done this? My reason for considering this is the size of the current server, and the need to bringup other applications...more >>

Is there a documentation on how to rebuild one node of an active/passaive SQL Server cluster from the O/S up with the SQL Server in use by the other node? ...more >>

I have a 2 nodes active/passive SQL Server 2000 cluster running on a Windows 2003 server cluster. When I shutdown the active node and then the failover is starting to work. I can see all of the SQL Server services has failovered to passive node in Cluster Manager and no error or warnning m...more >>

I am in the process of setting up a new exchange cluster on a pair of Dell servers. I have three physical disks that appear in the disk management console. On the primary node I wrote a signature to each of them while the secondary node was offline. I then created partitions on each of the ...more >>

I've read and heard some conflicting information about the best method for setting up a MSDTC resource in a cluster. I am running MSSQL 2000 SP3a and Windows 2003. 2 node cluster with currently only once instance of MSSQL with a great chance of growing. A few questions I have: Should the re...more >>

I have a 2 node active/passive sql server 2000 sp3a running on Windows 2003. Whenever I run a distributed query I get the following error: MSDTC on server 'VirtualServerName' is unavailable Does anyone have information regarding this problem?...more >>

Hi, I am a newbie to Clustering so please bear with me. We have a db environment set up with Win 2003 and SQL 2000 connecting to a single disk array. The question I have is, what is the difference between the Cluster IP Address and the SQL IP address. What I really want to know is what...more >>

Hi I have read most the articles and posts about move sql server. Here is my situation: I have stand alone standard sql server 2000 and with about 40 databases. And I am moving the server to a SQL cluster(Active/passive). I have to use the old name, IP on the new server and with minimum down...more >>

Problem Full-text indexing option is greyed out in the enterprise manager. Setup SQL2000 sp3a running on windows 2003 cluster. (Default install with SQL Fulltext) All resources are on line, including SQL Server Fulltext. No errors reported in the event log. Changes Made which may have an...more >>

Hello, Is it possible to deny access to local NT administrator and one specific domain user on sql server cluster? The cluster runs under domain user account with adminstrator privileges on the local machine, I have another domain user account, it is my personal account - but this one s...more >>

If I want to put one server in one datacenter and the other server in another datacenter what are the limitations of the heartbeat? ...more >>

I have two non-clustered win2k servers (advanced server) with SQL Enterprise installed with local storage. Production use has already started on a limited basis. Would it be possible to to in place clustering using the following steps? 1. Installation and configuration of additional hardwa...more >>

I've come across a Transact-SQL statement as follows: -- Statements start here select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from sysobjects where type = 'U' -- end here Questions: (1) How should the 'select' statement be interpreted? (2) What are the rules for u...more >>

Hello, I have a Dell PE6650 with only 5 drives(15k). what is the best raid configuation i can acheive for higest performace with this amount of drives. I was thinking or either of the following Option 1 --------------------------- RAID 1 - 2 drives - os and backups RAID 1 - 2 drives - d...more >>

Platform: Windows 2003 ent ed, SQL Server 2000 sp3a enterprise We tried to bcp file into our Failover Cluster SQL Server database, but with serious error: SQLState = 08001, NativeError = 17 Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. S...more >>

Article 301600 (http://support.microsoft.com/?kbid=301600) mentions that MSDTC should be in its own resource group. - What is the recommended size for the physical disk that needs to be in this resource group? - Is it necessary to add the Network Name resource to DNS? Thank you....more >>

We are in the process of implementing a SQL server and are thinking about a SQL cluster on Windows 2003 Enterprise Edition Servers. But money is preventing us buying extra hardware at this moment. Is it possible to install first an SQL server with all the databases and upgrade it later to a...more >>

Please help me determine what could cause the SQL Server 2000 Cluster error listed below. This is a server with SQL Server 2000 Enterprise Edition as an Active/Active Cluster and Windows 2003 Server. Please help me with this error. Thanks, 00000780.0000149c::2005/01/05-18:22:53.035...more >>

Hi, I have SQL2000 cluster on Windows 2003 (2 Active nodes and 1 passive), one of the active server is missing the SQL performance counters, the weird thing is, if I run Perfmon remotely connecting to this node, it will not display any SQL Performance counters but if I login locally to the se...more >>

I have a web application that takes in thousands of financial transactinos a day, as well as displays all this financial data. I just purchased two dell pe6650 with quad 3.0 xeons, and 12 gigs of ram a piece. Would I benifit from configuring these servers into a cluster or would it be more eff...more >>

Hello, I need a value for switching time sql-on-node-1 to sql-on-node-2 (best win2003 cluster, slq 2000). microsoft says 2 - 30 seconds. Is this a real value? Thanks ...more >>

I am newbie in SQL server and have one, maybe dumb question. I have SQL2000 cluster on Windows 2003 with shared storage on SAN. Cluster operates with one database only. I need to temporary attach second database to SQL server, but problem is that I do not have enought free space on shared stor...more >>

Hello, I appreciate any suggestions or comments on the following. We have active/active cluster, SQL 2000, Win 2000. All databases on first instance/node are on drive E, and second instance/node on drive F. We are trying to move all database files to new drives, P and Q respectively. One ...more >>