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 |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-01-18 : 01:56:54
|
| hi Guys its been long time. and when i am stuck with issue i come back to forum and all the time the group been very helpful.we have a project which is developed VB.net that needs to access SQL Server that exists on another LAN. Client has multiple domains and the application should be able to connect to the database server (SQL Server) which can be on any one of the domains. so the first Q is how do i access it.and as firewall will be in place.what firewall considerations and settings need to be performed to achieve this======================================Ask to your self before u ask someone |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-01-18 : 08:37:03
|
| We just had someone post the same question yesterday. You have several options here. The right option would be to have an application layer able to access the database layer. The application layer would serve up data to the client application.You might be stuck with not what you currently have. In that case, you can either:1. Setup a trust between the client domain and yours (your network guys will probably laugh).2. Use VPN to give the clients access to your domain when they use the application (this is a secure, easy to implement option).3. Use a thin client and either remote desktop or Citrix to allow them to access the application in a hosted manner.4. Have the database exposed to the outside world (this one is the worst idea).I'm sure that I could think of more options, but you should have some food for thought now.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-01-18 : 19:43:22
|
| >> access SQL Server that exists on another LAN.you mean you on remote network or same local network but different subnet ?-----------------'KH' |
|
|
|
khalik
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-02-01 : 05:38:44
|
| can be remote network or may have diffrent subnet======================================Ask to your self before u ask someone |
|
|
|
|
|
|
win APP accessing DB that exists on another LAN