Getting the latest SQL Server Native Client

If you are installing a Service Pack (SP) or Cumulative Update (CU) for SQL Server, you may notice that the SQL Server Native Client doesn’t get updated.  It may also be difficult to find the item to actually get it updated. If you go look at the Feature Packs for the Service Packs, or go…

2

Reporting Services: Error creating HTTP endpoint - Access is Denied

I’ve seen this issue a few times.  We had a case come in where they were seeing a blank page when they went to Report Manager for Reporting Services.  You may also see an HTTP 503 error.  This just means that the service had a problem and there was probably an exception that occurred under…

1

Troubleshooting Memory Issues with Reporting Services

We had a case where Reporting Services was crashing with the following error. Failed allocate pages: FAIL_PAGE_ALLOCATION 2 The number at the end can be different.  In the customer’s case it was a 1.  In my local repro it was a 2.  This is basically an indication that we are out of memory for the…

2

#Error When Rendering Report

Last week a case was brought to me where the customer was getting a #Error for a field within their report.  The field value was normally a number, but they wanted to change it to something like “1&1”.  That is when they would see the #Error. I created my own report that reproduces the issue…

3

JDBC: This driver is not configured for integrated authentication

I’ve had about 4 cases in the last two months that centered around the following error when trying to use Windows Integrated authentication with JDBC. java.sql.SQLException: This driver is not configured for integrated authentication The key environment point on this was that they were trying to do this on a Linux platorm and not a…

12

Power View in Excel won’t render from SharePoint

I originally encountered this issue back in May with a customer.  We had another customer this month that had the same issue.  When you try to load an Excel Document with a Power View Report in it from SharePoint, you may encounter the default unable to load power view report image. Before I get into…

2

Getting Cross Domain Kerberos and Delegation working with SSIS Package

I started working on this issue started by way of a Twitter conversation between myself, Jorge Segarra (@sqlchicken) and Matt Masson (@mattmasson). I then found out that Jorge was working with a customer that had opened up a Support Case.  Also special thanks to Joey Seifert for letting me bounce some Active Directory questions off…

3

Kerberos Configuration Manager updated for Analysis Services and SQL 2014

Kerberos Configuration Manager was released back in May of 2013.  It initially released with only SQL Server support. This was followed up with support for Reporting Services in November 2013. You can download the latest release from the following link: Microsoft® Kerberos Configuration Manager for SQL Server® http://www.microsoft.com/en-us/download/details.aspx?id=39046 This month we have released Version 3…

2

How to grab multiple parent/child elements from XML Data Source

We had a question come up about why an XML query wasn’t pulling a 2nd Parent/Child element from the resulting data.  This was grabbing data off of a Web Service.  The example I was given was a public Web Service call for getting Weather information. http://wsf.cdyne.com/WeatherWS/Weather.asmx?op=GetCityForecastByZIP The data that is returned looks like the following:…

0

SharePoint Adventures : Using Claims with Reporting Services

Back in February of 2011, I created a blog that walked through using Kerberos with Reporting Services. Since then, we have moved Reporting Services to a shared service within SharePoint.  This changes the game and we are now in the Claims world.  I’ve been asked a bunch of times regarding Claims Configuration, and just clearing…

7