August 27, 2010 at 12:54 am
Hi,
We have SQL Server 2005 x64 with SP3 on a 2 node a/p Windows 2003 x64 with SP2 cluster. We are Upgrading SQL Server 2005 x64 with SP3 on Windows 2003 x64 with SP2 to SQL Server 2008 x64 with SP1
Existing Configuration:
Node1: SQL01 – Windows 2003 x64 (SP2) - Active
Node2: SQL02 - Windows 2003 x64 (SP2) - Passive
Virtual Server name: SQLVS
Instance name: INS1
SQL Server: SQL Server 2005 x64 with SP3
Planned Configuration:
Node1: SQL03 – Windows 2008 x64 (SP2) - Active
Node2: SQL04 - Windows 2008 x64 (SP2) - Passive
Virtual Server name: SQLVS
Instance name: INS1
SQL Server: SQL Server 2008 x64 with SP1
Note: Here, our application requires same instance name after the upgrade.
So we must need to keep the same SQL Server instance name
As the in-place Upgrade from Clustered Windows 2003 to Windows 2008 is NOT possible and NOT supported by MS, we are following the below steps:
1.Backup the databases , logins, jobs
2.In Cluster Administrator, Make the SQL Server Group offline
3.Delete the Fail over Virtual Server name SQLVS from AD
4.Evict the passive node SQL02
5.Build the Server with Windows Server 2008 with SP2 and node name is SQL03
6.Create and configure the cluster
7.Grant the permission to Cluster name to create objects in AD
8.Create and configure MSDTC
9.Validate the Single node cluster SQL03
10.Install .Net Framework 3.5 SP1
11.Install SQL Server 2008 with SAME NAME SQLVS & INSTANCE NAME INS1 and then install SQL Server 2008 SP1 on new node SQL03
12.Restore the databases and move the logins, jobs from step 1 to the new SQL 2008 instance SQLVS\INS1
13.Verify the resources are online the databases are up and running
14.Perform post upgrade steps
15.Evict the node SQL02.
16.Build the Server with Windows Server 2008 with SP2 and node name is SQL04
17.Create and configure the cluster
18.From Failover cluster manager, Perform ADD node option. The ADD node was successful but at this step we are getting the following warning:
The node was added successfully, but the 'SQL Server' resource type could not be installed on it. Unable to find 'sqsrvres.dll' on any of the cluster nodes
Question:
Can we ignore and continue with Install SQL Server 2008 using ADD NODE option?
Thanks
August 27, 2010 at 1:37 am
The node was added successfully, but the 'SQL Server' resource type could not be installed on it. Unable to find 'sqsrvres.dll' on any of the cluster nodes
Question:
Can we ignore and continue with Install SQL Server 2008 using ADD NODE option?
Absolutely, the warning saying that you need to configure SQL Server 2008 on the added node.
So you are good to go:-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply