Groups | Blog | Home
all groups > sql server reporting services > september 2005 >

sql server reporting services : RSCONFIG round 2


Lou
9/30/2005 10:07:34 AM
I am being required to change the user account on my MSRS instance.

We are going to use a domain level account and I have given it the
rights that are specified on the books online.

"The account specified is granted public and RSExecRole roles for the
reportserver database, and the RSExecRole role for the master, msdb and
ReportServerTempDB databases.

When I try to run RSCONFIG with the new login, I get a SECURITY ERROR.
When I run RSCONFIG with a -t switch, I get the following printout.

System.Security.SecurityException: Security error.at
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.ConnectToWmi()
at
Microsoft.ReportingServices.ConfigManagement.ConfigFileApp.InstanceMain()
at
Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
BaseCmdLine instance)

Any guesses on what security setting I am missing?
leo_b
10/21/2005 6:35:02 AM

The problem occured because I was running the RSCONFIG from a mapped drive.

I created a share in the folder where the RSCONFIG utility resides and then
I mapped a drive to that location. so when I ran the utility, it was running
from a location like z:\RSCONFG ....

That does not work. When I traversed the drive to the actual location of the
config and ran it from there, all worked as designed.

Moral is there are very few shortcuts that work. ;)
--
Leo Bonnes


[quoted text, click to view]
AddThis Social Bookmark Button