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.

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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

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.

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.

Taw (tawfiq.choudhury@grameenphone.com) writes:
> The problem is fixed. Just restarted the server. Dont know where the
> problem was, though.

Problem might have been that the server had not been restarted since
SQL authentication was enabled.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx