.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
SP
satyapriyanayak
Subhransu Sekhar Jena
abhays
DotnetUser
Post New Web Links

SQL Instance Installation on Passive Node

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server
 

Dear All,

I need a suggestion from you guys, one of our client asking me about the SQL Server New Instance Installation on SQL Cluster Passive node.

 

Scenario

Node 1

SQL Cluster (Active) Connected with SAN Fiber Channel

 

Node 2

SQL Cluster (Passive) Connected with SAN Fiber Channel

 

They are asking

Node 2

SQL Cluster (Passive) Connected with SAN Fiber Channel

New Instance of SQL Server (StandAlone) Will Connect with other Fiber Channel SAN Storage

 

Please let me know is it a good practice or Any Risk on that if we will implement that scenario.

 

Regards,

Adnan

 


Adnan Khan


View Complete Post


More Related Resource Links

SQL node remove failed on Cluster :The state of your SQL Server installation was not changed after t

  
HI guys , Have you faced this .I am not able to remove the SQL Server 2008 ENT node .The error is : Overall summary:   Final result:                  Failed: see details below   Exit code (Decimal):           -2068643838   Exit facility code:            1203   Exit error code:               2   Exit message:                  The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details.   Start time:                    2010-09-12 09:40:40   End time:                      2010-09-12 09:48:26   Requested action:              RemoveNode The details.txt shows the same error in a different way : Running Action: CloseUI 2010-09-12 09:44:44 Slp: Stop action skipped in UI

Issues reinstalling a Second Node (Active/Passive) SQL Server 2005 Lustering

  
We originally had an Active /Active-Passive Node Cluster; (SQLCLUSTER1 (S1) and SQLCLUSTER2 (S2). After a client who needed access to SQLCLUSTER2 was unable to connect, I discovered that the TCP Ports somehow got corrupted.  I couldn’t find a 1433 port. So, I obviously had to do a reinstall.  NOTE: S1 contains the R and S drives (SANs).  S2 contained the T and U drives (SANs as well).   I used the following site to check my install: http://www.sql-server-performance.com/articles/clustering/cluster_server_2003_p1.aspx  By: Brad McGehee   While installing a failover (active/passive node) everything was going well, until I got to the Cluster Group Selection screen.  Under Available cluster groups showed: Cluster Mgmt Group (this Group contains the Quorum Q drive). Under the Unavailable cluster groups showed:  SQL Cluster Group (SQLCLUSTER1) – Already contains a SQL Virtual Server and the next one, SQLCLUSTER2 – Already contains a SQL Virtual Server. Under Data files:  I tried to place the data on the T: drive and I received an error stating that I cannot put data on the same drive as the Quorum drive.   Prior to the reinstall of S2, I deleted/removed all SQL Server data on S2.  Perhaps, this is where my problem may lie. So, my first question is, do I need to reinstall S2? My second question is, could there be

SQL Management Studio not on Passive Node SQL 2008 Cluster

  
Hello, I would like to be able to use SQL Management Studio on the passive node in our cluster if there's a failover and Passive Node becomes Active Node.  It seems like the Add Node install didn't load SQL Management Studio on our passive node. Any help is appreciated. Thanks,  Morrisos

Bad Install on our second Active/Passive node (SQL2)

  

Yesterday when I was trying to bind the port 1433 to the IP Address, the Bind didn't work.  I ran 'Netstat -an' and noticed that there wasn't a port 1433 for listening.  I found on MSDN how to manually uninstall a SQL Server Failover Cluster (msdn.microsoft.com/en-us/library/ms180973) .  My question when I proceed is with the uninstall of SQL2 , will this affect our SQL1 Active Node?

 

Thanks,


Add a new passive node to set up Active/Active/Passive cluster

  

 

We have a SQL cluster server running with SQL 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition.

Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So after I have done it, the cluster will be a Active/Active/Passive cluster.

 

Because the cluster is a production server, I need to know exactly how I add a new node onto the current cluster without breaking anything. Also this is my first time to install a passive node, so it is difficult for me to understand how to install and configure it.

 

I have already added the physical node onto the cluster group so I can see the new node 'paused' from the Cluster Administrator.  Now I need to install the SQL but I am too nervous to run the installation p

Intermittent unavailability of an instance in a failover cluster while a standby node is offline.

  

Hi everyone.

I've got a small failover cluster that I run for the websites my company has. During a RAM upgrade of the standby server, our websites started to show errors about not being able to access the database server. I verified that the instance was indeed up and the server accessable via remote desktop.
I also tried a SQL connection to it and it worked, but that might have been after it became available again.

This happened on and off until we were able to roll back the hardware changes that were in progress on the standby server and we were able to bring it back up.

There was nothing of interest in the SQL Server log, but there is a continous log for the whole duration of the problem, so there was no restart of the SQL Server service. The event viewer is of more interest, since it shows events relating to the heartbeat network card, but I don't know how that would affect the availability of the server, since the standby node is offline. I'd appreciate any help you can provide, it's not very redundant if it also depends on the standby server being up. :)

Here are the event logs from the time of the problem:

Level Date and Time Source Event ID Task Category
Information 4/23/2010 10:55:56 AM Microsoft-Wind

sql2005 job not work in passive node

  
We have SQL Server 2005 cluster setup, active/passive, 2 nodes, on Windows
2003. If I try to add a maintenance task using sql management studio .active  node working fine.if active node down Sql agent is not here. so  jobs are not working

sql 2005 cluster ssis not installed passive node

  

I am doing an SQL Server 2005 Cluster install. The install appeared to go
okay. On the active node everything installed fine. However, when we looked
at the other node only the configuration tools got installed. SQL Server
Management Studio did not get installed. Would anyone know what caused this
and how to install the SQL Server 2005 on a cluser correctly? I understand
that that the management tools only get installed on the primary node.
Should I run setup on the secondary node to install the tools?

I also went through the summary log for the install and  noticed that almost
everything that was installed on the active node was  also installed on the
passive node. The products that did not get installed  on the passive node
were:

- Microsoft SQL Server 2005 Integration Services
- Microsoft SQL Server 2005 Notification Services
- Microsoft SQL Server 2005 Reporting Services
- Microsoft SQL Server 2005 Tools

Should not these have been installed on the passive node as well?


Full text search missing from one instance on one node of 3 node MSSQL 2008 cluster

  

Hello to all, 

I just started at a new client and on becoming familiar with the environment, I noticed that one of our instances on one node is missing the full text search option. The instance is not active on this node but I fear that if we ever need to failover it wont work.

The full text option is installed on the active node instance and the other passive node.

How do I add the full text search option to the instance on the node thats missing it ?

thank you.

Paul 


SQL Server 2008 R2 Side by Side installation in Cluster(Active/passive on Windows 2003 SP2).

  

Hi all,

I came again with couple question on SQL Server 2008 R2 side by side installation in Cluster(Active/passive on Windows 2003 SP2).


1.I have already have SQL Server 2000 SP4 Installation.
 
2.Can I start Installation(Side by Side) from Passive node ?

3.you want me give New SQL Server Netwrok name (Instance Configuration  Screen)?.

4.you want me give New Instance ID  name (Instance Configuration  Screen)?

5.Can I chose Excixting Clustore resource group or I need to Create New group which is the best ?

 

Thanks in advance


SNIVAS

Passive node doesn't run scheduled jobs when it becomes the active node

  

I have one cluster with two nodes. For reference, Node A = the normally active node, and Node B = the normally passive node.

When the cluster is running on Node B, scheduled jobs don't run. They work just fine when the cluster is running on Node A.

I have checked that on both nodes, all services are running under the same domain logins, and that both the jobs and the schedules within the jobs are enabled.

Everything else on the SQL seems to be working properly. I'd really like to get this working, but I don't know what else to look into.

Thanks!

@@VERSION: Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)   May 26 2009 14:24:20   Copyright (c) 1988-2005 Microsoft Corporation  Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

SQL 2008 Single Node cluster installation fails on Windows 2008

  

Environment:
SQL Server 2008 Enterprise Edition 64 Bit
Windows 2008 64 Bit SP2

SQL installation failed with this error message:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. Reason: Token-based server access validation failed with an infrastructure error

Please let me know what the issue is.

I found 2 solutions in net:

1. Add new registry key named DisableLoopbackcheck under "HKLM\SYSTEM\CurrentControlSet\Control\Lsa\" and set to value 1

2. Set server principal name


How to re-enable clustered node from previously Passive back to Active cluster?

  

Hi all experts,

 

I pretty new in SQL database along with WinServ clustering, so please mind my knowledge level in the overall process.

http://s961.photobucket.com/albums/ae95/neoswo/?action=view&current=pic.jpg

Base on the screenshot above, we have currently a single cluster created base in which that is controlling DB1 and DB2. Primarily DB1 would be our Active node whereas DB2 would be our Passive, both have it's own designated Public and Private IP. After a small issue previously in which our cluster service failed, it seems that the failover has taken place in which at the moment is running on DB2, which bears the question now is would it be possible to have DB1 being the Active node without downtime? and what is the process flow to change reactivate it back?

Servers Details:

- Win2k3 Ent Application Server

- Win2k3 Ent DB1&2

- IBM DS5020 SAN Storage

On the disk management on each DB servers, we are not able to see the LUNs in DB1 (shown as Unreadable) whereas on DB2 it is shown as normal, in which we would assume that this is normal since DB2 is the active node.

Thanks for reading & most of my search base on this question ended up in this forum, which I would assume that this is the correct place to ask.

Regards.


To install SQL in a passive node

  
Hi..We have a two node cluster. We have the SQL 2000 SP4 running and now active only in one node as the passive node got something wrong and corrupted. Restoring the backups also didnt work. So we have built up that passive node from scratch. We have to again make this working as a two node cluster. Is this possible to install the SQL in one node merging as a cluster pair while it is already running as a cluster in another node after adding the node in the windows cluster ?
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend