Configuring SQL Server 2008 after installing SQL Server 2008

Recently, a few of my customers complaint to me the they couldn’t find the Surface Area Configuration anymore in SQL Server 2008. You should be using the SQL Server Configuration Manager in SQL Server 2008. SQL Server Configuration Manager is a tool to manage the services associated with SQL Server, to configure the network protocols used by SQL Server, and to manage the network connectivity configuration from SQL Server client computers. SQL Server Configuration Manager can be used to start, stop, pause, resume, or configure services on another computer.

SQL Server Configuration Manager and SQL Server Management Studio use Window Management Instrumentation (WMI) to view and change some server settings. WMI provides a unified way for interfacing with the API calls that manage the registry operations requested by the SQL Server tools and to provide enhanced control and manipulation over the selected SQL services of the SQL Server Configuration Manager snap-in component.

To open the SQL Server Configuration Manager
1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Configuration Manager.

To configure a service to start automatically
1. In SQL Server Configuration Manager, expand SQL Server Services.
2. In the details pane, right-click one of the SQL Server services, and then click Properties.
3. In the Properties dialog box, set Start Mode to Automatic.

To configure the Database Engine to accept remote connections
1. In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click Protocols for <instancename>.
2. In the details pane, right-click one of the available protocols, and then click Properties.
3. To enable a protocol for remote connections, set the Enabled box to Yes.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: