SQL Server Performance Forum – Threads Archive

MS Enterprise Reporting on Extranet

Not sure if this is the best place but here goes…. I am due to impliment MS Enterprise reporting on behalf of a client. They want to setup an Extranet that their clients can logon to. MS Enterprise Reporting needs to connect to a SQL server – that runs in mixed-mode. Does anyone have any experience in such a setup – trying to get help from MS is impossible [}<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] I am aware that I could use IPsec and the suchlike to secure the server commnications through the firewall but am not too sure about how to handle the SQL side of things, specifically: The current server uses multiple instances – for an Extranet to keep things secure I am thinking we should use a dedicated server… Mixed-mode – can’t seem to do anything about this – what’s my best bet to help keep it secure? Thanks

]]>