SQL Script fails with error: The login already has an account under a different user name
- by Rock Hymas
I have a script that creates a user associated with a login for SQL Server 2005. It does this immediately after creating the database and the login. One user of the script reported the following error:
The login already has an account under a different user name
Any idea how this might happen, and how I could modify the script to handle it?