SCSM Setup fails when using Remote SQL with "Access to the SQL Server Instance was denied" Error message.
I'm running with trouble while installing SCSM Management server and SCSM DWH Management server (each in different box).<o:p></o:p>
It fails with "Access to the SQL Server Instance was denied" Error message at the database configuration page.<o:p></o:p>
I want to use one of my Central SQL Server for all the DB's but for SCSM it's not working out but when I install the SQL Server locally into that server it works fine (but I do not want to do that).<o:p></o:p>
Environment: SQL 2K8R2 SP1, Windows 2K8R2 SP1, SCSM 2010 SP1 <o:p></o:p>
PS: Installation account has got all the SQL Server role privilege and is also part of local administrator of SQL Box.<o:p></o:p>
Please help me to resolve this issue. Error files have been attached for your reference.<o:p></o:p>
Thanks in Advance.<o:p></o:p>
This is solved by change the Windows Firewall to allow incoming connections on the TCP port of SQL Server. But on "Configure the reporting server for the data warehouse page" I'm getting “The SSRS Web service URL is not valid” error message. I'm not able to browse the URL with installation account also; I know there is some permission issue on SQL box but don't know exactly where. Can anyone pls let me know where should I check for this issue? Thanks<o:p></o:p>
I have assigned all the SQL Server role for the Reporting DB to the SCSM Installation account but still not working.<o:p></o:p>
You'll need to install and configure SSRS on the server you intend to use for reporting. You'll also need to copy a dll file to the computer hosting SSRS.
As always, double check your firewall settings.
Allen Anderson Systems Analyst Arizona State University - OKED Knowledge Informatics