Deploying a .net winforms application that uses a remote sql server

[steve1rm]

Hello,

I have a windows application that uses a sql server remote database.

Which is the best method to deploy an application that has to connect to a remote server on an another computer, that is part of the LAN Network.

I have been told that during installation the connection will be setup.

At the moment I am using the sqlclient connection. I have my connection string in the app.config. But when the customer installs that want to be able to browse to the server that they will have to connect to.

Well as I have never deployed, I will never know what is best.

Give you could give a short example, i would be most grateful.

Thanks

 

[mrdenny]

If the user needs to be able to select what server to connect to you will need to build this ability into the application. After they select the SQL Server you should write back to the app.config with the new connection string.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com