Here's the setup: Windows 2003 Enterprise (Fully Patched) SQL Server 2000 SP 3 Quorum(E:) and Data(F:) disks on same external SCSI Raid Here's the problem: I've lost the ability to do anything to Data(F:) drive. I am able to work with Quorum(E:) disk with no problems. Her...more >>

Hi, Can we do this: Configuration: A 3-node SQL server cluster that uses a majority node set (MNS) quorum. The quorum would be an MNS quorum where the quorum is stored locally on each node's system disk. There is no shared storage. Each node has an internal RAID-1 mirrored disk. So it ...more >>

Hi! I'm about to install Sql2k in a cluster enviroment. The problem is the collation. In my other Sql2k database servers (non cluster) i did an unattended setup, in the unattended file I wrote the collation I wanted because it cant be chosen in the installation of Sql2k. Sql2k installation in c...more >>

Hi! I have a problem with linking two servers. I have created a login called "linked" and set full permissions to the pubs-database on booth servers. When I first create the linked server and linked server login on server1 everything goes fine. And I can connect to server2:s pubs-database...more >>

Hi I had a sql 2000 cluster with 2 node active\active and I would like to rename my sql default name to another name but MS recommend to uninstall and reinstall sql If I uninstall just the default name.Will it create any impact on my second instant name? Have any one done this before? Pleas...more >>

Hi all, I need to know how to install sp3 of sql on my sql cluster.Sql server runs properly now.Is there any notes to pay attention to while installing the packs? What shuld be the best pratices and best procedures for it. Thanks a lot. ...more >>

I understand it is recommended to have a private LAN for inter-cluster communication but we are not able to do that due to resource limitations. We have one network interface on each node in the 2 node SQL server cluster (no room for expansion). Each port goes to a switch where there is o...more >>

MS SQLSever service accounts should not be members of the local Administrator or Domain Admins groups. Is this also troug for SQL Server Cluster? Many Thanks John...more >>

Hi I've got a big probem, my service accounts for the cluster and sql are losing there password from time to time. So I can't move the cluster resource. All servers are W23, 2 AD Controllers, 2 Cluster Nodes. Any ideas to solve this problem? Thanks...more >>

Have cluster running on two servers; suppose I lost both of them, but have a tape backup of the cluster. Does anyone have some thorough directions on restoring the cluster on different servers? We've had no luck in completely making the restore function....more >>

Hi, We have a W2k3 cluster with a group MSSQL 2000 sp2. Now when we try to start the setup for MS SQL sp3a it stops saying that it cannot detect the satus of a service. We have applied a security template which might conflict with MS SQL sp 3a. In security log we get message as below : Does ...more >>

Hello: I took the MCDBA exam last week. I almost got over the hump, but one question on the test (related to the Subject:) left completely stumped. If you can provide any help, I would be most appreciative. The gist of the question is: -------------------------------------------------------...more >>

I have a Windows 2000 Advanced Server with SQL Server 2000 Enterprise Edition with SP3A. The cluster is set up as a Active/Active cluster. What would cause the Cluster File Share resource to fail? I have a file share directory set up so that if my server fails over the file share dir...more >>

I understand it is recommended to have a private LAN for inter-cluster communication but we are not able to do that due to resource limitations. We have one network interface on each node in the 2 node SQL server cluster (no room for expansion). Each port goes to a switch where there is...more >>

You would think this would be relatively staight forward as they are both Microsoft products. Now the issue is that when trying to run the sql 2000 setup the installtion always bombs out out when I enter the remote information ie either the designated sql service account or the administrator's...more >>

Is there any way that we can use two drives on a single database and server. Example, my database is located at drive C and that drive becomes full. Is there anyway that the data will automatically written to the second drive (Drive D for example) without user intervervention? If so, what ...more >>

on the passive node i tried to set range port for DTC I tried using dcomcnfg, but when i reboot the node cannot join the cluster. Why ? thanks in advance. Regards, Dario ...more >>

Hi All We're doing a demo tomorrow. However we only have a single node available and SQL 7 clustering wizard tells me that there is no cluster. There is, but its only a single node. Everything else is in order re disks, resource groups, services, etc. Am I to take if from this that SQL Server...more >>

My cu has the Win2003 Cluster 4 nodes with 1 Default and 3 Named instances SQL 2000, each instance is on different node, we noticed that every instances have configured with TCP port 1433. Is it possible on Cluster??? Hello.K ...more >>

Reading some previous threads, I am a little confused. We have 2 Windows 2003/SQL 2000 clusters. One has been in production for months now, without problems. We did not follow KB 817064 (how to enable network DTC access) or KB 301600 (configuring MSDTC on 2003), yet our install went fine and S...more >>

1. This is a different cluster with 2 nodes. I was not involved whatsoever during the setup and install. Therefore I have no idea what Server Admin did; 2. Win2k Advanced, SQL2kEnterprise SP3, 2 Nodes, SQL Default instance; 3. There are 2 groups configured under Cluster Admin: Cluster...more >>

Hi Guys, I implemented log shipping but if database is open during load the restore is failing. i think i selected "terminate users in database" option. how i can confirm whether i selected this option? and how can i change this. THNKS BIJU...more >>

Hi all, I have some trouble with SQLAgent...when I try to schedule a job that invokes a script (vbs, java, cmdshell,...), SQLAgent crashes at the moment of scheduled execution. If I try to execute it manually, all works fine. This installation runs on a cluster Win2003 and the node initiate a fa...more >>

I've upgraded our SQL2k server to cluster using Dell 2650's attached to Powervault chasis -- U320 all the way through. Our db's are 90% read, and performance had degraded significantly. Anyyone able to suggest a better external raid config and still keep my u320 15k scsi disks? I see the Hp offeri...more >>

I would like to setup SQL Enterprise in a 2 node cluser to act in a "active/active" form. I may be using the wrong termanolgy. I would like to have both SQL servers handle client requests for the same database. In the event if one node fails the other node will handle all of the traffic....more >>

Hi, My end goal is an active-passive sql2000 cluster running on 2 windows 2003 ee nodes. I have installed the os, got the san drives recognised and setup the cluster. then i run sql2000 setup: specify virtual,name,ip specify default instance name specify drives install options setup...more >>

I'm a newbie with a big load, and I would appreciate some insight. In my environment, I have an active/active cluster, that also has Snapshot Replication from the slave node to the master node. Can someone offer some guidance how to apply the SQL SP3a service pack? In the Service Pack 3...more >>

I'm in the process of setting up my first W2K3 / SQL 2000 cluster and I have a few questions with regards to MSDTC. Documentation I have says that MSDTC must be clustered in order for SQL clustering to work. It also says that you cannot use comclust.exe anymore and that MSDTC must be setup in i...more >>

In a two node SQL server cluster, with each computer in the cluster storing the database on its local hard drive, is it OK to have the quorum drive on a NAS/network server. So the database will be direct attached on one server. The database will be replicated to another computer with a di...more >>

Hi, We have a SQL 2000 cluster server. We need to run a query on an access database. We have set up a linked server, however we always get the error; Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned m...more >>

I'm planning on installing SQL 2000 on a 2 node Windows Server 2003. I want to have both nodes to be active SQL servers and they will both be available for each other in the case of a Failure. Any issues regarding this tipe of setup? Is there a way to setup the second node without havin...more >>

See error below "An error occurred while creating virtual server resources for clustering. The system cannot find the file specified."...more >>

Hello, We are setting up a 2-node active/active SQL 2000 cluster on Windows 2003 ent. ed. Our DB team writes MS Access XP front-ends for client connection to SQL cluster. NODE1 and NODE2 are working fine. I can fail INST1 over to NODE2 and INST2 over to NODE1, vice versa, all is good. Ho...more >>

Does anyone have a good starting point for creating a "high availabilty" solution. I'm working on designing a solution that will allow for us to have a primary site in Orlando and a secondary site in another state. The system needs to have data moving in almost real time between the master and s...more >>

Hi Guys, i am managing an OLTP system using sql 2000 and these system is running for last 4 years and now having 25 million records for main transaction table. is it advisable to go for OLAP Systems to get fast summary report. if so pls advice me how i should start. Thanks Biju...more >>

i was deleting a disk resource from our cluster, the sql resource depended on that disk, when i was asked about deleting the dependent resources i clicked the delete option, so now i dont have any sql resourse. now i can´t see my SQL anymore even whe i try to create a sql resource manually. Wha...more >>

Is SQL Server clustering supported/recommended using a NAS/RAID to hold the database? Here is the hardware setup Let's say there are 25 computers on a network. Two of these computers are running as a 2-node SQL server cluster. The database resides on the Z: drive. The Z: drive is a NAS....more >>

Currently, we have two sets of SQL 2000 cluster servers in two different regions. We are trying to implement log shipping for redundancy. Does log shipping require a share from the Operating System stand point?...more >>

We have a SQL 2000 cluster that is running on two Windows 2003 Enterprise boxes and everything works fine, except that after the cluster has been running for a while (24 hrs.), if you fail the cluster over to the failover node, then when you go to fail it back to the primary node SQL spits an SPN...more >>

If a customer has a na application that accesses SQL server running on a single machine (Windows 2003 Server) and then decided to implement an active/passive server cluster with SQL Server Enterprise, does the application that accesses the database need to change? I am not sure what is m...more >>

Hello. I was given the task to cluster our existing standalone W2K SQL server. I've purchase a new server from Dell along with an external SCSI array plus 2 SQL2K Enterprise and 2 W2K Advanced CDs for both servers in my future cluster. We have an existing W2K SQL Standard running on a W2...more >>

Security Best Practices tell us to remove BULITIN\Administrator from SQL Server Logins. Is this also true in SQL Server 2000 Cluster. Many Thanks John...more >>

I am looking to go into a DBA role and I keep hearing about clustering servers. Is there anywhere I can go to learn about it? Or can someone please tell me what it is and how to set it up? Thanks, GP...more >>

I've got 2 Arrays on my SAN. Array 1 is 66 gb. Array 2 is 230 gb. I've partitioned the drives in MS2003 this way: Array 1, Drive Q: (Quarum) 2gb Array 1, Drive S: 64gb Array 2, Drive R: 230gb. I installed SQL Server after setting up MSCS. Everything went fine. Now I want to add the ...more >>

I'm not sure this is on topic for the group, but someone here would know I have a question about a too good to be true deal on ms sql server 200 ent 1 processor license being listed for sale on saveintheusa.com for $3,245. This just seems completely unreasonable considering the list price is 20...more >>

Hi, We want to run a two node server cluster with Windows Server 2003 Enterprise and SQL Server 2003 Enterprise. How many copies of SQL Server Enterprise (1 Server, 25 clients) do we need to purchase, 1 or 2? Since it is only actively running on one server at one time, I would think w...more >>

Hi, i try to install a SQL2000 on Windows 2003 Ent.; i enable Network DTC and manually configure a MSDTC Resource reading the article : http://support.microsoft.com/default.aspx?scid=kb;en-us;301600 http://support.microsoft.com/default.aspx?scid=kb;EN-US;811054 After verified the MSDTC Re...more >>

Hello everyone! We currently have a one node cluster (w2k3 and sql2000ent) and have had it this way for a while waiting on the second server to arrive, well, the time has come and now we are about to install the second node in this active/passive cluster. I have been reading in booksonline ...more >>

Two 4GB mem clustered sql servers. Two sql instances. If leave 1GB for the OS. 1.5GB for each instances. Still need enable AWE? Thanks a lot!!! K....more >>

Hi, If I have an existing SQL 2000 server that I want to move into a cluster, will I need to reinstall from scratch, or can I simply upgrade the OS to Enterprise, then upgrade the SQL to enterprise? Of course, my goal is to leave the data intact (the data is already stored on a SAN, not local). ...more >>