SQL Server - How to connect to a private SSRS intance publicly
Asked By Brandon Schave on 02-Apr-13 10:36 AM
I have a requirement for security purposes to connect to a private instance of ssrs which connects to a private instance of SQL Server 2005 from a public domain. How can I do this? Please give particulars.
Thanks in advance.
Robbe Morris replied to Brandon Schave on 03-Apr-13 07:47 AM
I think you'd have to use SQL authentication. But, if that SQL instance is configured not to accept remote connections, it won't matter.
Exposing your server over the internet (which is what I "think" you are talking about) is not smart. You'll undoubtedly get hacked. Can you elaborate more on why you are exposing your private instance and why it is a requirement versus building a public facing web service that accesses your private instance of SSRS?