sql server reporting services: SP2: Install Issue on Win2003 -- sql server reporting services

Re: Install Issue on Win2003

TomT
4/24/2005 9:54:02 PM

Brian,

Re the MSVCR71 issue, VS 2003 is not on the system. Will putting that file
in the system32 directory solve the problem? That file is in the
Microsoft.NET\Framework\v1.1.4322 directory however.

Regarding the Windows 2003 SP1 issue, on the system I installed the service
pack, I was assisted by MS Support and had to redeploy all my reports.

Here is a summary of what the support person had me do:

"Problem: After installing Windows 2003 SP1, SQL Server Reporting Services
now fails with the following error message:

Key not valid for use in specified state

Root Cause: Unknown. Looks like the Service Pack changed something to do
with the SRS Service account and this affected the ability to generate or
retrieve an encryption key.

Solution: Performed a couple of actions:

1. Deleted the following file:

C:\Documents and Settings\Network Service\Application
Data\Microsoft\Crypto\RSA\S-1-5-20\1aedd7b5699f3d6a88e354100b596aae_*

2. Deleted the application keys from the Keys table in the catalog database.
Left the 00000 key.

3. Ran RSCONFIG to re-encrypt the catalog database connection string.

4. Ran http://localhost/reportserver to re-activate SRS.

5. Deleted the data sources and reports and redeployed them."

Thanks for your help Brian.

Tom

[quoted text, click to view]

Re: Install Issue on Win2003

TomT
4/26/2005 8:53:01 PM

Brian (or anyone else),

Do you have any suggestions as to how to get the SSRS service pack
installed? Should I just copy the MSVCR71 file to the system32 directory?

Thanks

Tom

[quoted text, click to view]

Re: Install Issue on Win2003

Brian Welcker [MSFT]
4/26/2005 11:12:45 PM

Yes, just put a copy this file there. I don't know why it isn't there as we
put it there with both RTM and SP1.

--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Install Issue on Win2003

TomT
4/28/2005 4:44:01 AM

Thanks Brian - it is strange...

I'm all set - appreciate your help.

Tom

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.