Login Name losses password when recreated

Packages and compresses schema and contents of SQL Server databases

Moderators: JonathanWatts, Chris Auckland, David Atkinson, david connell, Anu Deshpande, Michelle Taylor, james.billings, Marianne

Login Name losses password when recreated

Postby Jimij09 » Fri Jul 24, 2009 2:23 pm

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
Jimij09
 
Posts: 1
Joined: Fri Jul 24, 2009 3:50 am

Postby Brian Donahue » Mon Jul 27, 2009 3:32 pm

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Packager 6

Who is online

Users browsing this forum: No registered users and 0 guests