SQL Compare locking SQL Accounts?

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

SQL Compare locking SQL Accounts?

Postby AnthonyBaratta » Fri Jan 13, 2012 7:37 am

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.
AnthonyBaratta
 
Posts: 4
Joined: Fri Jan 13, 2012 7:31 am

Postby AnthonyBaratta » Fri Jan 13, 2012 10:30 pm

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.
AnthonyBaratta
 
Posts: 4
Joined: Fri Jan 13, 2012 7:31 am

Postby alice.easey » Mon Jan 16, 2012 2:18 pm

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.
alice.easey
 
Posts: 94
Joined: Wed Feb 27, 2008 12:56 pm
Location: Red Gate

Also experiencing this problem

Postby ChrisDuncanMnx » Mon Jan 16, 2012 10:03 pm

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
ChrisDuncanMnx
 
Posts: 6
Joined: Mon Jan 16, 2012 9:55 pm

Postby AnthonyBaratta » Tue Jan 17, 2012 8:01 am

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.
AnthonyBaratta
 
Posts: 4
Joined: Fri Jan 13, 2012 7:31 am

Postby james.billings » Wed Jan 18, 2012 6:49 pm

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.
james.billings
 
Posts: 1144
Joined: Wed Jun 16, 2010 11:10 am
Location: My desk.


Return to SQL Compare 10

Who is online

Users browsing this forum: continetal and 2 guests