I am trying to run the 'SQL Server Surface Area Configuration' for our SQL
2005 Cluster Server (passsive/active). The Configuration does point to the
Virtual IP of SQL cluster. I still have the following error message. I try to
run the Configuration on active node, passive node, remotely, all the same
error message. Any idea ?
You cannot configure surface area of clusted services by connecting to a
computer anme. connect to the virtual server to configure clustered services.
(SQLSAC)
thanks
nkumari - 31 Mar 2006 20:44 GMT
Faced same problem and got the solution.
http://msdn2.microsoft.com/en-US/library/ms173748(SQL.90).aspx
SQL Server Surface Area Configuration is available on the SQL Serve
start menu:
On the Start menu, point to All Programs, Microsoft SQL Server 2005
Configuration Tools, and then click SQL Server Surface Are
Configuration.
The first page to appear is the SQL Server Surface Area Configuratio
start page. On the start page, specify which server you want t
configure:
Click the link adjacent to Configure Surface Area for. The defaul
value is "localhost". If you previously selected a named server, yo
would see the server name.
In the Select Computer dialog, do one of the following:
To configure SQL Server 2005 on the local computer, click Loca
computer.
To configure SQL Server 2005 on another computer, click Remote compute
and then enter the computer name in the text box.
To configure a failover cluster, click Remote computer and then ente
the virtual server name in the text box.
Click OK
--
nkumar