“SSRS The permissions granted to user are insufficient for” ..

Wire to add header and footer http://mssqlcorruptiontackle.blogspot.com/2010/12/ssrs-report-adding-header-and-footer.html

When i try to deploy the ssrs report then I get following weird error:

The permissions granted to user USERNAME are insufficient for performing this operation.

ID: sReportServerDatabaseUnavailable
Source: Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings

Solution: Verify under which account your ssrs service is running? Go to reporting services configuration manager and configure the user properly.

Then you might get following error:

“The specified TargetServerURL is not valid. Specify a valid URL for a report server in the deployment settings.”

Solution: Correct the report configuration as follows:

and then

INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.

  1. SQL Server DBA “Interview Questions And Answers”
  2. SQL Azure Interview Questions and Answers Part – 1
  3. SQL Azure Interview Questions and Answers Part – 2
  4. Powershell Interview Questions and Answers

Along with technical learning I would like to share some great articles for anyone interested in the betterment of his/her family life


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s