Click here to Skip to main content
15,436,928 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi friends
i want my C# windows application to connect a sql server which is hosted in online site
My Connection String:
<add name="Connection" providerName="System.Data.SqlClient" connectionString="Data,8003; Network Library=DBMSSOCN; User ID=UserName; Password=Password; timeout=500;"/>

when executing this query the following error is shown

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
Abhishek Pant 19-Dec-12 2:37am    
timeout=500 really 500 miliseconds?
Kuthuparakkal 19-Dec-12 4:32am    
Wasit working before ? Are you sure the SQL server,8003 is configued to allow remote connections ?

1 solution

You may be disabling pooling or opening more connections that you realise. Have a look at[^]

or it could be the way you're connecting ... have a look at[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900