Remote access to SQL server - 09-25-2005 , 09:17 PM
We currently have a database that is in development using MSDE and being
hosted at the delopers site (Front end is in Access). Clients currently
access the database via IP.
We are planning on bringing this in house and using sql server. Just got
Now, how can I give the deloper full access to the database? My thinking is
that giving them VPN into the network and then setup a DSN/DSN less
connection that allows them full access to the specific database but not to
any of the other databases within SQL server. Is this correct?