Connection issue when trying to connect MS SQL SERVER from Linux

**Erland Sommarskog** · Sep 23 '08, 09:35 PM

Re: Connection issue when trying to connect MS SQL SERVER from Linux

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@sommarsk og.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

**SRK** · Sep 24 '08, 05:25 AM

Re: Connection issue when trying to connect MS SQL SERVER from Linux

On Sep 24, 2:12 am, Erland Sommarskog <esq...@sommars kog.sewrote:

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...@sommarsk og.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

**Erland Sommarskog** · Sep 24 '08, 07:25 AM

Re: Connection issue when trying to connect MS SQL SERVER from Linux

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 help with is asking some
checking questions.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

**prasanna.mpv@gmail.com** · Oct 10 '08, 08:05 AM

Re: Connection issue when trying to connect MS SQL SERVER from Linux

On Sep 23, 6:44 pm, SRK <kuma...@gmail. comwrote:

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

**Erland Sommarskog** · Oct 10 '08, 10:05 PM

Re: Connection issue when trying to connect MS SQL SERVER from Linux

(prasanna.mpv@g mail.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@sommarsk og.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

**SRK** · Oct 21 '08, 09:55 AM

Re: Connection issue when trying to connect MS SQL SERVER from Linux

On Oct 11, 2:42 am, Erland Sommarskog <esq...@sommars kog.sewrote:

(prasanna....@g mail.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...@sommarsk og.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

Connection issue when trying to connect MS SQL SERVER from Linux

Connection issue when trying to connect MS SQL SERVER from Linux

Comment

Comment

Comment

Comment

Comment

Comment