473,372 Members | 1,037 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Connection issue when trying to connect MS SQL SERVER from Linux

SRK
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
Sep 23 '08 #1
6 8568
SRK (ku*****@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, es****@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

Sep 23 '08 #2
SRK
On Sep 24, 2:12*am, Erland Sommarskog <esq...@sommarskog.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...@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
Sep 24 '08 #3
SRK (ku*****@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, es****@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
Sep 24 '08 #4
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
Oct 10 '08 #5
(pr**********@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, es****@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

Oct 10 '08 #6
SRK
On Oct 11, 2:42*am, Erland Sommarskog <esq...@sommarskog.sewrote:
*(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
Oct 21 '08 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Georg Gerber | last post by:
Hello, I use an Apache-Web-Server 1.3 with PHP 5 under Windows 2000. With a PHP-script I want to get data from a MS-SQL-Server. Therefore is within my php.ini: extension=php_mssql.dll ...
1
by: vichet | last post by:
Dear All; I have two servers: Webserver(WebServer) and Database server(DBServer). In Webserver, i asp to connect to sqlserver in dbserver. but i can not connect it, it show error "No Trust...
2
by: Tinnu | last post by:
My asp.net application uses a class which needs an unmanaged dll named SSlibrary. When trying to load the page it gives me the folllowing error. === Pre-bind state information === LOG:...
3
by: JD | last post by:
Hello, I am dealing with an issue, that although probably simple, is driving me crazy. I am trying to connect to a SQL 2005 Express database through a web service using the following code: ...
0
by: cwho.work | last post by:
Hi! We are using apache ibatis with our MySQL 5.0 database (using innodb tables), in our web application running on Tomcat 5. Recently we started getting a number of errors relating to...
4
by: =?Utf-8?B?VGVycmFuY2U=?= | last post by:
I have an application that runs fine on my machine(of course) that access the local Sql Server. However, when trying to run this application from another machine I receive a Sql timeout error. I...
0
by: ronscottlangham | last post by:
I have a WCF Web Service that I develop using the ASP.NET Development Server in Visual Studio. In release, the web service will support both HTTP and HTTPS. Initially I had only HTTP configured in...
2
by: jeffhan | last post by:
we have os/400 db2 database at the backend. i installed db2 v9 connect server on one windows server which is locating the same network with database server. now how to i configure the connect...
3
by: =?Utf-8?B?QXho?= | last post by:
Is there a limitation on the number of (sequential) opened connection for SQL Server User Instances? The following method will run to about the 240th iteration then will receive a timeout...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.