SQL Reporting Services – Applying Connection Rights Error

When changing the database in SQL Reporting Services, you can sometimes get an error in the Report Server Database Configuration Wizard around applying connection rights. This is because the account used to enable the connection to the database doesn’t have the right level of permissions in SQL Server. To fix this, connect to the SQL […]
Continue reading…

 

Custom Extensions Or Assemblies Were Detected On The Report Server – SQL 2008 R2 Upgrade Advisor

When upgrading an existing installation of MSSQL to Microsoft SQL 2008 R2, the SQL Upgrade Advisor may highlight the follow issue with Reporting Services: Custom extensions or assemblies were detected on the report server This error occurs because there has been some custom extentions or assemblies installed into the current version of SQL Reporting Services. This […]
Continue reading…

 

The ‘VSTS For Database Professionals SQL Server Data-Tier Application’ Package Did Not Load Correctly

Upgrading SQL or installing SQL management tools (and various other actions) can break Visual Studio 2010 and cause this error on start up: The ‘VSTS for Database Professionals Sql Server Data-tier Application’ package did not load correctly This is because SQL Express 2008 is part of the Visual Studio 2010 install and tampering with the […]
Continue reading…

 

The Report Server Cannot Access The Private Key For The Service Account In Reporting Services

After changing the password for the SQL Reporting Services account, I now have the following error when I visit the report manager URL: The report server cannot access the private key for the service account. This key is used to decrypt the symmetric key that protects content in the report server database. This condition might […]
Continue reading…

 

SQL 2005 Error: Property Owner Is Not Available For Database

This is a particularly annoying error, whereby the db_owner property displayed in the SQL 2005 GUI for a particular database doesn’t reflect the actual owner of the database. To fix this you need to set the owner property for the database using the following SQL query: USE <DatabaseName> GO EXEC sp_changedbowner ‘sa’ This is useful […]
Continue reading…

 

SQL Restore Failed For Server – Exclusive Access Could Not Be Obtained Because The Database Is In Use

When restoring a SQL server database, you may get the following error: Restore failed for server. Exclusive access could not be obtained because the database is in use. RESTORE DATABASE is terminating abnormally (MICROSOFT SQL Server, Error: 3101) This error occurs because the database you are trying to restore is in use. Ie: Someone is […]
Continue reading…

 

Unable To Release Guest. Error: VSSControl: Failed To Freeze Guest, Wait Timeout

I installed Veeam Backup and Replication 6 for VMware. It was backing up my virtual machines fine, but I got the following error on some SQL servers: Unable to release guest. Error: VSSControl: Failed to freeze guest, wait timeout Error: VSSControl: Failed to freeze guest, wait timeout It’s pretty easy to understand what the error […]
Continue reading…