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.
Navigation:
[Reply to this message]
|