In the tutorial windows 11th Server Installation and setup tutorial-mssql security Article 1 (run ms SQL Server under a common user), the author said step 1 "after setting directory permissions, the ms SQL Server Running user needs to be set to mssqlrun; "is implemented through the" service "in the management tool of Windows2003. This operation has never been a problem, however, today, Microsoft SQL Server cannot be started. The solution is as follows:
Check NTFS permissions, no problems found; reset the user, the situation is still the case; restore the initial windows status and reinstall sqlserver, according to the installation and setup tutorial of Windows Server-mssql security Article 1 (run ms SQL Server under a common user), the user cannot be started, and the user is restored to the initial installation status from windows, use the sqlserver installation disc with successful settings to install it. After installation, the problem still cannot be solved.
If you think of another place to set up a running user, you can manage the server in the sqlserver Enterprise Manager and set it through the Enterprise Manager, if mssql security Article 1 (running ms SQL server on a common user) is not successfully set through Windows Server Installation and setup tutorial, you can replace steps 11th to 14th with the following process:
Open the sqlserver Enterprise Manager and connect to the sqlserver server you want to set, as shown in:
Right-click the server name you want to set, select "properties" in the pop-up menu, open the Properties dialog box, and click the "Security" tab. The interface shown in is displayed:
Find "this account" under "Start Service Account", click "select", and enter the user name and password of the set common user in the text box that follows, as shown in:
After entering the information, click "OK". The sqlserver dialog box is displayed, as shown in:
Click OK to restart sqlserver.
At this time, sqlserver runs again under the normal user permission and is set successfully.
This method is supplemented by mssql security Article 1 (running ms SQL Server under normal users, solved the problem that SQL Server cannot run under the permissions of common users.