Where is the Surface Area Configuration tool in SQL Server 2008
来源:互联网 发布:淘宝怎么下载 编辑:程序博客网 时间:2024/06/06 03:47
Problem
I just installed a new instance of SQL Server 2008 and I can't find the Surface Area Configuration tool that I used to use in SQL Server 2005. How can I manage the Database Engine features in SQL Server 2008?
Solution
Microsoft has removed the Surface Area Configuration tool that was shipped in SQL Server 2005. The Services and Connections that were once managed in Surface Area Configuration tool should now be managed using the SQL Server Configuration Manager. So how do you manage the Database Engine features? You can now manage the Surface Area Configuration for the Database Engine using Policy Based Management. A new Surface Area Configuration Facet in SQL Server Management Studio exposes the properties necessary to make required changes.
First, right-click on the instance name that you would like to configure in SQL Server Management Studio and select "Facets" from the context menu as shown below.
This will display the View Facets dialog box that will provide you with a drop down of all the available facets that can be configured for the instance.
Select "Surface Area Configuration" from the Facet drop down to display the properties exposed by that facet. Make the appropriate changes and select OK to apply them to the server.
One interesting feature is the ability to make the appropriate changes for your organization and export them to create a policy using the "Export Current State as Policy..." button. This allows you to configure this once and use this policy throughout your enterprise.
Next Steps
Although you can use the Surface Area Configuration Facet to manually implement the changes on each individual server, you should review some other articles on Policy Based Management. Once you see the power of using Policy Based Management with a Central Management Server, I think you will be pleasantly surprised by these new changes in SQL Server 2008.
- Where is the Surface Area Configuration tool in SQL Server 2008
- -server 'default' is an unknown server in the configuration file.
- Where is the XML Editor in Eclipse
- Where is the xm Command in XenServer
- 错误提示「URL file-access is disabled in the server configuration」解决方案
- there is no examin menu in the top tool bar
- MyEclipse启动报错The configuration area at is not writable
- where is the first step in Lean thinking
- where is the chrome exension in my computer
- Where is the 'this' pointer stored in computer memory
- Where is the TJH?
- Where is the Marble
- Where is the Marble?
- Where is The Marble
- Where is the Marble?
- Where is the Marble?
- Where is the Marble?
- Where is the Marble?
- Java初学者实践:httpclient+HTMLParser 的应用
- Java初学者实践:httpclient+HTMLParser 的应用
- 注册windows
- USACO算法系列四——inflate
- 一个Sqrt函数引发的血案
- Where is the Surface Area Configuration tool in SQL Server 2008
- ADO.NET小结
- 安装Ubuntu10.10(RC)方法
- 解释:Alpha,Beta,RC,OEM各个版本
- 美好的事情
- 深入浅出JSON
- fork
- SQL Server 2005 T-SQL 学习笔记:排名函数
- zjut 1166 a-b