Hi all, we have a 2 Node Active-Active SQL Cluster and wanted to enlarge disk space. The following steps we made: - Backup RAID 5 (Image) - Delete logical Volume by RaidManager - Changed Discs - Create new logical Volume by RaidManager - Restore of the Backup - Node1 started - Clust...more >>

Is this a suported configuration?...more >>

Is there a way to detect if the principal or mirror is running the database? I want build my own altert system, sending an SMS whenever a automatic failover/failback happens. Per Schjetne ...more >>

I have been using Mirroring now for a while and put the system into production now after applying SQL sp 1. We have a setup with a witness, principal and mirror with certificates (the witness is on a webserver in a different domain, so we can't use integrated security). Automatic failove...more >>

I get microsoft odbc sql server driver tcp/ip sockets general network error and microsoft odbc sql server driver communication link faillure errors when I open our client app and while I did a cluster failover. Any reasons. Thanks. ...more >>

Does anyone else have problems with their cluster machines being able to see the domain. i have 2 clustering setups on 2 different subnets and none of the 4 machines can see the domain, list the domain server, or connect to any of the domain machines besides the domain controller. The dns is f...more >>

Hi all, the BOL state that a domain user account with two additional privileges (act as part of OS and connect as service) and membership in the local administrator group in all nodes is sufficient for installing SQL Server 2005. Has anybody successfully installed the product under these ...more >>

Our second node in an active/active SQL cluster (Win 2K SP4/ SQL2K SP2) failed as a result (it seems) of a bad NIC at the public interface. Cluster and SQL logs seem to support that the failover went successfully, except for SQL job agent suddenly stopping on the first node. However, 2 hour...more >>

Hi, We recently change the IP of SQL Virtual server, the IP was updated using the installation wizard. SQL Server starts but does not listens on port 1433, below error is logged in event log "19012 : SuperSocket Info: Bind failed on TCP port 1433." "SuperSocket info: (SpnRegister) : Error...more >>

On SQL Server 2000 Enterprise Edition with SP3a running on Windows Server 2003 Enterprise Edition in a Active \ Active Cluster. There are two nodes on the cluster. Both nodes are active. There are 6 instances of SQL Servers running on each nodes. The box is with 24x7 availability....more >>

I am being asked to migrate various SQL Databases, 2000 and 2005 to a single large clustered enviroment. I believe that you can install a single seperate instance of SQL 2000 on a Virtual Machine (this is required as they each use differeing collation sequences), however, can both SQL 200...more >>

Hi, We're planning to implement mirroring with SQL-Server 2005. On: http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx Microsoft advises againts using this technology in production situations. What are my alternatives? Regards, Jeroen ...more >>

Hi, Is it possible to have a database (on SAN) that two active nodes of clustering environment work on it simultaneously? Thanks in advance, Leila ...more >>

Hi, Are there any solution to implement load balancing on one database between two nodes of cluster? Thanks in advance, Leila ...more >>

I have a two-node SQL Server 2000 cluster. Each node has two network interfaces - one interface on each is connected to its opposite number by a crossover cable, and the other interface is connected to an gigabit ethernet switch, to talk to the outside world. All standard stuff. (Both nodes ...more >>

Hi, Our company has a HP Proliant DL380 and we need another server to establish a clustered environment. Should we but exactly the same server with the same hardware configuration or if the new server is listed in HCL will be enough? Thanks in advance, Leila ...more >>

Current topology - Sql Server 2000 on Windows 2003 Cluster The Client access to the database started to degrade on a particular database, when we tried to access the SQL Enterprise Manager - it result in connection failed. however other databases were available. Being in a cluster we mo...more >>

Hi, I have problem in understanding term "Public Network" and "Private Network". I need some clarification. For example in this sentence: "Disable NetBIOS for all private network cards before beginning SQL Server Setup" Many thanks in advance, Leila ...more >>

Hi I need to set security for row level but not based on Database user's login. It should be based on the user table login. For the particular user I need to allow only the particular records to access insert, update delete and select. Let me explain clearly For example think we are usin...more >>

I have an HP Proliant DL380 clustered server running SQL2000 and W2K with a mirrored array. I need to reconfigure the array to change the relative sizes of data drives; backup drives; quorum drives, etc. AND upgrade to W2003R2 and SQL 2005. Any suggestions on the order of how to proceed? I ...more >>

Hello Everyone, Since I'm in the process of decommissioning my production SQL 2000 server and bring up a clustered two node system (Windows 2003 R2, SQL 2005), I would like to preserve the instance (it was default) name on the old production server and use it in the new cluster. Right now,...more >>

Hi, Just been gotcha'd by the problem of adding x64 nodes to an x32 cluster... Has anyone seen the steps to move all the resources and the Virtualserver to a new x64 cluster (resources are SQL2000+SP4). Is it as straightforward as it sounds? Any pointers/articles gratefully received. ...more >>

I am planning to upgrade from Windows 2000 to a Windows 2003 Cluster. I have SQL server 2000 which we installed it as a virtual server. We are doing a rolling upgrade and want to introduce new hardware at the same time. Is it possible/recommended? On the Windows 2000 cluster take one of th...more >>

I have a Windows 2003 cluster already built. For some reason, the secondary NIC for the private (heartbeat) network connection did not get added to the cluster. I am trying to figure out how to add it in. It is not a cluster resource, so I cannot add it that way. Does anyone have any suggestions?...more >>

Hello, I have a Windows 2003 cluster already built. Then I script SQL server 2000. Installing a Local instance goes good. Installing SQL 2000 Virtual unattended failed. I have read "You -cannot perform an unattended installation to setup a failover cluster" Is there no solution to insta...more >>

Hi, I read in an article that SCSI is not supported in a Windows 2000 Datacenter Server cluster. What about Advanced Server? Thanks in advance, Leila ...more >>

Hi, I read this in documents: "If the solution does not appear on the HCL, the cluster configuration is not supported." What does "is not supported" mean exactly? Does it mean that virtual server cannot be created? Or I cannot setup SQL Server for clustering environments? Thanks in advance, ...more >>

Hello! We will be installing SQL Server Enterprise Edition 64-bit on Windows 2003 64-bit Server. I was wondering if anyone could recommend step-by-step documentation on how to accomplish this task. Thanks, Igor ...more >>

I have setup an Active Passive Cluster in SQL Server 2005. For security issue we wanted to change the port from default 1433 to 1456. In SQL Server 2000 it was pretty straight forward but it looks complicated in SQL Server 2005. If anyone has done anything in it please help. When I go to SQL S...more >>

Hi All, Can someone point out whitepaper or links for Clustering with SQL Server 2005? TIA ...more >>

My sql server2000 ususally auto stop!!When i start my sql server2000 server the sql server2000 along increasing while inscreased 6GB the sql server2000 is stop!how can i do?? -- Study everyday!...more >>

hi Guys, i m facing a problem with my cluster setup, i have setup a 2 nde cluster but my resources cannot filover to the 2nd node, if i move group it will always fail to node 1, i have checked the disk signature for both nodes and its the same, i have got a eventid 1034 its telling me "...more >>

I've been searching for a Windows 2003 version of Course 2087, Implementing Microsoft Windows 2000 Clustering, and there doesn't appear to be an updated course. We've done a lot of clustering in the past in Windows 2000 and are now doing much more clustering on W2k3 in production. I'd like to...more >>

Hi all, is it possible to install SQL Server 2005 Standard Edition on two nodes of a 4-node-cluster? MSFT states that Standard Ed. supports two-node-clusters but does it also supports a two-node-cluster within a 4-node Windows cluster? Thanks and best regards Nils Loeber ...more >>

What are organizations using today for HA ? I guess organizations who have money to spend ;) Are they using clustering or mirroring or both ? I would really like to know. Thanks ...more >>

hi i working on SQL2000, and want to make "Stored Procedure" that's working every 5 mibute, without making any calling. how i can make that ? -- Best Regards Tark M. Siala Development Manager INTERNATIONAL COMPUTER CENTER (ICC.Networking) Mobile: +218-91-3125900 E-Mail: ...more >>

I have 2 SQL databases which are the same and are giving me different query plans. select s.* from hlresults h inner join specimens s on s.specimen_tk = h.specimen_tk where s.site_tk = 9 and s.location in ('ABC','WIAD') and s.date_collected between '2/1/2003' and '2/3/2006' order by s.loca...more >>

I have entered the name of my virtual server, have then stated the details of the user that is a member of the administrators group on both nodes then I get the 'Setup is performing required operations on cluster nodes. This may take a few minutes' screen. 2 or 3 minutes later the setup fai...more >>

Hi, I have a fail over SQL Server cluster, everything is working fine until this morning, now all the sudden, I can not open up Enterprise Manager any more. The error I get is 'SQL Server does not exist', But my client application is running fine. It seems like only SQL Server Enterprise ma...more >>

Hello Everybody, I just wanna know if is possible to balance sql 2000. I mean, my customer wants to install 2 new w2k3 balanced servers (with = WLB or CSS) , balancing Ms SQL2000 as well (read only). Do u think is possible? Thx for any help Gennaro ...more >>

Hello Everyone From what I've read (correct me if I'm wrong) only basic disks are supported under clustering? If this is correct, how do people with expanding arrays when space becomes a problem? Are most people using third party tools to address their space needs? I'm using HP's MSA1500...more >>

Hello Everyone, Can someone tell me how to move the master and msdb database from SQL 2000 to SQL 2005? I'm trying to move those databases however it's telling me there is a build conflict. How do you get around this exactly? Hopefully not a inplace upgrade. Thank you Alex Anderson ...more >>

Hello to everyone, I made a new SQL (2000 SP3) Activer/Active cluster in my company with the below nodes scheme : SQLGroup1 -->SQLCLUST1 -> owner node1 SQLGroup2 -->SQLCLUST2\SQLCLUST2 -> owner node2 When i try to failover SQLGroup1 to node2 or the same procedure for ...more >>

Hello, I have installed a 2 nodes cluster under W2003. I have created a group called SQL with a physical disk ressource, IP ressource (different of the IP of cluster: 192.168.0.11 for this ressource, cluster has 192.168.0.10) and Network name (sqlserv). But when I launch the SQL 2000 Enter...more >>

Hello everybody, i got error in the EV 2019: The server was unable to allocate from the system nonpaged pool because the pool was empty. After this happened, every connections between my cluster and external clients stopped . To workaround the problem i have to manualy restart SERVER ser...more >>

I am attempting to install SQL 2005 as a clustered install on a single machine (we are currently testing and have no need for the true redunancy). One of the nodes in the cluster is currently running 2000 and the other is the one I'm trying to install 2005 on. Both have access to the quorum....more >>

Hello, I posted a question yesterday morning. I hate to ask it again, but wanted to try it once more. We have installed SQL Server 2000 Enterprise edition into a clustered environment. There are two nodes, SQL is clustered and working properly. When we installed it we chose to not install t...more >>

I've set up a 2 node virtual server R2 running Win 2003 enterprise server with Svc Pack 1 on each node and have also installed Microsoft clustering. All shared drives failover thru cluster administrator fine. I have just completed jinstalling a named instance of SQL2000 with clustering on the...more >>

Hi, I have a SQL 2000 failover cluster. I want to stop all SQL services on the active node, but not fail it over to the passive node. How can I accomplish this? I see that I should use cluster admin to stop services, but not 100% sure how. Can you provide me with a step-by-step guide. Should I...more >>

We currently have a win2k3 2-node cluster is configured as Active/Passive. On each node has 2 instances of SQL2K. We now need to add a SQL2k5 instance to this cluster. Would the right way to go about this: 1. create a new cluster resource group which has disks not been used by SQL2k 2. creat...more >>