SQL Server privileges for memoQ server service account
Reference Number: AA-00339 Created: 03-01-2013 08:32 Last Updated: 03-01-2013 08:32 0 Rating/ Voters

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.
Login failed for user 'NT AUTHORITY\SYSTEM'.

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.


Rss Comments (Please do not post support requests here.)
  • There are no comments for this article.
Info Add Comment
Nickname: Your Email: Subject: Comment:
Enter the code below:
Quick Jump Menu
Info Missing an article? Let us know!