error 40 need help!!

Try a connection string like this:

Server=mssql03.discountasp.net;Database=DB_270453_gms;User ID=DB_270453_gms_user;Password=********;Trusted_Connection=False

 

Thanks Mate it worked oout fine for me now.

 

Hi,

I have been trying to solve this error for some times now, but dont get it. Please look below

The Error:


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)


I am using this connection string:


SqlConnection connString1 = new SqlConnection("Provider=sqloledb;Data Source=tcp:mssql03.discountasp.net,1433; Initial CataLog=DB_270453_gms; User Id=DB_270453_gms_user;Password=************");





Thanks for all help

 

Hi again,


I forgot to say that I am using SQL 2000





Thanks