Click here to Skip to main content
15,390,456 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[^]

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