Figure

Selecting the Automatic start mode for SQL Server.

SQL Server (SQLEXPRESS] Properties 1-gHliSM

Log On Service | Advanced |

3 General

Binary Path Error Control Exit Code Host Name Mame Process ID SQL Service Type

J: \Program File ^ Microsoft SQL S 1 0

DELL_DIMEN_8300 SQL Server ISQLEXPRE55) 2000

SQL Server

U Start Mode

Disabled !»!

State

Disabied ^^^ Manual

Start Mode

The start mode of this service,

6. Click OK. Next, right-click the SQL Server Browser row and select Properties.

7. Click the Service tab and set the Start Mode attribute to Automatic if needed, similar to step 5.

8. If you had to set the start mode to Automatic, and the state of the Browser was stopped, start it manually by right-clicking the SQL Server Browser row and selecting Start (Figure 18.6).

FIGURE 18.6

Manually starting the SQL Server Browser.

FIGURE 18.6

Manually starting the SQL Server Browser.

9. You will get a progress bar (see Figure 18.7) as the SQL Server service is started.

FIGURE 18.7

Starting the SQL Server service.

FIGURE 18.7

Starting the SQL Server service.

Next, you must enable network access — this is required even if you are connecting to SQL Server on the same computer.

1. Start by expanding the SQL Server 2005 Network Configuration folder in the left pane of the SQL Server Configuration Manager, and select the Protocols for SQLEXPRESS folder under it.

2. Enable the TCP/IP protocol from its right-click menu (Figure 18.8).

0 0

Post a comment