I have read a lot of scripts on the Internet. Article The following steps have been completed, which can basically be called the Final Solution. Here we will give you a detailed explanation, hoping to help our updated friends and make our servers more secure. Dedication to the home.
First, you have installed sqlserver Enterprise Edition.
Step 1: win2003 MSSQL security settings for normal users
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, you can refer to this article to add a solution to SQL Server errors.
For more information about this article, see:
Permissions required for running SQL2000 with common users
Win2003 MSSQL security settings for normal users