User profile for AnthonyBaratta – Support

Activity overview Badges (0) Posts (3) Comments (3)

Comments

Thanks Eddie. What I'm looking to replace is a tool to "visually build" the databases. The Dependency Tracker is very nice, but it's more of an after the fact visualization tool. It's not helpful to building the tables directly or the foreign key relationships. With SSMS abandoning the visual diagram tool, there is going to be a population of Database designers that are looking for a replacement. / comments

Thanks Eddie. What I'm looking to replace is a tool to "visually build" the databases. The Dependency Tracker is very nice, but it's more of an after the fact visualization tool. It's not helpful t...

0 votes

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. / comments

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 ...

0 votes

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. / comments

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 faile...

0 votes

Total activity: 8
Last activity: February 06, 2025 08:37
Member since: February 04, 2025 16:09

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 2