The process of running the Mssql database as a regular user

Published: 2014-12-26

After installing sqlserver, it runs as the system account by default. If it encounters injection attacks, overflow vulnerabilities, etc., hackers will obtain system privileges, causing great harm.


It is recommended to download the script on the server:

http://download.myhostadmin.net/%E5%B8%B8%E7%94%A8/mssqlputong.bat  


Change it to run as a normal user.

If it is a 2008 database, our company's template is already a normal user; if the above bat has been executed, it may cause the service to fail to start.

In the local user group, add the mssqluser user to the corresponding database group and it can start, as shown in the figure below.

blob.png

Then start the service and it will start normally.