Login failed for user when trying to open .sqlgen file

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

Login failed for user when trying to open .sqlgen file

Postby debdeb75 » Thu May 16, 2013 8:55 pm

I am trying to open my Sql Data Generator file (.sqlgen). I get the error message 'Login failed for user blah' The username's password has changed so I understand why it is failing. My questions is HOW do I modify the password so that Sql Data Generator can open it?

<Username>blah</Username>
<SavePassword>True</SavePassword>
<Password encrypted="1">randomlettersandnumbers</Password>

I can modify the .sqlgen file. If I set SavePassword to False that did not allow me to open the file with Sql Data Generator. Do I have to null out the Password option as well? Or remove it all together?

Thank you,
debdeb75
 
Posts: 1
Joined: Thu May 16, 2013 8:48 pm

Postby Manfred.Castro » Fri May 17, 2013 9:09 pm

You should be able to set password encrypted ="0" and then you can free type the password for the account.

<Password encrypted="0">your_unencrypted_password</Password>
Manfred Castro
Product Support
Red Gate Software
Manfred.Castro
 
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm


Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests