Archive for the ‘Errors’ Category

error 5 RESTORE HEADERONLY Error when Restoring a Database

Friday, May 28th, 2010

I recieved the following error when trying to restore from a .bak file:

error 5
RESTORE HEADERONLY

The error while very frustrating was easy to work around. I simply changed my logon to ‘Local System’ and was able to restore the backup.

To take you through the process step by step I:

1) Navigate to SQL Server Confiuration Manager

2) Right click on the instance you are using

3) Click on properties

4) Select thethe Logon Tab

5) Click on built in account

6) select ‘Local System’ from the drop down

7) Apply and ok your way out of the menus.

Posted in Errors, Workarounds | No Comments »

Every other page is blank

Monday, April 19th, 2010

I am frequently asked the question “Why does a blank page get inserted every other page in an SSRS report?”

The solution is usually simple. The Body of your report could be too large for your page. Simply make sure that the Body of your report added to the left and right margin is less than the page width.

Usually it will be the margins that push you over the limit.

Posted in Errors, SSRS | No Comments »

SHOWPLAN permission denied in database

Thursday, April 15th, 2010

A colleague recieved the following error when attempting to display a query execution plan:

SHOWPLAN permission denied in database.

A quick internet search revealed that SHOWPLAN is a database level permission which allows users to view query execution plans. It is automatically assigned to the db_owner database role and to the sysadmin fixed server role. If you don’t want to assign the user to either of these roles you can just grant SHOWPLAN permissions to the role by running the following SQL:

USE {Database}
GO

GRANT SHOWPLAN TO {UserName}
GO

Tags: ,
Posted in Errors | No Comments »