Attaching database at runtime

I have made at database at SQL 2008. I have added the database at my Visual basic project and prepare my application. While I am adding records from the FORMS I have made at VB, it is saving at the database . Now while making setup files of the Project I have made at VB it is running from the machine where I have made the application BUT when I install it in different SERVER/Client network machines it won't work.

HOW THE APPLICATION WHICH I MADE AFTER INSTALLING ASK FOR THE SQL SERVER NAME, SQL USER NAME, PASSWORD AND THE DATABASE PATH AT THE TIME OF ITS FIRST RUN.

WHERE THE CONNECTION STRING IS TO BE INSERTED

1 answer

Dibyandu
I am having the exact same problem. Please give me heads up if you get an answer. Same product works on other server/client and this one it doesnt. The server is on win server 2003 and the client is on win xp pro.

On other server/client most issues had to do with ensuring on server conf mgr that the iinstance name had shared memory, named pipes and tcp/ip enabled and that the browser was automatic and running as network service. That solved most issues. Also made sure that the server firewall had port 1434 open, browser passthrough and sql instance name passthrough. All worked until now