SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Logging into SSRS with NT AUTHORITY\NETWORK SERVICE instead of Windows Authenticated User


Logging into SSRS with NT AUTHORITY\NETWORK SERVICE instead of Windows Authenticated User

Author
Message
aber
aber
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2559 Visits: 239
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?
adb2303
adb2303
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1290 Visits: 3150
my guess would be you need to recover the rsreportserver.config file too
aber
aber
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2559 Visits: 239
I was able to restore the rsreportserver.config file but this didn't help anything.
aber
aber
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2559 Visits: 239
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?w00t
aber
aber
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2559 Visits: 239
OK, I think I finally got this running again! :-D

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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search