Reply
New Member
Posts: 1
Registered: ‎01-23-2017

SCCM Solution Template - Can't get past step 4 (Target)

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.

Moderator
Posts: 39
Registered: ‎01-14-2016

Re: SCCM Solution Template - Can't get past step 4 (Target)

Can you contact the support alias pbisolntemplates@microsoft.com and we'll take a look.

 

Regards,

Richard

Occasional Visitor
Posts: 1
Registered: ‎01-26-2017

Re: SCCM Solution Template - Can't get past step 4 (Target)

Hi, 

 

I'm having this exact same issue... can't get past step 4.   If a root cause is found, please share!

 

Source:

SCCM 1610, SQL Server 2012,  

Server 2012 R2

 

Destination:

Windows 10 (1511)

SQL Express 2016

 

 

Moderator
Posts: 39
Registered: ‎01-14-2016

Re: SCCM Solution Template - Can't get past step 4 (Target)

Hi,

 

I'm afraid sql express is not supported as a target. Can you try with Azure DB or SQL Server 2008 R2 or later?

 

Regards,

Richard