Posted by Taw on 02/07/07 11:06

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.

[Back to original message]