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 |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2010-01-10 : 03:32:27
|
| I installed RS2005, I connected to it using windows authentication (user is already on the windows administrator group) on Management Studio. When I expand Security/Roles/, and right click on Roles, the New Role option is grayed out. Anyone has faced this kind of issues before?FYI when I use firefox to access http://localhost/reportserverI get the following error:The permissions granted to user 'baby-PC\baby' are insufficient for performing this operation. (rsAccessDenied) I also try pinging localhost/reportserver. But I get ping can't find host error.Win7SQL Server 2005 SP3 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2010-01-10 : 10:08:23
|
| Probably installation might have gone wrong. Try reinstalling or check in IIS Manager for Reports and Report Manager Tab. Does it open? |
 |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-01-10 : 16:34:54
|
| Thanks for the help. But reinstalling will be my last alternative.I'm on the IIS Manager. But I can't see any Report Manager Tab. I see only Reports and ReportServer on my left hand panel, and if I expand these two Web Site they have folders in them. |
|
|
|
slimt_slimt
Aged Yak Warrior
746 Posts |
Posted - 2010-01-10 : 17:03:40
|
| your error is the result of the fact that user "baby" in "Baby-PC" domain does not have access granted to this site, to your RSRM has website driven engine for setting the roles for your report manager. as an administrator you ought to have access to main site. your username should be in administrative group.if you have access - from what i see in your last answer you have access granted. now you should add users (via AD) for accessing to your RerportServer. |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-01-11 : 01:06:39
|
| User Baby is already in the group Administrators, SQLServer2005ReportServerUser$BABY-PC$MSSQLSERVER, SQLServer2005ReportingServicesWebServiceUser$BABY-PC$MSSQLSERVER, SQLServer2005SQLBrowserUser$BABY-PC.But I still get this error msg on firefox. |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-01-12 : 21:47:35
|
| bump |
|
|
|
|
|
|
reporting service create roles