| Author |
Message |
Charles Gregory
Guest
|
 Posted:
Wed Dec 22, 2004 4:15 pm Post subject:
MOM Reporting Permissions |
|
|
Hi,
I've installed SQL Reporting services and MOM Reporting on a seperate server
(in the same domain) to my MOM 2005 server.
It works fine if I'm an admin. I've been into SQL Reporting Services and
granted a domain group permissions on the top level report folder. That seems
to have filtered down to the lower level folders.
If I login to a workstation as a member of that group and access the SQL
Reporting server I can navigate within the MOM Report folders - but when I
choose a report and it's going to fetch the report parameters that I can
choose from I get prompted by IE for a usernane/password. If I login as the
same user - it doesn't work. If I login as an admin here it works OK.
Any ideas on what I have missed?
Thanks
Charles |
|
| Back to top |
|
 |
KMCB
Guest
|
| Posted:
Wed Dec 22, 2004 11:15 pm Post subject:
RE: MOM Reporting Permissions |
|
|
I found this entry in the help files for SQL reporting services that may help
with the issue you are encountering. "If the report server is running under
a local account, you must specify local groups or users. If the report server
is running under a domain account, you must specify domain groups or users."
I used the Network Service account for Reports Server service and therefore
had to add domain groups to the local groups for the security to work
correctly.
"Charles Gregory" wrote:
| Quote: | Hi,
I've installed SQL Reporting services and MOM Reporting on a seperate server
(in the same domain) to my MOM 2005 server.
It works fine if I'm an admin. I've been into SQL Reporting Services and
granted a domain group permissions on the top level report folder. That seems
to have filtered down to the lower level folders.
If I login to a workstation as a member of that group and access the SQL
Reporting server I can navigate within the MOM Report folders - but when I
choose a report and it's going to fetch the report parameters that I can
choose from I get prompted by IE for a usernane/password. If I login as the
same user - it doesn't work. If I login as an admin here it works OK.
Any ideas on what I have missed?
Thanks
Charles |
|
|
| Back to top |
|
|
Arie de Haan
Guest
|
| Posted:
Thu Dec 23, 2004 4:18 am Post subject:
Re: MOM Reporting Permissions |
|
|
In article <50711F60-1219-462C-BDBC-BFDD4A0F3749@microsoft.com>,
CharlesGregory@discussions.microsoft.com says...
| Quote: | Hi,
I've installed SQL Reporting services and MOM Reporting on a seperate server
(in the same domain) to my MOM 2005 server.
It works fine if I'm an admin. I've been into SQL Reporting Services and
granted a domain group permissions on the top level report folder. That seems
to have filtered down to the lower level folders.
If I login to a workstation as a member of that group and access the SQL
Reporting server I can navigate within the MOM Report folders - but when I
choose a report and it's going to fetch the report parameters that I can
choose from I get prompted by IE for a usernane/password. If I login as the
same user - it doesn't work. If I login as an admin here it works OK.
Any ideas on what I have missed?
Thanks
Charles
I'm not toally sure if it solves your issue, but you might add the |
domain user group to the SC DW Reader local group.
If that doesn't work, maybe some ntfs permissions for the reporting web
are not 'open' enough.
HTH
--
Greetz,
Arie
This posting is provide "AS IS" with no guarantees, warranties, rigths
etc. |
|
| Back to top |
|
|
James Morey
Guest
|
| Posted:
Wed Jan 05, 2005 4:50 am Post subject:
Re: MOM Reporting Permissions |
|
|
I agree. This is probably the source of the problems. You can also get more
information from the MOM 2005 Security Guide:
You can get the Security Guide at:
Download (Word file):
http://www.microsoft.com/downloads/details.aspx?FamilyID=812b3089-18fe-42ff-bc1e-d181ccfe5dcf&displaylang=en
TechNet (HTML):
http://www.microsoft.com/mom/techinfo/productdoc/default.mspx
Also look at the main page for MOM 2005 Documentation:
http://www.microsoft.com/mom/techinfo/productdoc/default.mspx
--
=====================
NOTE - This posting is provided "AS IS" with no warranties, and confers no
rights.
James Morey | Microsoft | Windows & Enterprise Management Division
=====================
"Arie de Haan" <com.pandinus@ariedh.reversed> wrote in message
news:MPG.1c3410f22645c4939897c7@207.46.248.16...
| Quote: | In article <50711F60-1219-462C-BDBC-BFDD4A0F3749@microsoft.com>,
CharlesGregory@discussions.microsoft.com says...
Hi,
I've installed SQL Reporting services and MOM Reporting on a seperate
server
(in the same domain) to my MOM 2005 server.
It works fine if I'm an admin. I've been into SQL Reporting Services and
granted a domain group permissions on the top level report folder. That
seems
to have filtered down to the lower level folders.
If I login to a workstation as a member of that group and access the SQL
Reporting server I can navigate within the MOM Report folders - but when
I
choose a report and it's going to fetch the report parameters that I can
choose from I get prompted by IE for a usernane/password. If I login as
the
same user - it doesn't work. If I login as an admin here it works OK.
Any ideas on what I have missed?
Thanks
Charles
I'm not toally sure if it solves your issue, but you might add the
domain user group to the SC DW Reader local group.
If that doesn't work, maybe some ntfs permissions for the reporting web
are not 'open' enough.
HTH
--
Greetz,
Arie
This posting is provide "AS IS" with no guarantees, warranties, rigths
etc.
|
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in