Showing posts with label disabled. Show all posts
Showing posts with label disabled. Show all posts

Sunday, March 25, 2012

Does SQL Express suport SQL Agant?

hi

As you may know by default instalation SQL Agant node in

object browser in Management Studio is not shown or is disabled.

For me It is not shown.So I enabled OLE Automation in

Surface Area configuration.Even by doing this I can't find the SQL Agant service in

Control Panel\Administrative Tools\Services

so I want to know should I do any thing else or does SQL Express suport SQL Agant service at all?

thanks

SQL Server Agent is not included with SQL Express.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Sunday, February 26, 2012

Does anonymous access have to be disabled in IIS?

I want anonymous users to be able to see my reports. But it says here it
has to be disabled.
http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsAccessDenied&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
I'm getting an rsAccessDenied if I give it anon access.Ok, I got a solution, but is this ok?
I got anonymous access to work on the report server. I hope there's no
security issues with it. Reporting services won't allow anonymous access,
so I set in IIS ReportServices Properties->Directory Security-> anonymous
access->edit-> anonymous access->edit
And Used my username Domain/CLee and my password. Also Integrated Windows
Security needs to be checked too.
Then, anyone can access the report server.
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:e3PvN3vfEHA.644@.tk2msftngp13.phx.gbl...
> I want anonymous users to be able to see my reports. But it says here it
> has to be disabled.
>
http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsAccessDenied&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> I'm getting an rsAccessDenied if I give it anon access.
>|||If you wanted to set up a totally open site, running as your domain account,
then you have succeeded.
A better way of allowing anonymous access is to
1. give the IUSR_computername the required permissions (for ex. browser, or
content manager) in the report server - use Home | Properties | Security and
Site Settings | Security
2. enable anonymous access, and leave the account as IUSR_machine... or some
equally unpermissioned account.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:Osp9VLwfEHA.636@.TK2MSFTNGP12.phx.gbl...
> Ok, I got a solution, but is this ok?
>
> I got anonymous access to work on the report server. I hope there's no
> security issues with it. Reporting services won't allow anonymous access,
> so I set in IIS ReportServices Properties->Directory Security-> anonymous
> access->edit-> anonymous access->edit
> And Used my username Domain/CLee and my password. Also Integrated Windows
> Security needs to be checked too.
> Then, anyone can access the report server.
>
>
> "Cindy Lee" <cindylee@.hotmail.com> wrote in message
> news:e3PvN3vfEHA.644@.tk2msftngp13.phx.gbl...
> > I want anonymous users to be able to see my reports. But it says here
it
> > has to be disabled.
> >
>
http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsAccessDenied&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >
> > I'm getting an rsAccessDenied if I give it anon access.
> >
> >
>