https: access to the SQL report SQL2012

Hi,

I just successfully bind the https to the SQL reporting, however, I cannot access the report Manager or reports thereafter although I am sure I provide the correct user name/password (even tried Administrator), after 3 attampts, a blank page is shown...

Please help on how to fix it...

Event log also thrown out the error message .. (event id 110)

The value for UrlRoot in RSReportServer.config is not valid. The default value will be used instead.

March 10th, 2015 2:49am

https://msdn.microsoft.com/en-us/library/ms156034.aspx

Also read this thread

https://ask.sqlservercentral.com/questions/101721/ssrs-asks-for-credentials-when-entering-report-man.html

Free Windows Admin Tool Kit Click here and download it now
March 10th, 2015 4:37am

https://ask.sqlservercentral.com/questions/101721/ssrs-asks-for-credentials-when-entering-report-ma

March 10th, 2015 5:10am

Hi,

After I modified the RsReportSerer.config, changed to <AuthenticationTypes ... <RSWindowsBasic>..

It seems can login but after loading 2-3 minutes, it pop out the error message...

Free Windows Admin Tool Kit Click here and download it now
March 10th, 2015 5:15am

March 11th, 2015 2:15am

An account failed to log on.

Subject:

Security ID: NULL SID

Account Name: -

Account Domain: -

Logon ID: 0x0

Logon Type: 3

Account For Which Logon Failed:

Security ID: NULL SID

Account Name: report

Account Domain: SERVERNAME

Failure Information:

Failure Reason: An Error occured during Logon.

Status: 0xC000006D

Sub Status: 0x0

Process Information:

Caller Process ID: 0x0

Caller Process Name: -

Network Information:

Workstation Name: SERVERNAME

Source Network Address: -

Source Port: -

Detailed Authentication Information:

Logon Process:

Authentication Package: NTLM

Transited Services: -

Package Name (NTLM only): -

Key Length: 0

This event is generated when a logon request fails. It is generated on the computer where access was attempted.

The Subject fields indicate the account on the local system which requested the logon. This is most commonly a service such as the Server service, or a local process such as Winlogon.exe or Services.exe.

The Logon Type field indicates the kind of logon that was requested. The most common types are 2 (interactive) and 3 (network).

The Process Information fields indicate which account and process on the system requested the logon.

The Network Information fields indicate where a remote logon request originated. Workstation name is not always available and may be left blank in some cases.

The authentication information fields provide detailed information about this specific logon request.

- Transited services indicate which intermediate services have participated in this logon request.

- Package name indicates which sub-protocol was used among the NTLM protocols.

- Key length indicates the length of the generated session key. This will be 0 if no session key was requested.

Free Windows Admin Tool Kit Click here and download it now
March 11th, 2015 2:21am

The program ReportingServicesService.exe, with the assigned process ID 1784, could not authenticate locally by using the target name HTTP/project.xx.hk. The target name used is not valid. A target name should refer to one of the local computer names, for example, the DNS host name.

Try a different target name.

March 11th, 2015 2:35am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics