Red Gate forums :: View topic - SQL Compare locking SQL Accounts?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

SQL Compare locking SQL Accounts?

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
AnthonyBaratta



Joined: 13 Jan 2012
Posts: 3

PostPosted: Fri Jan 13, 2012 7:37 am    Post subject: SQL Compare locking SQL Accounts? Reply with quote

Howdy...

I upgraded to v10 a week or two ago and it works great with my local copy of MS SQL 2008. But when I connect to my client's MS SQL 2008 server the SQL Account (that worked flawlessly with v9) is being locked when I attempt to connect using SQL Compare v10.

I can login successfully with the SQL account via SQL Studio Manager "before" I connect with SQL Compare - but not after.

I've never seen this type of behaviour before. Version 9 and the same SQL Server and SQL Account have been working fine for months.

Any ideas? Anything you need from me to help debug this?

P.S. I don't have access to the SQL logs so I can't see if it's giving a reason for the lock. When I first had this issue the lock cleared by morning - but I have a software patch that is being held up because I can't do an SQL compare and sync the DBs.
Back to top
View user's profile Send private message
AnthonyBaratta



Joined: 13 Jan 2012
Posts: 3

PostPosted: Fri Jan 13, 2012 10:30 pm    Post subject: Reply with quote

Is it possible that SQL Compare is sending the password as it's being typed? I'm seeing the following in the SQL Logs when I type the SQL Account name:


01/12/2012 22:17:04,Logon,Unknown,Login failed for user 'sql_Account'. Reason: Could not find a login matching the name provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:04,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
01/12/2012 22:17:04,Logon,Unknown,Login failed for user 'sql_Accoun'. Reason: Could not find a login matching the name provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:04,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
01/12/2012 22:17:04,Logon,Unknown,Login failed for user 'sql_Accou'. Reason: Could not find a login matching the name provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:04,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
01/12/2012 22:17:03,Logon,Unknown,Login failed for user 'sql_Acco'. Reason: Could not find a login matching the name provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:03,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
01/12/2012 22:17:03,Logon,Unknown,Login failed for user 'sql_Acc'. Reason: Could not find a login matching the name provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:03,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
01/12/2012 22:17:03,Logon,Unknown,Login failed for user 'sql_Ac'. Reason: Could not find a login matching the name provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:03,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
01/12/2012 22:17:03,Logon,Unknown,Login failed for user 'sql_A'. Reason: Could not find a login matching the name provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:03,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
01/12/2012 22:17:03,Logon,Unknown,Login failed for user 'sql_'. Reason: Could not find a login matching the name provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:03,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
01/12/2012 22:17:02,Logon,Unknown,Login failed for user 'sql'. Reason: Could not find a login matching the name provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
01/12/2012 22:17:02,Logon,Unknown,Login failed for user 'sq'. Reason: Could not find a login matching the name provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
01/12/2012 22:17:02,Logon,Unknown,Login failed for user 's'. Reason: Could not find a login matching the name provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:02,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
01/12/2012 22:17:01,Logon,Unknown,Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 10.31.37.205]
01/12/2012 22:17:01,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 58.


Then when I type the password:


01/12/2012 22:17:10,Logon,Unknown,Login failed for user 'sql_Account'. Reason: Password did not match that for the login provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:10,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.
01/12/2012 22:17:09,Logon,Unknown,Login failed for user 'sql_Account'. Reason: Password did not match that for the login provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.
01/12/2012 22:17:09,Logon,Unknown,Login failed for user 'sql_Account'. Reason: Password did not match that for the login provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.
01/12/2012 22:17:09,Logon,Unknown,Login failed for user 'sql_Account'. Reason: Password did not match that for the login provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.
01/12/2012 22:17:09,Logon,Unknown,Login failed for user 'sql_Account'. Reason: Password did not match that for the login provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.
01/12/2012 22:17:09,Logon,Unknown,Login failed for user 'sql_Account'. Reason: Password did not match that for the login provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:09,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.
01/12/2012 22:17:08,Logon,Unknown,Login failed for user 'sql_Account'. Reason: Password did not match that for the login provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:08,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.
01/12/2012 22:17:08,Logon,Unknown,Login failed for user 'sql_Account'. Reason: Password did not match that for the login provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:08,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.
01/12/2012 22:17:07,Logon,Unknown,Login failed for user 'sql_Account'. Reason: Password did not match that for the login provided. [CLIENT: 10.31.37.205]
01/12/2012 22:17:07,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 8.


Then the SQL Account is locked because of too many failed attempts.
Back to top
View user's profile Send private message
alice.easey



Joined: 27 Feb 2008
Posts: 93
Location: Red Gate

PostPosted: Mon Jan 16, 2012 2:18 pm    Post subject: Reply with quote

Hi Anthony,

Sorry you've run into this issue. We're looking into it now and will hopefully have a fix for this.

Will post here with any updates.
Back to top
View user's profile Send private message
ChrisDuncanMnx



Joined: 16 Jan 2012
Posts: 6

PostPosted: Mon Jan 16, 2012 10:03 pm    Post subject: Also experiencing this problem Reply with quote

Hey, guys.

Thought I'd throw my two cents in as well. We're new to Redgate tools and I just installed last week at the office. Everything worked fine on the lan.

This weekend I tried to work from home being connected to the company over a vpn (my Internet connection is DSL, about 2.5 meg down, 650k up). Had the same lockout issues as others reported. Thinking it might be a timeout issue with multiple retries, I set long timeout but got the same results.

If I can be of any use as your guys debug just let me know. Happy to help as I may.
_________________
Christopher Duncan
Midnite Express
Back to top
View user's profile Send private message
AnthonyBaratta



Joined: 13 Jan 2012
Posts: 3

PostPosted: Tue Jan 17, 2012 8:01 am    Post subject: Reply with quote

I did further testing with my local installation of SQL 2008 R2, and SQL Compare v10. I get the same behaviour as reported earlier with my client's MS SQL installation.

It's definitely SQL Compare v10, because I tested v9 and that did not exhibit the auto-checking behaviour.
Back to top
View user's profile Send private message
james.billings



Joined: 16 Jun 2010
Posts: 1123
Location: My desk.

PostPosted: Wed Jan 18, 2012 6:49 pm    Post subject: Reply with quote

We have a patch available which should fix the problem reported here. You can obtain it via this FTP link

Please post back if you encounter further trouble, and thanks for your patience while we investigated.
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