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 ...
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 ...
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 ...
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 ...
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 ...
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
...
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-...
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 ...
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.
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 ...
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 ...
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 ...
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 [...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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-...
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....
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 ...
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. ...
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 ...
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 ...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
ssrs × 244sql-server × 88
sql-server-2008 × 36
sql-server-2005 × 26
sharepoint × 17
ssrs-2008 × 15
iis × 13
sql-server-2008-r2 × 11
sql × 9
windows-server-2008-r2 × 8
team-foundation-server × 7
sql-server-2012 × 7
reporting × 7
ssrs-2012 × 7
windows-server-2008 × 6
authentication × 6
kerberos × 6
windows × 5
security × 5
ssl × 5
windows-server-2003 × 5
iis-7 × 5
ssrs-2008-r2 × 5
email × 4
windows-server-2012-r2 × 4