sp_dropserver and sp_addserver manual steps are required for configuring the internal name of the clustered instance for Microsoft SQL Server 2005 service group under SFW-HA 5.1 SP1 and VCS 5.1 SP1

book

Article ID: 100001854

calendar_today

Updated On:

Resolution


The manual steps needed to add the internal name forthe clustered instance for Microsoft SQL Server 2005 are intended to be fullyautomated in future releases of SFW-HA and VCS Products

The steps need tocomplete this process are the following:
Setting theinternal name to clustered instance (SQL 2005)
Note: Performthese steps only once per instance and must be done after SQL Server isinstalled and configured on the last failover node.
Toset the internal name to a clustered instance
1.Start the SQL Server Management Studio. Click Start > All Programs >Microsoft SQL Server 2005 > SQL Server Management Studio.
2.In the Connect to Server dialog box, provide the connectioninformation:
  • Selectthe server type.
  • Enterthe server name in the format system_name/intance_name. For a default instance,enter only the system name.
  • Selectthe appropriate authentication mechanism.
  • Entervalid user credentials if using Domain Authentication
  • ClickConnect.
3.Open a new query window in the right pane.
Fromthe Object Explorer in the left pane, right-click the SQL Server instance namethat will be set to the virtual server name.
From thepop-up menu, click New Query. A query window appears in the right pane. Use theSQL Server Management Studio to set the internal name of the clustered instanceto be the virtual server name. Before you proceed ensure that the volumecontaining the SQL data files is mounted, and the SQL Server service isstarted.
4.Perform the following steps in the query window:
  • Retrievethe SQL Server name
  • Typesp_helpserver in the upper pane.
  • PressF5.
Makea note of the name listed in the lower pane. For a default instance, the namewill be System Name. For a named instance, the name will be System Name\InstanceName. You must provide this name in the next step.
  • Disconnectthe database
  • Deletethe content in the upper pane.
  • Typesp_dropserver 'name of the system displayed in previousstep\instance_name'.
  • PressF5.
  • Reconnectthe database using the clustered instance name
  • Deletethe contents in the upper pane.
  • Typesp_addserver 'name of clustered instance', local
  • PressF5.
5.Exit the SQL Server Management Studio.
6.Stop the SQL Server instance.

7. Unmount the volumes. See “Unmounting thevolumes” on page 64 for instructions.
 

 

Issue/Introduction

sp_dropserver and sp_addserver manual steps are required for configuring the internal name of the clustered instance for Microsoft SQL Server 2005 service group under SFW-HA 5.1 SP1 and VCS 5.1 SP1
Powered by Wolken Software