Reporting Services Snapshots Access Denied

Hi guys,
I've set up a scheduled execution snapshots on a report; however, the
snapshot could only be viewed once. After the snapshot file being created on
rstempfiles directory, it cannot be acessed anymore. The error was 'Access to
path "C:\Program Files\Microsoft SQL Server\RSTempFiles\RSFile_da9ed300-e4a9-
4f7f-8ee7-48edf9ebedcd" is dnied.'
I've checked the security on the RSTempFiles directory and the snapshot file,
they both have users ASP.NET and SYSTEM with all permissions except the Full
Control permission.
Any help is appreciated.
Paul
--
Message posted via http://www.sqlmonster.comI think the login that the Reporting Services Services uses must also be
granted permissions on that directory..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul L via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:54476CB0823F7@.SQLMonster.com...
> Hi guys,
> I've set up a scheduled execution snapshots on a report; however, the
> snapshot could only be viewed once. After the snapshot file being created
> on
> rstempfiles directory, it cannot be acessed anymore. The error was 'Access
> to
> path "C:\Program Files\Microsoft SQL
> Server\RSTempFiles\RSFile_da9ed300-e4a9-
> 4f7f-8ee7-48edf9ebedcd" is dnied.'
> I've checked the security on the RSTempFiles directory and the snapshot
> file,
> they both have users ASP.NET and SYSTEM with all permissions except the
> Full
> Control permission.
> Any help is appreciated.
> Paul
>
> --
> Message posted via http://www.sqlmonster.comsql

Reporting Services portal

Hello all,

I'm considering using reporting services as a reporting tool for my end users.
My users will access the report through the web from my company's homepage.

As I see, the Report Manager is not an option to use as a report portal since it lacks the look and feel of my website and also it approaches the more administrative side.

Does anyone have a suggestion of what will be an appropriate way to do it?

Thanks,

Liran

There are two SSRS Sharepoint Web Parts that you can drop into your portal to display and/or list the reports in SSRS. Try playing with these.|||You could look at using reportviewer|||Could you direct me to the SSRS Sharepoint Web Parts?|||

Found and installed it. works fine, but in the documentation I found that:
"Included with Report Explorer is a subscription function that allows you to receive reports by e-mail"

but I was unable to find that function.

Thanks, Liran

sql

Reporting Services on the Web

Hi there

We use Reporting Services within our organisation to display real time reports on our business, we access this by typing the URL to our server,

We want to make Report manager visable over the web, how can this be done?

thanks

Tim

http://ServerName/Reports

this will open report manager in IE. If you want to open this from remote location then you have to add remote machine identity in /Home folder permisssion list on ReportServer with Content Management role.

Reporting Services not working

Hi,
I'm tearing my hair out with this problem, hopefully someone can help me.
When I try to access the Report Manager (http://server/reports/), I get this error:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
When I try to access the report server (http://server/reportserver/), I get this error message:
The permissions granted to user 'SERVER\LowPriviligeAccount' are insufficient for performing this operation. (rsAccessDenied) And finally, when I try to deploy a report from inside Visual Studio, I get this error message:

A connection could not be made to the report server http://server/ReportServer.
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The request failed with HTTP status 404: Object Not Found. (Microsoft.ReportingServices.Designer)
Hopefully you can help me!
Thanks in advance!

You need to use the rsconfig command line tool to specify a connection to the Report Server database. If you use a non-service account, it needs to have rights to log on interactively.

Reporting Services Installation Issues

The Issue is -- I have Reporting Services installed in a seperate Machine
other than our Web Server. I am trying to access the reports from the web
application on the web server using the Report Viewer, Whenever it hits the
URL on the Reporting Service to retrieve the Report, I get a
Challenge/Reponse to enter userid and Password, How can i configure to avoid
reentering the userid/password again and again.
Please respond if you know the solution ...I'd start by comparing the IIS settings on your SRS web server to those on
your other web server. The allow anonymous authentication setting is a
common culprit.
"Prankster" wrote:
> The Issue is -- I have Reporting Services installed in a seperate Machine
> other than our Web Server. I am trying to access the reports from the web
> application on the web server using the Report Viewer, Whenever it hits the
> URL on the Reporting Service to retrieve the Report, I get a
> Challenge/Reponse to enter userid and Password, How can i configure to avoid
> reentering the userid/password again and again.
> Please respond if you know the solution ...|||I have tried all the IIS Settings on the SRS web server, The anonymous
authentication setting is Off since SRS uses Integrated login(Windows
Administrator)
Still i have the same issue
Thanks
"mthomason" wrote:
> I'd start by comparing the IIS settings on your SRS web server to those on
> your other web server. The allow anonymous authentication setting is a
> common culprit.
> "Prankster" wrote:
> > The Issue is -- I have Reporting Services installed in a seperate Machine
> > other than our Web Server. I am trying to access the reports from the web
> > application on the web server using the Report Viewer, Whenever it hits the
> > URL on the Reporting Service to retrieve the Report, I get a
> > Challenge/Reponse to enter userid and Password, How can i configure to avoid
> > reentering the userid/password again and again.
> >
> > Please respond if you know the solution ...|||Hi man,
First: Security over the reports:
Make sure your user accounts have permissions on the reports that are going
to be accessed.
Second: Authentication Method:
Make sure you are using only Windows Integrated Method on your Reports
Virtual Directory.
Third: Include URL as part of your Intranet Site.
In Internet Explorer, configure your Reports URLs as part of your Intranet
Site, in order to be recognized as a part of your Intranet. This should avoid
that you enter the userid and password again.
Regards.
"Prankster" wrote:
> I have tried all the IIS Settings on the SRS web server, The anonymous
> authentication setting is Off since SRS uses Integrated login(Windows
> Administrator)
> Still i have the same issue
> Thanks
> "mthomason" wrote:
> > I'd start by comparing the IIS settings on your SRS web server to those on
> > your other web server. The allow anonymous authentication setting is a
> > common culprit.
> >
> > "Prankster" wrote:
> >
> > > The Issue is -- I have Reporting Services installed in a seperate Machine
> > > other than our Web Server. I am trying to access the reports from the web
> > > application on the web server using the Report Viewer, Whenever it hits the
> > > URL on the Reporting Service to retrieve the Report, I get a
> > > Challenge/Reponse to enter userid and Password, How can i configure to avoid
> > > reentering the userid/password again and again.
> > >
> > > Please respond if you know the solution ...

Reporting Services in Sql Server 2005 - how to access?

Hello,
I have worked with Reporting services (only a few times - still a beginner)
for sql server 2000, and I access it through Visual Studio 2003. My place
upgraded VS to VS2005, and I don't see an icon for reporting services.
Still using Sql Server 2000 though. But our MSDN subscriptoin finally gave
us Sql Server 2005 Enterprise(not installed yet).
So my question is if Reporting services comes with Sql Server 2005
Enterprise? If so, how to access?
While I am at it, is there a way to access Reporting Services for sql Server
2000 from VS2005 or am I limited to VS2003 for that?
Thanks,
RichRS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS 2005
is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
2005 install media. If you have VS 2005 installed it will integrate with it.
If you do not have VS 2005 installed then it installs a version of VS 2005
just for the report designer (so if you don't not have VS 2005 you do not
have to buy it).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
> Hello,
> I have worked with Reporting services (only a few times - still a
> beginner)
> for sql server 2000, and I access it through Visual Studio 2003. My place
> upgraded VS to VS2005, and I don't see an icon for reporting services.
> Still using Sql Server 2000 though. But our MSDN subscriptoin finally
> gave
> us Sql Server 2005 Enterprise(not installed yet).
> So my question is if Reporting services comes with Sql Server 2005
> Enterprise? If so, how to access?
> While I am at it, is there a way to access Reporting Services for sql
> Server
> 2000 from VS2005 or am I limited to VS2003 for that?
> Thanks,
> Rich|||Thanks for your reply. I think we have the delux MSDN subscription. Gives
us everything. So yes, we have VS2005 installed. After a big ToDo (next
month) we will install Sql Server 2005. So, I am understanding then, that RS
2005 will install as part of the sql Server 2005 (enterprise) install? Well,
I guess I will find out. I hope RS2005 isn't quite as finicky as RS2003
(sometimes I can't preview reports from within the designer with RS2003 - get
weird error messages).
Rich
"Bruce L-C [MVP]" wrote:
> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS 2005
> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
> hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
> 2005 install media. If you have VS 2005 installed it will integrate with it.
> If you do not have VS 2005 installed then it installs a version of VS 2005
> just for the report designer (so if you don't not have VS 2005 you do not
> have to buy it).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
> > Hello,
> >
> > I have worked with Reporting services (only a few times - still a
> > beginner)
> > for sql server 2000, and I access it through Visual Studio 2003. My place
> > upgraded VS to VS2005, and I don't see an icon for reporting services.
> > Still using Sql Server 2000 though. But our MSDN subscriptoin finally
> > gave
> > us Sql Server 2005 Enterprise(not installed yet).
> >
> > So my question is if Reporting services comes with Sql Server 2005
> > Enterprise? If so, how to access?
> >
> > While I am at it, is there a way to access Reporting Services for sql
> > Server
> > 2000 from VS2005 or am I limited to VS2003 for that?
> >
> > Thanks,
> > Rich
>
>|||You have to select to install RS on the server (just like you have to select
the other services like integration services, analysis services,etc). The
designer is a client install.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:5C71BA15-6565-467F-87E2-F839F731920C@.microsoft.com...
> Thanks for your reply. I think we have the delux MSDN subscription.
> Gives
> us everything. So yes, we have VS2005 installed. After a big ToDo (next
> month) we will install Sql Server 2005. So, I am understanding then, that
> RS
> 2005 will install as part of the sql Server 2005 (enterprise) install?
> Well,
> I guess I will find out. I hope RS2005 isn't quite as finicky as RS2003
> (sometimes I can't preview reports from within the designer with RS2003 -
> get
> weird error messages).
> Rich
> "Bruce L-C [MVP]" wrote:
>> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS
>> 2005
>> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
>> hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
>> 2005 install media. If you have VS 2005 installed it will integrate with
>> it.
>> If you do not have VS 2005 installed then it installs a version of VS
>> 2005
>> just for the report designer (so if you don't not have VS 2005 you do not
>> have to buy it).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
>> > Hello,
>> >
>> > I have worked with Reporting services (only a few times - still a
>> > beginner)
>> > for sql server 2000, and I access it through Visual Studio 2003. My
>> > place
>> > upgraded VS to VS2005, and I don't see an icon for reporting services.
>> > Still using Sql Server 2000 though. But our MSDN subscriptoin finally
>> > gave
>> > us Sql Server 2005 Enterprise(not installed yet).
>> >
>> > So my question is if Reporting services comes with Sql Server 2005
>> > Enterprise? If so, how to access?
>> >
>> > While I am at it, is there a way to access Reporting Services for sql
>> > Server
>> > 2000 from VS2005 or am I limited to VS2003 for that?
>> >
>> > Thanks,
>> > Rich
>>|||Thank you for that tip. I am glad that I asked. So after I install RS on
the server, then I guess I run setup on the workstation and select client
tools or something?
"Bruce L-C [MVP]" wrote:
> You have to select to install RS on the server (just like you have to select
> the other services like integration services, analysis services,etc). The
> designer is a client install.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:5C71BA15-6565-467F-87E2-F839F731920C@.microsoft.com...
> > Thanks for your reply. I think we have the delux MSDN subscription.
> > Gives
> > us everything. So yes, we have VS2005 installed. After a big ToDo (next
> > month) we will install Sql Server 2005. So, I am understanding then, that
> > RS
> > 2005 will install as part of the sql Server 2005 (enterprise) install?
> > Well,
> > I guess I will find out. I hope RS2005 isn't quite as finicky as RS2003
> > (sometimes I can't preview reports from within the designer with RS2003 -
> > get
> > weird error messages).
> >
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS
> >> 2005
> >> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot be
> >> hosted in VS 2005. The RS 2005 report designer is part of the SQL Server
> >> 2005 install media. If you have VS 2005 installed it will integrate with
> >> it.
> >> If you do not have VS 2005 installed then it installs a version of VS
> >> 2005
> >> just for the report designer (so if you don't not have VS 2005 you do not
> >> have to buy it).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
> >> > Hello,
> >> >
> >> > I have worked with Reporting services (only a few times - still a
> >> > beginner)
> >> > for sql server 2000, and I access it through Visual Studio 2003. My
> >> > place
> >> > upgraded VS to VS2005, and I don't see an icon for reporting services.
> >> > Still using Sql Server 2000 though. But our MSDN subscriptoin finally
> >> > gave
> >> > us Sql Server 2005 Enterprise(not installed yet).
> >> >
> >> > So my question is if Reporting services comes with Sql Server 2005
> >> > Enterprise? If so, how to access?
> >> >
> >> > While I am at it, is there a way to access Reporting Services for sql
> >> > Server
> >> > 2000 from VS2005 or am I limited to VS2003 for that?
> >> >
> >> > Thanks,
> >> > Rich
> >>
> >>
> >>
>
>|||Yep.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:736D9C89-D8D0-46DE-A67C-750002DF8251@.microsoft.com...
> Thank you for that tip. I am glad that I asked. So after I install RS on
> the server, then I guess I run setup on the workstation and select client
> tools or something?
> "Bruce L-C [MVP]" wrote:
>> You have to select to install RS on the server (just like you have to
>> select
>> the other services like integration services, analysis services,etc). The
>> designer is a client install.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:5C71BA15-6565-467F-87E2-F839F731920C@.microsoft.com...
>> > Thanks for your reply. I think we have the delux MSDN subscription.
>> > Gives
>> > us everything. So yes, we have VS2005 installed. After a big ToDo
>> > (next
>> > month) we will install Sql Server 2005. So, I am understanding then,
>> > that
>> > RS
>> > 2005 will install as part of the sql Server 2005 (enterprise) install?
>> > Well,
>> > I guess I will find out. I hope RS2005 isn't quite as finicky as
>> > RS2003
>> > (sometimes I can't preview reports from within the designer with
>> > RS2003 -
>> > get
>> > weird error messages).
>> >
>> > Rich
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> RS 2000 is a framework 1.1 product (VS 2003 is also framework 1.1). RS
>> >> 2005
>> >> is a framework 2.0 app (as VS 2005 is). RS 2000 report designer cannot
>> >> be
>> >> hosted in VS 2005. The RS 2005 report designer is part of the SQL
>> >> Server
>> >> 2005 install media. If you have VS 2005 installed it will integrate
>> >> with
>> >> it.
>> >> If you do not have VS 2005 installed then it installs a version of VS
>> >> 2005
>> >> just for the report designer (so if you don't not have VS 2005 you do
>> >> not
>> >> have to buy it).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:C3541818-7B91-45D3-BCA8-A7AE292A7A6A@.microsoft.com...
>> >> > Hello,
>> >> >
>> >> > I have worked with Reporting services (only a few times - still a
>> >> > beginner)
>> >> > for sql server 2000, and I access it through Visual Studio 2003. My
>> >> > place
>> >> > upgraded VS to VS2005, and I don't see an icon for reporting
>> >> > services.
>> >> > Still using Sql Server 2000 though. But our MSDN subscriptoin
>> >> > finally
>> >> > gave
>> >> > us Sql Server 2005 Enterprise(not installed yet).
>> >> >
>> >> > So my question is if Reporting services comes with Sql Server 2005
>> >> > Enterprise? If so, how to access?
>> >> >
>> >> > While I am at it, is there a way to access Reporting Services for
>> >> > sql
>> >> > Server
>> >> > 2000 from VS2005 or am I limited to VS2003 for that?
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >>
>> >>
>> >>
>>

Reporting Services fresh install Access Problem

Hi -
I installed SQL Server 2005 with RS2005 on a Windows 2003 server. I used
LocalSystem account as owner of services. I logged in as a local Admin of the
box where all services are on teh same box.
My SS2005 is a side-by-side name instance on same box where I have SS200
database.
I am getting the following error when I first try to access the ReportServer
with the following URL:
http://DBServer/ReportServer$SS2005
Reporting Services Error
----
--
The Report Server Web Service is unable to access secure information in the
report server. Please verify that the WebServiceAccount is specified
correctly in the report server config file. (rsAccessDeniedToSecureData) Get
Online Help
----
--
SQL Server Reporting Services
By the way when I clicked on the link for online help, the message was that
there was no data on the subject.
Not sure where I went wrong here.
Thank You
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200712/1You can open rsreportserver.config located in:
C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting
Services\ReportServer\
with notepad and change the following line:
<WebServiceAccount>NT Authority\NetworkService</WebServiceAccount>
to the account that your app services pool is using for its identity...
If that doesnt fix it it may be due to the fact that your service account
doesnt have the appropriate permissions so if you've change that or are using
a custom application pool try switching back to the default app pool.
"wiseteufel" wrote:
> Hi -
> I installed SQL Server 2005 with RS2005 on a Windows 2003 server. I used
> LocalSystem account as owner of services. I logged in as a local Admin of the
> box where all services are on teh same box.
> My SS2005 is a side-by-side name instance on same box where I have SS200
> database.
> I am getting the following error when I first try to access the ReportServer
> with the following URL:
> http://DBServer/ReportServer$SS2005
> Reporting Services Error
> ----
> --
> The Report Server Web Service is unable to access secure information in the
> report server. Please verify that the WebServiceAccount is specified
> correctly in the report server config file. (rsAccessDeniedToSecureData) Get
> Online Help
> ----
> --
> SQL Server Reporting Services
> By the way when I clicked on the link for online help, the message was that
> there was no data on the subject.
> Not sure where I went wrong here.
> Thank You
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-reporting/200712/1
>

Reporting Services Filter

I `m using Reporting Services from web. I mean that I have created some reports in report builder and put them in web. Other users can access and view this reports and everything works good. My question: Can other user apply some filter on the report if user has no any Reporting Services ?

For example:

If I created a report, wich contains 2 fields (ClientName and BirthDayDate), and I select all clients with birthdays from 1900 to 2007. But what if user wants to filter this clients and choose those, who hase birthdays from 1998 to 2001 for instance.... Is there a posibility like this in Reporting Services ?

You can configure the Report Builder parameter as prompted by right-clicking on it (on the Filter dialog) and choose Prompt.

Reporting Services Error - SQL Server does not exist or access denied

Hi, I am unable to view my reports once deploying them. The error I get in Report Manager is SQL "Server does not exist or access denied". What is weird about this is that I am able to run the reports within the preview tab (in visual studio .net 2003). When I try to use the same connection string in Report Manager I get the error. Please note that I deploy the reports from my computer onto a different server where I am trying to access them. This problem started after installing some critical windows updates onto my local computer and it is driving me crazy. If anyone could suggest a course of action it would be greatly appreciated - so far I have not been able to make sense of what the problem is.
Thanks.Problem Solved - the database was using port 2433 - so i just changed that in my connection string.

Reporting services Error

Hi guys,
when I try to access http://localhost/reportserver,
it returns following on webpage:
The report server installation is not initialized. Check the documentation
for more information. (rsReportServerNotActivated) Get Online Help
-2147159550
0x800a0bcd
What is the problem?
Here is the error log:
----
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__01_05_2006_11_01_10.log</Path>
<SystemName> W80824</SystemName>
<OSName>Microsoft Windows NT 5.1.2600.0</OSName>
<OSVersion>5.1.2600.0</OSVersion>
</Header>
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
Initializing WebServiceUseFileShareStorage to default value of 'False'
because it was not specified in Configuration file.
ReportingServicesService!resourceutilities!eb4!1/5/2006-11:01:10:: i INFO:
Running on 0 physical processors, 1 logical processors
ReportingServicesService!resourceutilities!eb4!1/5/2006-11:01:10:: i INFO:
Reporting Services starting SKU: Developer
ReportingServicesService!runningjobs!eb4!1/5/2006-11:01:10:: i INFO:
Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle:
600 seconds
ReportingServicesService!runningjobs!eb4!1/5/2006-11:01:10:: i INFO: Running
Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!eb4!1/5/2006-11:01:10:: i INFO: Running
Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!eb4!1/5/2006-11:01:10:: i INFO:
Execution Log Entry Expiration timer enabled: Next Event: 53929 seconds.
Cycle: 86400 seconds
ReportingServicesService!runningjobs!eb4!1/5/2006-11:01:10:: i INFO: Memory
stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!crypto!968!1/5/2006-11:01:10:: i INFO: Initializing
crypto as user: AD\ch03
ReportingServicesService!crypto!968!1/5/2006-11:01:10:: i INFO: Exporting
public key
ReportingServicesService!library!968!1/5/2006-11:01:10:: Exception caught
while starting service. Error: System.IO.DirectoryNotFoundException: The
system cannot find the path specified.
at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
errorCode, IntPtr errorInfo)
at RSManagedCrypto.RSCrypto.ExportPublicKey()
at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
at
Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!968!1/5/2006-11:01:10:: Attempting to start
service again...I just changed report server service to use local account instead of domain
account.
now it works..
thanks
"Kevin" wrote:
> Hi guys,
> when I try to access http://localhost/reportserver,
> it returns following on webpage:
> The report server installation is not initialized. Check the documentation
> for more information. (rsReportServerNotActivated) Get Online Help
> -2147159550
> 0x800a0bcd
>
> What is the problem?
> Here is the error log:
> ----
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.1038.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Eastern Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__01_05_2006_11_01_10.log</Path>
> <SystemName> W80824</SystemName>
> <OSName>Microsoft Windows NT 5.1.2600.0</OSName>
> <OSVersion>5.1.2600.0</OSVersion>
> </Header>
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing ConnectionType to '0' as specified in Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing IsNotificationService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in Configuration
> file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
> file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
> file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration file.
> ReportingServicesService!library!eb4!1/5/2006-11:01:10:: i INFO:
> Initializing WebServiceUseFileShareStorage to default value of 'False'
> because it was not specified in Configuration file.
> ReportingServicesService!resourceutilities!eb4!1/5/2006-11:01:10:: i INFO:
> Running on 0 physical processors, 1 logical processors
> ReportingServicesService!resourceutilities!eb4!1/5/2006-11:01:10:: i INFO:
> Reporting Services starting SKU: Developer
> ReportingServicesService!runningjobs!eb4!1/5/2006-11:01:10:: i INFO:
> Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle:
> 600 seconds
> ReportingServicesService!runningjobs!eb4!1/5/2006-11:01:10:: i INFO: Running
> Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
> ReportingServicesService!runningjobs!eb4!1/5/2006-11:01:10:: i INFO: Running
> Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
> ReportingServicesService!runningjobs!eb4!1/5/2006-11:01:10:: i INFO:
> Execution Log Entry Expiration timer enabled: Next Event: 53929 seconds.
> Cycle: 86400 seconds
> ReportingServicesService!runningjobs!eb4!1/5/2006-11:01:10:: i INFO: Memory
> stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
> ReportingServicesService!crypto!968!1/5/2006-11:01:10:: i INFO: Initializing
> crypto as user: AD\ch03
> ReportingServicesService!crypto!968!1/5/2006-11:01:10:: i INFO: Exporting
> public key
> ReportingServicesService!library!968!1/5/2006-11:01:10:: Exception caught
> while starting service. Error: System.IO.DirectoryNotFoundException: The
> system cannot find the path specified.
> at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32
> errorCode, IntPtr errorInfo)
> at RSManagedCrypto.RSCrypto.ExportPublicKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.GetEncryptionKey()
> at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
> at Microsoft.ReportingServices.Library.ConnectionManager.VerifyConnection()
> at
> Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
> ReportingServicesService!library!968!1/5/2006-11:01:10:: Attempting to start
> service again...
>
>

reporting services description property from analysis server

hi guys
I want to access description property of cubes entities and should be
able to get this description property in the tooltip description
property of the fields.
Can anyone help me with this.
Regards
Passxin other words is ther any way that i can access extended properties
for cube entities in analysis server, per say description property of
any cube entity.
Passx wrote:
> hi guys
> I want to access description property of cubes entities and should be
> able to get this description property in the tooltip description
> property of the fields.
> Can anyone help me with this.
>
> Regards
> Passx|||You should be able to retrieve the description property using Sql DMO. Then
you can pass that in as a parameter.
Rich
"Passx" wrote:
> in other words is ther any way that i can access extended properties
> for cube entities in analysis server, per say description property of
> any cube entity.
>
> Passx wrote:
> > hi guys
> >
> > I want to access description property of cubes entities and should be
> > able to get this description property in the tooltip description
> > property of the fields.
> >
> > Can anyone help me with this.
> >
> >
> > Regards
> > Passx
>|||Hi
What is Sql DMO. Can you tell me how to use that to solve my problem.
Regards
Passx
Rich wrote:
> You should be able to retrieve the description property using Sql DMO. Then
> you can pass that in as a parameter.
> Rich
> "Passx" wrote:
> > in other words is ther any way that i can access extended properties
> > for cube entities in analysis server, per say description property of
> > any cube entity.
> >
> >
> > Passx wrote:
> > > hi guys
> > >
> > > I want to access description property of cubes entities and should be
> > > able to get this description property in the tooltip description
> > > property of the fields.
> > >
> > > Can anyone help me with this.
> > >
> > >
> > > Regards
> > > Passx
> >
> >

Reporting Services Deployment Problem

I'm new to Reporting Services and whenever I try to deploy a report I've
build in .NET, I have to turn off anonymous access to the ReportServer folder
in IIS. I imagine that Reporting Services wasnt installed correctly or that
there is some way to fix this. However, I havent been able to find any help
by searching the web or other sites I usually find helpful. Does anyone know
how to fix this?I suspect I am also in the same set of issues. My configuration is SQL
Server 2005, IIS5.1 on XP-SP2 using VS.NET 2005. The tool I am using to
debug IIS is the IIS 6.0 RK. I think my problems are related to it appears
that RS wants to be on a real server with SSL and Kerberos. NT
authentication doesn't appear to be enough to get to the virtual drive?
Al
"Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> I'm new to Reporting Services and whenever I try to deploy a report I've
> build in .NET, I have to turn off anonymous access to the ReportServer
> folder
> in IIS. I imagine that Reporting Services wasnt installed correctly or
> that
> there is some way to fix this. However, I havent been able to find any
> help
> by searching the web or other sites I usually find helpful. Does anyone
> know
> how to fix this?|||You lose functionality if you have anonymous access because everyone is
treated the same. RS uses roll based security. What I do is setup local
groups. To the local groups I add the appropriate domain groups/users. The
local group is assigned to a roll with certain rights, usually just browse
rights.
Here is a good link to read up on security.
http://odetocode.com/Articles/215.aspx
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> I'm new to Reporting Services and whenever I try to deploy a report I've
> build in .NET, I have to turn off anonymous access to the ReportServer
folder
> in IIS. I imagine that Reporting Services wasnt installed correctly or
that
> there is some way to fix this. However, I havent been able to find any
help
> by searching the web or other sites I usually find helpful. Does anyone
know
> how to fix this?|||Bruce,
That may be helpful, but it looks cumbersome. I'm deploying reports across
a company Intranet. Would using role based security require me to give every
single user (there are a LARGE number) an account? What I would really like
is a way to have an 'anonymous' user group that can only browse the reports -
that way I dont spend half of my time fielding requests for access to the
reports and setting up new accounts. Any suggestions?
Derek
"Bruce L-C [MVP]" wrote:
> You lose functionality if you have anonymous access because everyone is
> treated the same. RS uses roll based security. What I do is setup local
> groups. To the local groups I add the appropriate domain groups/users. The
> local group is assigned to a roll with certain rights, usually just browse
> rights.
> Here is a good link to read up on security.
> http://odetocode.com/Articles/215.aspx
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > I'm new to Reporting Services and whenever I try to deploy a report I've
> > build in .NET, I have to turn off anonymous access to the ReportServer
> folder
> > in IIS. I imagine that Reporting Services wasnt installed correctly or
> that
> > there is some way to fix this. However, I havent been able to find any
> help
> > by searching the web or other sites I usually find helpful. Does anyone
> know
> > how to fix this?
>
>|||Most domains have a generic group that everyone in the domain belongs to.
For instance yourdomain\users, at my company it is ourdomain\domain users.
So you should be able to just add that group once.
If you have resource kit installed there is a dos command called showgrps
that will show you all the groups you are part of, this would show you the
catchall group.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> Bruce,
> That may be helpful, but it looks cumbersome. I'm deploying reports
across
> a company Intranet. Would using role based security require me to give
every
> single user (there are a LARGE number) an account? What I would really
like
> is a way to have an 'anonymous' user group that can only browse the
reports -
> that way I dont spend half of my time fielding requests for access to the
> reports and setting up new accounts. Any suggestions?
> Derek
> "Bruce L-C [MVP]" wrote:
> > You lose functionality if you have anonymous access because everyone is
> > treated the same. RS uses roll based security. What I do is setup local
> > groups. To the local groups I add the appropriate domain groups/users.
The
> > local group is assigned to a roll with certain rights, usually just
browse
> > rights.
> >
> > Here is a good link to read up on security.
> >
> > http://odetocode.com/Articles/215.aspx
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > I'm new to Reporting Services and whenever I try to deploy a report
I've
> > > build in .NET, I have to turn off anonymous access to the ReportServer
> > folder
> > > in IIS. I imagine that Reporting Services wasnt installed correctly
or
> > that
> > > there is some way to fix this. However, I havent been able to find
any
> > help
> > > by searching the web or other sites I usually find helpful. Does
anyone
> > know
> > > how to fix this?
> >
> >
> >|||Bruce,
Thanks for your help. I'm a bit over my head in this discussion - since I'm
a developer with very little to no experience in network administration /
server administration but I will look into setting up role based security.
Thanks for your help.
Derek
"Bruce L-C [MVP]" wrote:
> Most domains have a generic group that everyone in the domain belongs to.
> For instance yourdomain\users, at my company it is ourdomain\domain users.
> So you should be able to just add that group once.
> If you have resource kit installed there is a dos command called showgrps
> that will show you all the groups you are part of, this would show you the
> catchall group.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
> news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> > Bruce,
> >
> > That may be helpful, but it looks cumbersome. I'm deploying reports
> across
> > a company Intranet. Would using role based security require me to give
> every
> > single user (there are a LARGE number) an account? What I would really
> like
> > is a way to have an 'anonymous' user group that can only browse the
> reports -
> > that way I dont spend half of my time fielding requests for access to the
> > reports and setting up new accounts. Any suggestions?
> >
> > Derek
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > You lose functionality if you have anonymous access because everyone is
> > > treated the same. RS uses roll based security. What I do is setup local
> > > groups. To the local groups I add the appropriate domain groups/users.
> The
> > > local group is assigned to a roll with certain rights, usually just
> browse
> > > rights.
> > >
> > > Here is a good link to read up on security.
> > >
> > > http://odetocode.com/Articles/215.aspx
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in message
> > > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > > I'm new to Reporting Services and whenever I try to deploy a report
> I've
> > > > build in .NET, I have to turn off anonymous access to the ReportServer
> > > folder
> > > > in IIS. I imagine that Reporting Services wasnt installed correctly
> or
> > > that
> > > > there is some way to fix this. However, I havent been able to find
> any
> > > help
> > > > by searching the web or other sites I usually find helpful. Does
> anyone
> > > know
> > > > how to fix this?
> > >
> > >
> > >
>
>|||That's OK. A network admin or server admin will be able to translate my
suggestion and the link I sent you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
news:036B5699-7C2E-4F8D-BBEE-4CD1084C1EAD@.microsoft.com...
> Bruce,
> Thanks for your help. I'm a bit over my head in this discussion - since
I'm
> a developer with very little to no experience in network administration /
> server administration but I will look into setting up role based security.
> Thanks for your help.
> Derek
> "Bruce L-C [MVP]" wrote:
> > Most domains have a generic group that everyone in the domain belongs
to.
> > For instance yourdomain\users, at my company it is ourdomain\domain
users.
> > So you should be able to just add that group once.
> >
> > If you have resource kit installed there is a dos command called
showgrps
> > that will show you all the groups you are part of, this would show you
the
> > catchall group.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Derek Fisher" <DerekFisher@.discussions.microsoft.com> wrote in message
> > news:79E8F3FF-5113-4DE8-83D9-5E3371FF89A9@.microsoft.com...
> > > Bruce,
> > >
> > > That may be helpful, but it looks cumbersome. I'm deploying reports
> > across
> > > a company Intranet. Would using role based security require me to
give
> > every
> > > single user (there are a LARGE number) an account? What I would
really
> > like
> > > is a way to have an 'anonymous' user group that can only browse the
> > reports -
> > > that way I dont spend half of my time fielding requests for access to
the
> > > reports and setting up new accounts. Any suggestions?
> > >
> > > Derek
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > > > You lose functionality if you have anonymous access because everyone
is
> > > > treated the same. RS uses roll based security. What I do is setup
local
> > > > groups. To the local groups I add the appropriate domain
groups/users.
> > The
> > > > local group is assigned to a roll with certain rights, usually just
> > browse
> > > > rights.
> > > >
> > > > Here is a good link to read up on security.
> > > >
> > > > http://odetocode.com/Articles/215.aspx
> > > >
> > > >
> > > > --
> > > > Bruce Loehle-Conger
> > > > MVP SQL Server Reporting Services
> > > >
> > > > "Derek Fisher" <Derek Fisher@.discussions.microsoft.com> wrote in
message
> > > > news:93B7F131-D5F8-4AAE-9B18-5702240DE3C5@.microsoft.com...
> > > > > I'm new to Reporting Services and whenever I try to deploy a
report
> > I've
> > > > > build in .NET, I have to turn off anonymous access to the
ReportServer
> > > > folder
> > > > > in IIS. I imagine that Reporting Services wasnt installed
correctly
> > or
> > > > that
> > > > > there is some way to fix this. However, I havent been able to
find
> > any
> > > > help
> > > > > by searching the web or other sites I usually find helpful. Does
> > anyone
> > > > know
> > > > > how to fix this?
> > > >
> > > >
> > > >
> >
> >
> >