RSActivate

I have just installed RS (Standard Edition on Win2K. SQL instance on same
server). At the end of install, I got a dialog that said: Setup could not
initialize the report server. You must manually initialize the report
server before using using it for the first time..
I ran:
rsconfig -c -s sqlservername -d ReportServer -a SQL -u username -p
password
It returned:
The command completed successfully
I then ran:
rsactivate -c"C:\Program Files\.\RSReportServer.config" -t
It returns:
Failure starting the web service:
System.Exception: Unexpected database error (-2147159548) .
I appreciate any help on this. Thanks!Hi Todd!
Did you find a solution? I have the same problem.
http://msdn.microsoft.com/newsgroups/managed/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&tid=89f0d955-4f23-47a2-886b-dc3a6d8ec457&cat=en-us-msdnman-eprise-sql&lang=en&cr=US&sloc=en-us&m=1&p=1#top
thx, yara
"Todd" wrote:
> I have just installed RS (Standard Edition on Win2K. SQL instance on same
> server). At the end of install, I got a dialog that said: Setup could not
> initialize the report server. You must manually initialize the report
> server before using using it for the first time..
> I ran:
> rsconfig -c -s sqlservername -d ReportServer -a SQL -u username -p
> password
>
> It returned:
> The command completed successfully
>
> I then ran:
> rsactivate -c"C:\Program Files\.\RSReportServer.config" -t
>
> It returns:
> Failure starting the web service:
> System.Exception: Unexpected database error (-2147159548) .
>
> I appreciate any help on this. Thanks!
>
>

RS2005 setup blues

I installed RS2005(SP2) with a SQL2000(sp4) db. Both are on seperate Windoes 2003 servers. I configured the reports manager to connect to a different web site on the same server instead of default web site. There were no installation prohlems. The RS server is up and running , all the virtual directories setup etc. When I try to access the reports directory via: http://dev2/Reports or browse the reports virtual directory from IIS, I get a 401 access denied error. The RS log reads:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.3042.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>D:\ReportingServices2005\MSSQL.1\Reporting Services\LogFiles\ReportServerWebApp__07_10_2007_11_29_21.log</Path>
<SystemName>NWISTCST99</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 2</OSName>
<OSVersion>5.2.3790.131072</OSVersion>
</Header>
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!7/10/2007-11:29:22:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!5!7/10/2007-11:29:30:: e ERROR: The request failed with HTTP status 401: Unauthorized.
w3wp!ui!5!7/10/2007-11:29:31:: e ERROR: HTTP status code --> 500
-Details--
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!5!7/10/2007-11:29:32:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Please advise.

The RSweApplication.config in the ReportManager folder has the fully qualified URL to ReportServer<ReportServerUrl> and I have blanked out the <ReportServerVirtualDirectory>

Also the <UrlRoot> in rsreportserver.config in ReportServer folder points to the fully qualified URL to ReportServer.

What am I missing here ..?

Hello,

Can you hit http://<server>/ReportServer? This is the underlying worker site for the Web Application found at http://<server>/Reports.

Here is a blog post on troubleshooting 401 errors with IIS: http://blogs.msdn.com/david.wang/archive/2005/07/14/HOWTO_Diagnose_IIS_401_Access_Denied.aspx

You could be having a Kerberos issue because SQL and IIS are on different servers. Here is an blog post from Brian Kelley on troubleshooting Kerberos: http://blogs.sqlservercentral.com/blogs/brian_kelley/archive/2006/04/05/568.aspx.

Let me know if this doesn't help.

Larry

|||

When I try http://<web site>/ReportServer, I can get to it. It comes up with a version number:

10.32.12.204/ReportServer - /

Microsoft SQL Server Reporting Services Version 9.00.3042.00

I had the virtual directories set up for Integtated windows authentication only.

When I enable anonymous access, I do not get the 401 error but there is no way I can create folders, subscriptions set up users etc. There are only 3 links: Home (to the reports directory). My subscriptions that is empty (There are no items to show in this view) and a help link.

Something is missing here ...

|||

Setting the sites to use anonymous and having it work means that it is an IIS permissions issue, thus, a SSRS configuration issue. Your installation worked. Try changing the configuration file to use the IP address or the Fully Qualified Domain Name for the Report Server location. Take a look at the 401 troubleshooting article and see if it can help you track down the problem.

The reason that you can't do anything as anonymous is that the anonymous user does not have any rights in SSRS by default. For testing purposes, you could change the accound used for anonymous access (IUSR_<machine name>) to an account with Admin rights and you would be able to manage SSRS. By default, all Admins are given full rights to an SSRS installation.

Larry

|||

thanks a lot Larry,

change the config files from name to hard coded IP address resolved the issue. I had already re-installed RS and IIS and was running out of options.

|||

No problem! Glad to hear that it worked out!

Larry

RS2005 service using Report Services 2000 databases

Hi folks.
Is it possible setup RS 2005 keeping reporting services databases in sql
2000 or RS2005 works only with sql 2005?
[]s
RobsonNo problem at all. 100% supported. I did this as an upgrade (just pick RS
2005 and don't upgrade SQL Server). I assume from scratch that you would
just pick RS 2005 when installing..
Note that you do need a SQL Server 2005 license.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Robson Luiz" <robsonbr_2004@.yahoo.com.br> wrote in message
news:uU0LqTm%23FHA.3708@.TK2MSFTNGP10.phx.gbl...
> Hi folks.
> Is it possible setup RS 2005 keeping reporting services databases in sql
> 2000 or RS2005 works only with sql 2005?
> []s
> Robson
>sql

RS2005 Report Paper / Page / Scaling - Setup

Hi,
I've a report with more than 20 columns in it. I want to print this
report in "1 page wide/Multi page tall" scaling & also in "Legal paper
- Landscape orientation". I was able to set the Landscape in the Page
setup, but not the scaling/Paper selection! Is there any way to do this
setting for each report in RS? Right now, the columns are getting
printed in multiple pages.
Actually I've this report in Excel as well. As you know, in excel I can
set the "Print Area and all the Page setup" through a macro which is
running properly. Now, I cannot ask the users to generate the report in
RS and export the report to Excel, then set the "Print Area & Page
setup" & then Print it, which I don't think they'll buy it. I also dont
want to have a separate front-end in .Net or something else to do this
setup!
Is there any way to do this in RS 2005?
Thanks,
GaneshThe only way I have managed to do this is programmatically. I get the
report as a Metafile image using the webservice and can then print this
image scaled to the paper afterwards.
Craig
"Ganesh" <imsganesh2@.gmail.com> wrote in message
news:1142364252.533688.323570@.i39g2000cwa.googlegroups.com...
> Hi,
> I've a report with more than 20 columns in it. I want to print this
> report in "1 page wide/Multi page tall" scaling & also in "Legal paper
> - Landscape orientation". I was able to set the Landscape in the Page
> setup, but not the scaling/Paper selection! Is there any way to do this
> setting for each report in RS? Right now, the columns are getting
> printed in multiple pages.
> Actually I've this report in Excel as well. As you know, in excel I can
> set the "Print Area and all the Page setup" through a macro which is
> running properly. Now, I cannot ask the users to generate the report in
> RS and export the report to Excel, then set the "Print Area & Page
> setup" & then Print it, which I don't think they'll buy it. I also dont
> want to have a separate front-end in .Net or something else to do this
> setup!
> Is there any way to do this in RS 2005?
> Thanks,
> Ganesh
>|||Thanks Craig!
Can't we do this any other reporting tool? How about in Crystal
Reports. I remember doing this when I was on Crystal Reports a year
back. Is there no other way to do this? I can't sell RS to my users
(who are very comfortable with Excel 2000) without this option.
or Can you tell me how you did this programmatically to get report as a
Metafile and print it?
Thank you!|||Hi All,
Can anyone please tell me whether this is not possible at all in
RS2005, so that I don't have to waste much time in searching for this
all over the net?
Thanks!

RS2005 Drop-down list

This there a way to increase the time it takes when users select items from
the drop-down list.
Please note that the drop-down list is setup to extract data items from
backend database (from query). (also, using multi-value selections)When I run the report in Visual Studio, it quick and runs as expected.
However, when the report is deployed and ran, its seems to be slow.
Thanks!
"Terry" wrote:
> This there a way to increase the time it takes when users select items from
> the drop-down list.
> Please note that the drop-down list is setup to extract data items from
> backend database (from query). (also, using multi-value selections)
>|||Hi everybody,
i'm just started using the Reporting services...
I want to display all the staff name in a dropdown list or combo box.
and based on the staff name the report is displayed...
can any one help me..
Thankx in advance
ren
From http://www.developmentnow.com/g/115_2005_10_0_0_626054/RS2005-Drop-down-list.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com|||Many ways you can do this.
1. Write your own custom code so that depending on the user you can display
reports.
2. If you are storing all your staff name in a table you can query the table
for the dropdown and once it is selected, the name is passed to a stored
procedure and the stored procedure runs the query depending on the staff.
e.g. some staff should not see somethings etc...
Let me know where you store your staff names..
Amarnath, MCTS.
"Renuka" wrote:
> Hi everybody,
> i'm just started using the Reporting services...
> I want to display all the staff name in a dropdown list or combo box.
> and based on the staff name the report is displayed...
> can any one help me..
> Thankx in advance
> renu
> From http://www.developmentnow.com/g/115_2005_10_0_0_626054/RS2005-Drop-down-list.htm
> Posted via DevelopmentNow.com Groups
> http://www.developmentnow.com
>

RS2005 + Sharepoint 2007; installation doesn't works...

Hi,
I try to setup a server to test the integration of RS with sharepoint 2007.
The SP2 is installed on the server and the Sharepoint addin installed too.
I have created a RS instance and setup this instance to support sharepoint.
but in the application management pages of sharepoint I don't see the
reporting services section like describe in the installation document.
so the installation doesn't works and I don't see any error anywhere.
my server is an x64 version (windows, sql and sharepoint are in x64)
what can I do to diagnose what's appends?
thanks.
Jerome.Here you mean email subscription or file shared.
For file shared subcsription, you can give the authentication when you
create the subscription ,the option is available in the same page.
For email, go to Report Configuration from menu and give the server name
for authentication, you need to change the report server config file. "Search
for "SMTP" and you can give your authentication etc...
Amarnath, MCTS.
"Jeje" wrote:
> Hi,
> I try to setup a server to test the integration of RS with sharepoint 2007.
> The SP2 is installed on the server and the Sharepoint addin installed too.
> I have created a RS instance and setup this instance to support sharepoint.
> but in the application management pages of sharepoint I don't see the
> reporting services section like describe in the installation document.
> so the installation doesn't works and I don't see any error anywhere.
> my server is an x64 version (windows, sql and sharepoint are in x64)
> what can I do to diagnose what's appends?
> thanks.
> Jerome.
>
>|||Sorry wrongly posted.
Amarnath, MCTS
"Amarnath" wrote:
> Here you mean email subscription or file shared.
> For file shared subcsription, you can give the authentication when you
> create the subscription ,the option is available in the same page.
> For email, go to Report Configuration from menu and give the server name
> for authentication, you need to change the report server config file. "Search
> for "SMTP" and you can give your authentication etc...
> Amarnath, MCTS.
> "Jeje" wrote:
> > Hi,
> >
> > I try to setup a server to test the integration of RS with sharepoint 2007.
> >
> > The SP2 is installed on the server and the Sharepoint addin installed too.
> > I have created a RS instance and setup this instance to support sharepoint.
> >
> > but in the application management pages of sharepoint I don't see the
> > reporting services section like describe in the installation document.
> >
> > so the installation doesn't works and I don't see any error anywhere.
> >
> > my server is an x64 version (windows, sql and sharepoint are in x64)
> >
> > what can I do to diagnose what's appends?
> >
> > thanks.
> >
> > Jerome.
> >
> >
> >|||Jeje
I am having the same problem.
I hope someone posts a solution.
Regards,
Ben
"Jeje" <willgart@.hotmail.com> wrote in message
news:%23JHwTBQbHHA.3616@.TK2MSFTNGP05.phx.gbl...
> Hi,
> I try to setup a server to test the integration of RS with sharepoint
> 2007.
> The SP2 is installed on the server and the Sharepoint addin installed too.
> I have created a RS instance and setup this instance to support
> sharepoint.
> but in the application management pages of sharepoint I don't see the
> reporting services section like describe in the installation document.
> so the installation doesn't works and I don't see any error anywhere.
> my server is an x64 version (windows, sql and sharepoint are in x64)
> what can I do to diagnose what's appends?
> thanks.
> Jerome.
>sql

RS_BooksOnline error 2711

I'm doing the command line install with
setup.exe /settings.
In my ini file, I have the following enry (watch for line
wrap):
ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
_BooksOnline_EN,RS_Samples,RS_AdventureWorks
The setup fails, and in the setup log file, I have this
error:
DEBUG: Error 2711: The specified Feature name
('RS_BooksOnline_EN') not found in Feature Table.
The installer has encountered an unexpected error
installing this package. This may indicate a problem with
this package. The error code is 2711. The arguments are:
RS_BooksOnline_EN, ,
MSI (s) (18:A0): Product: Microsoft SQL Server 2000
Reporting Services Developer Edition -- The installer has
encountered an unexpected error installing this package.
This may indicate a problem with this package. The error
code is 2711. The arguments are
: RS_BooksOnline_EN, ,
Question: if RS_BooksONline_EN is not the right entry,
what should be?
JoeTry RS_BooksOnline_1033. It looks like the sample template.ini is
incorrect.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> I'm doing the command line install with
> setup.exe /settings.
> In my ini file, I have the following enry (watch for line
> wrap):
> ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> The setup fails, and in the setup log file, I have this
> error:
> DEBUG: Error 2711: The specified Feature name
> ('RS_BooksOnline_EN') not found in Feature Table.
> The installer has encountered an unexpected error
> installing this package. This may indicate a problem with
> this package. The error code is 2711. The arguments are:
> RS_BooksOnline_EN, ,
> MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> Reporting Services Developer Edition -- The installer has
> encountered an unexpected error installing this package.
> This may indicate a problem with this package. The error
> code is 2711. The arguments are
> : RS_BooksOnline_EN, ,
> Question: if RS_BooksONline_EN is not the right entry,
> what should be?
> Joe
>|||Where is the mapping between these numbers and the language names
documented? I guess 1033 refers to English, right?
Linchi
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:e7yokNMdEHA.212@.TK2MSFTNGP12.phx.gbl...
> Try RS_BooksOnline_1033. It looks like the sample template.ini is
> incorrect.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> > I'm doing the command line install with
> > setup.exe /settings.
> > In my ini file, I have the following enry (watch for line
> > wrap):
> >
> > ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> > _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> >
> > The setup fails, and in the setup log file, I have this
> > error:
> >
> > DEBUG: Error 2711: The specified Feature name
> > ('RS_BooksOnline_EN') not found in Feature Table.
> > The installer has encountered an unexpected error
> > installing this package. This may indicate a problem with
> > this package. The error code is 2711. The arguments are:
> > RS_BooksOnline_EN, ,
> > MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> > Reporting Services Developer Edition -- The installer has
> > encountered an unexpected error installing this package.
> > This may indicate a problem with this package. The error
> > code is 2711. The arguments are
> > : RS_BooksOnline_EN, ,
> >
> > Question: if RS_BooksONline_EN is not the right entry,
> > what should be?
> >
> > Joe
> >
>|||Here are the supported languages
Chinese Simplified = 2052
Chinese Traditional = 1028
English = 1033
French = 1036
German = 1031
Italian = 1040
Japanese = 1041
Korean = 1042
Spanish = 3082
Hope that helps.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:uf56xGOdEHA.1644@.tk2msftngp13.phx.gbl...
> Where is the mapping between these numbers and the language names
> documented? I guess 1033 refers to English, right?
> Linchi
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:e7yokNMdEHA.212@.TK2MSFTNGP12.phx.gbl...
> > Try RS_BooksOnline_1033. It looks like the sample template.ini is
> > incorrect.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> > news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> > > I'm doing the command line install with
> > > setup.exe /settings.
> > > In my ini file, I have the following enry (watch for line
> > > wrap):
> > >
> > > ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> > > _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> > >
> > > The setup fails, and in the setup log file, I have this
> > > error:
> > >
> > > DEBUG: Error 2711: The specified Feature name
> > > ('RS_BooksOnline_EN') not found in Feature Table.
> > > The installer has encountered an unexpected error
> > > installing this package. This may indicate a problem with
> > > this package. The error code is 2711. The arguments are:
> > > RS_BooksOnline_EN, ,
> > > MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> > > Reporting Services Developer Edition -- The installer has
> > > encountered an unexpected error installing this package.
> > > This may indicate a problem with this package. The error
> > > code is 2711. The arguments are
> > > : RS_BooksOnline_EN, ,
> > >
> > > Question: if RS_BooksONline_EN is not the right entry,
> > > what should be?
> > >
> > > Joe
> > >
> >
> >
>|||The mapping between culture identifiers and culture names is also documented
in MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemglobalizationcultureinfoclasstopic.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:%23GAOwwOdEHA.3016@.tk2msftngp13.phx.gbl...
> Here are the supported languages
> Chinese Simplified = 2052
> Chinese Traditional = 1028
> English = 1033
> French = 1036
> German = 1031
> Italian = 1040
> Japanese = 1041
> Korean = 1042
> Spanish = 3082
> Hope that helps.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:uf56xGOdEHA.1644@.tk2msftngp13.phx.gbl...
> > Where is the mapping between these numbers and the language names
> > documented? I guess 1033 refers to English, right?
> >
> > Linchi
> >
> > "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> > news:e7yokNMdEHA.212@.TK2MSFTNGP12.phx.gbl...
> > > Try RS_BooksOnline_1033. It looks like the sample template.ini is
> > > incorrect.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > >
> > > "Joe Bourne" <anonymous@.discussions.microsoft.com> wrote in message
> > > news:5d4101c474c2$1ccf94a0$a301280a@.phx.gbl...
> > > > I'm doing the command line install with
> > > > setup.exe /settings.
> > > > In my ini file, I have the following enry (watch for line
> > > > wrap):
> > > >
> > > > ADDLOCAL=RS_Server,RS_Manager,RS_Designer,RS_Admin_Tools,RS
> > > > _BooksOnline_EN,RS_Samples,RS_AdventureWorks
> > > >
> > > > The setup fails, and in the setup log file, I have this
> > > > error:
> > > >
> > > > DEBUG: Error 2711: The specified Feature name
> > > > ('RS_BooksOnline_EN') not found in Feature Table.
> > > > The installer has encountered an unexpected error
> > > > installing this package. This may indicate a problem with
> > > > this package. The error code is 2711. The arguments are:
> > > > RS_BooksOnline_EN, ,
> > > > MSI (s) (18:A0): Product: Microsoft SQL Server 2000
> > > > Reporting Services Developer Edition -- The installer has
> > > > encountered an unexpected error installing this package.
> > > > This may indicate a problem with this package. The error
> > > > code is 2711. The arguments are
> > > > : RS_BooksOnline_EN, ,
> > > >
> > > > Question: if RS_BooksONline_EN is not the right entry,
> > > > what should be?
> > > >
> > > > Joe
> > > >
> > >
> > >
> >
> >
>

RS: does not work without Visual Studio?

Hello,
i've installed Reporting Services on "Windows 2000 Server" and "SQL Server
2000 SP3a".
During the setup a window popped up with the "System Check Results" showing
a warning that "Visual Studio .net 2003" is not installed.
I've continued the setup process without any other warnings.
Then I've tried to find RS.. it is not in the program menu, there is only
"Reporting Services Books online - english".
There is also nothing in the menuebar of "Enterprise Manager".
Is it really necessary to install Visual Studio on a server'
I hope somebody can help me.
Greetings
Hendrik
--
Message posted via http://www.sqlmonster.comHendrik,
You should be able to access the reports server on your server machine at
the following address:
http://<servername>/reports
This should take you to the Reports Manager. You only need VS2003 installed
on a machine that you are going to use to design and develop the reports on.
Regards,
DF
"Hendrik Schulz via SQLMonster.com" wrote:
> Hello,
> i've installed Reporting Services on "Windows 2000 Server" and "SQL Server
> 2000 SP3a".
> During the setup a window popped up with the "System Check Results" showing
> a warning that "Visual Studio .net 2003" is not installed.
> I've continued the setup process without any other warnings.
> Then I've tried to find RS.. it is not in the program menu, there is only
> "Reporting Services Books online - english".
> There is also nothing in the menuebar of "Enterprise Manager".
> Is it really necessary to install Visual Studio on a server'
> I hope somebody can help me.
> Greetings
> Hendrik
> --
> Message posted via http://www.sqlmonster.com
>|||One other point to help explain why you are not seeing anything. Reporting
Services is an asp.net application. That is why you do not see anything in
the different places you looked. Just like any other website/asp.net
application. Only IIS knows about it.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dan Fell" <DanFell@.discussions.microsoft.com> wrote in message
news:6B5CBEDA-D6E4-4E0A-A79F-B41B00D310EF@.microsoft.com...
> Hendrik,
> You should be able to access the reports server on your server machine at
> the following address:
> http://<servername>/reports
> This should take you to the Reports Manager. You only need VS2003
installed
> on a machine that you are going to use to design and develop the reports
on.
> Regards,
> DF
> "Hendrik Schulz via SQLMonster.com" wrote:
> > Hello,
> >
> > i've installed Reporting Services on "Windows 2000 Server" and "SQL
Server
> > 2000 SP3a".
> > During the setup a window popped up with the "System Check Results"
showing
> > a warning that "Visual Studio .net 2003" is not installed.
> > I've continued the setup process without any other warnings.
> > Then I've tried to find RS.. it is not in the program menu, there is
only
> > "Reporting Services Books online - english".
> > There is also nothing in the menuebar of "Enterprise Manager".
> >
> > Is it really necessary to install Visual Studio on a server'
> >
> > I hope somebody can help me.
> >
> > Greetings
> > Hendrik
> >
> > --
> > Message posted via http://www.sqlmonster.com
> >|||Thank you all very much, now it works und looks really good!
--
Message posted via http://www.sqlmonster.com

RS/AS 2005 Reports on Cube datasource, drilldown not working

I have an AS 2005 cube created.
I am able to generate reports in RS 2005 by setting the report datasource to
point to my cube.
I have tried to setup a report to drillthrough to another report ( also
based on the same cube datasource ) via the TextBox Navigation/Jump To Report
setting.
I am able to select the report to which I need to jump. The parameters for
that report appear in the navigation setup dialog, and I am able to set the
parameter values e.g. =Fields!Product_Type.Value.
However, whenever I run the report ( in BIDS preview, via Report Manager, or
in a Report View web control ) and click the navigation text box, I always
get the message "The 'PRODUCTProductType' parameter is missing a value "
When trying to do this via a Report Viewer web control, I can look at the
parameters in the report being drilled into by examining the
DrillThroughEventArgs in my DrillThroughEventHandler of my Report Viewer web
control.
ServerReport serverReport = (ServerReport)e.Report;
ReportParameterInfoCollection parms = serverReport.GetParameters();
There are 3 parameters as expected, but for each of them, parms[i].state = "MissingValidValue"
I see that this exact same setup works when the datasource for the report is
relational, and I hope that I'm just missing something simple to make it work
when the data source is a cube.
Any help is greatly appreciated!If you are using the Analysis Services provider (the one that comes
with a UI for you to drag and drop), any query parameters are bound to
another dataset by default. The parameter value passed/received need
to be a member of the "available" list.
I got similar message ""The 'PRODUCTProductType' parameter is missing a
value " when the value is not found in the available list of values.
So, you may want to check this first?
Looking at the parameter name, its value should be of the format of
[PRODUCT].[Product Type].&[<a key>]. So, you need to also ensure the
value is passed in this format.|||One more thing:
RS has the behaviour of changing the query parameter to be
"multi-valued" enabled. So you need to make sure the parameters
defined at both main and sub reports are of the same type, either both
multi-valued or both single-valued.
Multi-valued requires a different format e.g.
=Fields!Product_Type.Value(0)|||Thanks for your help, I'm getting closer with this now.
For now, I've removed the product type parameter, because it's a calculated
field, adn I'm trying to use a parameter called FACDESC that is a straight
database column value.
When I literaly past in the value
[PRODUCT].[FACDESC].&[IMACS General Hospital]
the parameter is passed to the drill through report perfectly.
However, I'd like it to use the current value of the report fields in the
cell I'm drilling through. I've tried these:
[PRODUCT].[FACDESC].&[Fields!FACDESC.Value]
[PRODUCT].[FACDESC].&[Fields!FACDESC.Value(0)]
and it goes back to the missing parameter problem.
If I pass in as the drillthrough parameter
=[PRODUCT].[FACDESC].&[Fields!FACDESC.Value]
but then I get the build error:
[rsCompilerErrorInExpression] The Value expression for the textbox
â'DischargeQuarterâ' contains an error: [BC30451] Name 'PRODUCT' is not
declared.
"Rose" wrote:
> If you are using the Analysis Services provider (the one that comes
> with a UI for you to drag and drop), any query parameters are bound to
> another dataset by default. The parameter value passed/received need
> to be a member of the "available" list.
> I got similar message ""The 'PRODUCTProductType' parameter is missing a
> value " when the value is not found in the available list of values.
> So, you may want to check this first?
> Looking at the parameter name, its value should be of the format of
> [PRODUCT].[Product Type].&[<a key>]. So, you need to also ensure the
> value is passed in this format.
>|||Finally got this to work.
To set up a report in RS2005 that is based on an AS2005 Cube data source, so
that it will drill through to another report, also based on an AS2005 Cube
data source, passing parameter values to the subreport:
Pass the report parameters like this:
= "[PRODUCT].[FACDESC].&[" + Fields!FACDESC.Value + "]"
Thanks to Rose for pointing me in the right direction.
"Rose" wrote:
> If you are using the Analysis Services provider (the one that comes
> with a UI for you to drag and drop), any query parameters are bound to
> another dataset by default. The parameter value passed/received need
> to be a member of the "available" list.
> I got similar message ""The 'PRODUCTProductType' parameter is missing a
> value " when the value is not found in the available list of values.
> So, you may want to check this first?
> Looking at the parameter name, its value should be of the format of
> [PRODUCT].[Product Type].&[<a key>]. So, you need to also ensure the
> value is passed in this format.
>|||=Fields!Product_Type.UniqueName
should also work, exept when its part of a hierchy in the master-report and
not in the sub-report
"DTK" wrote:
> Finally got this to work.
> To set up a report in RS2005 that is based on an AS2005 Cube data source, so
> that it will drill through to another report, also based on an AS2005 Cube
> data source, passing parameter values to the subreport:
> Pass the report parameters like this:
> = "[PRODUCT].[FACDESC].&[" + Fields!FACDESC.Value + "]"
> Thanks to Rose for pointing me in the right direction.
>
> "Rose" wrote:
> > If you are using the Analysis Services provider (the one that comes
> > with a UI for you to drag and drop), any query parameters are bound to
> > another dataset by default. The parameter value passed/received need
> > to be a member of the "available" list.
> >
> > I got similar message ""The 'PRODUCTProductType' parameter is missing a
> > value " when the value is not found in the available list of values.
> > So, you may want to check this first?
> >
> > Looking at the parameter name, its value should be of the format of
> > [PRODUCT].[Product Type].&[<a key>]. So, you need to also ensure the
> > value is passed in this format.
> >
> >

Rs setup problem with version La versión encontrada es 'C.0.8.54'. La versión esperada es 'C.

Hello I got this error when installing rs 2005.

The thing is that sqlserver database is on another server, that server must have sp2 I think but the rs machine doesnt have sp2, that may be the problem?

La versión de la base de datos del servidor de informes no tiene un formato válido o no se puede leer. La versión encontrada es 'C.0.8.54'. La versión esperada es 'C.0.8.40'. Para continuar, actualice la versión de la base de datos del servidor de informes y compruebe los derechos de acceso. (rsInvalidReportServerDatabase) Obtener ayuda en pantalla

Obtener ayuda en pantalla

Inicio

I have the same problem, nobodby help you to solve it?
"La versión de la base de datos del servidor de informes no tiene un formato válido o no se puede leer. La versión encontrada es 'Unknown'. La versión esperada es 'C.0.8.40'. Para continuar, actualice la versión de la base de datos del servidor de informes y compruebe los derechos de acceso. (rsInvalidReportServerDatabase) Obtener ayuda en pantalla "
if you solved it, would you mind to help me ? thanks...

RS Setup Help??

I've posted a couple of times with problems after setup. Is there somewhere
else I should look for assistance in setting up RS when I can't get either
the Report Server or Report Manager working? Thanks.Hi, on wich system you try install RS and wich User-Account do you youse?
Are you shure you have enought rights for installing RS?
What kind of problem do you have?
"Don Miller" <nospam@.nospam.com> schrieb im Newsbeitrag
news:elNrhVxqEHA.536@.TK2MSFTNGP11.phx.gbl...
> I've posted a couple of times with problems after setup. Is there
somewhere
> else I should look for assistance in setting up RS when I can't get either
> the Report Server or Report Manager working? Thanks.
>|||Thank you for your offer of help. Here goes.
I have a Win2K SP4 system with SQLServer2000K SP3a, VS.NET 2003, .NET
Framework Version:1.1.4322.2032 on a Dell laptop. All this was installed
under an administrator signon (the same one I try to access RS via browser).
After routine, using all the default settings, installation of RS
everything goes smoothly until the last screen that says:
"Setup could not initialize the report server. You must manually initialize
the report server before using it for the first time. For more information,
see the Reporting Services setup documentation."
This happened after every uninstall/reinstall. I then activated the service
with:
rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config"
When I check Services->Reporting Services it is "Started"
In SQLServer there is a ReportServices DB and a ReportServiceTempDB (along
with AdventureWorks). I can open VS and open the sample reports.
When I try to access the Report Manager http://<servername>/reports, I do
get a web page that says Home with only three links (Home, My Subscriptions,
Help), and no toolbars, or tabs, no navigation or new folder icons, or
anything else that I see in RS books..
When I click My Subscriptions I get an error:
"Unable to find script library
'/aspnet_client/system_web/1_1_4322/WebUIValidation.js'. Try placing this
file manually, or reinstall by running 'aspnet_regiis -c'."
When I run aspnet_regiis, I get the following error,
"Start copying the ASP.NET client side script files for this version
(1.1.4322.0)
.
An error has occurred (0x80070003)."
When I try to test whether Report Server is working with
http://<servername>/ReportServer I get this error:
"Server Error in '/ReportServer' Application.
----
--
The resource cannot be found.
Description: HTTP 404. The resource you are looking for (or one of its
dependencies) could have been removed, had its name changed, or is
temporarily unavailable. Please review the following URL and make sure that
it is spelled correctly.
Requested Url: /ReportServer/Reserved.ReportServer
----
--
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032"
So, I've spent days on this, uninstalled/reinstalled every application three
times and cannot find documentation that deals with any of the above
problems. Any help or direction would be appreciated (this must all make
some sense to somebody ;)
"Moskito" <moskito@.wecomtec.no-ip.com> wrote in message
news:%23x7HXrxqEHA.376@.TK2MSFTNGP14.phx.gbl...
> Hi, on wich system you try install RS and wich User-Account do you youse?
> Are you shure you have enought rights for installing RS?
> What kind of problem do you have?
> "Don Miller" <nospam@.nospam.com> schrieb im Newsbeitrag
> news:elNrhVxqEHA.536@.TK2MSFTNGP11.phx.gbl...
> > I've posted a couple of times with problems after setup. Is there
> somewhere
> > else I should look for assistance in setting up RS when I can't get
either
> > the Report Server or Report Manager working? Thanks.
> >
> >
>|||Did you try this
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSinstall/htm/gs_installingrs_v1_0ijm.asp ?
"Don Miller" <nospam@.nospam.com> schrieb im Newsbeitrag
news:uO2A0z5qEHA.1296@.TK2MSFTNGP12.phx.gbl...
> Thank you for your offer of help. Here goes.
> I have a Win2K SP4 system with SQLServer2000K SP3a, VS.NET 2003, .NET
> Framework Version:1.1.4322.2032 on a Dell laptop. All this was installed
> under an administrator signon (the same one I try to access RS via
browser).
> After routine, using all the default settings, installation of RS
> everything goes smoothly until the last screen that says:
> "Setup could not initialize the report server. You must manually
initialize
> the report server before using it for the first time. For more
information,
> see the Reporting Services setup documentation."
> This happened after every uninstall/reinstall. I then activated the
service
> with:
> rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> When I check Services->Reporting Services it is "Started"
> In SQLServer there is a ReportServices DB and a ReportServiceTempDB (along
> with AdventureWorks). I can open VS and open the sample reports.
> When I try to access the Report Manager http://<servername>/reports, I do
> get a web page that says Home with only three links (Home, My
Subscriptions,
> Help), and no toolbars, or tabs, no navigation or new folder icons, or
> anything else that I see in RS books..
> When I click My Subscriptions I get an error:
> "Unable to find script library
> '/aspnet_client/system_web/1_1_4322/WebUIValidation.js'. Try placing this
> file manually, or reinstall by running 'aspnet_regiis -c'."
>
> When I run aspnet_regiis, I get the following error,
> "Start copying the ASP.NET client side script files for this version
> (1.1.4322.0)
> .
> An error has occurred (0x80070003)."
>
> When I try to test whether Report Server is working with
> http://<servername>/ReportServer I get this error:
> "Server Error in '/ReportServer' Application.
> ----
--
> --
> The resource cannot be found.
> Description: HTTP 404. The resource you are looking for (or one of its
> dependencies) could have been removed, had its name changed, or is
> temporarily unavailable. Please review the following URL and make sure
that
> it is spelled correctly.
> Requested Url: /ReportServer/Reserved.ReportServer
> ----
--
> --
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
ASP.NET
> Version:1.1.4322.2032"
> So, I've spent days on this, uninstalled/reinstalled every application
three
> times and cannot find documentation that deals with any of the above
> problems. Any help or direction would be appreciated (this must all make
> some sense to somebody ;)
>
>
> "Moskito" <moskito@.wecomtec.no-ip.com> wrote in message
> news:%23x7HXrxqEHA.376@.TK2MSFTNGP14.phx.gbl...
> > Hi, on wich system you try install RS and wich User-Account do you
youse?
> > Are you shure you have enought rights for installing RS?
> > What kind of problem do you have?
> >
> > "Don Miller" <nospam@.nospam.com> schrieb im Newsbeitrag
> > news:elNrhVxqEHA.536@.TK2MSFTNGP11.phx.gbl...
> > > I've posted a couple of times with problems after setup. Is there
> > somewhere
> > > else I should look for assistance in setting up RS when I can't get
> either
> > > the Report Server or Report Manager working? Thanks.
> > >
> > >
> >
> >
>|||Got it working and the clue was the inability to find a script library. I
had renamed the folder 'wwwroot' to 'OLDwwwroot' for security reasons and
when NET framework is installed it looks specifically for wwwroot to copy
such libraries (that ASP.NET apps look for)
"Don Miller" <nospam@.nospam.com> wrote in message
news:uO2A0z5qEHA.1296@.TK2MSFTNGP12.phx.gbl...
> Thank you for your offer of help. Here goes.
> I have a Win2K SP4 system with SQLServer2000K SP3a, VS.NET 2003, .NET
> Framework Version:1.1.4322.2032 on a Dell laptop. All this was installed
> under an administrator signon (the same one I try to access RS via
browser).
> After routine, using all the default settings, installation of RS
> everything goes smoothly until the last screen that says:
> "Setup could not initialize the report server. You must manually
initialize
> the report server before using it for the first time. For more
information,
> see the Reporting Services setup documentation."
> This happened after every uninstall/reinstall. I then activated the
service
> with:
> rsactivate -c "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config"
> When I check Services->Reporting Services it is "Started"
> In SQLServer there is a ReportServices DB and a ReportServiceTempDB (along
> with AdventureWorks). I can open VS and open the sample reports.
> When I try to access the Report Manager http://<servername>/reports, I do
> get a web page that says Home with only three links (Home, My
Subscriptions,
> Help), and no toolbars, or tabs, no navigation or new folder icons, or
> anything else that I see in RS books..
> When I click My Subscriptions I get an error:
> "Unable to find script library
> '/aspnet_client/system_web/1_1_4322/WebUIValidation.js'. Try placing this
> file manually, or reinstall by running 'aspnet_regiis -c'."
>
> When I run aspnet_regiis, I get the following error,
> "Start copying the ASP.NET client side script files for this version
> (1.1.4322.0)
> .
> An error has occurred (0x80070003)."
>
> When I try to test whether Report Server is working with
> http://<servername>/ReportServer I get this error:
> "Server Error in '/ReportServer' Application.
> ----
--
> --
> The resource cannot be found.
> Description: HTTP 404. The resource you are looking for (or one of its
> dependencies) could have been removed, had its name changed, or is
> temporarily unavailable. Please review the following URL and make sure
that
> it is spelled correctly.
> Requested Url: /ReportServer/Reserved.ReportServer
> ----
--
> --
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
ASP.NET
> Version:1.1.4322.2032"
> So, I've spent days on this, uninstalled/reinstalled every application
three
> times and cannot find documentation that deals with any of the above
> problems. Any help or direction would be appreciated (this must all make
> some sense to somebody ;)
>
>
> "Moskito" <moskito@.wecomtec.no-ip.com> wrote in message
> news:%23x7HXrxqEHA.376@.TK2MSFTNGP14.phx.gbl...
> > Hi, on wich system you try install RS and wich User-Account do you
youse?
> > Are you shure you have enought rights for installing RS?
> > What kind of problem do you have?
> >
> > "Don Miller" <nospam@.nospam.com> schrieb im Newsbeitrag
> > news:elNrhVxqEHA.536@.TK2MSFTNGP11.phx.gbl...
> > > I've posted a couple of times with problems after setup. Is there
> > somewhere
> > > else I should look for assistance in setting up RS when I can't get
> either
> > > the Report Server or Report Manager working? Thanks.
> > >
> > >
> >
> >
>|||I had the same problem described above...and the odd thing is that at one time Reporting Services was working on this system. The problem was I had deleted a folder that was the root folder for the 'default web app' in IIS 6.0.
Solution
I pointed the default web app file path back to a valid path (c:\inetpub\wwwroot in this case) and restarted both IIS and the Report Server windows service
From http://www.developmentnow.com/g/115_2004_10_0_0_451559/RS-Setup-Help.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

RS Setup

We have a two node clustered setup with couple of instances on each node. I
am trying to setup a reporting services on one of the nodes. For testing, we
did IIS install on the same machine. Used configuration tool and setup
reporting database on one of the sql instances. The install didn't report
any errors.
but now the problems is,
1. I created a report using VS business Intelligence tool and tried to
deploy it to report server -- but its failing. I get an error message .. A
connection could not be made to the report server
http://servername/ReportServer. ; Additional Information: The request failed
with HTTP status 503: Service Unavailable (
Microsoft.ReportingServices.Designer). There are virtual directories
'Reportserver' and 'Reports' under the IIS main folder.
2. Even when I try to do http://servername/Reports, I get an error -- The
request failed HTTP status 400: Bad request. I can see the page redirected
before dispalying this message to http://servername/reports/pages/folder.aspx
Any help is appreciated. We have a strong Group policy settings in place at
work on all these servers. All the services are running under the same
domain account except for ASP.NET service.
Thanks
BVR.You may need to use the actual IP address as the servername may not be
resolved with the two-node setup.
To be sure I would "ping" the servername and use the reply IP address in the
TargetServerURL instead of the servername...
See if that works!
-=Steve
"BVR" wrote:
> We have a two node clustered setup with couple of instances on each node. I
> am trying to setup a reporting services on one of the nodes. For testing, we
> did IIS install on the same machine. Used configuration tool and setup
> reporting database on one of the sql instances. The install didn't report
> any errors.
> but now the problems is,
> 1. I created a report using VS business Intelligence tool and tried to
> deploy it to report server -- but its failing. I get an error message .. A
> connection could not be made to the report server
> http://servername/ReportServer. ; Additional Information: The request failed
> with HTTP status 503: Service Unavailable (
> Microsoft.ReportingServices.Designer). There are virtual directories
> 'Reportserver' and 'Reports' under the IIS main folder.
> 2. Even when I try to do http://servername/Reports, I get an error -- The
> request failed HTTP status 400: Bad request. I can see the page redirected
> before dispalying this message to http://servername/reports/pages/folder.aspx
> Any help is appreciated. We have a strong Group policy settings in place at
> work on all these servers. All the services are running under the same
> domain account except for ASP.NET service.
> Thanks
> BVR.
>|||Steve,
I have the same problem. I have checked the scty setting on the Sites in the
IIS section of CompMgt and all seems OK, but when I right click the Site and
selct Browse, I still get Service Unavailable '
--
JK
"Steve Mann" wrote:
> You may need to use the actual IP address as the servername may not be
> resolved with the two-node setup.
> To be sure I would "ping" the servername and use the reply IP address in the
> TargetServerURL instead of the servername...
> See if that works!
> -=Steve
> "BVR" wrote:
> > We have a two node clustered setup with couple of instances on each node. I
> > am trying to setup a reporting services on one of the nodes. For testing, we
> > did IIS install on the same machine. Used configuration tool and setup
> > reporting database on one of the sql instances. The install didn't report
> > any errors.
> >
> > but now the problems is,
> > 1. I created a report using VS business Intelligence tool and tried to
> > deploy it to report server -- but its failing. I get an error message .. A
> > connection could not be made to the report server
> > http://servername/ReportServer. ; Additional Information: The request failed
> > with HTTP status 503: Service Unavailable (
> > Microsoft.ReportingServices.Designer). There are virtual directories
> > 'Reportserver' and 'Reports' under the IIS main folder.
> >
> > 2. Even when I try to do http://servername/Reports, I get an error -- The
> > request failed HTTP status 400: Bad request. I can see the page redirected
> > before dispalying this message to http://servername/reports/pages/folder.aspx
> >
> > Any help is appreciated. We have a strong Group policy settings in place at
> > work on all these servers. All the services are running under the same
> > domain account except for ASP.NET service.
> >
> > Thanks
> > BVR.
> >|||Browsing the Reports or ReportServer should render something. Do you happen
to have SharePoint running on the same IIS? If so, you need to tell
SharePoint that these web sites (or virtual directories) should not be
included.
Otherwise, try running "iisreset" at a command prompt (DOS window -
Start->Run-> cmd).
--
RDA Corp
Business Intelligence Evangelist Leader
www.rdacorp.com
"Joe Kelly" wrote:
> Steve,
> I have the same problem. I have checked the scty setting on the Sites in the
> IIS section of CompMgt and all seems OK, but when I right click the Site and
> selct Browse, I still get Service Unavailable '
> --
> JK
>
> "Steve Mann" wrote:
> > You may need to use the actual IP address as the servername may not be
> > resolved with the two-node setup.
> >
> > To be sure I would "ping" the servername and use the reply IP address in the
> > TargetServerURL instead of the servername...
> >
> > See if that works!
> >
> > -=Steve
> >
> > "BVR" wrote:
> >
> > > We have a two node clustered setup with couple of instances on each node. I
> > > am trying to setup a reporting services on one of the nodes. For testing, we
> > > did IIS install on the same machine. Used configuration tool and setup
> > > reporting database on one of the sql instances. The install didn't report
> > > any errors.
> > >
> > > but now the problems is,
> > > 1. I created a report using VS business Intelligence tool and tried to
> > > deploy it to report server -- but its failing. I get an error message .. A
> > > connection could not be made to the report server
> > > http://servername/ReportServer. ; Additional Information: The request failed
> > > with HTTP status 503: Service Unavailable (
> > > Microsoft.ReportingServices.Designer). There are virtual directories
> > > 'Reportserver' and 'Reports' under the IIS main folder.
> > >
> > > 2. Even when I try to do http://servername/Reports, I get an error -- The
> > > request failed HTTP status 400: Bad request. I can see the page redirected
> > > before dispalying this message to http://servername/reports/pages/folder.aspx
> > >
> > > Any help is appreciated. We have a strong Group policy settings in place at
> > > work on all these servers. All the services are running under the same
> > > domain account except for ASP.NET service.
> > >
> > > Thanks
> > > BVR.
> > >|||Thanks Steve,
I found an article in the Support base that pointed to a conflict between
files from versions of IIS for W2003 and W2003 SP1.
I have uninstalled SSRS and IIS and will reinstall from W2K3SP1 media. Will
report back.
JK
--
JK
"Steve Mann" wrote:
> Browsing the Reports or ReportServer should render something. Do you happen
> to have SharePoint running on the same IIS? If so, you need to tell
> SharePoint that these web sites (or virtual directories) should not be
> included.
> Otherwise, try running "iisreset" at a command prompt (DOS window -
> Start->Run-> cmd).
> --
> RDA Corp
> Business Intelligence Evangelist Leader
> www.rdacorp.com
>
> "Joe Kelly" wrote:
> > Steve,
> >
> > I have the same problem. I have checked the scty setting on the Sites in the
> > IIS section of CompMgt and all seems OK, but when I right click the Site and
> > selct Browse, I still get Service Unavailable '
> >
> > --
> > JK
> >
> >
> > "Steve Mann" wrote:
> >
> > > You may need to use the actual IP address as the servername may not be
> > > resolved with the two-node setup.
> > >
> > > To be sure I would "ping" the servername and use the reply IP address in the
> > > TargetServerURL instead of the servername...
> > >
> > > See if that works!
> > >
> > > -=Steve
> > >
> > > "BVR" wrote:
> > >
> > > > We have a two node clustered setup with couple of instances on each node. I
> > > > am trying to setup a reporting services on one of the nodes. For testing, we
> > > > did IIS install on the same machine. Used configuration tool and setup
> > > > reporting database on one of the sql instances. The install didn't report
> > > > any errors.
> > > >
> > > > but now the problems is,
> > > > 1. I created a report using VS business Intelligence tool and tried to
> > > > deploy it to report server -- but its failing. I get an error message .. A
> > > > connection could not be made to the report server
> > > > http://servername/ReportServer. ; Additional Information: The request failed
> > > > with HTTP status 503: Service Unavailable (
> > > > Microsoft.ReportingServices.Designer). There are virtual directories
> > > > 'Reportserver' and 'Reports' under the IIS main folder.
> > > >
> > > > 2. Even when I try to do http://servername/Reports, I get an error -- The
> > > > request failed HTTP status 400: Bad request. I can see the page redirected
> > > > before dispalying this message to http://servername/reports/pages/folder.aspx
> > > >
> > > > Any help is appreciated. We have a strong Group policy settings in place at
> > > > work on all these servers. All the services are running under the same
> > > > domain account except for ASP.NET service.
> > > >
> > > > Thanks
> > > > BVR.
> > > >

RS Manager how to setup the admins ?

I finally got RS 2005 up and running.

However when I go to my report manager all I see at the top is:

SQL Server Reporting Services
HOME

and at the top right links to HOME | My Subscriptions | Help

But as in 2000 i do not see how to add folders / reports or view
details. Its as if it is missing one piece of security. I need to
tell reporting services manager that I am an admin / developer and to
allow me to do this. Where or how can I do this? As I do not have any
permissions to do it right now in RS Report Manager.

We are running on win2k3, rs 2005, sql server 2k5.

Thanks,
Jon

Hi Jon,

You should be able to connect to RS 2005 using SQL Management Studio, and manage security settings from there.

http://msdn2.microsoft.com/en-us/library/aa337385.aspx

cheers,

Andrew

RS Install fails on Win2003

Hi gang,
Heres the problem: When I try to run the setup for Reporting Services it
fails near the end, stating the following:
Product: Microsoft SQL Server 2000 Reporting Services Standard Edition --
Error 29581. SQL Setup failed to execute a command for server configuration.
The error was: Database 'ReportServerDB' does not exist. Check sysdatabases.
Refer to the Server error logs and setup logs for detailed error information.
SETUP:
Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the server
Im trying to install RS to. Im unsure which service pack this server is
running; it doesnt say anything just version 5.2 build 3790
Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is the
server that I want to store the data on.
I have tried a couple of different settings to connect to the database; I
tried using the NT Authority\ Network service, the local machine acct, and
lately the administrator acct, but I still get the same error.
I would be thankful for any suggestions..
Take care,
ChristianSetup uses the user running setup to create the databases, make sure this
use is a dbo on your sql server. For some reason the database is not being
created, one thing we have seen before is if there is no default location
for DB's then setup will fail, so check to see if there is a default
directory for new databases.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"farastray" <farastray@.discussions.microsoft.com> wrote in message
news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
> Hi gang,
> Heres the problem: When I try to run the setup for Reporting Services it
> fails near the end, stating the following:
> Product: Microsoft SQL Server 2000 Reporting Services Standard Edition --
> Error 29581. SQL Setup failed to execute a command for server
> configuration.
> The error was: Database 'ReportServerDB' does not exist. Check
> sysdatabases.
> Refer to the Server error logs and setup logs for detailed error
> information.
> SETUP:
> Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the server
> Im trying to install RS to. Im unsure which service pack this server is
> running; it doesnt say anything just version 5.2 build 3790
> Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is the
> server that I want to store the data on.
> I have tried a couple of different settings to connect to the database; I
> tried using the NT Authority\ Network service, the local machine acct, and
> lately the administrator acct, but I still get the same error.
> I would be thankful for any suggestions..
> Take care,
> Christian|||Ok... still no luck.
I created a new user, gave him every single right you can possibly have, and
made him database owner of all databases.
I also went in under my database server's properties (in SQL Ent Mgr) and
specified a default database directory.
I tried loging in with different users, (both sql users, local/domain users)
but it is still giving me the same error: Database 'Report Server' does not
exist.
Does anyone else know how to solve this'
"Daniel Reib (MSFT)" wrote:
> Setup uses the user running setup to create the databases, make sure this
> use is a dbo on your sql server. For some reason the database is not being
> created, one thing we have seen before is if there is no default location
> for DB's then setup will fail, so check to see if there is a default
> directory for new databases.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "farastray" <farastray@.discussions.microsoft.com> wrote in message
> news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
> > Hi gang,
> >
> > Heres the problem: When I try to run the setup for Reporting Services it
> > fails near the end, stating the following:
> >
> > Product: Microsoft SQL Server 2000 Reporting Services Standard Edition --
> > Error 29581. SQL Setup failed to execute a command for server
> > configuration.
> > The error was: Database 'ReportServerDB' does not exist. Check
> > sysdatabases.
> > Refer to the Server error logs and setup logs for detailed error
> > information.
> >
> > SETUP:
> >
> > Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the server
> > Im trying to install RS to. Im unsure which service pack this server is
> > running; it doesnt say anything just version 5.2 build 3790
> >
> > Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is the
> > server that I want to store the data on.
> >
> > I have tried a couple of different settings to connect to the database; I
> > tried using the NT Authority\ Network service, the local machine acct, and
> > lately the administrator acct, but I still get the same error.
> >
> > I would be thankful for any suggestions..
> >
> > Take care,
> >
> > Christian
>
>|||You say you tried logging in as different users. Do you mean you entered
these in one of the RS setup dialogs? If so then that is not correct.
Setup uses the user that is running setup to create the databases. That is
the currently logged in windows user. If you want to use SQL Auth during
setup there are some command line parameters that you can use to make setup
use SQL Auth during setup. Look in the template.ini file for the
RSSETUPACCOUNT and RSSETUPPASSWORD parameters.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"farastray" <farastray@.discussions.microsoft.com> wrote in message
news:4560E92E-792B-4BE4-A405-88037601CE37@.microsoft.com...
> Ok... still no luck.
> I created a new user, gave him every single right you can possibly have,
> and
> made him database owner of all databases.
> I also went in under my database server's properties (in SQL Ent Mgr) and
> specified a default database directory.
> I tried loging in with different users, (both sql users, local/domain
> users)
> but it is still giving me the same error: Database 'Report Server' does
> not
> exist.
> Does anyone else know how to solve this'
> "Daniel Reib (MSFT)" wrote:
>> Setup uses the user running setup to create the databases, make sure this
>> use is a dbo on your sql server. For some reason the database is not
>> being
>> created, one thing we have seen before is if there is no default location
>> for DB's then setup will fail, so check to see if there is a default
>> directory for new databases.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "farastray" <farastray@.discussions.microsoft.com> wrote in message
>> news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
>> > Hi gang,
>> >
>> > Heres the problem: When I try to run the setup for Reporting Services
>> > it
>> > fails near the end, stating the following:
>> >
>> > Product: Microsoft SQL Server 2000 Reporting Services Standard
>> > Edition --
>> > Error 29581. SQL Setup failed to execute a command for server
>> > configuration.
>> > The error was: Database 'ReportServerDB' does not exist. Check
>> > sysdatabases.
>> > Refer to the Server error logs and setup logs for detailed error
>> > information.
>> >
>> > SETUP:
>> >
>> > Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the
>> > server
>> > Im trying to install RS to. Im unsure which service pack this server is
>> > running; it doesnt say anything just version 5.2 build 3790
>> >
>> > Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is
>> > the
>> > server that I want to store the data on.
>> >
>> > I have tried a couple of different settings to connect to the database;
>> > I
>> > tried using the NT Authority\ Network service, the local machine acct,
>> > and
>> > lately the administrator acct, but I still get the same error.
>> >
>> > I would be thankful for any suggestions..
>> >
>> > Take care,
>> >
>> > Christian
>>|||What I meant by different users is that I tried both different SQL users
(when using SQL authentiaction), as well as trying different domain users..
"Daniel Reib (MSFT)" wrote:
> You say you tried logging in as different users. Do you mean you entered
> these in one of the RS setup dialogs? If so then that is not correct.
> Setup uses the user that is running setup to create the databases. That is
> the currently logged in windows user. If you want to use SQL Auth during
> setup there are some command line parameters that you can use to make setup
> use SQL Auth during setup. Look in the template.ini file for the
> RSSETUPACCOUNT and RSSETUPPASSWORD parameters.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "farastray" <farastray@.discussions.microsoft.com> wrote in message
> news:4560E92E-792B-4BE4-A405-88037601CE37@.microsoft.com...
> > Ok... still no luck.
> >
> > I created a new user, gave him every single right you can possibly have,
> > and
> > made him database owner of all databases.
> >
> > I also went in under my database server's properties (in SQL Ent Mgr) and
> > specified a default database directory.
> >
> > I tried loging in with different users, (both sql users, local/domain
> > users)
> > but it is still giving me the same error: Database 'Report Server' does
> > not
> > exist.
> >
> > Does anyone else know how to solve this'
> >
> > "Daniel Reib (MSFT)" wrote:
> >
> >> Setup uses the user running setup to create the databases, make sure this
> >> use is a dbo on your sql server. For some reason the database is not
> >> being
> >> created, one thing we have seen before is if there is no default location
> >> for DB's then setup will fail, so check to see if there is a default
> >> directory for new databases.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "farastray" <farastray@.discussions.microsoft.com> wrote in message
> >> news:9AA86980-D98C-48A6-A58C-4EF5458F4381@.microsoft.com...
> >> > Hi gang,
> >> >
> >> > Heres the problem: When I try to run the setup for Reporting Services
> >> > it
> >> > fails near the end, stating the following:
> >> >
> >> > Product: Microsoft SQL Server 2000 Reporting Services Standard
> >> > Edition --
> >> > Error 29581. SQL Setup failed to execute a command for server
> >> > configuration.
> >> > The error was: Database 'ReportServerDB' does not exist. Check
> >> > sysdatabases.
> >> > Refer to the Server error logs and setup logs for detailed error
> >> > information.
> >> >
> >> > SETUP:
> >> >
> >> > Windows Server 2003 Std. Ed., running ASP.NET and IIS.. This is the
> >> > server
> >> > Im trying to install RS to. Im unsure which service pack this server is
> >> > running; it doesnt say anything just version 5.2 build 3790
> >> >
> >> > Windows 2000 with SP4, running MSSQL 2000 Std. Ed. with SP4, this is
> >> > the
> >> > server that I want to store the data on.
> >> >
> >> > I have tried a couple of different settings to connect to the database;
> >> > I
> >> > tried using the NT Authority\ Network service, the local machine acct,
> >> > and
> >> > lately the administrator acct, but I still get the same error.
> >> >
> >> > I would be thankful for any suggestions..
> >> >
> >> > Take care,
> >> >
> >> > Christian
> >>
> >>
> >>
>
>|||This maybe a silly question, but how do I pass in the commandline parameters?
I tried using setup.exe -RSSETUPACCOUNT="sa" and -RSSETUPPASSWORD="password"
in the command prompt, but it wont take the parameters.. I tried using single
quotes, space instead of =, and / instead of -.. What am I doing wrong?|||farastray wrote:
> This maybe a silly question, but how do I pass in the commandline parameters?
> I tried using setup.exe -RSSETUPACCOUNT="sa" and -RSSETUPPASSWORD="password"
> in the command prompt, but it wont take the parameters.. I tried using single
> quotes, space instead of =, and / instead of -.. What am I doing wrong?
Don't use anything but the property. msiexec uses PROPERTY=value
setup.exe RSSETUPACCOUNT=sa RSSETUPPASSWORD=password
Joachim.

RS E-Mails Not Sending

I have some subscriptions setup that automatically e-mail reports to the
end-user. However, the reports only work maybe 3 days out of the week the
other times the e-mails to not get sent. Has anyone ran into this problem
before? I am using SMTP.
Thank You.Do the log files contain any errors? Does the subscription status show
anything?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Andy Jones" <ajones@.rheemac.com> wrote in message
news:eW5xs1qwFHA.1148@.TK2MSFTNGP11.phx.gbl...
>I have some subscriptions setup that automatically e-mail reports to the
>end-user. However, the reports only work maybe 3 days out of the week the
>other times the e-mails to not get sent. Has anyone ran into this problem
>before? I am using SMTP.
> Thank You.
>|||I don't see anything that I am aware of in the subscription. I am not sure
what log files to look in?
thank you.
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ONgpsqtwFHA.3756@.tk2msftngp13.phx.gbl...
> Do the log files contain any errors? Does the subscription status show
> anything?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Andy Jones" <ajones@.rheemac.com> wrote in message
> news:eW5xs1qwFHA.1148@.TK2MSFTNGP11.phx.gbl...
>>I have some subscriptions setup that automatically e-mail reports to the
>>end-user. However, the reports only work maybe 3 days out of the week the
>>other times the e-mails to not get sent. Has anyone ran into this problem
>>before? I am using SMTP.
>> Thank You.
>

RS deployment on load balanced servers

Could anybody offer any advice on the internal mechanics of report server?
Our server setup is as follows.
SQL Server 2000 clusters in active/passive. Load balanced web servers x 3.
One of which is a publisher with files replicated to the other two.
We'd like to set up reporting services, but need a bit of advice as to the
role of the report server.
Our plan is to set up RS on all three servers for load balancing, all
pointing to the same SQL cluster.
As I understand it, when an rdl file is deployed or uploaded to report
server, report server takes the file, breaks it down, encrypts it and
publishes it to the RS database. Is this correct? Doe RS have any other
function at this point? Are references to the reports stored on the IIS
server?
In our setup when we publish to http://abcdefg/ReportServer, our content
switches will decide which server the report is sent to. If it *doesn't* go
to our publishing server, do we need to be concerned with replication?
Also, what issues do we face RE encryption key on the three servers? We need
to ensure that they are all the same. Is this something that can be specified
during setup?
I Hope this makes sense!
JoeThis is 100% supported configuration. Search BOL for web farm (if you do not
have RS installed yet and don't have BOL then you can search the Microsoft
site for this). I don't have a web farm configuration but based on my
experience with RS this is what happens: In a web farm all the server front
ends use the same SQL Server database. So, when you deploy you only need to
deploy once and that gets the information used by the app into the database.
RS has three parts. The SQL Server database object store, and two asp.net
1.1 applications. One of the applications is core to the product, it does
all the rendering of the reports and uses the object store. The other
(Report Manager) you can consider a portal. This is optional, some people
use either URL integration or webservices and have their own front end
instead of using Report Manager.
Note that for a web farm you need to have enterprise licenses. Not only for
the SQL server cluster you have but you need an SQL Server interprise
license for each IIS server in your web farm. Every server used by RS has to
have a SQL Server license.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:0739946E-1912-4EB1-BDC1-E4DA34740295@.microsoft.com...
> Could anybody offer any advice on the internal mechanics of report server?
> Our server setup is as follows.
> SQL Server 2000 clusters in active/passive. Load balanced web servers x 3.
> One of which is a publisher with files replicated to the other two.
> We'd like to set up reporting services, but need a bit of advice as to the
> role of the report server.
> Our plan is to set up RS on all three servers for load balancing, all
> pointing to the same SQL cluster.
> As I understand it, when an rdl file is deployed or uploaded to report
> server, report server takes the file, breaks it down, encrypts it and
> publishes it to the RS database. Is this correct? Doe RS have any other
> function at this point? Are references to the reports stored on the IIS
> server?
> In our setup when we publish to http://abcdefg/ReportServer, our content
> switches will decide which server the report is sent to. If it *doesn't*
go
> to our publishing server, do we need to be concerned with replication?
> Also, what issues do we face RE encryption key on the three servers? We
need
> to ensure that they are all the same. Is this something that can be
specified
> during setup?
> I Hope this makes sense!
> Joe|||Thanks for the information Bruce. It looks like our options are to compromise
our SQL cluster by putting IIS and RS on it, something anybody with an ounce
of sense wouldn't do, or to pay MS for 3 additional enterprise liscences! I
don't know about you, but this seems to me like this is a liscence to print
money!
"Bruce L-C [MVP]" wrote:
> This is 100% supported configuration. Search BOL for web farm (if you do not
> have RS installed yet and don't have BOL then you can search the Microsoft
> site for this). I don't have a web farm configuration but based on my
> experience with RS this is what happens: In a web farm all the server front
> ends use the same SQL Server database. So, when you deploy you only need to
> deploy once and that gets the information used by the app into the database.
> RS has three parts. The SQL Server database object store, and two asp.net
> 1.1 applications. One of the applications is core to the product, it does
> all the rendering of the reports and uses the object store. The other
> (Report Manager) you can consider a portal. This is optional, some people
> use either URL integration or webservices and have their own front end
> instead of using Report Manager.
> Note that for a web farm you need to have enterprise licenses. Not only for
> the SQL server cluster you have but you need an SQL Server interprise
> license for each IIS server in your web farm. Every server used by RS has to
> have a SQL Server license.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:0739946E-1912-4EB1-BDC1-E4DA34740295@.microsoft.com...
> > Could anybody offer any advice on the internal mechanics of report server?
> >
> > Our server setup is as follows.
> >
> > SQL Server 2000 clusters in active/passive. Load balanced web servers x 3.
> > One of which is a publisher with files replicated to the other two.
> >
> > We'd like to set up reporting services, but need a bit of advice as to the
> > role of the report server.
> >
> > Our plan is to set up RS on all three servers for load balancing, all
> > pointing to the same SQL cluster.
> >
> > As I understand it, when an rdl file is deployed or uploaded to report
> > server, report server takes the file, breaks it down, encrypts it and
> > publishes it to the RS database. Is this correct? Doe RS have any other
> > function at this point? Are references to the reports stored on the IIS
> > server?
> >
> > In our setup when we publish to http://abcdefg/ReportServer, our content
> > switches will decide which server the report is sent to. If it *doesn't*
> go
> > to our publishing server, do we need to be concerned with replication?
> >
> > Also, what issues do we face RE encryption key on the three servers? We
> need
> > to ensure that they are all the same. Is this something that can be
> specified
> > during setup?
> >
> > I Hope this makes sense!
> >
> > Joe
>
>|||Depends on your licensing how bad a hit it is. If you are doing processor
licenses then it is a pretty big hit. If all you are paying for is the
server license then not too bad (especially if you compare against Crystal
or BO). In my case my corporation has SQL Server client licenses covered for
all PCs so I have no CALs to do, just the server license. It is a different
story if you are doing processor licenses.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:EECC39FD-C9F0-4F5A-B6EE-C19D689A2F15@.microsoft.com...
> Thanks for the information Bruce. It looks like our options are to
compromise
> our SQL cluster by putting IIS and RS on it, something anybody with an
ounce
> of sense wouldn't do, or to pay MS for 3 additional enterprise liscences!
I
> don't know about you, but this seems to me like this is a liscence to
print
> money!
> "Bruce L-C [MVP]" wrote:
> > This is 100% supported configuration. Search BOL for web farm (if you do
not
> > have RS installed yet and don't have BOL then you can search the
Microsoft
> > site for this). I don't have a web farm configuration but based on my
> > experience with RS this is what happens: In a web farm all the server
front
> > ends use the same SQL Server database. So, when you deploy you only need
to
> > deploy once and that gets the information used by the app into the
database.
> > RS has three parts. The SQL Server database object store, and two
asp.net
> > 1.1 applications. One of the applications is core to the product, it
does
> > all the rendering of the reports and uses the object store. The other
> > (Report Manager) you can consider a portal. This is optional, some
people
> > use either URL integration or webservices and have their own front end
> > instead of using Report Manager.
> >
> > Note that for a web farm you need to have enterprise licenses. Not only
for
> > the SQL server cluster you have but you need an SQL Server interprise
> > license for each IIS server in your web farm. Every server used by RS
has to
> > have a SQL Server license.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Joe" <Joe@.discussions.microsoft.com> wrote in message
> > news:0739946E-1912-4EB1-BDC1-E4DA34740295@.microsoft.com...
> > > Could anybody offer any advice on the internal mechanics of report
server?
> > >
> > > Our server setup is as follows.
> > >
> > > SQL Server 2000 clusters in active/passive. Load balanced web servers
x 3.
> > > One of which is a publisher with files replicated to the other two.
> > >
> > > We'd like to set up reporting services, but need a bit of advice as to
the
> > > role of the report server.
> > >
> > > Our plan is to set up RS on all three servers for load balancing, all
> > > pointing to the same SQL cluster.
> > >
> > > As I understand it, when an rdl file is deployed or uploaded to report
> > > server, report server takes the file, breaks it down, encrypts it and
> > > publishes it to the RS database. Is this correct? Doe RS have any
other
> > > function at this point? Are references to the reports stored on the
IIS
> > > server?
> > >
> > > In our setup when we publish to http://abcdefg/ReportServer, our
content
> > > switches will decide which server the report is sent to. If it
*doesn't*
> > go
> > > to our publishing server, do we need to be concerned with replication?
> > >
> > > Also, what issues do we face RE encryption key on the three servers?
We
> > need
> > > to ensure that they are all the same. Is this something that can be
> > specified
> > > during setup?
> > >
> > > I Hope this makes sense!
> > >
> > > Joe
> >
> >
> >|||Per processor licenses!!

RS 2005: Subscription fails with Internal error

Hi all,

I have a (for me) strange problem with subscribing reports.

I've setup several reports that I want to create monthly and store to a file share.
In BIDS Preview and deployed to the report server everything works fine.

Each of my reports has an own schedule (they'll be created step by step), export format is Excel, as credentials I use a local user, all parameters are set porperly.
When the time to render the reports has gone, I just see the following behind each subscription:

Failure writing file LIS04 : An internal error occurred on the report

server. See the error log for more details.

The Log file contains the following: (I highlighted what I think to be the key error)

ReportingServicesService!library!4!12/19/2006-10:20:35:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!e!12/19/2006-10:20:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
ReportingServicesService!runningjobs!f!12/19/2006-10:21:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:21:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1a!12/19/2006-10:22:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:22:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1b!12/19/2006-10:23:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:23:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!3!12/19/2006-10:24:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!17!12/19/2006-10:24:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!17!12/19/2006-10:25:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!3!12/19/2006-10:25:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!16!12/19/2006-10:26:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:26:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!18!12/19/2006-10:27:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!13!12/19/2006-10:27:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!d!12/19/2006-10:28:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:28:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:29:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:29:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!13!12/19/2006-10:30:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:30:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:31:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!8!12/19/2006-10:31:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!c!12/19/2006-10:32:10:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 executed at 12/19/2006 10:32:10 AM.
ReportingServicesService!schedule!f!12/19/2006-10:32:10:: Creating Time based subscription notification for subscription: 2ae5c0ed-9eea-4ca4-8e41-be5cde9f7908
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 execution completed at 12/19/2006 10:32:10 AM.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling finished processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!dbpolling!c!12/19/2006-10:32:20:: NotificationPolling processing 1 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!13!12/19/2006-10:32:20:: NotificationPolling processing item b216a965-eaa7-4003-b776-4663c19c8d54
ReportingServicesService!library!13!12/19/2006-10:32:21:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!13!12/19/2006-10:32:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.OverflowException: Arithmetic operation resulted in an overflow.
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
End of inner exception stack trace
ReportingServicesService!runningjobs!17!12/19/2006-10:32:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:32:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams

Does anyone have an idea what goes wrong here?

Best regards
Florian
Are you running 64 bit RS? If yes, it looks like a known problem that will be fixed in SP2.