Sqlserver connecting problem

[alav]

Dear all we have Vs2005, and sqlserver 2000 in our local system. We create a login.aspx file. Thru this login.aspx file(which is on the local system) , we can connect to the host server database.But while we try to connect the database thru the login.aspx file (which is on the host server) , we get the following error alert message. "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:TCP Provider,error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)" Can anybody help for this problem?

[kubben]

Most likely you have the wrong name for the sql server in your connection string. You might have local host for you local application. When you install this on a web service you will need to put the correct sql server name in the connection string. Hope that helps. Ben