DataGridViewComboboxcell value is not valid

You encountered this error when you're about to post a payment transaction.Notice that the deposit Account column at the left side are blank. To resolved this:

1. Go to Loan Account: Adjustment Module
2. Filter the center
3. Open the Loan Detail of Each Client
4. In the Link To Deposit Box, set the default deposit link.

Reportserver cannot decrypt error

Solution:

1.       Go to Reporting Services Configuration Manager then select Encryption Keys and click delete.

2.       Apply default settings both in Report Server Virtual Directory and Report Manager Virtual Directory.

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