SQL Server normal user run error resolution supplemental _win servers

In the Tutorial Windows2003 Server installation and Setup Tutorial--mssql Security Chapter One (with MS SQL Server running under ordinary users), the author said 11th step "after setting the permissions on the directory, you need to set the running user of MS SQL Server to Mssqlrun;" "is implemented by" services "in the Windows2003 administration tool, which is not a problem, but today it is. Unable to start Microsoft SQL Server, the resolution process is as follows:

Check NTFS permissions, no problem found; Reset user, this is still the case; re-restore Windows to its initial state reinstall SQL Server and install and set up a tutorial based on Windows2003 Servers--mssql Security Chapter One (Will Ms SQL Server runs under normal user settings, the user is still unable to start, restores windows2003 to the initial installation state, and installs with the SQL Server installation CD that has been successfully set up, or does not resolve the problem after the installation is complete.

After baffled, think of another place to set up the running user, that is, to manage the server in SQL Server Enterprise Manager, set up through Enterprise Manager, if you install and set up a tutorial through the WINDOWS2003 Server--mssql Security Chapter One (Will Ms SQL Server running under normal user) cannot be set successfully, you can replace steps 11th through 14th with the following procedure:

Open SQL Server Enterprise Manager, and connect to the servers you want to set up, as shown in the following illustration:

Right-click on the name of the server you want to set, select Properties from the pop-up menu, open the Properties dialog box, click the Security tab, and the following image shows the interface:

Under Start service account, find "This account", click to select, in the following text box, enter the user name and password of the normal user set, as shown in the following figure:

When you are finished, click OK, and SQL Server pops up the dialog box as shown in the following illustration:

Click OK to restart SQL Server.

At this time, SQL Server is running under the normal user rights, set successfully.

This method is used as a Windows2003 server installation and Setup Tutorial--mssql Security Chapter One (with MS SQL Server running under normal user) complements, successfully resolves the problem that SQL Server cannot be run under the rights of ordinary users.