Surface Area Configuration Tool Is Discontinued, SQL-DMO Removed from Microsoft SQL Server 2008 Express

Hi Denis Gobo,

I am trying to install the SQL Server 2008, but I

am coming up on the issue which the Surface Area Configuration available

with SQL Server 2005 would solve.

I need to allow remote connections / or any connection to the server.

I simply do not know where to start with the Declarative Management

Framework.   It seems I would need to use the SQL Management Studio

to begin to configure with the Declaration Management, but I can not

open any connection.

That's my problem.  Do you know of a solution.

Tom Cubbins

cubbins@hotmail.com

Tom, U need to right click on the sever instance go to properties and make sure " allow remote connections is ticked.  

Then you need to go the the SQL server configuration manager and enable the protocals you wish to use for the server and client.

Also make sure that the SQL serrver browser is started in the SQL server services node.

If you still have problems turn of your desktop firewall.

Forgot to mension a good idea is to restart the computer, to make sure the services are restarted and the new settings are applied.

Hi Denis,

I'm trying have a strored procedure in sqlserver 2008 that uses the xp-cmdshell.

sins the surface area counfiguration is discontinued in this fersion I tried to script in with the following:

EXEC sp_configure 'show advanced options', 1

GO

RECONFIGURE WITH OVERRIDE

GO

EXEC sp_configure 'xp-cmdshell', 1

GO

RECONFIGURE WITH OVERRIDE

GO

EXEC sp_configure 'show advanced options', 0

GO

I get an error like this:

The configuration option 'xp-cmdshell' does not exist, or it may be an advanced option.

Any ideas?

En...ja Ajax is de beste.

Please let me know.

Hi Denis,

Thanks for this information.  Rod

Where do I need to get to in dos to execute this command?

I have the same problem with needing to enable xp_cmdshell

Thanks for the info guys!

PingBack from http://www.alfredivy.per.sg/blogger/?p=1114

Right click on the Server instance,Select Facets, from the top drop down select Surface are configuration and enable the last option setting to True

For more information visit the following lick

Go to http://technet.microsoft.com/en-us/library/ms161956.aspx