SOLVED Default data connector problem

[Marek Belan]

Hi all

maybe after update KB4500571 i have problem with reporting.
All reports loading many minutes.
When i change default data connector to embedded all is OK and fast.

Is there a way how to recreate default connector or i must change this on every report?

 

[Garth]

Are the reports successful with the default datasource? Or do they timeout?

 

[Marek Belan]

Are the reports successful with the default datasource? Or do they timeout?

After long time yes but when I change data source it was in second.

in connection string is something like this
Persist Security Info=False;Initial Catalog=CM_PRI;Data Source=sccmserver;Encrypt=true;TrustServerCertificate=false

when I change it to

Data Source=sccmserver;Initial Catalog=CM_PRI

after some time it revert to this ...

 

[Garth]

Yes every 10 minutes it will be overwritten. there isn't a lot that you can do other than open a support case or send a frown. https://www.enhansoft.com/how-to-send-a-smile-to-the-sccm-product-team/

 

[Marek Belan]

Yes every 10 minutes it will be overwritten. there isn't a lot that you can do other than open a support case or send a frown. https://www.enhansoft.com/how-to-send-a-smile-to-the-sccm-product-team/

so there is no way to change all datasource in all report?

 

[Garth]

I'm sure that you can do it with powershell but that isn't going to solve you problem in the long term. It will come back.

 

[Marek Belan]

I'm sure that you can do it with powershell but that isn't going to solve you problem in the long term. It will come back.

I hope when I create new connector not created by SCCM and change all report to this it wil not change. Or?

 

[Garth]

Everytime the RP gets update all the DS will get reset to the MS one. Again, I strongly recommend that you contact support.

 

[Marek Belan]

Everytime the RP gets update all the DS will get reset to the MS one. Again, I strongly recommend that you contact support.

I resolve this by reinitializing all lreport by
HKEY_Local_Machine\Software\Microsoft\SMS\SRSRP\ change the SRSInitializeState key to 0

all is working now.