Surface area configuration in 2008 ? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Other SQL Server 2008 Topics

Surface area configuration in 2008 ?

Author

Topic

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-07 : 19:26:58

hello,
We installed MS SQL 2005 express and 2008 on the same server.

However I cant seem to find the "SURFACE AREA CONFIGURATION TOOL"

Does anyone know where it is or has it been replaced by something else ?

Thanks

Ehi

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-07 : 19:42:54

A quick Google brought me to this: http://sqlblog.com/blogs/denis_gobo/archive/2007/11/20/3441.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-07 : 19:53:28

Amazing

Quite an interesting article. Thanks Tara.

Back to the problem. I tried using TSQL scripts to configure it, running the script below. But get an error


sp_configure 'Ole Automation Procedures', 1;
GO
RECONFIGURE;
GO

But i get this error.

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 51
The configuration option 'Ole Automation Procedures' does not exist, or it may be an advanced option.

However when i run

SELECT * FROM sys.configurations
ORDER BY name ;
GO

I get 'Ole Automation Procedures' back.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-07 : 19:58:37

Did you enable advanced options?

EXEC master.dbo.sp_configure 'show advanced options', 1
RECONFIGURE

EXEC master.dbo.sp_configure 'Ole Automation Procedures', 1
RECONFIGURE

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-07 : 20:10:49

Thanks a lot.

It worked.

However, I noticed that the individual Extended SP I wanted to use had permissions set on them "INDIVIDUALLY" so i had to add public permissions to each of the objects in the master DB.

Which is a lot different from 2005, whereby I simply enable the surface area configurations.

Thank you.

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-08 : 03:22:57

Though the above is sorted using TSQL Statements.

Does anyone know where or what has replace "SURFACE AREA CONFIGURATIONS" in MS SQL 2008 ???

Or how to handle it via GUI ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-08 : 12:32:55

It shows in the link that I posted what replaced it.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-10-08 : 17:19:38

Ok.
Am interested in OLE Automation which falls under the database engine.

According to that blog it says the DB Engine now comes under "Declarative Management Framework" Cant seem to find that in 2008. But will keep at it.

Ta

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources