Hi Experts,
I hope you can help me with this?
I recently built and SQL Server Reporting Service. All was working fine, but i needed it to work over HTTPS. Unfortunately when attempting to browse HTTPS it kept prompting me for credentials, but would not accept any (this is despite me being an administrator, sysadmin and explicitly referenced as a SSRS administrator
I did some googling and found you could change the manor of authentication via the following link
https://technet.microsoft.com/en-us/library/cc281309(v=sql.105).aspx
I was able to change authentication to basic and it worked. i could use HTTPS and login with my credentials. But now i've hit a new snag. Now when ever i open the report builder i get the following error
"Cannot retrieve application. Authentication error"
Details revel the following
"PLATFORM VERSION INFO
Windows : 6.1.7601.65536 (Win32NT)
Common Language Runtime : 4.0.30319.18444
System.Deployment.dll : 4.0.30319.34244 built by: FX452RTMGDR
clr.dll : 4.0.30319.18444 built by: FX451RTMGDR
dfdll.dll : 4.0.30319.34244 built by: FX452RTMGDR
dfshim.dll : 4.0.41209.0 (Main.041209-0000)
SOURCES
Deployment url :
http://dc4insql01/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application
ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of
http://dc4insql01/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application resulted in exception. Following failure messages were detected:
+ Downloading
http://dc4insql01/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application did not succeed.
+ The remote server returned an error: (401) Unauthorized.
COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.
WARNINGS
There were no warnings during this operation.
OPERATION PROGRESS STATUS
* [28/08/2015 08:34:46] : Activation of
http://dc4insql01/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application has started.
ERROR DETAILS
Following errors were detected during this operation.
* [28/08/2015 08:34:46] System.Deployment.Applicat
ion.Deploy
mentDownlo
adExceptio
n (Unknown subtype)
- Downloading
http://dc4insql01/ReportServer/ReportBuilder/ReportBuilder_3_0_0_0.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Applicat
ion.System
NetDownloa
der.Downlo
adSingleFi
le(Downloa
dQueueItem
next)
at System.Deployment.Applicat
ion.System
NetDownloa
der.Downlo
adAllFiles
()
at System.Deployment.Applicat
ion.FileDo
wnloader.D
ownload(Su
bscription
State subState)
at System.Deployment.Applicat
ion.Downlo
adManager.
DownloadMa
nifestAsRa
wFile(Uri&
sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Applicat
ion.Downlo
adManager.
DownloadDe
ploymentMa
nifestDire
ctBypass(S
ubscriptio
nStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Applicat
ion.Downlo
adManager.
DownloadDe
ploymentMa
nifestBypa
ss(Subscri
ptionStore
subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Applicat
ion.Applic
ationActiv
ator.Perfo
rmDeployme
ntActivati
on(Uri activationUri, Boolean isShortcut, String textualSubId, String deploymentProviderUrlFromE
xtension, BrowserSettings browserSettings, String& errorPageUrl)
at System.Deployment.Applicat
ion.Applic
ationActiv
ator.Activ
ateDeploym
entWorker(
Object state)
--- Inner Exception ---
System.Net.WebException
- The remote server returned an error: (401) Unauthorized.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.
GetRespons
e()
at System.Deployment.Applicat
ion.System
NetDownloa
der.Downlo
adSingleFi
le(Downloa
dQueueItem
next)
COMPONENT STORE TRANSACTION DETAILS
No transaction information is available."
This is the authentication string i am using currently. Any ideas?
<Authentication>
<AuthenticationTypes>
<RSWindowsBasic>
<LogonMethod>3</LogonMetho
d>
<Realm></Realm>
<DefaultDomain>mydomain</D
efaultDoma
in>
</RSWindowsBasic>
</AuthenticationTypes>
<EnableAuthPersistence>tru
e</EnableA
uthPersist
ence>
</Authentication>
Try to either add the site to your "LocalIntranet" zone in IE (which automatically sends id and password) or make sure that the "automatic login with current username and password" option is set for the "Logon" option in the Internet zone. Launch IE by right clicking the IE icon and clicking "Run As Administrator" and tick the "Save Password" check box on the user name and password entry box when the user starts the session.