To run an MS SQL Server database in a normal user (independent user) state setting method finalization

Look at the script home online a lot of articles, sorted out the following steps, basically can be said to be the end of the solution, here to the detailed collation, hoping to help the updated friends, let our servers more secure. The Scripting House is dedicated.

The first is that everyone has installed the SQL Server Enterprise Edition.

First step: Win2003 MSSQL to run by ordinary users Security SettingsArticle

this inside is mainly explained, the common user's creation and the setting, but needs to notice, the permission setting

C disk requires the following permissions:
C:\administrators All Permissions
System Full Permissions
IIS_WPG read-only and run permissions (applies only to the current folder)
SQL2000 Run User (applies only to current folder)
List Folder/Read data
Read properties
Read Extended Properties
Read permissions

C:\Program Files\Microsoft SQL Server\MSSQL\Data (if this directory is used to place the SQL2000 user database)
Administrators all permissions
System Full Permissions
SQL2000 full permissions of the running user



If your database is installed in the C disk, but the user's library directory is placed in the F:\SQLDATA directory, and there is a backup database placed on this disk, F disk will need to have the following permissions:

F:\ (If this partition is used to place the SQL2000 user database)
Administrators all permissions
System Full Permissions
SQL2000 Run User (applies only to current folder)
List Folder/Read data
Read properties
Read Extended Properties
Read permissions

F:\SQLDATA (if this directory is used to place the SQL2000 user database)
Administrators all permissions
System Full Permissions
SQL2000 full permissions of the running user

F:\SQLBACK (if this directory is used to place the SQL2000 backup database)
Administrators all permissions
System Full Permissions
SQL2000 full permissions of the running user

The above settings are basically completed, and also need to note that other SQL Server related services can not be modified, we have modified the discovery can not be run, if you can modify the message, we will be added to help more friends.

If you can't, you can view this article SQL Server normal user run error resolution supplement

This article related article reference:
Description of the required permissions to run sql2000 with ordinary users
Win2003 MSSQL runs as a normal user Security SettingsArticle