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.Taw (tawfiq.choudhury@.grameenphone.com) writes:
Quote:
Originally Posted by
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, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Feb 7, 4:43 pm, Erland Sommarskog <esq...@.sommarskog.sewrote:
Quote:
Originally Posted by
Taw (tawfiq.choudh...@.grameenphone.com) writes:
Quote:
Originally Posted by
I can connect to the 2000 server from 2005's SSMS using windows
authentication mode but fail to connect using SQL authentication.
>
Quote:
Originally Posted by
The follwoing message is displayed.
>
Quote:
Originally Posted by
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:
Quote:
Originally Posted by
Taw (tawfiq.choudh...@.grameenphone.com) writes:
Quote:
Originally Posted by
I can connect to the 2000 server from 2005's SSMS using windows
authentication mode but fail to connect using SQL authentication.
>
Quote:
Originally Posted by
The follwoing message is displayed.
>
Quote:
Originally Posted by
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.|||Taw (tawfiq.choudhury@.grameenphone.com) writes:
Quote:
Originally Posted by
The problem is fixed. Just restarted the server. Dont know where the
problem was, though.
Problem might have been that the server had not been restarted since
SQL authentication was enabled.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
No comments:
Post a Comment