The final setting method for running the ms SQL SERVER database in the normal user (independent user) State

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 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