I built a new SCCM 2012 R2 CU2 suite on Server 2012 R2. This also uses SQL 2012 SP1 CU6. This suite has 4 servers: site server, two for WSUS and secondary DPs, and SQL. This problem is true for the built in reports and my custom reports. Our SQL guy has been helping me a lot but we've gotten nowhere. I can run a report. I can open one in edit mode after it prompts me for credentials. It loads Report Builder 3.0. But when I go to a dataset/query, enter credentials, and try to open it, I get a popup that says "Unable to connect to data source. 'AutoGen_5C6358F2_yayak..." When I click on details it says "The target principal name is incorrect. A connection was succesfully established with the server, but then an error occurred during the login process.  (SSL Provider, error: 0 -The target principal name is incorrect.)" In SQL Reporting Services Config Manager the paths for Web Service URL is http://ip.ip.ip.ip:80/ReportServer_SC01 and for Report Manager URL: http://ip.ip.ip.ip:80/Reports_SC01.

This is one of three problems I'm having a lot of difficulty with on this network. I'm making separate threads for all

Could this be a SPN issue? Is SQL / SRS running using a domain user account instead of local system?

A domain user account is used. One thing we don't get is why the SSL portion of the error is showing up since the URL in Report Mgr is not using SSL.

This happens when you r-click a dataset and select query to edit the code of a dataset, ie, when query designer tries to open up. It happens in both Admin Console and when using the Report Manager URL within SQL SSRS. All other functions of using edit mode of a report work fine. Anyone have some&n

Hi,

I notice that you have a different data source name, have you ever changed it? You can manage the data source via web access. And you test the connection there. Here is my screenshot:

You're probably talking about the "AutoGen_" part. I've tried it with and without that in the source name. I get the same error either way Thanks for the suggestion.

Hi i am also facing the same issue how did u solve tihs

I never have. Sorry.

Hi Ben,

I've noticed you have this question posted several times across the forums in different threads.  It may be a good idea to allow a single instance of this issue play itself out.

Anyhow, have you tried browsing to your datasource from within the Reports site using the Report Builder link?  It's in the upper ribbon next to "New Data Source." Steps below to try.

1)  Click Report Builder link and allow report builder to start

2)  Click Table or Matrix Wizard

3)  Ensure "create a dataset" radio button is checked and click Next

4)  Within the Data Source Connections window, click the Browse button

5)  Navigate to your ConfigMgr_[sitecode] folder and drill down to the next level

6)  Use the scroll bar and scroll all the way to the right and you'll see your DB connection source at the end under all the folders.

7)  Select that and click Open

8)  Test the connection and wait for a response dialog box

Let us know the results please and give the exact error message (screenshot preferred)

Will try tomorrow.

When I do that, browse is dimmed out.

But, if I deselect "create a data set" and click "choose an existing dataset in this report..." there is no data connection at the end.

But if I don't use report builder and instead use IE to browse to my ConfigMgr_ABC, I do see the connection at the end: {123...}.

This problem is on a network that is not on the 'net, so it's hard to do screen shots, so I'll reproduce this problem step by step:

I pick a report to edit, it doesn't matter which one.

If I try it in Admin Console, I right-click, Edit the report, it asks me for a login, I login, then I get a popup that says "Cannot continue. The application is improperly formatted. Contact the vendor for assistance. I click the Details button and get a long set of text but the key part is "Your web browser settings do not allow you to run signed applications." This msg didn't appear before, so something changed, so I will investigate. I think it used to give a SPN error.

If I use IE within report builder and navigate to whatever report, click open, everything works, except, when I click on Dataset0 (the key one I normally need to edit), click query, it prompts me for a login and no matter which one I use, i get a popup that says "unable to connect to data source 'AutoGen_123...'". If I click details I get "the targe principal name is incorrect. A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider 0-The target principal name is incorrect.)

Sounds like a permissions issue to me.  I'd go through your permissions settings within SSRS and ensure they match those needed to run the Reporting Services Point role.  Also, check that the installation procedures for the role and SSRS were followed.

http://technet.microsoft.com/en-us/library/gg712698.aspx

I went through all that, found some SQL rights on SYSTEM that needed changed, rebooted the SQL box and the site server = no change. This stuff really shouldn't be this difficult.

Yes, I know this is an old post, but Im trying to clean them up. Did you solve this problem, if so what was the solution?

What I do is create a new Data source for all my reports. Once the Report is upload I change the datasource to the MS datasource any everything is good.

http://www.enhansoft.com/blog/how-to-upload-a-ssrs-report-and-change-its-data-source

BTW, I never recommend use Report build, instead I recommend use BIDS

No one in my office has ever figured this out. My guess it's because of all the security lockdowns we're forced to live with and the fact that on this network (call it B) the SQL db is on a separate server from the site server. On another network (call it A) the db is on the same box as the site server and I don't have this problem. What I have to do is make a copy of a custom report on A, edit it as needed, export it into .rdl, copy it over to B, upload it, and change the data source connector.

Is BIDS free? What do you do? How does it work with SCCM? It has a plug in or what?

Garth:

Could you go to https://social.technet.microsoft.com/Forums/en-US/677c54eb-7a4e-4a62-8fde-40fa2b20b3e7/get-sccm-report-code-to-return-just-one-collection?forum=sqlreportingservices

and maybe help with the where code there? Thanks.

Is BIDS free? What do you do? How does it work with SCCM? It has a plug in or what?

Yes BIDS is free it is part of SQL.  It is basically the same as RB. IT works the same way as RB does with CM12 (or CM07 or CM16). It is a tool within the SQL setup.