Problem

[Exception: System.Data.SqlClient.SqlException - Login failed for user 'domain\username'.]

Cause

If any new Sprinx CRM user doesn't have write access to the database on server, where runs Sprinx CRM SQL database, then he will get the error. So you have to set write access for this user on the SQL server.

Solution

On the server where is installed SQL database for CRM, you have to run these script, but only after you have created these users under CRM User Administration:
    • EXEC [proc_Admin_RecompileProceduresAndViews] 
    • EXEC [proc_ADMIN_SetPermissionOnTablesAndViews] 'public', 'grant', 'select'
    • EXEC [proc_ADMIN_SetPermissionOnStoredProceduresAndFunctions] 'public', 'grant', 'execute'

If the CRM DB runs on SQL 2005 Express, you have to set SQL access rights even for others than only local PC.