{"id":732,"date":"2014-01-14T11:32:44","date_gmt":"2014-01-14T11:32:44","guid":{"rendered":"http:\/\/sccm.haas.se\/?p=732"},"modified":"2014-01-14T12:31:05","modified_gmt":"2014-01-14T12:31:05","slug":"report-builder-cant-connect-to-sql-server","status":"publish","type":"post","link":"http:\/\/sccm.haas.se\/?p=732","title":{"rendered":"Report Builder can’t connect to SQL Server"},"content":{"rendered":"

You try to connect to the SCCM 2012 Data Source but Report Builder throws this error:<\/p>\n

“A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.)”<\/p>\n

\"2014-01-14<\/a><\/p>\n

This is because the connection needs to be authenticated by the means of a certificate that is on the SQL-server which your client doesn’t have. You need to export the “ConfigMgr SQL Server Identification Certificate” from your SQL Server Personal store to your clients Trusted Root store. Here’s a How-To:<\/p>\n

On the SQL-Server, open an MMC and from the File Menu, choose Add\/Remove Snap-in and then choose Certificates.<\/p>\n

\"Certificates<\/a><\/p>\n

Choose Computer Account after you press “Add”.<\/p>\n

\"MMC<\/a><\/p>\n

You will then export the “ConfigMgr SQL Server Identification Certificate” from the Personal Store on the SQL-server.<\/p>\n

\"Export<\/a><\/p>\n

\"Export2\"<\/a><\/p>\n

Do not export the Private Key<\/p>\n

\"Private<\/a><\/p>\n

Put the certificate somewhere where you can import it from your computer with Report Builder.<\/p>\n

On the computer with Report Builder, open a new MMC-console. Add the Certificate Snap-in for that computer and then import the certificate that you exported above into the Trusted Root Store.<\/p>\n

\"Cert<\/a><\/p>\n

After that you should be able to connect to the Data Source without problems.<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

You try to connect to the SCCM 2012 Data Source but Report Builder throws this error: “A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.)” This is because the<\/p>\n

Continue Reading… Report Builder can’t connect to SQL Server<\/span>Continue Reading…<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[45,44,32,13],"_links":{"self":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/732"}],"collection":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=732"}],"version-history":[{"count":7,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/732\/revisions"}],"predecessor-version":[{"id":759,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=\/wp\/v2\/posts\/732\/revisions\/759"}],"wp:attachment":[{"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=732"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/sccm.haas.se\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}