Run SQL Server 2000 as an individual user

The service in the "logging management tool" finds that the sqlserver.exe service is run by special users for the sake of server security: My computer-control panel-management tools-services-right-click MSSQLServer-properties-login identity

(If it is a "Local SYSTEM account", it is the user currently logged on to the operating system), and check whether the user has an operation C: /program files/Microsoft SQL Server/MSSQL/data.

From the security perspective, "SQL2000 database" is installed in an independent partition, and "SQL2000 database" Must run in the "common user" state. A common user is a user without any permissions.

Why must I run the "SQL2000 database" in the "common user" status? If "Super administrator" or "local system user" is used to run the "SQL2000 database", the server will be infiltrated. Therefore, for your server security, you must run the "SQL2000 database" in the "common user" status. At the same time, you must set the corresponding permissions for the hard disk to "SQL2000 database" for normal operation. For details about how to set disk permissions, see:

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

(Assume that your data backup directory is installed in F:/sqlback)

1. the root directory of drive F (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 database installation directory (F:/sqlback) requires the following permissions:

All permissions for "Administrators"
All permissions of "system"
All permissions of "SQL2000 running user"

 

You also need to add permissions in C:/Documents and Settings.

 

 

If SQLAgent cannot be started when a Custom User cannot be used, or "the data portion of event 17052 from MSSQLServer is invalid" is displayed, it may be because the database is moved from another place. In this case, you need to add the individual user as the super administrator in "security"-> "login.