standard user with sufficient privileges to run the memoQ server service
sure you are logged in to Windows with a user that is added to the
Administrators group (i.e. Administrator)
- Open the Windows command line and create a standard user (non-administrator), for
example: net user mq memo2QnewUser /add (where
memo2QnewUser is the password defined for the user mq).
services.msc and select the memoQ server service.
click on it and select Properties.
to the Login tab.
the This account: option, enter .\mq
the password and click the Apply button, then the OK button. Now the
memoQ server service is configured to be run by the user mq
regedit and navigate to: Computer\HKEY_LOCAL_MACHINE\Software\Kilgray\
on 64 bit Windows).
- Right-click the Kilgray folder and select Permissions.
- Add the user mq and check the Full control permission check box. Click
Apply and then OK.
- Give Full control permission for the user mq for the following folders: C:\Program Files\Kilgray\ (or C:\Program
Files (x86)\Kilgray\ on 64 bit Windows systems), C:\ProgramData\MemoQ\, C:\ProgramData\MemoQ Server (or C:\Documents and
Settings\All Users\Application Data\MemoQ\, C:\Documents and Settings\All
Users\Application Data\MemoQ Server\ on Windows XP or Windows Server 2003) and the
folder where the resources are stored (if the Support team defined a custom
folder during the server installation, i.e.: C:\mq\). Note: You can check this
dbcreator fixed server and db_owner
database level roles for user mq: Open
Windows command line, and enter the following: sqlcmd –S .\<instancename> (i.e. sqlcmd –S .\MEMOQSERVER) sp_addsrvrolemember
- Now the user mq has dbcreator fixed
- Note: You can find out the
computer name if you open a new command line and enter the command hostname.
- USE MEMOQSERVER
- sp_addrolemember ’db_owner’,
- Now the user mq has db_owner database
the Windows command line.
the memoQ server service.
Note: It might happen that the current administrator user
does not have sufficient rights to run the above SQL statements. In this case
the MS SQL Server instance should be run in single user mode:
i.e: cd C:\Program Files\Microsoft SQL
- Enter services.msc in the Search field of the Start menu to open Services.
the appropriate MS SQL Server instance (the one that runs the MemoQServer
Windows command line.
Files or go to Program Files (x86)\Microsoft SQLServer\[instancename]\MSSQL\Binn\
and enter sqlservr.exe –m –s <instancename>,
i.e.: sqlservr.exe –m –s MEMOQSERVER
The MS SQL
Server instance will start up in single user mode, which means that local
Windows Administrators will have the sysadmin fixed server role on the MS SQL Server (this is the strongest
open another command line and proceed as described above; you should be
able to grant the appropriate roles.
back to the single user mode command line and press Ctrl+C and enter y to stop
running in single user mode
the approriate MS SQL Server instance in services.msc.
the command line(s).
the memoQ server service.