Showing posts with label virtual. Show all posts
Showing posts with label virtual. Show all posts

Wednesday, March 7, 2012

Anonymous access...

I want my report be accessible for everybody. So i enable anonymous access
(IUSR_MACHINE) on the virtual site ReportServer.
On my report, i allow IUSR_MACHINE the Browser Role.
Administrators have all Role on my report.
When i want to acces to the admin page (http://localhost/Reports), I have a
window authentification (like I want), I put my Admin login and pass but I
have not the Administrators rigth. I can only see what the IUSR_MACHINE as
right.
When I disable anonymous acces on ReportServer, I can see everything.
Can you help me 'Karine,
The Report Server itself does not authenticate the user. Instead, it obtains
the user identity from IIS. When Anonymous is enabled, all requests to the
Report Server will come in under the IUSR_<computer name> account or
whatever account you use for Anonymous access. Therefore, the Report Server
cannot differentiate the users.
Since you will need to manage the Report Server you will need to elevate
IUSR permissions in RS or assign it to a Windows group which has management
rights. Both approaches are equally bad from security standpoint and a sure
invitation for a security hack. Besides, Anonymous access is not officially
supported.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Karine" <Karine@.discussions.microsoft.com> wrote in message
news:49C55288-1B45-44BB-870D-CBDF84420D72@.microsoft.com...
> I want my report be accessible for everybody. So i enable anonymous access
> (IUSR_MACHINE) on the virtual site ReportServer.
> On my report, i allow IUSR_MACHINE the Browser Role.
> Administrators have all Role on my report.
> When i want to acces to the admin page (http://localhost/Reports), I have
a
> window authentification (like I want), I put my Admin login and pass but I
> have not the Administrators rigth. I can only see what the IUSR_MACHINE as
> right.
> When I disable anonymous acces on ReportServer, I can see everything.
> Can you help me '
>
>
>

Thursday, February 16, 2012

Analysis Services will not start after failover

On Thursday, everything was fine. On Friday my second virtual instance
of SQL Server was now on Node 2 for some reason. I tried to move it
back to Node 1 and it failed and continued to go back to Node 2. I
looked for errors in the SQL Error log and the system error logs and no
information why the system failed in the first place.
Now I was able to get the second instance of SQL Server back over to
Node 1 but the Analysis Services and the MSOlap resources along with
one additional resource will not come back on either Node.
When Analysis Services was first installed on the cluster (yes I know
it isn't cluster aware), I failed over the node and Analysis Services
worked fine.
Anyone have any ideas? Luckily this is the test system, but until I
get this figured out, I won't even think about production.
If you have absolutely no errors, then you'll have to open a support case
with PSS. I couldn't even begin to guess what might be wrong without an
error message to point to something
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Benny" <wildfire77@.peoplepc.com> wrote in message
news:1144166302.904251.252350@.u72g2000cwu.googlegr oups.com...
> On Thursday, everything was fine. On Friday my second virtual instance
> of SQL Server was now on Node 2 for some reason. I tried to move it
> back to Node 1 and it failed and continued to go back to Node 2. I
> looked for errors in the SQL Error log and the system error logs and no
> information why the system failed in the first place.
> Now I was able to get the second instance of SQL Server back over to
> Node 1 but the Analysis Services and the MSOlap resources along with
> one additional resource will not come back on either Node.
> When Analysis Services was first installed on the cluster (yes I know
> it isn't cluster aware), I failed over the node and Analysis Services
> worked fine.
> Anyone have any ideas? Luckily this is the test system, but until I
> get this figured out, I won't even think about production.
>