Run time Remote Connection Config in EXE Application ? - General SQL Database Question & Answer

Member of the LearnItFirst.com Video Training Network	\| LearnSqlServer.com \| SQL SSIS Training \| SQL Programming Tutorials \|

Welcome Guest

Search | New Posts | Members | Log In | Register

LearnSqlServer.com's SQL Server Forums » SQL Server Database Administration » General SQL Database Question & Answer » Run time Remote Connection Config in EXE Application ?

Run time Remote Connection Config in EXE Application ?

Options

Previous Topic · Next Topic

dotnetnewbie

Posted: Sunday, March 30, 2008 11:27:33 AM

Rank: Newbie

Joined: 3/30/2008
Posts: 1
Points: 3

I am getting this 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)(Microsoft SQL Server,Error:2)"

in SQL EXPRESS 2005"

1.Just changing the service config settings that is TCP/IP to enable will it work?i changed i run my application but it didn't work they have written the code to the server(connection string to their server- if it was to common how to write the code ?) & is there any other changes ?

2.I have developed a VB.NET EXE file -In that application(inside the code) i am using run time connection string queries to connect to the database & created run time tables.
Suppose if i want to install the application to all clients/users how to Configure that application - self configuration/self installer to the installing machine SQL SERVER.
How can i do this ?

3.Is there any way i can write config file for sql server along with exe application code ? How can i do this ?

Pls answer with details/screenshots or diagramatical (if possible)

Dotnetniewbie

Scott Whigham

Posted: Wednesday, April 02, 2008 9:31:38 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 345
Points: 748
Location: Dallas, TX

1 - It shows you are trying to use Named Pipes to communicate. Enabling TCP/IP will not help you - you must enable Named Pipes protocol.

2 - I'm sorry but I don't understand what you're asking - can you please elaborate/re-state?

3 - That's what settings files and app.config are for.

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.