Login failed for user when trying to open .sqlgen file

The simplest way to populate your database with test data.

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?

<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,
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
Posts: 209
Joined: Mon Apr 23, 2012 2:49 pm

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: Bing [Bot] and 0 guests