having problem while connecting sql 2000

im using sql server 2000 and i m facing this problem

plz tell me why is this

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

You failed to connect into the SQL server. I think the IP or the host name is wrong.

Check the following site for connectionstrings

www.connectionstrings.com

Regards

|||Also make sure Named Pipes and TCP/IP network libraries are enabled for the SQL2000 instance. You can easily archieve this in Server Network Utility.|||

hai dude

i want to mentions one thing that i have previously used the same connection class made my self for connecting to the db..

but now on new another pc with new installation of sql server ,,having the same previously used setting.,,its not woking,,,

one thing more im not usgin ip based connection string ...

|||Why not use IP based connection string? IP is often more reliable than machine name, for example when DNS does not work properly so the machine name can't be intepreted?to IP.|||

yah thanks dude

its done