SQL2000 database "permissions required to run under normal users

The SQL2000 database is a software that must be run during use on the [off-star virtual host management platform]. It is closely related to the operating system security. Therefore, from a security perspective, we require all users to install the SQL2000 database in an independent partition, And the SQL2000 database must run in the state of a common user. Common users

The SQL2000 database is a software that must be run during use on the [off-star virtual host management platform]. It is closely related to the operating system security. Therefore, from the security perspective, we need to ask all users to install the SQL2000 database in an independent partition. Moreover, the SQL2000 data base must run in the state of a common user. Common users

"SQL2000 database" is the software that must be run on the [off-star virtual host management platform ].

And operating system security. Therefore, from the security perspective, we must

Ask all users to install "SQL2000 database" in an independent partition, and, "SQL2000

The database must run in the "normal user" status. The so-called "common user" means that there is no right

Users.

Why must I run the "SQL2000 database" in the "common user" status? Because

If "Super administrator" or "local system user" is used to run "SQL2000 database ",

This will cause the server to be intruded. Therefore, for the security of your server, you must

The database is running in the "normal user" status. At the same time, you must set the corresponding permissions for the hard disk.

"SQL2000 database" can run normally. For details about how to set disk permissions, see:

Bytes --------------------------------------------------------------------------------------------------------------

(Assume that your data is installed on E: \ Program Files \ Microsoft SQL Server \)

1. The root directory (E: \) of the E disk requires the following permissions:

All permissions for "administrators"
All permissions of "System"
Permission for "SQL2000 running users (only applications in the current folder) to list folders/read data"
"Read attribute" permission
"Read extended attributes" permission
"Read" permission

2. The database installation directory (E: \ Program Files \ Microsoft SQL Server \) needs
Permission:

All permissions for "administrators"
All permissions of "System"
All permissions of "SQL2000 running user"

Bytes --------------------------------------------------------------------------------------------------------------

(Assume that your data backup directory is installed in F: \ SQLBACK)

1. The root directory (F: \) of drive F requires the following permissions:

All permissions for "administrators"
All permissions of "System"
Permission for "SQL2000 running users (only applications in the current folder) to list folders/read data"
"Read attribute" permission
"Read extended attributes" permission
"Read" permission

2. The following permissions are required for the database installation directory (F: \ SQLBACK:

All permissions for "administrators"
All permissions of "System"
All permissions of "SQL2000 running user"

Bytes --------------------------------------------------------------------------------------------------------------

Note: you must follow
Otherwise, the database fails to start. Many users tend to be
According to the setting of "root directory permission", after setting "SQL2000 running user ",
Later, we found that the SQL2000 database could no longer be started. If this happens to you
Please follow the instructions above to reset the "root directory permissions", SQL2000
The database can be started normally.

Note: The "SQL2000 running user" mentioned here is in the SQL 2000 Enterprise Manager ----
Users set in the Security Attribute (default: System users ). If you have read
The "external security package video description" should have changed the "default System user" to another
The user who has "No permissions" is here.
"SQL2000 running user ".
SQL2005 running user -- Microsoft SQL Server 2005 -- Configuration Tool
-- SQL Server Configuration Manager, in The QL Server 2005 service,
Select "SQL Server (MSSQLSERVER)" to set this account.