Hi,
I have installed SQL 2005 in my PC and am trying to connect to SQL
Server 2000 installed in a different machine. Both the server are
installed in mixed mode.
I can connect to the 2000 server from 2005's SSMS using windows
authentication mode but fail to connect using SQL authentication.
The follwoing message is displayed.
Cannot connect to <servername>.
Additional information:
Login failed for user 'username'. (Microsoft SQL Server, Error: 18456)
TIA,
Taw.
4  6263 
Taw (ta**************@grameenphone.com) writes:
I can connect to the 2000 server from 2005's SSMS using windows
authentication mode but fail to connect using SQL authentication.
The follwoing message is displayed.
Cannot connect to <servername>.
Additional information:
Login failed for user 'username'. (Microsoft SQL Server, Error: 18456)
Seems like you should verify that you have the correct username and
password. Also check that SQL authnetication is enabled on the SQL 2000
instance.
You can also try to connect with SQLCMD from the command line.
--
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
On Feb 7, 4:43 pm, Erland Sommarskog <esq...@sommarskog.sewrote:
Taw (tawfiq.choudh...@grameenphone.com) writes:
I can connect to the 2000 server from 2005's SSMS using windows
authentication mode but fail to connect using SQL authentication.
The follwoing message is displayed.
Cannot connect to <servername>.
Additional information:
Login failed for user 'username'. (Microsoft SQL Server, Error: 18456)
Seems like you should verify that you have the correct username and
password. Also check that SQL authnetication is enabled on the SQL 2000
instance.
You can also try to connect with SQLCMD from the command line.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Actually I have seen this - 2005 is case sensitive, 2000 is not. Check
the case on the password, probably first char is capital or something.
On Feb 8, 4:43 am, Erland Sommarskog <esq...@sommarskog.sewrote:
Taw (tawfiq.choudh...@grameenphone.com) writes:
I can connect to the 2000 server from 2005's SSMS using windows
authentication mode but fail to connect using SQL authentication.
The follwoing message is displayed.
Cannot connect to <servername>.
Additional information:
Login failed for user 'username'. (Microsoft SQL Server, Error: 18456)
Seems like you should verify that you have the correct username and
password. Also check that SQL authnetication is enabled on the SQL 2000
instance.
You can also try to connect with SQLCMD from the command line.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
The problem is fixed. Just restarted the server. Dont know where the
problem was, though. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: davidman73 |
last post by:
Hello,
I have VS 2005 with SQL Server Express in the same machine, but need to
connect to a remote SQL Server 2000. I'm getting this error:
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not...
|
by: Ann Marinas |
last post by:
Hi there,
I am currently developing an ASP.NET program that connects to a SQL Server
2000 database. I also have SQL Server 2005 Express installed on the same
local machine.
Prior to installing SQL Server 2005, my apps were working and is connecting
flawlessly to a database on the SQL Server 2000. Now, whenever I connect to
the same...
|
by: RvGrah |
last post by:
After much hair-pulling, I've finally found the answer to a problem
that many are fighting with, difficulty connecting from Sql 2005 Server
Management or VS2005 to a remote Sql Server running Sql 2000. In my
case the server I couldn't reach was across a vpn connection, behind
ISA server 2000, (which had port 1433 open).
The answer was in...
|
by: acwomble |
last post by:
I am working with a database on another system via a ssh tunnel using
plink. We have setup an alias the local system for the remote database.
I am able to connect and work from within Visual Studio if I connect to
the remote database using with "SQL Server" as the data source and
".NET Framework Data Provider for OLEDB" as the data...
|
by: Chris |
last post by:
Don't know if there is a simple solution for this one or not. When
running SQL server on a machine with 2000 loaded and the complete SQL
package I don't have any issues. Now I'm trying to login using my XP
machine with MSSQL developer edition, and I can not connect to my
remote servers via TCP/IP. It can see the server, and it establishes a...
| | |
by: Todd Brewer |
last post by:
Windows Server 2000
ASP.NET 2.0
SQL Server 2000 (on a physically seperate server)
I moved an ASP.NET 2.0 application from a development server to production,
and am getting the following error:
System.Data.SqlClient.SqlException: An error has occurred while establishing
a connection to the server. When connecting to SQL Server 2005,...
|
by: =?Utf-8?B?TmVpbCBQYWRkb2Nr?= |
last post by:
Using asp.net in Visual Studio 2005, we are getting an error message when
trying to connect to an existing SQL 2000 database.. This has only hapenned
since we installed the SQL 2005 client tools.
The error is:
"An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be...
|
by: TerpZebra |
last post by:
I am having difficulty connecting to SQL Server 2000 on one of our
servers via a VB6 program on Vista. I can connect fine to a different
server, but it gives me the following error with the server in
question:
"Unable to connect to database. Please check your internet connection
Error# -2147467259
SQL Server does not exist or
access...
|
by: Me LK |
last post by:
I did a search but could not find an aswer that worked so here it
goes.
I just did an upgrade from 2003 to vs 2005 express. I am using a
remote sql server 2000. I specifically upgrade to make use of the
login control. Everything upgraded fine and the site is working on my
local machine.
It seems that my site is trying to connect to a...
|
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. ...
|
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...
| | |
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...
|
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...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
