Error 44. No mapping between account names and security IDs was done

Have you ever received this error?

Error 44 The following system error occurred: No mapping between account names and security IDs was done.

You will receive this error when you have windows accounts or groups in an AS project that you are deploying to a server in a different domain. Ie. the server does not recognise these accounts.

A simple work around is to leave the windows users and groups out of the roles and add them in from SQL Server Management Studio. Another option, if it is a common deployment is to use AMO and add the appropriate accounts automatically. Also, if you use the AS Deployment wizard there are options to omit role deployment.

Richard