I recently took over a server and installed sqlserver. For security reasons, we run sqlserver under normal permissions, so that it will not be caused by the security issues of sqlserver, this may cause the server to become a zombie.
I recently took over a server and installed sqlserver. For security reasons, we run sqlserver under normal permissions, so that it will not be caused by the security issues of sqlserver, this may cause the server to become a zombie.
I read a lot of articles on the official website and sorted out the following steps. It can basically be said that the solution was terminated. Here I have sorted out the steps in detail, hoping to help updated friends, this makes our servers more secure. Dedication to the home.
First, you have installed it.
Step 1:
This section mainly explains how to create and Set permissions for common users.
Disk C requires the following permissions:
C: \ administrators all Permissions
All System Permissions
IIS_WPG read-only and running permissions (only apply to the current folder)
SQL2000 running user (apply only to the current folder)
List folders/read data
Read attributes
Read extension attributes
Read Permission
C: \ Program Files \ Microsoft SQL Server \ MSSQL \ Data (if this directory is used to place the SQL2000 user database)
All permissions for administrators
All System Permissions
All SQL2000 running User Permissions
If your database is attached to disk C, but your database directory is stored in the F: \ SQLDATA directory and the backup database is stored on this disk, you must have the following permissions on disk F:
F: \ (if this partition is used to place the SQL2000 user database)
All permissions for administrators
All System Permissions
SQL2000 running user (apply only to the current folder)
List folders/read data
Read attributes
Read extension attributes
Read Permission
F: \ SQLDATA (if this directory is used to place the SQL2000 user database)
All permissions for administrators
All System Permissions
All SQL2000 running User Permissions
F: \ SQLBACK (if this directory is used to store the SQL2000 backup database)
All permissions for administrators
All System Permissions
All SQL2000 running User Permissions
The preceding settings are basically complete. In addition, you must note that other SQL Server-related services cannot be modified, and we find that the modifications cannot be run. If you can modify the settings, you can leave a message and we will add it to help more friends.
If not, view this article.
For more information about this article, see:
Article
