Posted by pb648174 on 02/08/07 11:18

On Feb 7, 4:43 pm, 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

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.

• Next in forum: Re: Why optimizer is not smart? Is dynamic SQL my only option...
• Prev in forum: Re: NULLS and ''
• Thread view: Re: Connecting SQL 2000 using SQL 2005

[Reply to this message]