I'm attempting to deploy my security tables using the DDT. When I do the deploy, I create a new package, which includes the permissions table as part of the deployment. I first got an error that a login (to a common db user for the dev db) failed because the user needed to change their password. I figure out that this is set on the permission package, so I go to SQL Server and change it and update the password for the permission data. Now I get an error that the login is just failing...sigh... So I open up SQL Management Studio and test the user/password (all sql user/passwords btw). They work...sigh... So I change the user/password to another one. I STILL get an error related to the login failing for the first user.



Now, I decided I didn't want to deploy all the security tables, so I deleted some of the packages. Could there be some residual info that could be causing this problem? I'm stuck until I can get this solved (can't deploy).



Thanks!