Access SQl server remotely

[jgat2011]

Hi every one,
I would like to deploy my Vb.net application but the database will be installed on one server and other users will only have interfaces on thei computers.
How can one make it possible to access the database on the server?
I was thinking of using the server IP Address but the network uses DHCP,which means that IP will keep on changing. Can any one help please?

 

[jmcilhinney]

You simply use the server name. For a default instance you use just the machine name as the Data Source in the connection string and if it is a named instance then you use the machine name and instance name, e.g. Machine\Instance.

 

[jgat2011]

THank you!I will try it out and let you know