Is This Cluster Configuration Possible In SQL Server 2000?

Jan 29, 2008

Hi, could someone tell me if this configuration is possible?

Machine A: Instance 1 (ACTIVE) + Instance 2 (passive) + Instance 3 (pasive)
Machine B: Instance 1 (passive) + Instance 2 (ACTIVE) + Instance 3 (pasive)
Machine C: Instance 1 (passive) + Instance 2 (passive) + Instance 3 (ACTIVE)

I know that it is possible with 2 machines with the clasical solution of Machine1: active-passive, Machine2: passive-active, this way if one of the machines goes down the other one will take the job of both instances, but I dont know if this solution is possible in SQL server 2000 with 3 instances at the same time.

Help please? thanks

View 3 Replies


ADVERTISEMENT

How To Upgrade SQL Server 2000 Cluster To SQL Server 2005 Cluster(Database)

May 8, 2007

Hi



We are planning to upgrade the SQL Server in our production environment from SQL Server 2000 to SQL Server 2005. This is a 4 Node cluster environment with 3 Databases on 3 Virtual instances. The main requirement is to achieve this with no/minimal downtime.



Could you please suggest or direct me to any documentation for the best practices used to upgrade such an environment?



Thanks

Priyanka

View 2 Replies View Related

Upgrading A SQL Server 2000 Cluster To A SQL Server 2005 Cluster

Dec 28, 2007



We're upgrading a SQL Server 2000 cluster (Active/Passive) running on Windows 2000 Server to a SQL Server 2005 Cluster running on Windows Server 2003. We can't purchase new hardware and we have no spare hardware. We also need to move from Windows 2000 Server to Windows 2003 Server at the same time. We want to keep downtime to a bare minimum.

What we were thinking was the following steps... Anyone try this?

1. Break the link between the servers.

2. Install a fresh copy of windows 2003 server on one side along with SQL Server 2005. While this step is running, the active node would still be live on Windows 2000 Server and SQL Server 2000 serving our customers.

3. Restore a copy of a backup from the active production side to the node we're upgrading and at that point we would bring the active node down, switching the active node to be the newly upgraded server.

4. As a final step, the old active node would now have the link to it broken, we would install a fresh copy of windows 2003 server on it and sql server 2005. At this point we would bring it back into the cluster and the cluster would be complete again.

Thoughts?

View 2 Replies View Related

Upgrading SQL Server 2000 Cluster To SQL Server 2005 Cluster

May 14, 2008



Friends -

Need your help and guidence for doing upgrading SQL Server 2000 Cluster to SQL Server 2005 Cluster.

Let me explain my current environment.

1. Currently SQL Server 2000 Cluster environment is running on Windows 2000 Server we need to upgrade this to SQL Server 2005 on Windows 2003 Server. >>> Production environment.


My Plans:

1. On Testing Environment Install SQL Server 2000 cluster on Windows 2003 Server and do a restore of databases from the produciton environment.

2. Upgrade In-Place from SQL Server 2000 Cluster to SQL Server 2005 Cluster.

My doubts

1. Can i install SQL Server 2000 Cluster on Windows 2003 Server. Is it possible or not.

Please advise me and correct my steps.

Cheers
VSH

View 1 Replies View Related

Step By Step For Upgrading SQL Server 2000 Cluster To SQL Server 2005 Cluster

May 15, 2008



Friends -

Could any one of you provide steps for upgrading SQL Server 2000 cluster to SQL server 2005 cluster.

My environment is Windows 2003 server.

Appreciate your support.

Cheers
VSH

View 1 Replies View Related

How To Transfer Or Migrate From Old SQL Cluster 2000 To New SQL Cluster 2000

Jul 4, 2007



I have two Windows 2000 servers (Advance Edition) to form a Windows Cluster. I also install MS SQL 2000 Enterprise Edition on the cluster to form a MS SQL cluster. Now, I want to upgrade the hardware and OS (but keep on using SQL 2000), so I install Windows 2003 server Enterprise Edition on two new servers to form a new Windows Cluster. I am planing to install MS SQL 2000 Enterprise Edition on the new cluster, so the old SQL cluster and new SQL cluster are side by side. I would like to know how to setup a new SQL cluster (I know it has problem to rename SQL Cluster name, so how to fix this problem)? And how to transfer everything (such as system databases, users database, sql user account, password and maintenance plan jobs etc) from old SQL cluster to new SQL cluster? And how to switch over from old SQL cluster to new SQL cluster?



Thanks a lot !

View 8 Replies View Related

Cluster Configuration W/ Drives

Apr 19, 2001

Ideally we'd like to configure our SQL cluster w/ the databases on one drive and the logs on another. Is this feasable in a cluster solution.. Will it basically just be 2 drives that are failed over vs. 1?

Thanks

View 1 Replies View Related

Changing Cluster Configuration

Oct 17, 2006

In a two node cluster, is it possible to change from a Active-Passive configuration to Active-Active without completely reinstalling?

Thanks

View 1 Replies View Related

Cluster Sql Server 2000

Jul 20, 2005

Hi,I need manuals, tecnical papres, instalation guide, etc abouthow to install one cluster sql server 2000 64 bits withwindows server 2003.It`s posible a need one document step by step about thisThanks,RaulGZ.

View 1 Replies View Related

Performance Monitoring A SQL 7 Cluster Configuration.

Apr 11, 2000

I have SQL 7 running on an Active/Passive Cluster configuration. My problem is that I can not see any
SQL objects listed on perfmon.
Can this be because of the Cluster configuration? I trying to run perfmon directly from the main system console.

Thanks,
Randy

View 2 Replies View Related

ACTIVEACTIVE Cluster Configuration, Urgent

Sep 7, 2006

Hey. I've 2 nodes in this activeactive cluster. Both of them have 20gb memory. Right now, both are configured to use 12gb each. Is that the right way to configure it? I was thinking we'll have IO issues if we ever failed over to a server. I've to migrate to SQL 2005 and needed some help regarding using accounts.

Should I use the same account for the cluster service and the SQL Server/Agent service? If not what are the permissions I've to give to the cluster service account in SQL? I've a cluster with 2 nodes. What permissions should the SQL account be given on the box? Should it be a local admin or when installing, I give it the account and let SQL worry about giving permissions to the box?

Thank you.

View 2 Replies View Related

Starting Configuration Manager In A Cluster

Nov 19, 2007

I have a 2 node cluster in an active/active configuration. Install is SQL 2005 Enterprise Edition x64, patched to KB934458

If I try and run SQL Server Configuration Manager on node 1 the application does not start and I get the following message: "Connection to target machine could not be made in a timely fashion." This happens for both SQL Server instances (SQL01 and SQL02).
I can connect fine on the 2nd node with both instances.

Further to this, if I try and run the Surface Area Configuration tool on node 1 - I can't connect to either SQL Instance (SQL01 and SQL02)
If I run the SAC tool on the second node, I can connect to the instance SQL02 that is active on node 2. If I fail that SQL Instance over to node 1, I can no longer connect
I think there is clearly something not quite right about node 1.

Any help/pointers would be appreciated.

View 5 Replies View Related

SQL Server 2000 Password Configuration

Sep 26, 2006

Is there any way in SQL Server 2000 to configure password rules for SQL server logins, e.g. minimum password length, complexity etc?

Thanks!

View 1 Replies View Related

Upgrading SQL Server 2000 SP3 To SP4 - In A SQL Cluster

Mar 26, 2008



We have 2 SQL servers in a failover cluster environment. SQL1 and SQL2. Currently SQL1 is the primary in the cluster, and we need to upgrade from Service Pack 3 to Service Pack 4.

Our setup:

Both servers are Windows 2003 Server Enterprise Edition.
Both servers have SQL Server 2000 Service Pack 3.

My question is:

Which upgrade plan do I take? Do I:

1. Upgrade the backup (offline) server in the cluster (SQL2) first, reboot, then failover from SQL1 to SQL2? Then do the other server?

2. Upgrade the primary (online) server in the cluster (SQL1) first and see if it replicates to the backup?

Any advice or tips would be most appreciated.

Thanks.

View 6 Replies View Related

SQL Server 2000 Cluster Upgrade

Apr 2, 2008

We're upgrading a SQL Server 2000 cluster (Active/Passive) running on Windows 2003 Server 32 - bit Standard to a SQL Server 2005 Cluster running on Windows Server 2003 64-bit Enterprise. Our existent cluster's databases are residing on SAN. We can't purchase new hardware and we have no spare hardware. We also need to move from Windows 2003 32-bit Server to Windows 2003 64-bit Enterprise Server at the same time. We want to keep downtime to a bare minimum.

What we were thinking was the following steps... Anyone try this?

1. Break the link between the servers. Or should we just evict the passive node?

2. Install a fresh copy of windows 2003 64-bit server on one side along with SQL Server 2005. While this step is running, the active node would still be live on Windows 2003 32-bit Server and SQL Server 2000 serving our customers.

3. Bring the active server down.

4. Create new cluster on the newly upgraded server and assign the same cluster name and IP as the original one.

5 Bring the luns from SAN to the newly upgraded server and initialize SQL Upgrade

6. As a final step, the old active node will be rebuilt, we would install a fresh copy of windows 2003 64 - bit server on it and sql server 2005. At this point we would bring it back into the cluster and the cluster would be complete again.

Thoughts?

View 1 Replies View Related

SQL 2012 :: Add Node In A Cluster - Network Configuration?

Sep 8, 2014

I have installed SQL Server 2012 on Node1 successfully and trying add node on Node2 and its failing with below message. I attached the screen shot.

Here we are not doing multi-subnet failover clustering. Why we are getting extra and asking for IP and what IP should we enter there?Add Node option should automatically detect the IP we configured on Node1.

[Error Message] To support SQL Server multi-subnet failover clustering, you must select at least one valid IP address for every subnet in the cluster.

[Details] Microsoft.SqlServer.Configuration.Cluster.ClusterIPAddressPublicValidationException: To support SQL Server multi-subnet failover clustering, you must select at least one valid IP address for every subnet in the cluster.

View 1 Replies View Related

SQL Server Windows 2000 Event Log Configuration

Mar 23, 2004

Hi ,
Do you know what is the registry key / parameter that can be change in order to configure SQL 2000 to report on warning / Error event only ( just dismiss all the information messages)


Thanks,
Eyal

View 1 Replies View Related

Moving SQL Server 2000 Instances To A Cluster

Dec 10, 2006

Hi,

We have a new failover cluster (Windows 2003 SP1, Microsoft SQL 2000 SP4) with each node of the cluster hosting 7 SQL Server instances in a 2-node active-active configuration connected to a SAN. We are planning to move some SQL Server Instances(from existing stand-alone servers) into this Cluster. Any insight into the process of moving SQL Servers into the cluster would be highly appreciated.

Best Regards,
Himansu

View 4 Replies View Related

[Q]SQL Server 2000 Cluster Load Balancing

Nov 8, 2001

Hey guys,

Lately we have come across a problem where our application is undergoing some extreme load against the SQL 2000 server database we have setup, where the server is hitting 100% CPU utilization each time. Currently the box is a 2 processor box.

Here is the question I have. I have seen under most SQL Server clusters that an active/passive setup is implemented. Where the passive server just exists as a failover mechanism. What I am looking for is some information on how to setup active/active setup where each server receives processes to handle.

Has anyone created a setup like this? Are there any standard benchmarking tools that can be used to see how this configuration increases performance? Is this setup more favorable than going to a 4 processor server as oppossed to our current 2 processor server?

BTW: We have noticed that after a web application where the user sits idle for a while the SQL Server application loses the connection with the application user...Is this the SQL Timeout causing the connection to disconnect?

Thanx for any response...

Bri

View 1 Replies View Related

Adding New Node In SQL Server 2000 Cluster

Jun 24, 2008

Friends -

Currently we are using SQL Server 2000 Cluster (Active/Active) on windows 2000 advance server.

This cluster contains two nodes.

Is it possible to add another two nodes on the existing cluster, please provide me steps or any link.

Appreciate your support

Cheers:)
satish

View 1 Replies View Related

Upgrade SQL Server 2000 Failover Cluster From SP3 To SP4

Sep 13, 2006

I have a production failover cluster running SQL Server 2000 at SP3that I want to upgrade to SP4. I do not have a test failover clusterto test with so I need the install on the primary server to work thefirst time. Per the information I have I just install the patch on theprimary server and it will install both on the primary and on thesecondary.However, I remember when I did the initial install and it failed. Thefirst problem traced to the fact that the install uses temporary filesunder the profile of the installing administrator and the id had neverlogged into the second server so the install failed on creating thetemporary file. The was a second problem that related to an OS featurethat had to be off for the install to work.If anyone out there has done this upgrade and remembers encountering aproblem and its fix/workaround I would appreciate a head up warning.Thank you-- Mark D Powell --

View 1 Replies View Related

SQL 2000 Server Does Not Start In A Win2003 Cluster

Nov 5, 2007

We have a sql2000 clustered server running on a windows 2003 cluster, today we noticed that the
SQL resources where in a Online Pending state and do not came up anymore.

I have searched the net and found some info about the sqlstate = 08001 Native error 11 , witch indicated that the SQL Network name could have been renamed , however this is not the case here , .
i also found that there might be Resolve issue but The Cluster Name and the SQL Network name can be resolved by both Cluster nodes ..

does anyone here got experience with this kind of problem ? Pls Help

Here is a part of the cluster.log with the errors :

ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 2; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 2; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
INFO [CP] CppRegNotifyThread checkpointing key SOFTWAREMicrosoftMicrosoft SQL ServerDBHSBMSSQLSERVER to id 4 due to timer
INFO [Qfs] QfsGetTempFileName C:DOCUME~1SRVCCL~1LOCALS~1Temp, CLS, 13 => C:DOCUME~1SRVCCL~1LOCALS~1TempCLSD.tmp, status 0

According to the SQL server log the server is started and all databases are brought on-line then a stop request from Service Control Manager terminates SQL Server see log below:

2007-11-05 14:04:02.89 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )

2007-11-05 14:04:02.89 server Copyright (C) 1988-2002 Microsoft Corporation.
2007-11-05 14:04:02.89 server All rights reserved.
2007-11-05 14:04:02.89 server Server Process ID is 3264.
2007-11-05 14:04:02.89 server Logging SQL Server messages in file 'P:mssqlMSSQL$DBHSBlogERRORLOG'.
2007-11-05 14:04:02.89 server SQL Server is starting at priority class 'high'(2 CPUs detected).
2007-11-05 14:04:03.61 server initdata: Warning: Could not set working set size to 823168 KB.
2007-11-05 14:04:03.66 server SQL Server configured for thread mode processing.
2007-11-05 14:04:03.72 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2007-11-05 14:04:03.77 server Attempting to initialize Distributed Transaction Coordinator.
2007-11-05 14:04:06.32 spid2 Starting up database 'master'.
2007-11-05 14:04:06.52 spid2 Server name is 'HSBSQL01DBHSB'.
2007-11-05 14:04:06.52 spid5 Starting up database 'msdb'.
2007-11-05 14:04:06.52 spid6 Starting up database 'model'.
2007-11-05 14:04:06.52 spid8 Starting up database 'dbHSB'.
2007-11-05 14:04:06.52 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2007-11-05 14:04:06.56 server SQL server listening on 10.122.131.103: 1433.
2007-11-05 14:04:06.62 spid8 Analysis of database 'dbHSB' (7) is 100% complete (approximately 0 more seconds)
2007-11-05 14:04:06.63 server SQL server listening on TCP, Shared Memory, Named Pipes.
2007-11-05 14:04:06.63 server SQL Server is ready for client connections
2007-11-05 14:04:06.66 spid6 Clearing tempdb database.
2007-11-05 14:04:07.10 spid6 Starting up database 'tempdb'.
2007-11-05 14:04:07.20 spid2 Recovery complete.
2007-11-05 14:04:07.20 spid2 SQL global counter collection task is created.
2007-11-05 14:04:16.41 spid1 Warning: unable to allocate 'min server memory' of 1658MB.
2007-11-05 14:10:45.18 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.

View 2 Replies View Related

Kerberos Issue With An Endpoint In SQL 2005 In Cluster Configuration

Oct 17, 2007

Hi all,

I have an issue with an SQL cluster.

I have two MS Windows 2003 Server Ent Ed. SP2 in cluster. They have MS SQL Server 2005 in cluster.

I have created and endpoint and when I try to access I get the attached error in client machine. This problem only occurs in cluster configuration, because the same installation in an SQL (no cluster) works fine.

EventID: 4 Source: Kerberos
The kerberos client received a KRB_AP_ERR_MODIFIED error from the server host/fra-lille-hel03.ea.holcim.net. This indicates that the password used to encrypt the kerberos service ticket is different than that on the target server. Commonly, this is due to identically named machine accounts in the target realm (EA.HOLCIM.NET), and the client realm. Please contact your system administrator.

Anybody knows how to solve it?

Thanks in advanced.

View 1 Replies View Related

How To Migrate Linked Server Configuration SQL 2000 And 2005?

Mar 14, 2007

I plan to migrate a SQL 2000 instance with everything in it to another SQL2000 server, and eventually in the future to SQL 2005.

I've pretty much figured out how to migrate everything execept the linked server configuration (there're many linked servers configured in the old server with different security credentials). I'm wondering if there's way I can save the linked server configuration and restore it to the other server.

Thanks much.

Ed

View 4 Replies View Related

Upgrading Mulitple 7.0 Servers To 2000 Cluster Server

Jun 6, 2002

We shall be taking a bunch of 7.0 instances and moving/upgrading to a SQL 2000 cluster server. I was thinking of creating new named instances on the 2000 cluster and upgrading each 7.0 server to it's respective named instance. Also thought of using the 2000 copy database wizard; I was told this didn't always work. Anyone hear of problems with this?
Thanks

View 2 Replies View Related

Install SQL Server 2000 SP4 Via Remote Desktop On The Cluster.

Apr 17, 2007

Hello.


Has anyone attempted and successfully installed SQL Server 2000 SP4
via remote desktop on the cluster.


The reason I am asking is that SP4 readme file has this:


"...
4.3 Systems Management Server Distributed Installation
You cannot install Database Components SP4 from a remote location.
..."



Currently SQL Server has SP3a installed.


Thank you in advance.

View 2 Replies View Related

How To Uninstall A Specific Instance Of SQL Server 2000 From A Cluster

May 8, 2007

I have a SQL 2000 clustered environment with 4 SQL instances and i need to remove a specific instance from the cluster the resources(physical drive,virtual IP,instance name) being used by it

View 5 Replies View Related

SQL Server 2000 Cluster - Excessive Page Faults

Jul 31, 2007

We are running SQL Server 2000 Enterprise Edition on a 2-node cluster with IIS/ASP.NET front-end hosting 150-200 active connections. There is a SVCHOST process running under LOCAL SERVICE account - hosting the Remote Registry process that is using only 4,200K but is page faulting 200-500 times per second. I realize this process is used for failover, but the page fault seems excessive. Any thoughts on this?

The servers are running Windows Server 2003 with 4 processors and 4gb RAM.

View 1 Replies View Related

SQL Server 2000 Installation Problems On Windows 2003 Ent X64 Cluster

Jun 26, 2006

I have a Windows 2003 Enterprise x64 edition cluster setup and functioning normally. Now, I am trying to get SQL Server 2000 installed as a failover cluster but am having some difficulty. When installing, I get the message '[sqsrvres] ODBC sqldriverconnect failed' in the event log. The message happens when the installer is trying to bring the SQL Server Service resource online.

I am able to ping the name of the instance successfully. I am able to manually start the 'MSSQL$InstanceName' service. I have turned off the firewall on both machines, but this did not help. I have the DTC Service setup as a resource in the same cluster group.

I also read http://support.microsoft.com/default.aspx?scid=kb;en-us;815431 which seemed promising, but did not reolve the problem.



Any help would be much appreciated.

Andy

View 2 Replies View Related

Upgrade An Active Passive Sql Server 2000 Cluster To 2005

Aug 14, 2006

I have upgraded our test server and on non cluster production machine. My next server is a cluster and I don't have a test cluster server. Do I upgrade the active node and that is all or am I going to need to fail it over and upgrade the other node.

Also the prerequesite for the upgrade advisor is .net 2.0 I am going to up that on each server one at a time but I am only going to add the upgrade advisor to one node is that ok.

I read the SP1 documentation and it clearly states only patch the active node and do not patch the inactive nodes.

View 1 Replies View Related

SQL 2012 :: Instance Name Not Appearing In Drop Down List On Cluster Node Configuration Window

May 29, 2013

I am trying to install the MS SQL Server 2012 Failover Cluster on Windows Server 2012 . I successfully Installed the Failover cluster instance on my primary node.

But when I am running the installation process on passive node to add node in the failover cluster I am stuck with very unique kind of issue.

I am following the Standard process of Installation and I am getting the same windows for each next process, but after License Agreement window when I get the Cluster Node Configuration window, then in "SQL Server Instance Name" drop down box I am not getting the Name of Instance which is already installed on the primary node. But this Instance complete information is appearing in below given box.

Only issue is Instance name is not appearing in the drop down list, that's why I am not able to select and when I click on next it trough error and do not proceed.

View 3 Replies View Related

Cluster Sql Server 2000 And Sql Server 2005?

Apr 20, 2006

Can multiple SQL instances (sql server 2000 and sql server 2005) be clustered in an active/active environment?

Thank you.

View 7 Replies View Related

SQL 2005 Express Setup Issue (The SQL Server System Configuration Checker Cannot Be Executed Due To WMI Configuration )

Sep 22, 2007

I am getting following error when trying to install SQL express 2005 on XPSP2.


TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SIGMA-805539A79 Error:2147944122 (0x800706ba).

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342


I tied re-installing WMI using http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx link but could not get it working.


Do i need IIS installed? Its not installed on this box...

please suggest something... i am stuck...

Thanks,

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved