I am trying to run our sql packager 5.4 executable on a Windows Vista OS with SQL Express 2005 using command line. I ran the same executable successfully on other installations of Vista/Sql Express but not this particular computer. The executable creates the database with username and roles fine: however, an error pops up immediately after saying that the username / login already exists. I know that the login does exist on this machine and is applied to other databases. I tried deleting the login and users from the other databases but I still get the same error message. It almost appears to be a permission issue but I ran the command line with a sql authenication that has sysadmin priviledges.
There is a reference to (sp_grantloginaccess N'UserName') as part of the error.
The windows user is an administrator on their machine.
Does anyone know what else this could be?