Hi,
I have installed free TDS ODBC driver on Linux and from there I am
trying to connect to MS SQLSERVER installed on Windows machine. But it
gives me following error -

tsql -H ps6312 -p 1433 -U shiv
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:
Msg 18456, Level 14, State 1, Server , Line 0
Login failed for user 'shiv'.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server


I am not sure what could be the reason behind this error as the user
has been configured on SQL server. Do I need to do some configuration
on SQL server side for connecting from Linux or should I have some
thing else at Linux side.


Looking forward to get reply.

Thanks in advance.

Regards
Shiv

SRK (kumarsr@gmail.com) writes:
> I have installed free TDS ODBC driver on Linux and from there I am
> trying to connect to MS SQLSERVER installed on Windows machine. But it
> gives me following error -
>
> tsql -H ps6312 -p 1433 -U shiv
> locale is "en_US.UTF-8"
> locale charset is "UTF-8"
> Password:
> Msg 18456, Level 14, State 1, Server , Line 0
> Login failed for user 'shiv'.
> Msg 20014, Level 9, State 0, Server OpenClient, Line 0
> Login incorrect.
> There was a problem connecting to the server
>
>
> I am not sure what could be the reason behind this error as the user
> has been configured on SQL server. Do I need to do some configuration
> on SQL server side for connecting from Linux or should I have some
> thing else at Linux side.

The login shiv is an SQL login?

You typed the password correctly?

The default datbase for this login exists?

There is no login trigger?

Are you able to connect if you use the same user/password from SQLCMD
on Windows?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Sep 24, 2:12am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> SRK (kuma...@gmail.com) writes:
> > I have installed free TDS ODBC driver on Linux and from there I am
> > trying to connect to MS SQLSERVER installed on Windows machine. But it
> > gives me following error -
>
> > tsql -H ps6312 -p 1433 -U shiv
> > locale is "en_US.UTF-8"
> > locale charset is "UTF-8"
> > Password:
> > Msg 18456, Level 14, State 1, Server , Line 0
> > Login failed for user 'shiv'.
> > Msg 20014, Level 9, State 0, Server OpenClient, Line 0
> > Login incorrect.
> > There was a problem connecting to the server
>
> > I am not sure what could be the reason behind this error as the user
> > has been configured on SQL server. Do I need to do some configuration
> > on SQL server side for connecting from Linux or should I have some
> > thing else at Linux side.
>
> The login shiv is an SQL login?
>
> You typed the password correctly?
>
> The default datbase for this login exists?
>
> There is no login trigger?
>
> Are you able to connect if you use the same user/password from SQLCMD
> on Windows?
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hi,
I have tried using all the logins such as SQL server sa user, windows
domain user as well as shiv, which I created for SQL server. I was
able to login on windows using all the users specified above, but when
I try to connect it using free TDS odbc driver through Linux, it
fails.

Thanks
Shiv

SRK (kumarsr@gmail.com) writes:
> I have tried using all the logins such as SQL server sa user, windows
> domain user as well as shiv, which I created for SQL server. I was
> able to login on windows using all the users specified above, but when
> I try to connect it using free TDS odbc driver through Linux, it
> fails.

And you try to connect to the server you intend to? I don't see any server
specification in your command line.

Does the password contain any non-ASCII characters?

I've never used Free TDS, but since other people appears to use it, I guess
it works sometimes at least. All I can really with is asking some
checking questions.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Sep 23, 6:44pm, SRK <kuma...@gmail.com> wrote:
> Hi,
> I have installed free TDS ODBC driver on Linux and from there I am
> trying to connect to MS SQLSERVER installed on Windows machine. But it
> gives me following error -
>
> tsql -H ps6312 -p 1433 -U shiv
> locale is "en_US.UTF-8"
> locale charset is "UTF-8"
> Password:
> Msg 18456, Level 14, State 1, Server , Line 0
> Login failed for user 'shiv'.
> Msg 20014, Level 9, State 0, Server OpenClient, Line 0
> Login incorrect.
> There was a problem connecting to the server
>
> I am not sure what could be the reason behind this error as the user
> has been configured on SQL server. Do I need to do some configuration
> on SQL server side for connecting from Linux or should I have some
> thing else at Linux side.
>
> Looking forward to get reply.
>
> Thanks in advance.
>
> Regards
> Shiv


Hi Shiv,

I am facing the same issue , Could you share the solution with me i
you have solved the problem. I am using the FreeTDS 5.0 driver.

The erro is
locale is "C"
locale charset is "ANSI_X3.4-1968"
Msg 18456, Level 14, State 1, Server , Line 0
Login failed for user 'ibia_ir'.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server.

But i am able to login using the same id from the Query Analyser.

Thanks in Advance,
Prasanna

(prasanna.mpv@gmail.com) writes:
> I am facing the same issue , Could you share the solution with me i
> you have solved the problem. I am using the FreeTDS 5.0 driver.
>
> The erro is
> locale is "C"
> locale charset is "ANSI_X3.4-1968"
> Msg 18456, Level 14, State 1, Server , Line 0
> Login failed for user 'ibia_ir'.
> Msg 20014, Level 9, State 0, Server OpenClient, Line 0
> Login incorrect.
> There was a problem connecting to the server.
>
> But i am able to login using the same id from the Query Analyser.

The one thing I would check is whether the password includes any
characters not in the ASCII character set.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Oct 11, 2:42am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> (prasanna....@gmail.com) writes:
> > I am facing the same issue , Could you share the solution with me i
> > you have solved the problem. I am using the FreeTDS 5.0 driver.
>
> > The erro is
> > locale is "C"
> > locale charset is "ANSI_X3.4-1968"
> > Msg 18456, Level 14, State 1, Server , Line 0
> > Login failed for user 'ibia_ir'.
> > Msg 20014, Level 9, State 0, Server OpenClient, Line 0
> > Login incorrect.
> > There was a problem connecting to the server.
>
> > But i am able to login using the same id from the Query Analyser.
>
> The one thing I would check is whether the password includes any
> characters not in the ASCII character set.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Links for SQL Server Books Online:
> SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
> SQL 2000:http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thanks to all for showing interest. Actually there was issue related
to named instance and port. When I checked port for named instance, it
was different and so after changing port it worked fine. Before that I
had to enable TCP/IP on SQL server side.

thanks
Shiv