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…


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…


#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…


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…


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…


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…


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:…


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…