Mssql/mysql run the method under the Low privilege account (text set tutorial) _win Server

Example: MSSQL mounted in D plate

First create an account such as: MSSQL set a good password, remember the password, assign a good group, such as Guetst
Reverse point D Disk, properties, security, Advanced, add, enter created account name, select: Only the folder, tick: ReadPermissions(third last), point OK. MSSQL Data directory to the MySQL account read and Write permissions
In the INI andsystemProduct ListSet upOfDataLibrary usersDirectoryand the root directory of the disk where the backup directory is located, do similar permissions settings, otherwiseTipsOpening failed

Reverse point of my computer, management,Serviceand applicationprogram, Microsoft SQL Servers, against MSSQL, security, bottom:


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


SQL2005:
SQL2005 is a bit different, it's configured via SQL Server Configuration Manager
Open SQL Server Configuration Manager


Open the service account, select login, this account input:. \ account name, enter the password, click OK, OK


MySQL is similar
First create an account such as: MySQL set a good password, remember the password, assign a good group, such as Guetst
MySQL installation directory add a MySQL account


MySQL Data directory to the MySQL account read and Write permissions

The following settings are set in the service.

Entry method: Start > Run > Services.msc
And then find the MySQL right key property

Photo: Mysql.gif