Posted by Erland Sommarskog on 02/07/07 22:43

Taw (tawfiq.choudhury@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, esquel@sommarskog.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

[Back to original message]