How to configure IIS in windows7 before deployment of Report?

"The permission granted to user are insufficient for performing this operation."

  

We got this error "The permission granted to user are insufficient for performing this operation." whenever we deploy our report whether your operating system is Windows XP or Windows 7. And this is caused by our IIS (internet Information Services) that were not configure to allow anonymous access.

To configure the IIS in windows 7:

1. Go to Control Panel > Administrative Tools > Internet Information Services

2. On the left side panel, expand the default web site and configure both the Reports and ReportServer as shown on the image below:

 

3. Open the IIS Authentication

4. The following must be enable (as shown on the image below)

• Anonymous Authentication
• Forms Authentication
• Windows Authentication

 5. Right Click the Anonymous Authentication and edit the specific user. Here you must fill up the username with Administrator account and password protected

 

How to install SQL Server 2005 in Windows 7

Step by Step Installation of SQL Server 2005 in Windows 7

1. Before installing SQL Server 2005 in Windows 7, you must first install or enable your IIS (Internet Information Services). How? Click Here.

2. Your Windows 7  must be compatible to your SQL Server 2005 installer. Check your OS if its 32bit or 64bit

3. You must logged as Administrator and the account should be password protected.

Now you're ready to run that application! Just follow the step by step screenshot below:

During the installation this  pop up window will sometimes appear, just click the Run Program button.

Do this if you want to create an instance

 After installation, don't forget to update it to service pack 3. To see a step-by-step update to SP3 Click Here

To configure IIS before deployment of report Click Here

Step By Step Update of SQL Server 2005 to Service Pack 3

Follow the step-by-step screenshot below:

IIS Installation in Windows 7 (Internet Information Services)

You need to configure IIS first before installing SQL Server 2005 in Windows 7. To do so, follow the steps below:

1. Log-on with a user having administrative privileges, or invoke applications explicitly as the built-in Administrator using the command ‘runas /user:administrator cmd.exe’.


2. Install IIS 7 on Vista

--> Start

   --> Control Panel

      --> Programs

         --> Programs and Features

            --> Turn Windows features on or off

               --> Enable <Internet Information services>



3. Enable various features of IIS

--> Web management tools

   --> IIS 6 Management Compatibility

      --> IIS 6 WMI Compatibility

      --> IIS Metabase and IIS 6 configuration compatibility

--> World Wide Web Services

   --> Application Development Features

      --> ASP.NET

      --> ISAPI Extensions

      --> ISAPI Filters

   --> Common Http Features

      --> Default Document

      --> Directory Browsing

      --> HTTP Redirection

      --> Static Content

   --> Security

      --> Windows Authentication



4. Install SQL Server 2005.

LOG-IN INFO REQUIRED TO GENERATE REPORTS

Log in required in generating reports

Solution:

1.       Go to http://localhost/reports

2.       Open QSCFG and in the Connection String box, paste this script:

Data Source=localhost;Initial Catalog=qsCFG

3.       Choose Credentials stored securely in the report server then type the username and password then Apply

4.       Repeat steps 2 & 3 for QSRDS using this script: Data Source=localhost;Initial Catalog=qsDAT

Report Server is not running

Solution:

1.       If you happen to encounter this error when generating any report in Report Module, go to SQL Configuration Manager to run the services that has been stopped.

2.       If the Reporting Services cannot be able to start, try rebooting the computer.

Database Error

Database Error

There are many possibilities that cause this kind of error but check the following steps to verify which one is the right solution.

Solution:

1.       Check the connection by clicking the yellow button found at the left side of server name. Make sure to type the right password if the letter p should be in capital letter or in small letter.

2.       If the connection is working and you still got the same error, open the SQL Management Studio to check if the qsDAT database still exists. If none, right click the Databases then select New Database to create one then restore the database to be able to open the Gold Rush.

3.       If the qsDAT database exists but you still got the same error, check if all the reporting services are running under the SQL Configuration Manager.