MS Enterprise Reporting on Extranet | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

MS Enterprise Reporting on Extranet

Not sure if this is the best place but here goes….<br /><br />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.<br /><br />MS Enterprise Reporting needs to connect to a SQL server – that runs in mixed-mode.<br /><br />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=’:)‘ />]<br /><br />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:<br /><br />The current server uses multiple instances – for an Extranet to keep things secure I am thinking we should use a dedicated server…<br /><br />Mixed-mode – can’t seem to do anything about this – what’s my best bet to help keep it secure?<br /><br />Thanks