Hi Can anybody give me some URL:s with good documents that explains how to install SQL 2000 Enterprise on Windows 2003 Enterprise (2 node-cluster) against a SAN? Regards Mikael ...more >>

I have installed SQL Server on a new cluster. We are having problems with the SQL Server Failing Over on the Full Text service. I do not see an error and can not figure out why it will not failover to the other node. Also a question about how the cluster is setup, I noticed that sql ser...more >>

I am in the planning process of upgrading the hardware on our cluster. I need info/advice/suggestions on how to go about this. I am running an active/active cluster on 2 ML370 servers. They are running Windows 2000 Advanced Server/SP2, MSSQL 2000 Enterprise/SP2. I want to know if all I hav...more >>

I had to build a new node to replace a crashed node in my SQL cluster. After installing MSCS & SQL, I can transfer my resources from one node to the other. But, SQL has some problems. Looking at the files, I see SQLSERVR.EXE to be a different version on each servers. Do I need to...more >>

Hello, I have sql 2K on cluster Windows 3K but when i do a backup report this message on eventlo Event Type: Erro Event Source: MSSQLSERVE Event Category: (2 Event ID: 1705 Date: 1/26/200 Time: 9:21:33 A User: N/ Computer: JUPITE Description 18204 BackupDiskFile::OpenMedia: Backup ...more >>

How to set the idle timeout for the idle client connection ? ...more >>

We have a Windows 2003 EE Cluster Node [QAT2] that has an attached NAS device via iSCSI for disk storage. Previously, we had two large NAS partitions, drives K: [DATA] and L: [LOG]. Then we decided that we wanted to have 3 Virtual Servers, so we split up the partitions into 6 drives [3 DATA a...more >>

I recently upgraded our server to a 2 node cluster. We installed MS SQL server, and created the virtual server necessary for the cluster failover to work. I noticed today that I can not use SQL Enterprise manager from Node1. It does not see the instance of SQL Server. Under Server Groups i...more >>

Request for info on updating only Jet 4.0 to SP8 on a SQL 2000 sp3 cluster. Does each node need to be done separately or does in recognize that it is in a clustered environment....more >>

The servers are W2003 Enterprise SQL is 2000 Ent sp3a Active/Passive I just finished configuring the cluster and it looks fine except SQl does not see all drives. In other words when trying to create the database in enterprise manager server does sees only one drive. It bahaves the same w...more >>

I have SQL Server 2000 with SP3 running on a windows 2003 cluster. I need to setup log-shipping from a SQL Server 7 database server. The 2 servers are separated by a firewall. The guy that configures the firewall doesn't want to do trial-and-error to figure out which IPs to open up. I ...more >>

I am having a hard time finding any details/caveats with installing SQL 2000 on a Windows 2003 cluster. Can anybody point me in the right direction? Thanks! Michael Bates...more >>

Hi, I'm trying to install a second instance of SQL Server on a clustered node, from Node B. I had to cancel the first execution of setup installation program for different reasons. After that, we haven't been able to delete /Binn directory of that instance on Node B (sharing access vio...more >>

My boss tells me to install 2 SQL instances on each node. This means 8 instances on 4 nodes. His reasons: a) Rather than 1 instance with databases having both high and low transactions, better to split into 2 instances, 1 with high usage databases, and the other with lower usage databases. CPU and...more >>

Can a virtual SQL Server 2000 SP2 and a virtual SQL Server 2000 SP3a coexist in the same Windows 2000 Datacenter cluster? Will the different versions of MDAC coexist in each node?...more >>

We just installed a new SQL Server 2000 Active/Active cluster. We are trying to connect to the database from VB using ADO using the connection string: Provider=sqloledb;Data Source=HAZXXXXX\SDXXX;Network Library=dbmssocn;Network Address=172.99.99.99,1433;Initial Catalog=<DatabaseName>;Us...more >>

Hi, I am new with the SQL Server clustering, what do you recommend for jobs notification?...more >>

Thannks in advance for an help on this. I am attempting to set up SQL2K EE on Win2003 cluster (active/passive). I get this error msg "Setup failed to perform required operations on the cluster nodes." during the install process. I have looked through the newsgroups and knowledge base...more >>

I have a problem with my SQL cluster. One Windows 2000 server had a disk crash recently so I decided to reinstall it all under Windows 2003. So now I have the new Windows 2003 server and the good old Windows 2000 server. Let's call my servers SQL1 (Windows 2003) and SQL2 (Windows 2000). I i...more >>

Hello All, We have a SQL cluster in active/passive configuration. Unfortunately, our network has been having issues. More specifically, the line protocol on the Cisco 3550 that the primary node on this cluster is connected to seems to drop off temporarily from time to time. So the problem ...more >>

I have the following configuration 2 IBM x335 1 FASTT200 HA 1 Disk Array RAID 10 - 1 Partition (Drive S:) 1 Disk Array Raid 1 - 2 Partitions (Drives Q: & L:) The q: Drive and l: drive being 1 physical cluster resource, the sql server will NOT let me place the SQL Logs on the L: Driv...more >>

Hi guys, i am running a mission critical financial system on sql 2000 active/passive cluster. right now i have only cluster failover and transactional replication for reporting as disaster recovery mechanism. i want to implement a solution which will allow me to recover 100 % DATA with min...more >>

I have a two-node Active/Passive SQL Server Cluster on Win2k AS and SQL2000. When I attempt to manually failover to node 2 of the cluster all of the resources go over except SQL Server. The cluster log reports an Error 435. 'SQL Server failed to start'. I've just noticed another error ...more >>

We are running SQL Server 2000 Enterprise Edition [on Windows 2003 EE] on our PRD SQL Server Cluster. We have two nodes, PRD1 and PRD2. PRD1 will have one Virtual Server [and corresponding named instance], and PRD2 will have 3 Virtual Servers [and corresponding named instances]. So, my quest...more >>

Can Exchange Server 2000 & SQL Server 2000 can be installed in one cluster group? I have 2 node cluster and I plan to install both Exchange & SQL Server 2000 on it. Is this advisable to do? Thank you very much and more power!...more >>

Hi GUYS, in my sql server recently i am getting high Avg. Disk Queue Length of 40 for an array of 4 disks in every 5 minutes for around 20 sec and during this period the server performance is poor. any ideas? thanks Biju...more >>

Environment: SQL Server 2000 SP3a on W2K Advanced Server SP4. 1 IBM Server x440 with FastT700 Storage (Fibre Channel) We need to buy another IBM Server x440 or x445 and we would like to make a cluster. Question 1: Once we build the Cluster with the installation of the Cluster Service, mak...more >>

Hello. We have a QAT SQL Server 2000 2-node Cluster running on Windows 2003. The first node, QAT1, has a single Virtual Server [with a corresponding Named Instance]. The second node, QAT2, has 3 Virtual Servers [with 3 corresponding Named Instances]. What method can we use to estimate how m...more >>

Question: How to Clustered both SQL Server 2000 and MS Exchange in One Server? You know I have a machine server which i would like to configure MS Exchange in same manner of SQL Server 2000 that have shared storage. I mean computer A connect to virtual shared storage and computer B connect...more >>

Scenerio: I have an active/passive 2-node clustered SQL Server. I am connecting to the virtual machine via Computer Manager and creating a local group and then adding the appropriate global users/groups to this local group. I then grant database access to this group via SQL Enterprise Manager. ...more >>

I=B4m trying to install a SQL cluster, the description of=20 the environment is: Servers x370 IBM (4xPIII 700 MHz, 2 GB RAM, FC) FAStT200 Storage Server (SAN in FC) I install the machines from scratch, after the=20 installation of MSCS I made some test to verify the=20 operation of Cluster. ...more >>

Hello, I currently administer a two node active active cluster running Window NT 4.0 Server with SQL Server 7.0. Can anyone please explain to me what may be causing this particular problem? The Scheduler 3 appears to be hung. PSS 0x5277F110, EC 0x5F0FE084, UMS Context 0x01894F70. The Sche...more >>

We have 2003 server and cluster running on 2 nodes. Each node has 4 GB RAM. Each node has one instance of SQL Server 2000 ent. Recently we installed the /3GB switch and enabled AWE. We set max memory to 3.5 GB on each node. Memory on one node (actually the less utilized node) has achieved...more >>

I=B4m trying to install a MS Cluster with two IBM x370=20 machines and Storage Server IBM FAStT200 Fibre Channel. The cluster installation procedure complete succesfully. After the installation of MC we test the cluster=20 operations. After this test, we proceed to install MSDTC with the=20 co...more >>

I have a W2K3 cluster with the High Security Template installed. When I try to install SQL 2000 on the first node of the cluster, the setup fails while creating virtual server resources on the cluster. The installation works fine with the setup security template installed. The following ...more >>

I am planning on installing SP3 on SQL2000 with SP2. The SQL server is clustered and I am wondering if I am going to encounter any problems? I read the readme file and it looks as if it is stright forward, but I am worried becase it is a production database. I would appriciate any feed back...more >>

Is there any comparision whitepaper to describe to use a/a mode or a/p mode for SQL Cluster I was told that Microsoft suggested to use a/p mode, so during the failover to a/a mode server would have less chance to get trouble. Is this true? Any good reason to use A/A mode Both of my SQL cluster se...more >>

How load balancing feature is enabled with SQL 2000 clustering service. ...more >>

¸÷λºÃ£º ÎÒÔÚÒѾ­¼¯ÈºµÄ·þÎñÆ÷ÉÏʹÓÃASPÒ³ÃæÖеÄÊÂÎñTRANSACTIONÓöµ½ÁËÎÊÌ⣬ÌáʾÎÒ MSDTC²»¿ÉÓã¬ÎÒÏëÇë½Ì¸÷룬ÊÇʲôԭÒò£¬ÒªÈçºÎ½â¾ö£¿¶àл£¡ ...more >>

Hi - we would like to perform a test sql cluster setup (on two machines) and don't have an external drive array. We do have a some compatible servers and plenty of disk space. What is the cheapest solution for our test? We don't really care much about performance, just want to get some practic...more >>

Hi, I got a problem with a cluster with SQL 2000 EE. Had two servers, Win 2k Adv Ed., one of them died. Failover to node 2 worked fine. Bought some new hardware, installed Win 2k Adv. Ed., SP4, MSCS. I EVICTED the old server form the MSCS console from node 2. I did install the new...more >>

Hello, How do I set the SQL Server Agent and Fulltext Services to Autostart within our SQL Server 2000/Windows 2003 EE Server environment? In non-clustered SQL Server, I just set the services to startup "Automatic" within the Windows Services screen, but I doubt that this is the correct plac...more >>

I have 2 SQl servers one End1 and the other END2. SQL 2000 EE is being installed on ENDSQL1 after entering the the VIP it prompts for the location of the data on the shared array. I am selecting my F: drive which has 40 GB allocated(I can write to this drive, so the drive is configure correctly) o...more >>

The resource [SQL Server] fails to come online. The server is W2003 Enterprise SQL is 2000 Ent. After the cluster is up and running I installed SQL server as virtual and the installation finished with: An error occurred while creating virtual server resources for clustering. The system canno...more >>

For 3 years I had a Windows 2000 server farm consisting of 4 servers (2 web servers load balanced and 2 sql servers for clustering). The 4 servers are in domain. They are the only servers in that domain. I had a hard disk crash on 1 SQL server recently, so I decided to try reinstalling it with...more >>

I have done the setup of SQL Virtual server Cluster setup with one named instance with database and log file locations on the same drive over shared storage f:\. Now I have added new drives in my shared storage box and created a drive g:\ which is accessible in windows Explorer. Now I want ...more >>

Hi GUYS, i can see these errors in sql error logs . are they serious? what action should be taken. pls advice me . SQL Server Assertion: File: <p:\sql\ntdbms\storeng\drs\include\record.inl>, line=1447 Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'. Stack Signature for t...more >>

I got two hard disks (36GB each) on each of two SQL Servers and one Storage Area Network (SAN) as 73GB x 8. We would like to install SQL Cluster in Active / Active mode Here is my current proposed configuration. Can someone please provide a better configuration if possible The two hard disk in b...more >>

Hi All I'm struggling to find some good documentation on how to place SQL ersources in the cluster groups. Wuold I be correct in saying the following: 1) Place the Quorum and MS-DTC resources in a cluster group together. 2) Place all other SQL and Windows resources in another cluster group...more >>

OK, after several trial installations and reading many white papers and newsgroup posts, I have become completely confused on the proper use of Default vs. Named Instances vs. Virtual Servers. I am looking for the CORRECT METHOD to implement. This is what we have: [2] server nodes, QA...more >>