[RESOLVED]HELP: i dont know how to deploy my application on a networked environment

[rember241]

i am just new on visual studio 2005 and i created a simple programs but i want to run it on a networked environment. can anyone help me i'm using sql server 2005 and the connection i used is data souce..

thanks for you help guyz!

[Hack]

Your backend database would be on the network.

Your VB.NET frontend would be installed on each client.

[rember241]

how can i configure my database so that it would be on a network?
i'm using sql server 2005

thx!

[dilettante]

You need a machine on the network that can run SQL Server all of the time (or at least whenever anyone wants to use the database). All client machines will need to be able to connect to this server via whichever transport you have configured (usually TCP/IP these days I think).

Choosing a Network Protocol

If your clients must reach the database via the public Internet you may have to do some firewall configuration to allow them to reach the server.

Managing the "Surface Area" of SQL Server 2005 may prove helpful as well.

[mendhak]

Ensure that your connnection string is in the application's configuration file (.config) so that each client can connect to the SQL Server instance. And of course that you're not using 'sa' user in your connection string.

[rember241]

thanks Guyz!