Login Name losses password when recreated

[Jimij09]

Hello,

I am trying to pack my database so that when recreated during installation at client machine that I may use the pre-created web.config to be able run out of the box without alteration.

What is happening is that I need to change the Login password to match the previously set password before my web application can run.

I have already downloaded the 6.2 version but to no avail.

Any clues will be highly appreciated.


Thanks,

Jimi

[Brian Donahue]

Thanks for your post. SQL Packager always creates SQL users with a password of 'P@ssw0rd'. There is no option to change this. What you could try is to create a SQL Script to change the password and run it after the package has completed using the /postsql:<script name> argument.

I hope this helps.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521