Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Logging into SSRS with NT AUTHORITY\NETWORK SERVICE instead of Windows Authenticated User Expand / Collapse
Author
Message
Posted Friday, April 25, 2014 8:07 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 9:04 AM
Points: 2,075, Visits: 207
We recently had to recreate our development server, however, we were able to recover the ReportServer and ReportServerTempDB databases. We reinstalled Reporting Services and then replaced the newly created databases with the backup databases. All seemed to be working great to that point.

However, when we try to browse the Reporting Services website, there are no reports. We have been able to change the URL to get to the My Reports folder but when we create a new folder here the Modified By shows NT AUTHORITY\NETWORK SERVICE instead of the Windows Authenticated user that we are logged in as. This makes us think that we have an IIS issue but we have set up IIS exactly like our production server is.

To further complicate things, we change the URL to browse to a folder but we receive this error "The permissions granted to user <Windows Authenticated User that is logged on> are insufficient for performing this operation." This seems to contradict what happened in the My Reports folder.

Any ideas?
Post #1565105
Posted Friday, April 25, 2014 8:15 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:19 AM
Points: 811, Visits: 2,416
my guess would be you need to recover the rsreportserver.config file too
Post #1565109
Posted Monday, April 28, 2014 9:55 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 9:04 AM
Points: 2,075, Visits: 207
I was able to restore the rsreportserver.config file but this didn't help anything.
Post #1565636
Posted Wednesday, April 30, 2014 12:57 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 9:04 AM
Points: 2,075, Visits: 207
I'm still struggling with this issue. I have found a number of placing that talk about moving Reporting Services from one computer to another. However, all of these articles talk about making a backup of the encryption key from Reporting Services Configuration Manager and since our server is no longer available there is no way for me to make a backup of the encryption key. I'm not 100% sure that this is my issue.
If this is the issue, I would think that I'd need to somehow either get this key somehow or to remove the encrypted data. Any thoughts on either of these ideas? Or am I heading down the wrong path?
Post #1566560
Posted Wednesday, April 30, 2014 1:15 PM This worked for the OP Answer marked as solution


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 9:04 AM
Points: 2,075, Visits: 207
OK, I think I finally got this running again!

After my last post I went to the ReportServer DB and noticed that I had one record in the Keys table for the server that Report Server is running on. I thought that this might be the key from the old server so I deleted it. As soon as I deleted this and restarted both IIS and Reporting Services service, everything just worked!

Hopefully this may help someone else that runs into this situation down the road.
Post #1566575
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse