May 17, 2011 at 10:03 am
Hi all,I have a developer that I set up a SQL login to access a SQL database via a script.He was able to access the SQL database from machine #1 but when he uses the same login account to try to access the database from machine #2 he gets the message "BAD PASSWORD"
Please help.
May 17, 2011 at 10:17 am
davidshephard (5/17/2011)
I have a developer that I set up a SQL login to access a SQL database via a script.He was able to access the SQL database from machine #1 but when he uses the same login account to try to access the database from machine #2 he gets the message "BAD PASSWORD"
What Authentication method are you using on both Servers?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 17, 2011 at 10:21 am
The server is using Windows Auth,he is connecting from two diffrant Linux clients.
Thanks.
May 17, 2011 at 10:33 am
davidshephard (5/17/2011)
The server is using Windows Auth,he is connecting from two diffrant Linux clients.
"BAD PASSWORD" is not an error that I would expect. Do you have additional details in the error?
Can he login to the Second Server using the Linux Client that he was able to login to the First Server
Can he connect from a Windows Client using SSMS? If so then it is not a SQL Server issue.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 17, 2011 at 10:51 am
Its one SQL server, from client 1 we can connect no issues,from client 2 two using the same credentials it throws a error message.
May 17, 2011 at 10:58 am
davidshephard (5/17/2011)
Its one SQL server, from client 1 we can connect no issues,from client 2 two using the same credentials it throws a error message.
Then you do not have a SQL Server Issue; you have an issue with your Linux Client.
Check the configuration, installation, etc
Regards.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 17, 2011 at 11:04 am
Strange thing I tried from a Windows machine via ODBC tools and it also failed but it still works from the initial machine
May 17, 2011 at 11:10 am
davidshephard (5/17/2011)
Strange thing I tried from a Windows machine via ODBC tools and it also failed but it still works from the initial machine
I'm not surprised, you probably don't have the ODBC Driver installed on the second machine?
That is what I meant by configuration, installation.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 17, 2011 at 11:15 am
I guest my question is can you coonect to SQL server from multiple machines using the same credentials.
May 17, 2011 at 11:20 am
Date,Source,Severity,Message
05/17/2011 11:54:28,Logon,Unknown,Login failed for user 'uftmasterad\trackitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:54:28,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 6.
05/17/2011 11:41:44,Logon,Unknown,Login failed for user 'uftmasterad\trackitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:41:44,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 6.
05/17/2011 11:40:37,Logon,Unknown,Login failed for user 'uftmasterad\trackitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:40:37,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 6.
05/17/2011 11:40:27,Logon,Unknown,Login failed for user 'trackitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:40:27,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
05/17/2011 11:39:44,Logon,Unknown,Login failed for user 'uftmasterad\tracitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:39:44,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
05/17/2011 11:37:26,Logon,Unknown,Login failed for user 'uftmasterad\tracitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:37:26,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
05/17/2011 11:31:49,Logon,Unknown,Login failed for user 'trackitdev'. [CLIENT: 10.52.11.97]
May 17, 2011 at 11:21 am
davidshephard (5/17/2011)
I guest my question is can you coonect to SQL server from multiple machines using the same credentials.
If you are using WIndows Authenication then you have no option but to use the same credentials.
If you are using SQL Server Authentication then you may have the same or different credentials or passwords with the same UserName.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 17, 2011 at 11:24 am
davidshephard (5/17/2011)
Date,Source,Severity,Message05/17/2011 11:54:28,Logon,Unknown,Login failed for user 'uftmasterad\trackitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:54:28,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 6.
05/17/2011 11:41:44,Logon,Unknown,Login failed for user 'uftmasterad\trackitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:41:44,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 6.
05/17/2011 11:40:37,Logon,Unknown,Login failed for user 'uftmasterad\trackitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:40:37,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 6.
05/17/2011 11:40:27,Logon,Unknown,Login failed for user 'trackitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:40:27,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
05/17/2011 11:39:44,Logon,Unknown,Login failed for user 'uftmasterad\tracitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:39:44,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
05/17/2011 11:37:26,Logon,Unknown,Login failed for user 'uftmasterad\tracitdev'. [CLIENT: 10.52.208.160]
05/17/2011 11:37:26,Logon,Unknown,Error: 18456<c/> Severity: 14<c/> State: 5.
05/17/2011 11:31:49,Logon,Unknown,Login failed for user 'trackitdev'. [CLIENT: 10.52.11.97]
So what is "user 'uftmasterad\trackitdev'"?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 17, 2011 at 11:31 am
davidshephard (5/17/2011)
The server is using Windows Auth,he is connecting from two diffrant Linux clients.Thanks.
How are you authenticating to Windows from a Linux Client?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 17, 2011 at 12:03 pm
VIA a software tool,command line stuff.
May 17, 2011 at 12:19 pm
davidshephard (5/17/2011)
VIA a software tool,command line stuff.
Welsh Corgi (5/17/2011)
davidshephard (5/17/2011)
The server is using Windows Auth,he is connecting from two diffrant Linux clients.Welsh Corgi(5/17/2011)
How are you authenticating to Windows from a Linux Client?quote]davidshephard (5/17/2011)
VIA a software tool,command line stuff.
If your user is logging on to a Linux Client how are the Users Windows credentials being passed?
I believe that you are using SQL Server Authentication which is required when you log in as a non-Windows Client.
I don't believe that you are providing accurate information?
There are a lot of questions on the 70-228 and SQL Server 2005 & 2008 tests that cover this.
Do you know the difference between SQL Server Authentication & WIndows Authentication?
I would like to see the script that you used to create the Login & User Accounts.
Also are your Servers configured for Mixed Mode Authentication?
I don't think I'm getting the whole scoop.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply