01-23-2017 02:18 AM
At step 4, the target DB, I've successfully validated the target DB but when I click 'next' the wait icon appears for a few seconds and nothing happens. It stays on the 'Connect to your SQL database' screen and doesn't move on, no errors or anything in the event logs. There are no new tables or stored procedures in the target DB,
I've tried installing from a few machines, using admin accounts and the account that has rights to the DBs and will managed own the scheduled task. For info:
- The OS, SCCM and SQL versions are compliant
- The account used has db_datareader role privileges over the SCCM database
- The account used has db_owner role privileges over the target DB for the Power BI data
- The target DB is on premise, it's not in the default instance
Any advice would be much appreciated.
01-26-2017 04:49 AM
I'm having this exact same issue... can't get past step 4. If a root cause is found, please share!
SCCM 1610, SQL Server 2012,
Server 2012 R2
Windows 10 (1511)
SQL Express 2016