Hello. We want to setup a Single Node cluster for a Development Server, since we have only one server (we have 2 node Clusters already for Test and Production environments). If the Development SQL Server 2000 Environment is running in Clustered mode, it will be easier to migrate the databases...more >>

Hello, Just want to make sure I am setting my service accounts up correctly permission wise. In AD I have created two accounts, lets call clusterservice and sqlservice. These two accounts do not have ANY typye of elavated permissions in the domain, they are simply in the Domain Users Group....more >>

Scenario is: SQL Server 2000 sp3a, W2k Adv Server, 2 node cluster (active / passive)........... If the active node experiences a "Error 17883 - Process 0:0 (490) UMS Context 0x12AEB9A0 appears to be non-yielding on Scheduler 0." condition and SQL Server stops or severely slows responses to u...more >>

I have mistakenly installed MSDTC on my Clustered W2k3 server in the Cluster Group. I now know this is not recommended. I have not found a procedure for safely moving this resource under Windows 2003. KB 301600 does not show how to change it once it is installed. KB 243204 applies to Win...more >>

I am getting the following error when installing SQL 2000 on my cluster. Setup failed to perform required operations on the cluster nodes Both nodes are up and functioning. The Sqlstp.1 on both servers don't indicate any errors. Any ideas?...more >>

My secondary node which is currently on Advanced Server 2000 has been having problems, so I'm going to disjoin it and rebuild it.I would like to go ahead and upgrade that node to Advanced Server 2003 and rejoin it to the virtual server.I will of course eventually upgrade the other node to ...more >>

At current we have a 2 node clustered environment. We have 4 procs and 5 GB of ram in each physical box. If we upgrade the primary node to 10 GB of RAM do we also need to upgrade the second node? If we do upgrade to 10 GB does anyone have any memory setting recomendations? TIA Rob...more >>

hi, I installed sql 2000 on a one-node win2003 cluster. now i want to add a node. the mscs finds and adds the node fine and non-sql related groups can failover and back no problem. when i try to install sql2000 using the instructions from microsoft http://msdn.microsoft.com/library/default.asp?...more >>

Hi, SQL Server is listening on the cluster IP, not the SQL Server IP. Will this present a problem later down the line? I have no problem connecting, failing over, or creating a DSN from my webserver (using cluster IP of course). Thanks!...more >>

HI ALL I have new active/passive sql cluster with the name sql1 is it possible to rename it to my sql production server name after I retire the old production sql server with out reinstall sql server on the cluster. I have all databases transfer to the new cluster server I just would like to...more >>

Hi we do have two node SQL cluster on windows 2003 mssqlserver,sqlserveragent and clusterservice are using same service account. We need to change password for these service.. is there any article on how to change the password for sql service and cluster service account on cluster any...more >>

I understand that in order to create the Outlook MAPI Profile for SQL to use, you must log into the physical server with the service account that SQL uses to startup. My question is: Do both of the servers need to remain logged in under this account with Outlook running for this function? Than...more >>

We are looking at having a multi-instance cluster for an application instead of having 2 clusters for one application. First I need any information on why we should go with one cluster with multi-instance instead of two clusters each with one instance. Also one of the clusters is already...more >>

First of all, sorry for my ignorance if it appears that I don't completely understand it well... I'm currently looking deeper into NLB and SQL Server 2000 and the combination of both. If I understand the principle correctly, you set up an X number of computers and configure NLB. Then you...more >>

Does SQL Server 2000 Enterprise support a 4 node cluster on Windows Server 2003 Enterprise? ...more >>

I repeatedly get this error in the application event log. The Windows 2000 Advanced Server is one of a two- node SQL Server 2000 cluster that is log shipping to a third server. Source: ClusSvc Event ID: 1137 Description: Event log replication queue OUTQ is full. 1 event(s) is (are)...more >>

Hey Just wondering if there is something specail to have in mind. I will install the cluster from the beginning and then transfer the database-files. Could this go wrong? and what? As a have understod this would only cause one problem, the bulid in administrator? Would bee nice i...more >>

I am trying to get a certificate issued for the virtual SQL server through MS Certificate Services which is installed on our backup domain controller. The instructions on KB article Q276553 indicate that when I make the certificate request through the web browser, I should select "submit ...more >>

Hello I have a quick question, we are migrating a single Single server 7 DB to a new SQL Server 2K Enterprise Cluster. I am being told by another divisions DBA that I must detach the DB open upgrade it using my Developer addition of SQL 2K, Then Attach it to the cluster. I think that this person m...more >>

I'm trying to setup a log shipping and i end up with following error: Error 50007: xp_repl_encrypt: Error executing srv_paramsetoutput did anyone got this error? can someone help me? ...more >>

I am getting the following error when installing SQL 2000 on my cluster Setup failed to perform required operations on the cluster node Any ideas ...more >>

Hi, We have a SQL 2000 ent in cluster on Windows 2003 ent. on 2 nodes. We have created an instance called Prod1 and now we want to create a second one called Prod2 on another virtual server than the first because we can't have 2 instance on 1 virtual machine. My problem is, I have 2 disks for...more >>

Does SQL Server 2000 support dynamic clustering like Oracle 9i? What does this mean: Microsoft's documentation, "SQL Server 2000 does not support this type of clustering"? Does SQL Server 2000 has the same expansion capabilities as Oracle 9i? Is SQL Server 2000 more Susceptible to Vi...more >>

My company is looking at consolidating its Access databases from around the country into one centralised SQL resource. They are very worried about having all their 'eggs in 1 basket' and so are considering using clustering or a similiar solution. Unfortunately, whilst budgets can stretch for...more >>

Hello We are setting up a SQL Server 2000/Windows2003 cluster ACTIVE/PASSIVE with the following configuration: Server 1 - Active - 4Gbytes RAM Server 2 - Passive -2Gbytes RAM I know that on the server with 4Gbytes I should enable /PAE on boot.ini and configure SQL for AWE. But on ser...more >>

Folks, My current environment is Win2K and SQL 2K clustered in domain A. Need to migrate Cluster to domain B. Both domains are AD Can anyone point me to docs on what to do and what to look out for. Thanks, BC ...more >>

I have encountered something odd and am hoping someone can give me a hand. A clustered server was set up with the 3 partitions 1 quorum 2 data 3 logs After installing SQL, everything works great except that it will not acknowledge anything but the DATA directory for purposes of logs or a...more >>

We receive the following error using SQL 7: Cannot create more than one clustered index on table 'Profile'. Drop the existing clustered index 'PK__Profile__7B5B524B' before creating another. We're updating a field to a larger size, when we commit the changes, we receive the above error. ...more >>

This is done in the startup parameters of your SQL Server. You'll just have to specify the parameter to move it to a different drive. Thanks, Steven S. Warren MCDBA,MCSE,MCSA,CCA...more >>

I've noticed that dbcc shrinkdatabase does not shrink the log file. How do we shrink the log file? Thanks....more >>

hello all Can I add another IP address resource to a clustered SQL 2000 virtual server so that it can listen on two addresses ? Thanks Alice ...more >>

We are in the process of building a single instance cluster on Win2K Advanced Server/SS2K Enterprise. Does Microsoft support NIC Teaming for the heartbeat connections in a single-instance cluster configuration? If not, can 2 nics be dedicated to the heartbeat? ...more >>

I have several tables that are heavily fragmented in the database. The database maintenance plan I have selected the Optimization and Integrity features that runs weekly with the reorganize data and index pages set. I also have the Integrity selected to check database integrity and inclu...more >>

Anyone experienced using SQL Server Polyserve Matrix Server with SAN? ...more >>

It may not have anything to do with the cluster but the cluster dies or both nodes are effected so just a thought.... Configuration SQL 7 Ent with service pack 4 and MS 03-31 Win2k with SP 3 8 CPU 8 GIG memory with /3GB and /PAE Switch Errors 1450 Insufficient resources Error 823 Back...more >>

Hi all, we have two web servers talking to a clustered sql server 2000. all machines are running on win2k3. The application running on the webservers is type ..NET and requires distributed transactions. we encountered some questions regarding Best Practice: a: How do you configure MSDTC in ...more >>

Hi, I will have to change whole IP structure (different IP address and different network mask) in my company and it also means to change an IP address of cluster on MS Win2000 SP3. On the cluster is running MS SQL Server 2000 SP2 and MS Exchange 2000. I have been told that I will have to cha...more >>

Hi, Can anyone point me in the right direction for some good information on real life scenarios in clustering SQL 2000? I'm basically looking at have 2 servers with SQL server installed on both in a load balanced situation. What would be the most common way to ensure that data was kept identic...more >>

Is there an article on how to move the quorum from one drive to another or do you have to set the cluster back up?...more >>

Hello I'm trying to setup a LOG SHIPPING option in MS SQL 2000 Enterprise Edition and while I'm doing that I end up with following error Error 14261: The specified primary_server_name.primary_database_name ('(') already exists. I even found this http://support.microsoft.com/default.asp...more >>

All, Trying to find out if anyone has used the MS SQL within the Cisco Call Manager App. Currently I get a error messges that points back to a problem in my Database Replication setup. Any ideas?...more >>

Can someone help me here, I'm geting this while trying to execute SLS. Backing up t to DISK=\\db2d\c$\t_20031208_0734_LOG.BAK BACKUP LOG successfully processed 0 pages in 0.058 seconds (0.000 MB/sec). Execute [db2d].master.dbo.sp_ApplyStandByLog N't',N'\\db2d\c$\t_20031208_0734_LOG.BAK',N'c:\t...more >>

Is it possible to move the master db from one drive to another in a cluster? I am running a active/passive configuration. Currently I have the all the data files going to one drive. ...more >>

Hello, Sorry for reposting this issue but I never received a response to my follow up last week(on the 3rd). I am having a problem restoring the master db on a w2k/sql2k active/passive cluster. After I start sql server in single user mode I am unable to connect to query analyzer to run the ...more >>

Is this possible? Has anyone done it?...more >>

I have just moved several SQL Server databases from a SQL Server 7.0 with NT OS to a SQL Server 7.0 with Windows 2000 OS. Each of these databases are accessed via web server. I have no problems connecting to the db when I set up the ODBC connection and all of the databases are functional. I ...more >>

I know this topic has been covered many times, but i can't find the answer anywhere. I've been through the readme, books online and all through the forums, but can someone tell me if the service pack install needs exclusive access to the databases to complete in a cluster install? I know that th...more >>

I am rolling out a sql sever for a small business (30 users). Is there an advantage in terms of redundancy (failover/cluster) in purchasing sql enterprise without having enterprise server or cluster hardware? It seems from reading these newsgroups that to get the advantages of clustering sq...more >>

Hello all - I've 'inherited' the sysadmin position for our company's online parts store. This is driven by the following: 2 Dell 2650's as Nodes 1 & 2; Dell 350 as Domain Controller for cluster; Powervault 220s Storage as Cluster and SQL Server resources (disk). All 3 Dells run Windows 2000 whi...more >>

I'm restore a small SQL Server 2000 database (1.5 GB) that was created on the same SAN but a different Cluster and Server. This restore takes approximately 8 minutes to restore on another server it takes approimately 30 seconds. What could be the problem with the restore taking so long...more >>