SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-01-2008, 12:16 PM
| ||||
| ||||
 Connecting SQL 2000 using SQL 2005 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.      |
|
03-01-2008, 12:16 PM
| |||
| |||
| Re: Connecting SQL 2000 using SQL 2005 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 |
|
03-01-2008, 12:16 PM
| |||
| |||
| Re: Connecting SQL 2000 using SQL 2005 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. |
|
03-01-2008, 12:18 PM
| |||
| |||
| Re: Connecting SQL 2000 using SQL 2005 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. |
|
03-01-2008, 12:18 PM
| ||||
| ||||
| Re: Connecting SQL 2000 using SQL 2005 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 |
Linear Mode
