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


Post New Web Links

mixed SPs in a cluster environment

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :
 

we are planning to install sp4 on our cluster environment.  but the question came up "what if the problem being solved is overshadowed by something introduced by SP4"?  We are looking at installing Sp4 on the active node only.  If something doesn't work right then we could failover to the passive node still on SP3.

I haven't seen this configuration stated as supported but i thought i would ask.

dan


-- dan


View Complete Post


More Related Resource Links

SQL Server 2005 - Installation in Cluster Environment - "Service SQL Server Browser (SQLBrowser) fai

  
Windows Server 2003 R2 Enterprise Edition SP2 32-bit All updates and patches installed Two-node cluster environment configured. Cluster functions perfectly. Trying to install SQL Server 2005 Enterprise Edition (32-bit) as a clustered application. Installation proceeds fine until it begins to install the SQL Server Database Services product. Status window says "Starting Services. Service: SQL Server Browser". Error message is presented: "Service 'SQL Server Browser' (SQLBrowser) failed to start. Verify that you have sufficient privileges to start system services". SQL Server Service Account is in the Administrators group on both local systems, and is a domain account. Account used for the installation is in the Administrators group on both local systems, and is a domain account. Have cancelled out of the install and rebooted both servers numerous times. Exact same error continues to occur. Cluster is active and all resources are owned by node #1 - the node where SQL Server Installation is being run. In the event viewer, I see: Event ID: 10 Description: The SQLBrowser service was unable to establish SQL instance and connectivity discovery". I am also seeing errors like: Source: SQLBrowser. The SQL configuration for SQL is inaccessible or invalid. Source: SQLBrowser. The Configuration of the AdminConnection\TCP protocol in the SQL instance xxxxxx i

Network failure in Cluster Environment,will it stop the SQL Server Instances?

  
Hi All I have problem with cluster Environment that is there is network failure in Cluster Environment,will it stop SQL Server Instances Event viewrer Information 6:22:09 The MSSQLSERVER service entered the stopped state. 6:22:05 The MSSQLSERVER service was successfully sent a stop control. 6:22:04 The SQLSERVERAGENT service entered the stopped state. 6:21:43 The node lost communication with cluster node 'MSSQL0002' on network 'LAN'. 6:22:02 The SQLSERVERAGENT service was successfully sent a stop control. 6:22:02 Cluster resource 'SQL IP Address1(SQLCLUSTER)' in Resource Group 'SQL' failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'Cluster IP Address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'MSDTC IP address' has failed. 6:22:02 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 The TCP/IP interface for Cluster IP Address 'SQL IP Address1(SQLCLUSTER)' has failed. 6:21:58 Cluster network 'LAN' is operational (up). All available server cluster nodes attached to the network can communicate using it. 6:21:58 The interface for cluster node 'MSSQL0002' on network 'LAN' failed. If the condition persist

in-place upgrade in cluster environment(2000 to 2008),How to do compatabilty Test ???

  
Hi all As of I know there are three tools are involved in Upgrade process. 1.UpgradeAdvisor 2.RML utility 3.SQL Server Upgrade Assistant. I want do compabilty test...which tools in Best for that...  Thanks in advanceSNIVAS

SQL Server 2005 64bit -SP3 rollback process on A/P Cluster Environment

  

Hi all

Erlier I posted a questions Which I got Answer form Alberto Morillo & Siva...

See link http://social.technet.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/52bf813a-cd8b-4e40-a9a3-e80ceea0ee1b

in fact my question suppose to be  "SQL Server 2005 64bit -SP3 rollback process on A/P Cluster Environment"

Please some body guide rollBack process for given Rollout.

Pre-SQL Server SP3 Installation Steps. 

1. Prior to Installing the SP3,Take  the  Full Backup of All Database (System Databases, User Databases), Databases backup is required  for roll back process, If installation causes any Database Damages

2. Disconnect the all Application connects.

3. Announce the Down time for 60 minutes

SQL Server SP3 Installation Rollout Steps. 

1. Log into the server as an account that has privileges to install the service pack. On a failover
Cluster, this must be the cluster service account or a domain account that has ad-ministra

Hot fixes for Windows 2003 SP2 for Installing SQL Server 2008 R2 In Cluster environment

  

Hello all

Please some body help me to  find Hot fixes  for Windows 2003 SP2 to install SQL Server 2008 R2 In Cluster environment.

 

 

 

Thanks in Advance  


SNIVAS

SQLDIAG fails in SQL Server 2008 Cluster environment.

  

SQLDIAG failing with following errors in SQL Server 2008 cluster environment:

SQLDIAG Error opening Software key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG Failed to open Software\Microsoft\MSSQLServer key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG Failed to open Software\Microsoft\MSSQLServer key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG . Function result: 87. Message: The p

Adding New Storage for new Instance in Windows 2003 Cluster environment.

  

Hello all

Part of Preparation for adding new Instance in Cluster I required


1. IP   - I got It

2. Network name    - I got It

3.free disk resources     - I got iSCSI drive but I have to intilize now.

Here my question is

I have to Intilize the "iSCSI" from Both ndoes or it is ok if I intilized from Active node.


Please advise me.

Thanks in Advance


SNIVAS

Is a 3 Node Cluster the way to go for a high availability environment?

  

Good Morning,

My company currently has a 2 Node SQL 2008 Active / Passive cluster. Due to the sensitivity and ugency of our industry, we have to maintain a 100% uptime for our clients. The issue here is that we cannot do any maintenance that involves failovering the cluster (patching, SPs, etc), because of the time it takes to failover (even a few seconds is critical).

We are considering going to a 3 Node Active / Active / Passive cluster, with the theory that since one Node will always be active, we can failover to the passive Node without any disruption. However, we're not sure if this would be the case, and if it isn't, would there be something we can do instead to keep uptime at 100% w/o the risk of our environments being outdated?

Thank you all in advance,

Nick Gargano, Sr. DBA


Built For Speed: Develop Turbocharged Apps For Windows Compute Cluster Server

  

This article explores the services provided by Compute Cluster Server 2003 and the tools provided by Visual Studio 2005 that will help you develop High-Perfomance Computing applications.

Rich Ciapala

MSDN Magazine April 2006


.NET Delegates: Making Asynchronous Method Calls in the .NET Environment

  

One of the many great features of the .NET Framework is that it has asynchronous infrastructure built in. In .NET you can call any method asynchronously by defining a delegate for the method and calling the delegate's asynchronous methods. This is beneficial to your application because when a synchronous call is made, the calling thread is blocked until the method completes whereas an asynchronous call is made on a different thread, and this allows the original thread to continue its work while the asynchronous call is in progress.This article explains delegates in .NET and how to use them to perform asynchronous calls, eliminating age-old threading problems.

Richard Grimes

MSDN Magazine August 2001


Windows CE: eMbedded Visual Tools 3.0 Provide a Flexible and Robust Development Environment

  

This article provides an overview of writing applications for Windows CE 3.0. Unicode support in Windows CE, the kernel, memory management, the object store, and COM and DCOM are discussed. The article also covers the user interface, graphics, the Internet, and how Windows CE compares to the desktop in each of these areas. eMbedded Visual Tools 3.0 is discussed in depth. To help the reader decide which tools to use, development with Visual Basic, Win32, MFC, and ATL are explained. Text editor samples with this article have been developed with Visual Basic and Win32 so their implementations can be compared.

Paul Yao

MSDN Magazine January 2001


SSRS 2005 "Mixed" Authentication Mode

  

I have a web application where users can authenticate using either SiteMinder or Windows domain accounts.  This is actually configured as two separate virtual directories within IIS 6.  Both applications need to use the same instance of SSRS.  Is it possible to configure the SSRS web application so that if a user is authenticated by SiteMinder it impersonates a Windows account, but if they are already Windows-authenticated that account is used instead?


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