Profile Name Is Not Valid

This is a problem that I have only come across very recently. I was trying to provide the abiliby to send database mail to a group of applicaiton users. In order to do this, I planned to follow these steps.

1. Add the Windows group to the DatabaseMailUerRole in the MSDB database.
2. Create a private mail profile mapped to the applicaiton email account
3. Allow the Windows Group to use the profile.

While all this worked, when a member of the Windows NT group attempted to send a mail they received the “Profile Name Is Not Valid”  error.

If the accounts were added to DatabaseMailUserRole individually, this issue does not occur.

This is aparatnly a know bug in SQL 2005 SP2, for which there is a hotfix. For details of the fix, take a look here. This hotfix is also included in the Cumulative Update Package for SQL 2005 SP2

Advertisement

• Database Mail