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

On Feb 8, 4:43 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> 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.

[Back to original message]