Hello Folks, By tomorrow, I will be installing SQL2000 Cluster on Windows 2003 SP# 1 Cluster and was wondering for any known issues. Since SQL cluster sits on Windows, I will be responsible for both Windows & SQL Clustering. Based on my research, yes, we can implement this scenario but I nee...more >>

I am running a two node cluster. The failover node had a hardware failure and I had to re-install Windows. I have been trying to add the node back into the cluster for 3 days and it continually fails with MSDTC. Mostly it's been complaining that a DCPromo occured but it can't handle it correc...more >>

We have a 3 node active cluster with SQL. FOr a short time (5-10mins) we get alerted via NetIQ of these events: ->Failed to retrieve resource owner of MS DTC/MSCS_ResourceOwnerChange ->Failed to retrieve resource owner of MS DTC/The cluster resource could not be found This has happened o...more >>

Hello, I have a Windows 2003 Cluster running SQL Server 2000 SP4 in an Active/Passive configuration. There are 2 physical nodes and only a single virtual SQL Server Instance in the cluster. There are also 2 Terminal Servers in an NLB cluster at the front end that are running the software...more >>

Does anyone have any idea of what might be the issue? I've tried everything but with no success. I'm getting the following error every time I'm installing SQL 2000 on Active/Passive Win2003 Cluster. This is first time install on a new 2 Windows 2003 Server. I'm getting the error in the mid...more >>

Hi! We would like to install a named instance on a Windows Server 2003 Cluster. The named pipes settings are set correct but during the installation the instance name fail -> "Bring Online" process -> rollback installation. The same setup procedere on a Windows Server 20003 x86 run without ...more >>

I need help with a licensing question for 2005. Assuming two servers with two processors each: If I have one instance on Server A in an active/passive cluster with Server B, my understanding is that I need licenses for two processors on Server A) If I have one instance on Server A and one...more >>

I there, I want to upgrade a SQL active/ passive cluster from SQL SP3 to SP4. How can I prevent end users and tools from connecting to the server during the migration? I cannot disconnect the LAN cable since I use domain accounts for the cluster and the SQL server. The nodes run Wind...more >>

I'm planning a hardware upgrade of our active/active dual node Windows 2000 sql cluster. Hostnames and IP addresses will remain unchanged. Here's a high level overview of my plan.. 1. move all cluster groups/resources to node 2 2. shutdown sql services on node 1 3. uninstall MSCS on node 1...more >>

Just got this email from someone in Ops: http://news.zdnet.co.uk/0,39020330,39237341,00.htm http://blogs.msdn.com/slavao/archive/2005/11/12/492119.aspx Synopsis - Hyperthreading (Intel specific technology) can seriously impedes performance in SQL and Citrix especially under heavy load. ...more >>

Hi, I am aggregating 6-8 SQL Server 2000 databases to a cluster of SQL Server consisting of two nodes, each with four 3.1GHz Xeon CPUs. How do I estimate the memory requirement for each node? Do I simply add the memory utilization of each SQL Server instance on each individual SQL server? Or,...more >>

I am installing SQL Server 2005 RTM ent in a 2 node cluster Details - Windows 2003 Ent, SP3, QUAD PIII, 6GB ram per node Error Message: Setup failed to start on the remote machine. Check the task scheduler log on the remote machine Notes: -These are QA boxes, rebuilt, the account I am usin...more >>

Hi I have 2-node active/active cluster. I have installed 2 SQL instances (one per node). Now I want to install Analysis service in cluster for datawarehouse . I have some questions regarding this. 1. Should I have seperate cluster group to be created for this? if so, how many disk dri...more >>

I'm planning to use Exchange Server 2003 and SQL server 2000 in a clustered solution (windows 2003) with 2 nodes. One node should contain the active Exchange resources. The other node should contain the active SQL server resources. If one node failes the other node should run all Exchange AND ...more >>

Hi, I have moved our cluster SQL 2k server from a W2k cluster to a new w2k3 SP1 cluster server recently. After the move, I found two applications that use MSDTC didn't work. I realized that I made a mistake when I setup the MSDTC, I didn't enable network DTC access on both nodes before I co...more >>

When I try to connect to (local) server (in Query Analyzer for example) on an virtual sql server, the application tries to connect to the active node instead, resulting in an error message (SQL Server does not exist or access denied). Is it possible to configure this alias to connect to the...more >>

Hi Guy's, I've tried to install a instance SQL Server 2000 Enterprise on a Windows Server 2003 Cluster without SP1, only KB's were installed. Setup Program can't start the Microsoft SQL Server service and it does not end the setup process. I checked the event log and I noticed that the even...more >>

I assume this term is used for clustering all your Federated Server members. - Does each node have a SQL Instance installed? If yes, I assume 1 virtual instance of sql is treated as the main, and all federation members are configured as linked servers. - When I create my partitioned view...more >>

Hy all, we want to setup a geographically distribuited cluster on which we want to run sql server 2005... Is it possible such a solution? If yes, where can I find an howto? thnx bye Attilio. ...more >>

Sorry for the re-post. In a clustered SQL Server 2005 environment you must assign SQL Server, Agent and Full Text Search to domain groups. These groups then appear in the Sys Admin fixed role. With that, anyone who can add members to groups in the domain can also become SQL Server SAs. How ...more >>

Hello, I have a small question. We have an cluster (W2K) running with an SQL2000 and an IIS on it. Is it possible to rename the notes of the cluster without any problems? Greetings Stefan...more >>

Hello Group, I have SQL ENT SP4 installed on cluster with two nodes each node have 2GB memory serving 17 clients. when i am looking on task manager the proccess sqlservr.exe is getting bigger and bigger until he attained 1.7+- and stay stable. Is it normal that this proccess getting so big...more >>

Looking for quick answer. If we implement a 2 node cluster fora single SQL database....do we need to buy two licenses of SQL enterprise. It will reside on an active\passive cluster. Can I use SQL standard?? Dan ...more >>

hi..I am running DBLIB (sample application of SQL Server) between 2k and 2k3. Well seems working perfect..but want to know whats going on in the Database..I think some DB configuration (like DB connection or Table creation) is required to see the effect of executed/commited transactions..need s...more >>

Is there a possibility to create on each node a MSDTC resource (even local on each server)?...more >>

Hello! Although I have Installed MS Outlook 2000 on both clusters in a Windows 2003 2 node cluster system, I can't see a list of profiles in Sql Mail. I had create a valid profile (with the same account and name) in both nodes and tested them. The profiles also use the same account as the Sql...more >>

I successfully installed a SQL Virtual Server and a SQL Instance on a Clustered Environment. Is there a limitation as to the number of additional Vitual or Instances I can add. Also, what would be considering best practice? Virtual or Instance? Thank You in Advance! Drake Teran ...more >>

I have a Windows 2000 Advanced Server with SQL Server 2000 cluster. What is the undocumented commands that will roleback cluster checkpoint? The cluster keeps checkpoints just like the operating system. Please help me with the cluster roleback checkpoint commands. Thanks, ...more >>

hello i want someone to help me in solving a problem in sql server 2000 considering that i have a table named PAY(TITLE, SAL) where TITLE is the primary key of this table also this table is related to another one named EMP, where the other table has a foreign key to this table. ta...more >>

I'm having problems installing 2005 Ent on my Win 2003 SP1 2 node cluster. Please note this cluster has a SQL 2000 (SP4) virtual server/instance already installed. I would like to run them side by side. installing using the setup wizard I get error about the schedule task failing to start o...more >>

hi..i am trying to see TIP communication using msdtc sample applications (dblib: equipped with SQL Server) between w2k & w2k3. | w2k |------------------| w2k3 | My query is abt TIP...i couldn't find any check box or option to "Enable TIP" in Win2000. How can i enable TIP and see...more >>

I see that the new SQL 2005 Standard edition supports 2-node clustering. Does that mean that Standard edition could be used in a 4 node N+1 scenario set-up as follows: Node 1: File Server Node 2: Exchange Server Node 3: SQL 2005 Standard Node 4: Dedicated failover node for 1,2 & 3 Only ...more >>

I have 2 node failover cluster. I want to have sql server live on one node while analisys services on the other. In SQL2000 setup set one group for SQL, and I've manually installed AS in different group. But SQL 2005 setup installed sql and as in the same cluster group. Now, how can I s...more >>

I'm running SQL on a clustering configuration. I recently started noticing these phantom drives appearing under my computer. They are all relatively close in size and it appears to only create one phantom drive each Sunday. I currently have the SQL Server backing up it's files to the real Loca...more >>

I get the following error randomly on our Production SQL Cluster: Error: 845, Severity: 17, State: 1 Time-out occurred while waiting for buffer latch type 4 for page (3:410007), database ID 20. Has anyone seen this type of behavior? Any ideas on how to resolve it, or get more details? ...more >>

I have the following cluster config: 2x HP DL585 servers (identical) - 4x Opteron 852 processors, 8GB RAM, Win2003Enterprise, SQL 2000 Enterprise 1x HP MSA 500 SCSI shared-storage 1x HP SCSI adapter per server (included with MSA500, not sure of the model #) The servers are in an active/pa...more >>

We have an issue in our environment that requires me to bounce a cluster group and associated services ever other day and Im getting tired of it (out of control developers). I would like to create a script that I can schedule to do this and would like to know if there is a command line that...more >>

I have an "Active/Active" SQL 2000 cluster on Windows 2003 SP1. The first node is the default instance and the second is a named instance. They are both listenting on port 1433. When I fail the default instance over to the 2nd node, everything failsover and comes on line and I am able to conne...more >>

Hi all, I had a very simple cluster consisting of one Windows 2003 database server with an attached storage device and one Windows 2003 Domain controller. For some reason, Cluster Manager can no longer reach the cluster. If I try to connect, it can't find it. If I try to create a new one, it ...more >>

When I install the Cluster with Version of SQL 2005 CTP September ... After the Service Accounts (Clusters) page, Domain Groups For Clustering Service Page appears. How Can i configure this page...there is no information about it on BOL of SQL 2005 In my opinion , fill them with New SQL...more >>

Hello! I have a difficult situation with a clustered server. It consists of two parts - Cluster_1 and Cluster_2 computers with WINDOWS Server2003. Cluster_1 and Cluster_2 are with 6 GB RAM. The whole clustered server is named Cluster. SQL Server 2000 is installed on Cluster. Se...more >>

hi, I am new to creating clustering in windows 2000 advanced server. I've set up the clustering in vmware box. My sql installation fails every time i try to install on one of my cluster node. can some one help me how to uninstall the sql from cluster nodes? thanks in advance ...more >>

First of all, excuse me if my English isn't too correct. I need to install a portal infrastructure that was developed with ASP and SQL Server. The system would like to be redundant and scalable. To do that, I have in mind, the following diagram : - 2 W2003 Servers with IIS6 and NLB ( front...more >>

I have 12 gigs of memory on each server in a cluster. Each server carries about the same load. In this case I should allot 5.5 gigs to each server and leave 1 gig for the OS? Is 1 gig enough for the OS? I should use the /3GB switch and set the max server memory to 5.5 for each server. ...more >>

hi...trying DTCPing.exe between xp & wk3.. xp connects with wk3 but vice versa is problematic Error visible at MSDTC Simulation V1.9 window of wk3 ------------------- Problem:fail to invoke remote RPC method Error(0x6D9) at dtcping.cpp@303 ->RPC ping exception ->1753(There are no m...more >>