SQL Server 2005/2008 Windows Authentication – Not Associated with a Trusted SQL Server Connection Error

So you have setup SQL Server either version and from a separate box you are trying to access it using Windows Authentication as you rightly should. Doing so causes the proverbial “Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection” error, but you can happily login with basic SQL Server…

1

Enabling Impersonation in PerformancePoint Dashboard Viewer

One of there toughest challenges when setting up a PerformancePoint server environment is getting the impersonation aspect to work and work correctly. If anyone has attemped this they would realize that making the appropriate changes in SharePoint as well as in IIS does not guarantee you impersonation at all. In fact in most cases these two…

1

SSRS Subscription TGGAU Rights: AuthzInitializeContextFromSid Exceptions

When you configure SSRS using a domain account and allow users to setup subscriptions sometimes SSRS failed on running these SQL Agent jobs by saying “Failure writing file Test SSRS : The report server has encountered a configuration error. See the report server log files for more information.” in the subscription console itself. However when…

1

Getting the Wrong IIS Base Address in WCF for sites with one or more identities

By default WCF gets attempts to get the base address from the hosting server’s hostname, however in cases where the public hostname is totally different than the internal host name this can be a challenge. Fortunately one can address this by way of a host header setting, which forces IIS to use a that specific…

0

How to: Invoke a C# Assembly in SSRS

While SSRS has a lot of capabilities there are certain limitations that require the brute force of the CLR. This a walkthrough on how to create, reference and call a method in a C# assembly through SSRS in IDE mode or in Report Server mode.  1.       First you need to create the C# assembly and make sure…

0

Activating & Changing Product Key on Windows Server Core 2008 After Installation

Using the voluming licensing iso or media to install Windows Server 2008 does not provide you the opportunity to specify your approapriate product code for activation purposes. THis results in failed activations since it’s using the default product key.  Fortunately you can specify a different product key after installation or after a failed activation by…

1