have a win 2k adv active-active with SQL 2k Ent. the failover works great. However i noticed that on the other active node, even with AWE enabled, it doesn't record this in the event log upon SQL startup. On the 'good' AWE node, this is what I see in the event viewer: Address Windowi...more >>

What are the special settings that need to be set for a Active/Active Cluster? Thank You Mickey mautry@ev1.net...more >>

Hi Everyone, I'm new to the SQL Server world. I am looking for a tool similar to SQL navigator in Oracle, that will optimize Sql queries for me. Any suggestions? - SM ...more >>

Hi I'm a bit lost will all the requirements for changing my Active / Passive Cluster to Active / Active.... Currently I have - Compaq CL380 Dual Node W2K Adv + SQL2000 Ent C: drive - 4GB (Disk 2) (On each Node) D: drive - 4GB (Disk 2) (On each Node) E: drive - 17GB Data Volume (Disk...more >>

i have two dell 6450 with a share scsi drives, when i begin install the sql they say the follow error: "the path specified in a commmand line argument is invalid:\\cluster1 \admin$\cluster1_mssqlserver.iss", i read maybe is the net share admin$ or the priviligies of the account, but i try w...more >>

SQL Server 2000 Enterprise Manager cannot see my e-drive, which consists of two drives mirrored to appear to be one physical drive. However, this e-drive is visible in Cluster Administrator. Why can't the e-drive be seen from Enterprise Manager? To add to this, in Windows Explorer I tried ...more >>

Hi all The problem occurs when the cluster service attempts to take ownership of the quorum disk. The other node in the cluster is turned off, but the system still thinks that it is the current owner, eg it appears to be a classic deadlock issue. The relevant lines of the cluster log fil...more >>

hi, I have a new cluster and I need to move(copy) the databases about 100 of them to the new cluster leaving the old cluster functioning intact.will a backup of the databases(sys & usr) from the old cluster to a SAN and restoring it to the new cluster serve the purpose?.I would like ...more >>

I have seen some docs on installing Win2K clustering services but need to find a step by step document that talks about installing the OS on the 2 nodes prior to setting up win2k clustering services and eventually SQL 2K clustering. I have the h/w ( the 2 nodes ) and the storage attached physi...more >>

Hi I am thinking about installing SP4 on an Active/passive cluster in the hope that this error stops, are there any issues that I should know about error 64004 (Windows File Protection) Event Type: Information Event Source: Windows File Protection Event Category: None Event ID: 64004 D...more >>

Hi, can someone help with this... I tried to install sql server enterprise version on windows 2k advanced version with sp3 without much success. Here is the problem: I went through the intial installation procedure and answered all questions, as soon as I passed the screen to confirm user ...more >>

Hi; SQL 2000 Enterprise Windows 2003 Enterprise - Clustered (2 node) I have installed a Virtual server with one instance successfully (named instance). I now need to install a 2nd virtual server with another instance and after assigning the IP address I am asked to select the locatio...more >>

I have a Windows Server 2003 Enterprise Edition cluster up and running correctly. I am trying to install SQL Server 2000 on a virtual server. During installation, after I enter my sql service account info, I get this error message: The specified account can not be validated to have ad...more >>

Hi We are running a SQL 2000 cluster and using a SAN for our storage. We have dedicated a volume G for datafiles, F for logs, and H for backup files. Unfortunately when creating a database the only volume that is available to place data and log files is G. We would like to use F f...more >>

Hi; I have a clustered SQL server (2000) on a Server 2003. Initially the IP address used for the setup was an internal IP address and now we want to change it to an external IP. Can someone point me to the KB article discussing this. I remember seeing it somewhere but can't find it any...more >>

I setup perf mon for a SQL7 on winnt 4 cluster server. There are counters for physical disk, i.e. avg. reads/sec, etc. But I could not see any chart on the monitor screen. What is wrong? CPU and memory are fine. Thanks in advance....more >>

It is bad enough that my email address got harvested for the fake Microsoft IE 4.01 product alert email that has a virus attachment as a security patch. But I think the posts should be more closely censored as you can see from some of the posts in this newsgroup. -- ***********************...more >>

I have started noticing the following problems with my sql 2k sp 3 cluster. Occassionally it will hang up(other processes can't connect to it). I am find the following errors in event log. error: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed error: [sqsrvres] OnlineThre...more >>

I have one cluster Manager (2 servers A & B) with 2 SQL2K servers (SQL2K1 & SQL2K2). Is it possible to configure my setup to force my SQL2K1 to run on server A and SQL2K2 to run on the server B. So on a normal situation both servers will be active. If a failure occur, both SQL2K wil be ...more >>

...more >>

How does clustering help with database maintenance such as dbcc dbreindex,backups,etc... ? If the database is shared on a shared array in an active/passive mode , what database maintenance tasks does it actually help in other than maybe Service Packs upgrade ...more >>

Error-description and what we have done: ============================ Our customer has a database-cluster (MS SQL Server 2000 Enterprise running on two Windows 2000 Advanced Server in an active/passive configuration) which partly, under certain circumstances stops working. The web-site connecte...more >>

I have a Win2k SP3 one node cluster setup running SQL Server 2000 Enterprise SP3. I'm trying to register the instance with Active Directory, to no avail. When I register the sql server, it creates the entries in AD under the local computer name, instead of the sql server network resource name. I...more >>

We have a large project going on at the moment to migrate to Active Directory. All of our application servers are being migrated out of an NT resources domain to an AD domain. As yet we haven't touched our SQL Server clusters (SQL2000, Win2k Advanced). Has anyone ever performed this operation, o...more >>

I'm having an issue when running SP3a on a SQL Cluster. The cluster is made up of two machines, DB1 and DB2. DB2 is the active node. I have placed all SP3a setup files in c:\sql2ksp3 on DB2, and created a share for that directory. In addition, the account I'm using to logon the SQL Service...more >>

I can connect to our SQL cluster server only via named pipes. This is not good for remote connections but works locally. I want to be sure that TCP/IP is used for all connections. The server IP resource exists in cluster administrator. It has the "Enable Netbios" box checked. I think ...more >>

We're currently testing failover clustering to see if we want to start using it. I haven't found an answer to a very important question: Is the cluster available during service pack installations and other updates? Perhaps I've been searching in the wrong places, so if someone would be kind enou...more >>

Any help on this would be appreciated: I've set up 2 W2K Advanced servers in a clustered configuration with shared storage, clustering works seemlessly as far as I can see. When installing SQL2K, the installation hangs up when clicking 'next' after entering the IP address that will be used fo...more >>

We are looking at clustering our servers in an active/passive environment. My question is, according to MS documentation the secondary node MSSQL service is not running and will start when needed. Is this correct or can the secondary MSSQL be up? We have a datacenter implementation with 28GB r...more >>

I can connect to our non-clustered SQL servers, both SQL2K and SQL 7 via Enterprise Manager when dialed into our network (via a product called PAL). I can even get to one of our servers on the company WAN. However, I cannot register to our cluster server via EM. Message is "Server does ...more >>

Hi, Can I change sa password in Clustering SQL Server 2000? The method same as not clustering SQL Server? Thanks! Jenny...more >>

Hi Everyone, I have setup an IBM server raid cluster and found performance on the cluster nodes to be about five times slower than without the clustering. This is based on a series of test that I conducted. Even a simple file copy takes about 50% longer on the cluster node than a non cluster nod...more >>

Hi All, I'm working on a SQL Server 2000 cluster on Windows Advanced Server. Installation went fine but Now SQL Server can not see one of logical drive, whereas it's able to see the other logical drive. both are on different physical drive. Can anybody help me?? Adnan ...more >>

Hi Guys, my sql server system already using fail over clustering . what i need now is a stand by server in a remote location in case any disater like raid controller failure or fire in the server room i should be able to bring the stand by server online without any loss of data with minimu...more >>

Hello, We are have sql2000 clustered setup. Sql server stopped due the following error "insufficient memory available !!" Please let us know the reason for the same. Thanks in advance !! Veena ...more >>

i facing below problem, but after i restart server, it will work = again... Microsoft OLE DB Provider for ODBC Drivers error '80004005'=20 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist = or access denied.=20...more >>

I am getting a duplicate name being reported after a reboot of my server, the follwoing services do not start: SQL network name SQL server SQL agent. Can someone give me any hints....more >>

Hi, One of our two SQL 2000 cluster node has a wrong name according to our internal naming convention. I have to rename the machine (at the Windows level. It's WIndows 2000). How can I do that without reinstall the cluster ? I've try to rename the machine. I works but the SQL cluster do...more >>

I've got a SQL 2000 cluster on Win Adv Server. At least once a minute I'm getting a message in the SQL Server Error Log similar to this: "Resource Manager Creation Failed: Result Code = 0x8004d01c" It doesn't seem to be coming from just 1 connection or 1 application. Does anyone have any ide...more >>

Hi, Currently the cluster has only the default cluster group.I understand that this is not recommended as , if one resource fails , the entire groups fails. I need to create groups on the cluster and move resources to the concerened groups.Is it necessary to back up all the data and do it.Wh...more >>

During the install which is as default as you can get.. right after I select the licensing mode and for the actual SQL Server installaion I get the following error preventing me from continuing the clustered installation: The path specified in a command line argument is invalid: \\<server_...more >>

We are setting up a SQL Server 2000 Cluster Server would like to know the counters that should be monitored and send Alerts to the DBA when they have reached a corresponding threshold. Thank You, Mickey mautry@ev1.net...more >>

I have been recieving the following errer frequently in the last few weeks I was wondering if anyone else has come accross. "The node lost communication with another cluster node". I drop is just for a second but it is starting to concern me. ...more >>

I am using SQL Server Cluster for more then two years now and during last two years, I have Installed and UnInstalled the SQL Server many times but this time I am getting a weird error msg. Need Help...!! I am trying to install SQL Server 2000 Entp. Edition on a Win 2k Adv. Serv. Getting ...more >>

Well, we have been playing with our new cluster and realize now that we screwed up. It has been decided now that we would like the best possible performance rather than disk space. So we want to blow away the Raid5 and re-do it as multiple Raid 1+0 drives. This is presently a development sys...more >>

Without going to Cluster Administrator, is there a way (e.g., using Query Analyzer) to determine which node in a cluster an instance is running on?...more >>

Hi All, I am running a 3 node cluster on Windows 2003. The cluster is running. MSDTC is running. Cluster drives are ready for SQL. During the SQL install, after providing the virtual name, network and IP to the setup program, the installation stalls going to the next screen. I know ...more >>

When I try to run the MS03-031 HotFix on my newly built cluster running SQL2K, w/SP3a, I get an error that the user I am running as is not an Administrator on all possible nodes. There are only two nodes. I've tried running as the Domain Administrator and as the Cluster user (which is in t...more >>

Is there a way to set up a test SQL2K cluster without having to invest in a SAN? Can it be done with just two server boxes and mapped drives? Not looking for high performance, just a way to experiment with cluster software. If you could point me to some good information it would be help...more >>

What are the steps that need to be taken to create a Cluster SQL Server v2000 from a NonCluster SQL Server v2000. Are there problems that can occur later by not set up the Cluster when the server first installed. Thank You, Mickey mautry@ev1.net ...more >>