Use the normal user to run SQL2000 's required permission description _ outside the star virtual host

Generally, we recommend that C disk partitions above 15G, SQL 2000 can be directly installed in the C: Disk default directory, permissions can be referred to the video to set. In general, SQL 2000 uses no more than 3G of space, even if there is a MySQL database, its size will not exceed 2G, which is obvious, if the database more than 1G your server will need a lot of memory to work properly, such as 2G memory, so, The database that does the operation of the virtual host is not too big, there is not so much memory available at all.

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 "SQL2000 run user" Here is the user that is set up in SQL 2000 Enterprise Manager, in the security of the attribute, the default is system, if you have seen the "Extraterrestrial security Package Video description", you should have changed this user, you should use the changed username.