Remote connection
-
Hi everybody, I have a following problem. My computer uses SQL Server 2000. I write my project on my local machine. I use Dataset to retrieve data from QLNS database. When I set up my project to other machine in LAN. I encounter this error while running exe file. "An error has occured while establishing a connection to the server. When connecting to SQL Server 2000, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections (provider: Name Pipes Provider, error: 40 - Could not open a connection to SQL Server". Please kindly teach me how to solve this. Thank you very much. Hope your help.
It seem to be a solution or an answer.
-
Hi everybody, I have a following problem. My computer uses SQL Server 2000. I write my project on my local machine. I use Dataset to retrieve data from QLNS database. When I set up my project to other machine in LAN. I encounter this error while running exe file. "An error has occured while establishing a connection to the server. When connecting to SQL Server 2000, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections (provider: Name Pipes Provider, error: 40 - Could not open a connection to SQL Server". Please kindly teach me how to solve this. Thank you very much. Hope your help.
It seem to be a solution or an answer.
-
Is this server accessiable from your system. Try telnetting to port 1433 to confirm the same.
Thanks Laddie Kindly rate if the answer was helpful
I have checked port 1433.It is available in Client Network Utility. Maybe some security policies cause the problem. I'm so confused ...
It seem to be a solution or an answer.
-
Hi everybody, I have a following problem. My computer uses SQL Server 2000. I write my project on my local machine. I use Dataset to retrieve data from QLNS database. When I set up my project to other machine in LAN. I encounter this error while running exe file. "An error has occured while establishing a connection to the server. When connecting to SQL Server 2000, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections (provider: Name Pipes Provider, error: 40 - Could not open a connection to SQL Server". Please kindly teach me how to solve this. Thank you very much. Hope your help.
It seem to be a solution or an answer.
1. I don't mean to be condescending, but are you sure you aren't connecting to localhost? 2. Are you able to connect to this database from Query Analyzer on the second machine? 3. Check your SQL Server settings.
Cheers, Vikram.
The hands that help are holier than the lips that pray.
-
I have checked port 1433.It is available in Client Network Utility. Maybe some security policies cause the problem. I'm so confused ...
It seem to be a solution or an answer.