Configuring SQL Server

Feature Only in Enterprise Edition   This feature is supported only in Visual C++ Enterprise Edition. For more information, see Visual C++ Editions.

To use the SQL debugger, you must configure SQL Server according to the following instructions.

To configure your computer to run SQL Server as an NT Service

1. From the Control Panel, choose the Services application.

   The Services dialog box appears.

2. In the list box, select MSSQLServer.
   
   
3. Click Startup.

   The Service dialog box appears.

4. Click This Account.
   
   
5. In the This Account edit box, enter the logon user account of the person who will be using the SQL debugger. For example, type Domain1\MarkD.
   
   
6. In the Password and Confirm Password edit boxes, enter the user’s password.

Note   You must change and confirm the password in the Service dialog box if the user’s NT password changes.

7. Click OK.
   
   
8. Click Close.

   The SQL Server is now configured as an NT Service.

Note   The SQL Server is incorrectly configured if SQL debugging fails and the event log contains the entry, “SQL Server when started as service must not log on as System Account. Reset to logon as user account using Control Panel.”