Sql2005 Cluster, how do you get to surface area configuration

Question

Sql2005 Cluster, how do you get to surface area configuration

Summer90

SSC-Dedicated

Points: 32891
More actions
May 11, 2010 at 11:15 am

#143055

On a SQL 2005 Cluster I am trying to open up the Surface Area Configuration while logged onto the server via the Virtual server name. As I open it I get this message but I AM connected via that not by the physical server. What am I missing here? Win2003 SQL 2005 SP3
TITLE: Surface Area Configuration
------------------------------
You cannot configure surface area of clustered services by connecting to a computer name. Connect to the virtual server to configure clustered services. (SQLSAC)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 234013 More actions · Answer 1

doesnt matter if you are logged onto the machine via the virtual name. You need to tell SAC manager by clicking the 'change computer' option and specifying the virtual server name.

Currently it will read something like 'Configure surface area for localhost'. Change this to be the virtual server name!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 2

Summer90

SSC-Dedicated

Points: 32891

May 11, 2010 at 11:35 am

#1165723

Wow.... Great... Thanks! That worked...

Perry Whittle SSC Guru Points: 234013 More actions · Answer 3

your welcome

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

clyde46 Grasshopper Points: 23 More actions · Answer 4

I was able to log in to the SAC with the virtual server name but when I try to enable xp_cmdshell I get "Alter failed.

------------------------------

ADDITIONAL INFORMATION:

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo)"

Any advice?

Everything is relative.

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 5

Please start another thread for your issue. We will try to help you.

clyde46 Grasshopper Points: 23 More actions · Answer 6

Thanks but I went ahead and used this T-SQL;

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'xp_cmdshell', 1;

GO

RECONFIGURE;

GO

Everything is relative.

Anamika SSCertifiable Points: 6202 More actions · Answer 7

thanks,

i was having the same issue and got resolved.