Resolved: Connecting to a remote SQL Server

[tom_hotspur]

Hiya

Basically i've developed a VB.net/SQL Server 2k app locally on my machine.

In a few month time the system will be tested. This requires the SQL Server to be installed on a server so others can access it over the WAN with their VB.net clients.

obviously all users will require rights to access the server but i do not wish to map the drive on their local machine (as they do not require to see the server just to use it as an application server).

Therefore i plan to use the absolute path in the connection string.

Here is where i get confused...

the users are obviously not logged into the server when they first boot up in the morning, so when they attempt to access the sql server wih the client does this mean they have to log in to the server as well as the sql server?

If so how do i achieve this?

Also am i right in calling this 'accessing a remote sql server'? or
is this classed as somthing else?

any help would be great!