Still problems with Windows 2003 sp1

NH

unread,

Apr 11, 2005, 5:10:01 AM4/11/05

to

Hi,

I am just reposting an issue here, hopefully by reporting it it might catch
someones eye. Help on this would really be appreciated. I have tried the
suggested fix from this post...
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=d2f44745-4eb8-420d-b44a-da1b388069d7&sloc=en-us

But this hasnt fixed the error and our users are really looking for some
reports now.

Error:
Just installed Windows 2003 server SP 1. Everything works fine except for
Report Server which fails with this error from the web browser.

The request failed with HTTP status 401: Unauthorized

When I try to log into the http://oasis020/Reports/Pages/Folder.aspx site it
asks me for a login which it never did before.I also got this error...

Server Error in '/ReportServer' Application.
Access to the path "DE" is denied

Anonymous access it still set on in IIS.

Any ideas?

NH

unread,

Apr 11, 2005, 10:18:03 AM4/11/05

to

I had to uninstall the service pack, no resolution to the probelm. Shame.

TomT

unread,

Apr 12, 2005, 8:06:02 PM4/12/05

to

I had the same problem, and contacted MS Support. Here is the solution
provided:

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: Unknow. 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.

I also had to re-deploy the reports, as they were no longer working.

Hopes this helps.....

ECS

unread,

Apr 12, 2005, 9:43:34 PM4/12/05

to

>> > The request failed with HTTP status 401: Unauthorized

This is what you do to get rid of this error after sp1 is installed:

add a DWORD entry called DisableLoopbackCheck to
HKLM\System\CurrentControlSet\Control\Lsa. Setting this key to a value of 1
fixed our issue.

http://flarepath.blogspot.com/2005/04/2003-service-pack-1-and-sql-server.html

TomT

unread,

Apr 12, 2005, 11:20:01 PM4/12/05

to

Unfortunately, I tried that first without any result, and my error message
was different

DTG

unread,

Apr 14, 2005, 6:51:02 PM4/14/05

to

I've just been troubleshooting this issue too and used the registry entry as
described - solved the issue thankfully. D

Rob G

unread,

Jun 21, 2005, 6:30:03 PM6/21/05

to

THIS WORKED FOR ME TOO!

<b>Are you using 2003 server w/SP1? If so, the following solution may
solve your problem. (I had same problem and this solved)
"create a DWORD entry called DisableLoopbackCheck to
HKLM\System\CurrentControlSet\Control\Lsa. Set this key to a value of 1"

This is an issue which occures after appling SP1 to 2003 server.

I hope, this helps.

Rob Gerwing
</b>