Not able to use PFX format certificate in SQL Server?

[Update  8/24/2015 This issue has been fixed by SQL Server 2014 SP1 cumulative update 2.  See KB for more details. ]   If you have a security certificate in PFX format that is generated by Microsoft Certificate store, you can not use it directly in SQL Server.   But you can use PVKConverter.exe tool to convert…


The Additive Design of SSAS Role Security

SSAS security roles are additive – that is, a user gets permission to access data allowed in any role to which the user belongs, even if another role membership for the same user does not allow access to the same data. This can cause confusion in some circumstances, and has been incorrectly reckoned a defect…


Error trying to access SharePoint List from Power Query

When trying to pull data from a SharePoint List Data Source, using the Microsoft Online Services ID, you may see the following output in your query: DataFormat.Error: OData: The given URL neither points to an OData Service or a feed: ‘<URL>&lc=1033&id=500046&guests=1’. You may also see an error saying “The user was not authorized”. You may…


Analysis Services – Errors when trying to add a User as a Server Admin

When trying to add a user as a Server Admin to Analysis Services, you may encounter one of the following errors: The following system error occurred:  The trust relationship between the primary domain and the trusted domain failed. (Microsoft.AnalysisServices) Or The following system error occurred:  No mapping between account names and security IDs was done….


SQL Server 2008 R2 does not start when applying certain hotfix updates

We have noticed that when you install certain hotfixes (this includes Cumulative Update 1 and certain versions of security update MS11-049 etc. ) on an SQL Server 2008 R2 RTM Instance on which Utility Control Point is configured, the installer fails to apply the upgrade scripts and SQL Server does not start. You will see…

SharePoint Adventures : ADFS Setup – Part 2

In Part 1, we looked at getting ADFS actually installed, for Part 2, we will see what we need to do to get it working with SharePoint 2010. Being that I focus on Reporting Services, the end goal here is to see how it work with Reporting Services. However, RS will be for another post….

SharePoint Adventures : ADFS Setup – Part 1

I’ve had a few cases that involved customers using ADFS, SharePoint and Reporting Services. When going through this, one of the big struggles was just getting ADFS up and running with SharePoint 2010 so we could focus on the customer’s issue. I did find a few items out there that got me pointed in the…


MS11-028 may cause issues with SQL, Exchange and PowerShell

A .NET Security Update (MS11-028) may end up causing issues with applications that make use of the .NET Framework, mostly resulting in applications being unable to launch, or loss of functionality within Native Applications that make use of .NET. In some cases, it could lead to an application crash. For this issue to occur, the…


Why am I getting prompted for Credentials?

I just wrapped up a case for an issue I see every once and a while.  The scenario is the following: Browse to site Get Prompted for credentials and enter username and password Web site will come up normally I’ve seen where some people go into Kerberos troubleshooting mode, but that in itself is not…

SharePoint Adventures : Why isn’t Claims working with SSRS?

SharePoint 2010 introduced a new authentication architecture called Claims Based Authentication SharePoint Claims-Based Identity When using Claims Based Authentication for your SharePoint site, in order for authentication to flow between services, those services needs to be claims aware. That means that they understand what to do with the Claims Token as it is not…