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
6  8588 
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****@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
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
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****@sommarsk og.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: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
(pr**********@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, es****@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
On Oct 11, 2:42*am, Erland Sommarskog <esq...@sommars kog.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...@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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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
Within my PHP-script the first relevant line is:
|
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 Connection"
but the save connection string, when i used it in VB, it is ok. Also i can
connect from webserver to dbserver by using Analy Query, it is ok
|
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: DisplayName = SSLLibrary
(Partial)
LOG: Appbase = file:///c:/inetpub/wwwroot/Licmanager
LOG: Initial PrivatePath = bin
Calling assembly : (Unknown).
|
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:
public XmlDocument GetAllAuthors()
{
XmlDocument doc = new XmlDocument();
|
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
java.sql.SQLException: Deadlock found when trying to get lock; Try
restarting transaction message from server: "Lock wait timeout
exceeded; try restarting transaction";
We get such errors generally on inserts or updates while applying a
| | |
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 thought it was my stored procedure
but that doesn't seem to be the case. The following are the connection
strings that I've tried:
//private string connstring = "integrated security=SSPI;data source=<ip
address>;"
// "persist security...
|
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 my web.config
file, but have now added the HTTPS endpoints and bindings. When I do
this, I now get an error when trying to connect to the development
server from my client using HTTP. On the client side, I get the
error..
...
|
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 server and client, so client could
access the database through the connect server?
like that:
db2client <--db2 connect server <--db2 mainframe database
|
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 exception (SqlException. "Timeout
expired. The timeout period elapsed prior to completion of the operation or
the server is not responding."). If User Instance=false then the method will
execute to completion. Note that connection pooling is off just...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
