Generally speaking, we recommend that the partition of C drive is above 15G. SQL 2000 can be installed directly in the default directory of C: disk, and the permissions can be set by referring to the video. Generally speaking, SQL 2000 will not use more than 3G space. Even if there is a MySQL database, its size will not exceed 2G. This is obvious. If the database exceeds 1G, your server will need a large amount of memory to run normally, such as 2G memory. Therefore, the database operated by virtual hosts cannot be too large, and there is no such much memory available at all.
The following permissions are required for disk C:
C:\administrators All permissions
System All Permissions
IIS_WPG read-only and run permissions (applied only in the current folder)
SQL2000 running user (only applied to the current folder)
List folders/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 All Permissions
All permissions for SQL2000 running users
If your database is installed on disk C, but the user's library directory is placed in the F:\SQLDATA directory, and the backup database is placed in this disk, the F disk needs to have the following permissions:
F:\ (If this partition is used to place the SQL2000 user database)
administrators All permissions
System All Permissions
SQL2000 running user (only applied to the current folder)
List folders/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 All Permissions
All permissions for SQL2000 running users
F:\SQLBACK (if this directory is used to place SQL2000 backup database)
administrators All permissions
System All Permissions
All permissions for SQL2000 running users
The "SQL2000 running user" mentioned here is the user set in the SQL 2000 Enterprise Manager, the security in the properties. The default is System. If you have seen the "Out-Star Security Package Video Description", you should have changed this user and you should use the changed user name.
The following permissions are required for disk C:
C:\administrators All permissions
System All Permissions
IIS_WPG read-only and run permissions (applied only in the current folder)
SQL2000 running user (only applied to the current folder)
List folders/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 All Permissions
All permissions for SQL2000 running users
If your database is installed on disk C, but the user's library directory is placed in the F:\SQLDATA directory, and the backup database is placed in this disk, the F disk needs to have the following permissions:
F:\ (If this partition is used to place the SQL2000 user database)
administrators All permissions
System All Permissions
SQL2000 running user (only applied to the current folder)
List folders/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 All Permissions
All permissions for SQL2000 running users
F:\SQLBACK (if this directory is used to place SQL2000 backup database)
administrators All permissions
System All Permissions
All permissions for SQL2000 running users
The "SQL2000 running user" mentioned here is the user set in the SQL 2000 Enterprise Manager, the security in the properties. The default is System. If you have seen the "Out-Star Security Package Video Description", you should have changed this user and you should use the changed user name.