Archive for the ‘Break-Fix’ Category

SSRS Reports Issue after Migration: Invalid object name ‘ReportServerTempDB.dbo.TempCatalog’   4 comments

I recently migrated one of our SQL Server Database Engine and SSRS instances from SQL Server 2008 to SQL Server 2014. Post migration, when I tried to browse the SSRS reports, I get this error:

Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: 
An error occurred within the report server database.  
This may be due to a connection failure, timeout or low disk condition within the database
. ---> System.Data.SqlClient.SqlException: 
Invalid object name 'ReportServerTempDB.dbo.TempCatalog'.
Could not use view or function 'ExtendedCatalog' because of binding errors.

Read the rest of this entry »

FIX: The application-specific permission settings do not grant Local Launch permission…   1 comment

This problem occurred on a two node SQL Server 2008 clustered instance running on Windows Server 2008. Everything seemed to be fine, however, System logs was being spammed by these errors:

348106, [Error, EID:10016] Microsoft-Windows-DistributedCOM, 11-07-2012 11:07:15, The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID {46063B1E-BE4A-4014-8755-5B377CD462FC} and APPID {FAAFC69C-F4ED-4CCA-8849-7B882279EDBE} to the user domain\user SID (S-1-5-21-xxxx) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

 
Here are the steps as how I troubleshot and resolved this problem.

Read the rest of this entry »

DNS signature failed to verify for SQL Network Name   Leave a comment

This error was encountered during a regular failover testing for one of the SQL Server 2008 clustered instance. It won’t failover since SQL Network Name resource fails to come online. From Event logs:

Log Name:      System
Source:        Microsoft-Windows-FailoverClustering
Date:          10/6/2012 4:18:26 AM
Event ID:      1196
Task Category: Network Name Resource
Level:         Error
Keywords:
User:          SYSTEM
Computer:      Server_Name
Description:
Cluster network name resource 'SQL Network Name (SQLVS)' failed registration of one or more associated DNS name(s) for the following reason:
DNS signature failed to verify.

Read the rest of this entry »

SQL Server Perfmon counters missing for WoW installations   Leave a comment

Recently I encountered this issue where perfmon counters for SQL Server 2000 instances did not show up:

Read the rest of this entry »