Hello, Do i need SQL 2000 Server Enterprise edition to set up a cluster or will it work with SQL 2000 standard? Thanks, V...more >>

Hi all I am the SQL DBA for an organization. We have an active/passive 2-node SQL 2000 cluster running on Windows 2003 Server. So far, it has been very stable (knock wood) Somebody here wants to add FoxPro as a clustered application onto our (failover) clustered database server. My gut tells ...more >>

I have not seen any documentation on how to Convert from Active/Passive SQL Cluster to Active/Active SQL Cluster. Could you point me in the right direction? I am hoping that it will not require a re-build of the system. ...more >>

I just rebuilt a 2 node W2k/SQL2k cluster that resides in a NT4 domain. The cluster itself seems to be working fine, the website that runs off of the virtual SQL server is running fine. However, both nodes in the cluster are not able to communicate with other machines in my 2 other tru...more >>

Following this article, "Create a Group Named "MSDTC Group" that contains a Physical Disk, Network Name, and an IP Address. To do so: 1.. In the File Menu, and then click New , and then click Group. The New Group Wizard is available. 2.. Follow the instructions that the New Group Wizard p...more >>

I was hoping to install an active/passive SQL 2K Cluster on Windows 2003 and the sql install failed with the following error setup failed to perform required operation on the cluster nodes Heres are the contents of the sqlstp.log file 16:18:17 Begin Setup 16:18:17 8.00.194 16:18:17...more >>

How do I determine if the Cluster Group was moved before reboot the one node on a Windows 2000 Advanced Server? I have Active/Active Cluster with Node A and Node B My goal was to move Node A resources to Node B and reboot Node A and then resouces back to Node A. I think the Server Adm...more >>

We are doing a feasilibility study of using SQL Server cluster for load balancing. Our clients will be running on Linux/Apache, connecting to SQL Server using JDBC. Some c++ client tools will connect using ODBC. Based on my limited knowledge of SQLServer clustering technology, it seems that it...more >>

Is there anything different to setup a MSDTC cluster resource other than running comclust.ext in windows 2003 ? ...more >>

While setting up windows cluster in 2003, my external array which is logically partiotioned into P and Q appear as one disk group. If i wanted to setup an active/active SQL cluster, how can i seperate into 2 groups, so that one node owns P and SQL instance 1 has data files on P and the other nod...more >>

Setting up sql 2K cluster (single instance) on win2003 Does the path for the program files have to reside locally i.e on the local disk subsystem and not the shared disks ? Also my internal array i.e. local disks are broken up into C and D drive.. When i install SQL on node 1 and spe...more >>

Setting up sql 2K cluster (single instance) on win2003 I already have win2003 cluster service setup. I have a virtual server name and a virtual IP.. Now when I install SQL , what do I enter when i select virtual server ? Do I put in the same name as the Win2003 virtual server name I ent...more >>

I managed to successfully install the Windows clustering service on Node 1 of my active\passive setup environement on win2003. The only thing i had done on Node 2 was install the OS and did not configure the shared disks on the shared array... I now powered Node 2 and wanted to go to disk ma...more >>

Hi! I have a customer with a 2-node active/active sql2k cluster hosted on w2k. We now want to run this on w2k3 and we also want to build up the cluster to have a 4-node active/active/active/active sql2k cluster. Our plan is to do it in two steps as follow. We take the current 2 nodes of...more >>

Hi, I have installed SQL 2000 Enterprise Edition SP3 on a Windows 2000 SP3 Cluster. Everything went perfect. The database server is running. But when I initiated a failover to the other node, the SQL Server Cluster Resource fails. In the event log on the node where the resource failed I get...more >>

I want to setup SQL clustering but I seem to be hosed at setting up Windows Clustering. I want to setup a single instance ( Active/Passive ) using Windows 2003 EE and SQL 2000 When do i power up the second node ? Is it only after you configure Node 1 and even set up the cluster service ? I see...more >>

I would think there should not be a problem, but I just want to make sure. We have 2 win 2k servers in lets say Cluster 1 (running sql 2000). We are wanting to upgrade these 2k servers to 2003 server (obviously running sql 2000 since we don't have a choice). Our plan is to fail one s...more >>

Hi, We have recently setup a new cluster server. At the moment the resources have swapped over so that 1 is running on node 2 and vice-versa. However this appears to be causing a problem with the SQL scheduled tasks. All tasks in the list have (Date and Time are not available) under '...more >>

Hi, The Jobs in my sql server 2000 are hanging.The backup job backs up all the 30 databases except 2 of them,but the job never completes. I have to cancel it each time.I dont find any errors in the Win Event viewer or SQL error logs.When I use check db on tempdb I see two temp tables with the...more >>

I have a client that's having an issue where after changing the SA account password the SQL server is throwing a security error stating that the SA account doesn't have access to view XYZ. The application calls a stored procedure that builds a query string that is run against a fully qualified v...more >>

I will be replacing the shared storage system for a 2 node Windows 2000/SQL2000 cluster in a Windows NT4 domain. Replacing Compaq RA4100 with an HP MSA1000. My plan is to completely deconstruct the cluster and SQL virtual server, reinstall operating systems on nodes, recreate the clust...more >>

Almost everybody might have come accross this situation and handled it easily, but we are at the first step in setting up SQL Server cluster. I am contact person for the setup in my organization and I have no idea how to set up, and at the same time the NT person is also new to windows clustering. W...more >>

We change the IP addresses on the cluster and now are having problems with performace. We had to search through the registery and find instances of the old ip address and make changes to the registery. If I had to do this over I would not have done it. But to late now. NEED help. Thanks...more >>

hi,everyone: I insatll sql2000 enterprise edtion on Two node clusting(win2003),using MNS quorum mode,in install sql2000 prosess,apears no share disk.This is problem!please help....more >>

Is it recommended that we not use the quorum drive for any other data storage when installing SQL in a clustered environment. We were wondering if we could put the SQL logs on the Quorum drive. Thanks Bruce ...more >>

Does anyone know the optimal disk block size for running MS SQL Clustered with a SAN. We need to set it on the array controller And will the /PAE switch in the boot.ini change this. Thanks in advance for the help...more >>

At one point, I found some documentation on Microsoft's site for installing SQL 2000 on a Windows 2003 server. For some reason, I can not find it anymore. I have the documentation for installing SQL on a Windows 2000 server, but I was thinking some things have changed. From the SQL side, i...more >>

Installed SQL 2000 Enterprise with SP3 running on windows 2003 enterprise server, when creating database at share disk, got 5105 Error. try add access right for service account to share disk still failure. Please help...more >>

We are in the process of building a SQL server 2003 failover cluster on a 2 node system with a single server in each node in active/passive mode. These 2 servers would also be attached to 2 separate SAN boxes connected via FC switches. The goal of or design is to achieve a fault tolerant system with...more >>

Hi Would like to confirm if the sql virtual server is accessibe from both nodes. My setup is at such 1) Installed Clustering on 2 W2k3 nodes 2) installed sql virtual server on the cluster 3) Installed named instance as well on the cluster. 4) Resource able to failover to both servers. ...more >>

What are the advantages/disadvantages of using log shipping vs microsoft replication? Thanks, Alan ...more >>

I have a Windows 2000 Advanced Server with a Active/Active cluster with SQL Server 2000 Enterprise Edition SP3. I had the Cluster server fail last night and reboot. How could I analyze what cause the server failure not to move over to the other Active node? Please help me with this pr...more >>

Hi, I have a planification and architecture to do : I have to do, On failOver cluster with Win 2003, Installing up to 7 virtuals servers, 1 default and 6 instances because this server will be use by 7 differents clients and I want their administration separetly. I don't want one clie...more >>

h I have a running cluster on win2003. im trying to install SQL but i need shared external storage space. i have a NAS solution on place but it seems like the cluster servers wont point to any file share. they need direct attached storage like in a SAN solution. does anyone out there have a SQL...more >>

Hi Guys, i am using sql server 2000(sp3) transactional replication for reporting server.i found 4 additional records in a table at subscriber. i replicating only tables. btw there are no errors in the log files. any ideas? Biju...more >>

I keep getting an error when I try to set up a merge replication... Cannot insert duplicate key row in object 'TRDFIL' with unique index 'ITRDFIL0'. (Source: CMTSQL2 (Data source); Error number: 2601) I can't seem to figure out how to prevent this from happening, any ideas on what is not co...more >>

I have two Windows 2000 Advanced server cluster servers one for developement (DEV) and the other acceptance (ACC) servers. These cluster servers are set up as Active/Active. These servers are set up as a Primary Process server (Node A) and Secondary Process server (Node B). Several mon...more >>

If one database can be accessed by only one instance of SQL Server, how would you configure SQL Server (and hardware) to work in a large user based environment? Would you split the database off to two or more servers or would you use a multi instance setup on a multi processor server? ...more >>

I have two Windows 2000 Advanced server cluster servers one for developement (DEV) and the other acceptance (ACC) servers. These cluster servers are set up as Active/Active. These servers are set up as a Primary Process server (Node A) and Secondary Process server (Node B). Several mon...more >>

Is sql 2000 enterprise have a way to "slip stream" service pack updates like we can do in windows os service packs install files? I hate having to install sql 2000, then in a separate step install sp3a. Is there a version or does sql 2000 come updated with all service packs included in the ins...more >>

I have a system that we are setting up that has a Windows 2000 Advanced server with a Cluster and SQL Server 2000 replication. The Cluster is set up as a Active/Active. Should I use the same or different database name from the replicated database? When the failovers occurs will it be ...more >>

I have been asked to implement a SQL server environment with a HTML front end accessing SQL data. The data will be accessed mostly to read, but some changes will be made by clients. The server will need to be online permanently, however there will need to be fairly regular database updates...more >>

I run a SQL2K SP4 on WIN2K Ad Server SP 3 in an active/active two node cluster configuration node one hung and had to be rebooted Cluster Log had the message belo Cluster file sahre resource benthas failed a status check Error Code 64 Event Log had the messages below The message in the Event ...more >>

I configured a w2k3 cluster and everything seems to work properly. W are trying to add the MSDTC resource manually to the cluster group bu the resource refuses to start. Here is the event we are getting in th event log. MS DTC setup failed to populate the shared cluster registry. The DTC ...more >>

Hi All I am having problems with the SQL server Agent what the cluster fails over. The Event log is logging an event 103 "SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent Cannot start). The SQLAGENT.OUT log file reads as follows: 2004-03-...more >>

I have a Cluster Server with SQL Srv. Enterprise 2000 + last HF's installed. And i tray to connnect from an IIS (ASP) to my Virtual Server and i get an error (Access Denied), i read a lot of Articles from MS, but i don't have a clear answer to my problem. The question is: What is the difere...more >>

We are looking into setting up a SQL Server system that will be used in a manufacturing environment (i.e. production runs, accounting). I would like to get an idea as to the design that would allow us to run two servers with SQL Server in order to produce the best response time. My goal is to have o...more >>

To Cluster or Not to Cluster is the question folks. We want High avaiability. period We would like to run a Four PeopleSoft Production databases on this *Clustered* Database Server. My Boss is asking me if we should go for it ? We will be investing atleast 70-80K on a indentical pair of servers. C...more >>

Hey folks.. I have a SQL 7.0 sp3 Cluster (A\P) on NT 4.0 sp6a. We are running into an issue where we will get the following errors and then SQL Server will stop and restart automatically. The error is as follows: Error: 17801, Severity: 17, State: 1 2004-03-08 11:56:13.96 ods Unknown...more >>

I understand this is not recommended, but is it technically possible to have a non-clustered Default instance on a physical node and a clustered virtual Default instance running on the same node in the cluster group? I don't see how the operating system would allow for two MSSQLServer services t...more >>