Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL   (RSS)
Monday, August 10, 2009 10:02 AM

SSRS service might not start after installing Windows Security patches and rebooting the machine

Sometimes, if your server is under heavy load, or after installing Windows Security patches, like http://www.microsoft.com/technet/security/bulletin/ms09-004.mspx , you might experience issues where the SSRS service fails to start with the following information
Posted by emilianb | 0 Comments
Filed under: ,
Thursday, April 16, 2009 12:49 PM

Using DelegConfig tool for troubleshooting Kerberos Delegation issues

A couple of days ago I delivered a presentation on troubleshooting Kerberos configuration issues, especially from the SQL Server's perspective. Part of this presentation I demonstrated the use of Brian Murphy-Booth's ( http://blogs.iis.net/brian-murphy-booth
Posted by emilianb | 1 Comments
Filed under: , , ,
Monday, March 16, 2009 3:52 PM

WMI related errors while connecting to SQL Server 2005/2008 Reporting Services

Here's a quick guide describing a few checks you could make if you encounter any WMI related errors while trying to connect to your SSRS instance either with Management Studio or with the Configuration Tool. 1. The most common cause for these type of
Posted by emilianb | 0 Comments
Filed under: , ,
Thursday, October 30, 2008 8:18 AM

Could not locate entry in sysdatabases for database X

While upgrading a SQL Server 2005 Reporting Services instance to SP2 from SP1 or from RTM, you might encounter the following error and the upgrade fails, if your reporting Services database name is of the form XReportServer, where X is a string of characters:
Posted by emilianb | 1 Comments
Tuesday, August 26, 2008 1:58 PM

SQL Server Agent cannot be started after adding an "Alias Local Host Server"

We might find ourselves in the following scenario: for a SQL Server 2005 edition, you accidentaly specify a wrong "Alias Local Host Server" in Management Studio. Now, what happens is that, when the SQL Server Agent starts, it tries to connect to this
Posted by emilianb | 0 Comments
Filed under: ,
Tuesday, August 26, 2008 1:27 PM

"The specified @name (‘B3F7CB60-6636-4F67-93CF-B94C052DFD29’) already exists" while editing a subscription

Consider the following scenario: You have either SQL Server 2000 Reporting Services or SQL Server 2005 Reporting Services set up. You have SSRS configured so that the application pool used by the SSRS virtual directories (Reports and ReportServer) has
Posted by emilianb | 1 Comments
 
Page view tracker