Red Gate forums :: View topic - Login failed for user when trying to open .sqlgen file
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

Login failed for user when trying to open .sqlgen file

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
debdeb75



Joined: 16 May 2013
Posts: 1

PostPosted: Thu May 16, 2013 8:55 pm    Post subject: Login failed for user when trying to open .sqlgen file Reply with quote

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,
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Fri May 17, 2013 9:09 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group