Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
willem
Starting Member
1 Post |
 Posted - 2006-12-20 : 10:23:38
|
| Hello,I have a sql server express database engine, running a database,i have several 'access data project clients' that connect through lan . I want to make the database available remotely, does anyone have any suggestions on securing the database so i can do this relatively safe. Thank's Willem |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-12-20 : 21:04:45
|
| In our case, we setup a VPN tunneling to internal network. Each user assign a domain account. Once the VPN tunneling has been established then you can do the Enterprise Manager to that SQL Server. The WAN administrator keeps an eye the activity of the VPN all the time.For the mobile user that somehow does not have any enterprise manager, we setup Citrix Gateway that acceseebale through public URL to launch remote desktop to the SQL box. We only open up once awhile just upon request for security reason.Other alternative will be setup this SQL box somehow open up from public by putting into DMZ or behind firewall etc and the user will access through the public ip address in enterprise manager. Personally, I don't really like this.Hope this help. |
 |
|
|
|
|
|
securing wan