SQL Server privileges for memoQ server service account
Posted by Péter Botta on 03 January 2013 08:32 AM
This is a troubleshooting article.
Symptom: The memoQ server service does not start. If you attempt to start it from the Services console (services.msc), it reports that the memoQ server service started and then stopped. When you look it up in the Event Viewer (under Windows logs / Application, and look for an error coming from the memoQ server service), you see this error message:
Service cannot be started. System.Data.SqlClient.SqlException: Cannot open database "MemoQServer" requested by the login. The login failed.
Most likely cause: The memoQ server service account (in this case, SYSTEM) does not have sufficient privileges to access the memoQ server database under SQL Server.
Solution: Grant the privileges using SQL Server Management Studio (Ssms.exe):
1. Open SQL Server Management Studio, accept the default settings to log on to SQL Server, and then expand Security, then Logins:
2. Double-click NT AUTHORITY\SYSTEM. On the left-hand side, click User mapping, and then, in the list of databases, click MemoQServer:
3. In the Database role membership list (in the lower part of the dialog), check the check box for the db_owner role, and then click OK.
4. Close the SQL Server Management Studio, and then try starting the memoQ server service again. You might need to restart the SQL Server instance.