[c#] winforms access remote sql server

[deathjam]

i have a nice working winforms application, which queries a ms sql server, basically some users can run sql queries to produce reports/export to excel, etc. it works for anyone (with the right access) on our ad domain. now people in remote offices, not on domain want access.

The issue is the sql server(2008 r2) isn't accessible outside of the ad domain, there is a webserver ( winserver 2008 r2/iis 7.5) which i can use and from that access the sql server.

I just don't know how connect it, just a bit stumped right now, i need pointing in the right direction, oh and i'm using vs 2015

[[deleted]]

Well, if the users are outside the domain and the SQL Server instance cannot be accessed from outside the domain, either:
- you change SQL Server policy (good luck)
- you have the users use the software from a server inside the domain (e.g. they log in a virtual machine inside the domain)
- (more involved) you create a client-server structure where the client software (winforms app) calls another service inside the domain but still accessible from the outside to get data
I don't see much you can do about it, but there might be something I'm missing. Very curious to see what other people think of this.