Friday, January 14, 2011

Permissions to SQL Database

I have been working on the problem of Synchronization two vendor databases (to be particular – Symantec Endpoint Encryption (SEE) Database should be synchronized with Symantec Altiris Management Platform – former Notification Server Database). The synchronization did not work. What turned out to be a cause of the problem was a permission issue. I figured that Altiris Server (not an any user account) must have permissions to SEE Database. I added DomainName\AltirisServerName$ to the Users in the Security section of SEE Database with db_datareader and db_datawriter roles and synchronization started working.