FAQ Question
Who will see this problem:
This problem applies only to IGSS installations using MSDE or a full SQL Server 2000 for report data storage.
Symptoms:
Your report generation has been working correctly on your operator stations. Suddenly, you cannot establish a connection to your report data. When you analyze the error messages, you will find out that the connection to the MSDE/SQL Server cannot be established. How can I remedy this problem?
Answer
Reason:
New security updates from Microsoft have been installed. The first time we saw this problem was after installation of updates from April 10, 2007. If your MSDE/SQL Server 2000 has not been updated, it will not work together with the newest security updates and will not allow remote connections after the update.
Action:
You will need to update your MSDE/SQL Server 2000 to Service Pack 4 (SP4) or newer.
You can read about the Microsoft SQL Server 2000 Service Pack 4 at the Microsoft website:
http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en
You may need to restart the server after the update has been installed.