Hot answers tagged

12 votes
Accepted

Kerberos Configuration Manager for SQL Server error "unable to access user principal information from the system"

I know this is a really old post, but for anyone that is still having this issue... I managed to work around it by going into my local administrators group on the server and clearing out any accounts ...
Ben Sala's user avatar
  • 136
12 votes

Security Risk? Microsoft-HTTPAPI/2.0

If the response's Server header returns "Microsoft-HttpApi/2.0", it means that the HTTP.sys is being called instead of IIS. Exploits and port scans use this as a means of fingerprinting an IIS server ...
Jeffry McGee's user avatar
7 votes

SQL Server Reporting Services (SSRS) IP Handling on Multi-Instance Servers

Introduction According to the various documents I found during my initial research and the documents provided in links and discussions I have come up with a solid, reliable, compliant solution. RFC ...
John K. N.'s user avatar
  • 2,055
5 votes

SQL Server Reporting Services (SSRS) IP Handling on Multi-Instance Servers

SSRS supports several standard data sources as well as other .NET data sources: https://msdn.microsoft.com/en-ca/library/ms159219.aspx Assuming you are using the SQL native client for the data ...
Jens Ehrich's user avatar
3 votes
Accepted

Security Risk? Microsoft-HTTPAPI/2.0

The most common cause for this Server response header is when IIS cannot determine which website to serve. IIS will respond with this Server header when the following are both true the request ...
Cheekysoft's user avatar
2 votes

Install SQL CLR types & Report Viewer 2012 on Sql 2008 server

Here the solution to download the Microsoft® System CLR Types for Microsoft® SQL Server® 2012 Step 1 : Choose the below website link https://www.microsoft.com/en-us/download/details.aspx?id=29065 ...
Hem Shankar 's user avatar
2 votes

SQL Failover Cluster Clients not updating DNS

Ok, I think I found a workaround - it's not exactly pretty, but it does work. From information found here: https://blogs.msdn.microsoft.com/sambetts/2014/02/04/multi-subnet-clustered-sql-...
edgesrazor's user avatar
2 votes

Sending SSRS reports to distribution groups

The shared O365 mailbox. Is it a cloud-only or a hybrid (synchronized) object? Does your on-premises Exchange server know about it? If the mailbox has been created directly in Office 365 / Exchange ...
Massimo's user avatar
  • 71.1k
2 votes
Accepted

SSRS Prompting for credentials when using FQDN

Add the URL to your Local Intranet zone in Internet Explorer settings on the client laptop.
GregGalloway's user avatar
2 votes
Accepted

How do I grant Auth to an Application Pool to a seperate server

Yes, you have two use accounts (one on each server) with the same name and password. Then run your application Pool under that user-account. Give limited permission to the account, to just do what it ...
Peter Hahndorf's user avatar
2 votes
Accepted

Unable to login to stand alone SSRS 2012 from domain joined computers

In order to resolve the issue I had to edit C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer\reportserver.xml Under: <AuthenticationTypes> Comment out ...
Matt Bear's user avatar
  • 874
1 vote
Accepted

Are the results from Microsoft SSRS in real-time from SQL Server?

There are options on how to run the report. Doing a copy/paste summary from the docs to here for posterity: On demand - You can specify that a report query a data source each time a user runs the ...
Ben Thul's user avatar
  • 3,034
1 vote

SSRS-error about report server database version after hotfixing SQL. The found version is '164'. The expected version is '163'

Based on the version that you got which is 163, try to apply this query on the instance hosting your reporter server database. In my below example, the database is named ReportServer : USE [...
Scorpion99's user avatar
1 vote

Which Reporting Services instance is using this ReportServer database?

If you look in the ReportServer database in question and run the following query it will show the SSRS web server(s) that are connected to it in the MachineName column. SELECT * from Keys where ...
GregGalloway's user avatar
1 vote
Accepted

SQL Reporting Services 2016 - "Content Manager" predefined role not listed

From the http://reportservername/Reports/browse page, click on "Manage Folder" then from http://reportservername/Reports/manage/catalogitem/security/ page you can click add group or user. You should ...
Sergio Pacheco's user avatar
1 vote
Accepted

OpsMgr SDK Service Event ID 26219 - SCOM 2022

I finally figured this out after spending days on the issue. Turning on the Report Server HTTP Log allowed me to see what was happening. 06/17/2022 22:36:05 127.0.0.1 NT AUTHORITY\SYSTEM 127.0.0.1 ...
Jessie's user avatar
  • 192
1 vote

How do we install custom fonts on SSRS in AWS MS SQL hosted on RDS

I signed up for AWS support and requested they make the change, as described in the other answer to this question. They refused and said it is impossible as of April 2021: Therefore, based on the ...
Kenneth Allen's user avatar
1 vote
Accepted

Recreate encryption Keys in MS-SQL RDS instance on AWS

Ok, this appears to have been AWS RDS bug, we had to disable SSRS, drop the SSRS databases and enable it again. Remove SSRS from that option group Execute below command to drop the ssrs DB - `exec ...
user129615212's user avatar
1 vote

SQL Server Express Reporting Services is accesible from another server?

The short answer is yes users from another server could see the reports on that server. This article shows how to configure SSRS SQL 2017. If you look at the article the screenshot for 'Web ...
SQLBobScot's user avatar
1 vote
Accepted

Windows Memory Usage - Is something throttling available RAM

After the machine was rebooted we added 128GB of RAM and set a value for WorkingSetMaximum. SSRS was given 100GB of memory to consume and it never surpassed 84GB. I really cant say if the MS docs are ...
Ross Bush's user avatar
  • 121
1 vote
Accepted

SSRS shows blank page for 1 user

As his logging work on your side, as stated in comment, the next step would do to make a packet monitor from the sonicwall to identify what port the customer block, so he could contact his support to ...
yagmoth555's user avatar
  • 17k
1 vote

Where is this hidden computer name coming from?

The right way to do this is to use a sysprepped image. Barring that, you need to rename your SQL instance(s) after renaming the computer. https://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/ami-...
joeqwerty's user avatar
  • 111k
1 vote
Accepted

Install "Microsoft Report Viewer" on Windows Server 2012 R2

Uninstalling and reinstalling .NET 3.5 resolved this problem. Could not find a source for the problem, or what was wrong with the initial installation of .NET, and wish I could provide a better answer....
Bruno L.'s user avatar
  • 121
1 vote

Kerberos Configuration Manager for SQL Server error "unable to access user principal information from the system"

Got exactly the same problem, How I fixed it? I went to local users and groups on the server with SPN issues Groups>Administrators> and removed any account that is not part of the same domain as ...
Amani's user avatar
  • 11
1 vote

Kerberos Configuration Manager for SQL Server error "unable to access user principal information from the system"

I had the same issue on SQL 2016 hosted on a Windows Server 2016. Running as admin didnt resolve my problem. I had to 'Run as a different user', then I logged in as my Active Directory domain admin. ...
Dongminator's user avatar
1 vote

Kerberos Configuration Manager for SQL Server error "unable to access user principal information from the system"

Mine was similar to the other answers but slightly different. I had an account from another domain in the Local Administrators group. I'm not sure the exact type of trust that was present. After ...
graz's user avatar
  • 11
1 vote

Kerberos Configuration Manager for SQL Server error "unable to access user principal information from the system"

I know this thread is old, but I was having the same issue. In my case the Remote Registry service was not running. I have found that on some servers it is just running, and on others it shows ...
Richard Webster's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible