Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rjonnala
Starting Member
3 Posts |
 Posted - 2010-08-12 : 15:12:07
|
| I’m unable to connect to reporting services with the Local System account. I get an “Unauthorized” error. This seems to be a change in R2. I have a Windows service which connects to reporting services. This worked in SQL Server 2008 but not in R2 because the service is running under the Local System account.Is this documented anywhere? I’ve researched this item for about a week but no luck on documentation. Also is there a way to give Local System access? I know I can access it through a different user account but this is an extra step that wasn’t needed before.rj |
|
|
rjonnala
Starting Member
3 Posts |
Posted - 2010-08-23 : 11:29:36
|
| Anyone know why the Local System (NT AUTHORITY\System) account can't connect to Reporting Services? I have it permissions in Report Manager. |
 |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2010-10-03 : 07:51:07
|
| Try NETWORK SERVICE |
|
|
|
rjonnala
Starting Member
3 Posts |
Posted - 2010-10-08 : 16:44:52
|
| I was able to get Network Service to work but I had to give the Network Service user access to reports through Reports Manager. If I have to do this then I might as well create a separate user.I trying to figure out if a configuration has changed in R2 that I can set back to work the way it used or if Local System is "hard coded" to not work anymore. |
|
|
|
|
|
|
SQL Server 2008 R2 and Local System account