MSSQL/MySQL running under a low-permission account (Graphic settings tutorial)

For example, MSSQL is attached to disk D.

First, create an account, such as MSSQL, set the password, remember the password, and assign a group, such as guetst.
Reverse disk D, attribute, security, advanced, add, enter the account name created, select: only this folder, check: ReadPermission(Last to last), click OK. Read and Write Permissions Of the MySQL account to the data directory of MSSQL
In INI andSystemProduct listSetOfDataDatabase UserDirectorySimilar to the root directory of the disk where the backup directory is locatedPromptActivation failed

Click my computer, manage,ServiceAnd ApplicationsProgram, Microsoft SQL servers, opposite to MSSQL, security, bottom:


Start the service account, select this account, enter the. \ account name, enter the password, and click OK.


Sql2005:
Sql2005 is a little different. It is configured through SQL Server Configuration Manager.
Open SQL Server Configuration Manager


Open the service account and select "Log On". Enter ". \ account name", "password", and click "OK ".


MySQL is similar.
Create an account first. For example, set the password for MySQL, remember the password, and assign a group, such as guetst.
Add a MySQL account to the MySQL installation directory


Read and write permissions for the MySQL account in the MySQL DATA DIRECTORY

Figure: mysql.gif