Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Cluster   (RSS)

On a Clustered SQL Server 2005 running on Windows 2003 machine the maintenance plan MIGHT fail with: “The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired)”

On a Clustered SQL Server 2005 running on Windows 2003 machine the maintenance plan fails with below error. This issue is also seen on a newly created a maintenance plan as well. Executed as user: <Domain>\User. Microsoft (R) SQL Server Execute Read More...
Posted Monday, November 09, 2009 3:12 PM by Nikesh Mhatre | 0 Comments
Filed under: ,

Unable to failover a Named instance of SQL server 2005 in cluster or unable to bring a Named Instance of SQL server 2005 Online

The problem is that we have a Named instance of SQL Server 2005 in a 2 node cluster. While trying to bring the SQL Services online we get these error messages in the Application Event Log. Application Event Log: Event Type: Error Event Source: MSSQL$SQL2k5 Read More...
Posted Thursday, August 20, 2009 9:19 PM by sanjayap | 0 Comments
Filed under: ,

INFORMATIONAL: Understanding and Troubleshooting MSP Error: 29512 SQL Server Setup was unable add user <Domain\Username>, when you try to install SQL Server 2005

Good morning Folks! Today I will take you through a setup issue that many of you might have run into when trying to install SQL Server 2005 (especially on a cluster). I’ve tried to list down all possible solutions to the following errors one faces while Read More...
Posted Thursday, August 20, 2009 11:55 AM by sanjayap | 0 Comments

SQL Server 2005 SP2 installation hangs on a 2 Node cluster with the message: "Awaiting first complete passive cluster node"

Environment: SQL Server Enterprise Edition 2005 32 bit on Windows Server 2003 Enterprise SP1 Consider a scenario where you are installing SQL Server 2005 Servce Pack 2 on a clustered environment. Sometimes you will notice that the installation get hung Read More...
Posted Thursday, April 09, 2009 7:04 PM by sanjayap | 1 Comments

SQL Server 2005 Setup Failing to Install on Cluster with Unexpected Failure while Performing the SCC checks

We have observed a number of cases where the installation of the SQL server 2005 instance on the cluster fails with the following unexpected Failure Error Message while performing SCC checks. ERROR MESSAGE: ==================== There is unexpected failure. Read More...
Posted Wednesday, December 17, 2008 1:01 AM by sanjayap | 1 Comments

Did you know... Error: 29565 SQL Server Setup cannot upgrade the specified instance because the previous upgrade did not complete

We have observed a number of cases where the installation of SP2 succeeds on Active Node while it may fail on the passive node while installing SP2 on the clustered instance of SQL server 2005. In order to find the cause of the failure on passive node Read More...
Posted Friday, November 28, 2008 5:07 PM by sanjayap | 1 Comments

Did you know... SQL Server 2000 cluster Resource Fails to come online with error SuperSocket Info: Bind failed on TCP port 5184 reported in errorlog!

In order to change the Virtual IP of the sql server 2000 clustered instance we need to follow the following KB article http://support.microsoft.com/kb/244980 However If we try to change the Virtual IP by mapping the Virtual Server Name of the sql server Read More...
Posted Friday, October 17, 2008 1:18 AM by sanjayap | 0 Comments

How to Change the Dynamic Port of the SQL Server Named Instance to an Static Port in a SQL Server 2005 Cluster

In SQL server the default instance has a listener which listens on the fixed port which is TCP port 1433. This is the default behavior. However for the named instance the port on which the SQL server listens is random and is dynamically selected when Read More...
Posted Monday, June 02, 2008 2:41 PM by sanjayap | 2 Comments

How to convert a standalone Instance of SQL Server into an Clustered Instance

For SQL Server 2000: Case 1: If the default instance of sql server is to be upgraded to default clustered instance of sql server 2000 Note: 1) Only Default instance can be upgraded by this method 2) This Functionality is not vailable in sql server 2005 Read More...
Posted Sunday, April 27, 2008 9:20 PM by sanjayap | 1 Comments
 
Page view tracker