Reporting Services affected by a server name change?

We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
operating system. We had Reporting Services installed and configured but we
did not use it. A couple of weeks ago the server name was changed. I ran
sp_dropserver and then sp_addserver.
Since then our client want to utilize Reporting Services. Although
configured it is not working. I cannot even access Reporting Services
through SQL Server Management Studio. Could this be the result of the server
name change? What should be done with Reporting Services in the event of a
server name change?Go to RS Config Manager (Start Menu\Programs\Microsoft SQL Server
2005\Configuration Tools)
-Database Setup:
-Change the name in the "Server Name" field to your server's new name
-Click on "Connect"
-Click on "Apply"
-Encryption keys
-Click on "Delete" and Ok (deleting this can give you problems on an
active production server)
-Open the file C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\rsreportserver.config
and change the line
<UrlRoot>http://OldServerName/reportserver</UrlRoot>
to
<UrlRoot>http://NewServerName/reportserver</UrlRoot>
-In MSIE, check the following addresses:
http://localhost/reports
http://localhost/reportserver
-Try to connect to Reporting Services through Management Studio
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Loren Z" <anonymous@.discussions.microsoft.com> wrote in message
news:e$M4P4ThIHA.2268@.TK2MSFTNGP02.phx.gbl...
> We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
> operating system. We had Reporting Services installed and configured but
> we did not use it. A couple of weeks ago the server name was changed. I
> ran sp_dropserver and then sp_addserver.
> Since then our client want to utilize Reporting Services. Although
> configured it is not working. I cannot even access Reporting Services
> through SQL Server Management Studio. Could this be the result of the
> server name change? What should be done with Reporting Services in the
> event of a server name change?
>

Reporting Services affected by a server name change?

We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
operating system. We had Reporting Services installed and configured but we
did not use it. A couple of weeks ago the server name was changed. I ran
sp_dropserver and then sp_addserver.
Since then our client want to utilize Reporting Services. Although
configured it is not working. I cannot even access Reporting Services
through SQL Server Management Studio. Could this be the result of the server
name change? What should be done with Reporting Services in the event of a
server name change?Go to RS Config Manager (Start Menu\Programs\Microsoft SQL Server
2005\Configuration Tools)
-Database Setup:
-Change the name in the "Server Name" field to your server's new name
-Click on "Connect"
-Click on "Apply"
-Encryption keys
-Click on "Delete" and Ok (deleting this can give you problems on an
active production server)
-Open the file C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\rsreportserver.config
and change the line
<UrlRoot>http://OldServerName/reportserver</UrlRoot>
to
<UrlRoot>http://NewServerName/reportserver</UrlRoot>
-In MSIE, check the following addresses:
http://localhost/reports
http://localhost/reportserver
-Try to connect to Reporting Services through Management Studio
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Loren Z" <anonymous@.discussions.microsoft.com> wrote in message
news:e$M4P4ThIHA.2268@.TK2MSFTNGP02.phx.gbl...
> We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
> operating system. We had Reporting Services installed and configured but
> we did not use it. A couple of weeks ago the server name was changed. I
> ran sp_dropserver and then sp_addserver.
> Since then our client want to utilize Reporting Services. Although
> configured it is not working. I cannot even access Reporting Services
> through SQL Server Management Studio. Could this be the result of the
> server name change? What should be done with Reporting Services in the
> event of a server name change?
>sql

Reporting Services affected by a server name change?

We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
operating system. We had Reporting Services installed and configured but we
did not use it. A couple of weeks ago the server name was changed. I ran
sp_dropserver and then sp_addserver.
Since then our client want to utilize Reporting Services. Although
configured it is not working. I cannot even access Reporting Services
through SQL Server Management Studio. Could this be the result of the server
name change? What should be done with Reporting Services in the event of a
server name change?
Go to RS Config Manager (Start Menu\Programs\Microsoft SQL Server
2005\Configuration Tools)
-Database Setup:
-Change the name in the "Server Name" field to your server's new name
-Click on "Connect"
-Click on "Apply"
-Encryption keys
-Click on "Delete" and Ok (deleting this can give you problems on an
active production server)
-Open the file C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting
Services\ReportServer\rsreportserver.config
and change the line
<UrlRoot>http://OldServerName/reportserver</UrlRoot>
to
<UrlRoot>http://NewServerName/reportserver</UrlRoot>
-In MSIE, check the following addresses:
http://localhost/reports
http://localhost/reportserver
-Try to connect to Reporting Services through Management Studio
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Loren Z" <anonymous@.discussions.microsoft.com> wrote in message
news:e$M4P4ThIHA.2268@.TK2MSFTNGP02.phx.gbl...
> We are running 64-bit SQL Server 2005 build 3200 on a 64-bit Windows 2003
> operating system. We had Reporting Services installed and configured but
> we did not use it. A couple of weeks ago the server name was changed. I
> ran sp_dropserver and then sp_addserver.
> Since then our client want to utilize Reporting Services. Although
> configured it is not working. I cannot even access Reporting Services
> through SQL Server Management Studio. Could this be the result of the
> server name change? What should be done with Reporting Services in the
> event of a server name change?
>

Reporting Services Addin - Set Server Defaults Error

Hey All,

I installed Reporting Services Add-in with no problems on a Virtual server that already hosts MOSS 2007 and configured everything that was stated in documentation. The Report server Url works fine..like http://myserver1:802/ReportServer and I can see the contents when I type this url.

However, when I go to Central Administration and click on "Set Server Defaults"...I am getting a "401.1 Unauthorized..." error.I setup the Manage Integration to TrustedAccount and the Grant DatabaseAccess to the account that is the Server.Farm and local administrator.

In the Reporting Services Configuration, I used SSRSWebAccount for WebService and SSRSWindowsAccount for WindowsService and the RSAppPool which is the ApplicationPool for ReportingServices Web Site uses the SSRSWindowsAccount only.

Anybody..please help.

Thanks,

Vedala

I resolved my problem by installing SQL Server 2005 SP2. All along I assumed my virtual machine had SQL Server 2005 SP2, but after looking closely, I found that my version was 9.0.3033 and not 9.0.3042 which is official SP2 release version. I grabbed that and reinstalled it on my image and everything started working.

I however did couple of other steps too...which I did not go back and undo and test..so at this point I am not really sure if only the above was the problem or something else.,,, I will update this post with the blog entry about my issue later.

Thanks,

Vedala

Reporting Services Addin - Set Server Defaults Error

Hey All,

I installed Reporting Services Add-in with no problems on a Virtual server that already hosts MOSS 2007 and configured everything that was stated in documentation. The Report server Url works fine..like http://myserver1:802/ReportServer and I can see the contents when I type this url.

However, when I go to Central Administration and click on "Set Server Defaults"...I am getting a "401.1 Unauthorized..." error.I setup the Manage Integration to TrustedAccount and the Grant DatabaseAccess to the account that is the Server.Farm and local administrator.

In the Reporting Services Configuration, I used SSRSWebAccount for WebService and SSRSWindowsAccount for WindowsService and the RSAppPool which is the ApplicationPool for ReportingServices Web Site uses the SSRSWindowsAccount only.

Anybody..please help.

Thanks,

Vedala

I resolved my problem by installing SQL Server 2005 SP2. All along I assumed my virtual machine had SQL Server 2005 SP2, but after looking closely, I found that my version was 9.0.3033 and not 9.0.3042 which is official SP2 release version. I grabbed that and reinstalled it on my image and everything started working.

I however did couple of other steps too...which I did not go back and undo and test..so at this point I am not really sure if only the above was the problem or something else.,,, I will update this post with the blog entry about my issue later.

Thanks,

Vedala

sql

Reporting services access problem !!!!!!!

Hi ..

I am facing a peculiar problem ... We have Sql Server 2005 reporting services installed on our server ...unfortunately our sysadmin by mistake has reinstalled the IIS on the server due to which the report server is not accessible .. The sql server is working fine no problem ..

normally we used to give .. http://domainname/reports and all the reports will be shown.

Now how do i reinstate the settings of the IIS ... for the Reporting services.

Could anybody suggest some ideas ...

Rgds

Chandru

Should be able to run the Reporting Services configuration, and just re-set the Virtual Directories and the Web Service Identity.|||

Ya .. thats ok .. But what is the virtual directory mappings i should give in IIS for the Team Foundation Server ....

Kindly enlighten me on this ....

|||

In your Configuration settings stop the report server. Then restart IIS, then restart the report server. This may or may not work but is worth a try

sql

Reporting Services 2005 WMI documentation inccorect?

I have SQL Server 2005 + Reporting Services 2005 installed on a machine. I've
implemented Custom Forms Security Extension. When I run the code below I get
a WMI Exception "Not Found"? I think maybe I have the namespace or class name
wrong... The documentation has both "MSReportManager_ConfigurationSetting"
and "MSReportServerReportManager_ConfigurationSetting" but neither seem to
work. The only WMI class that works properly is "MSReportServer_Instance".
What am I doing wrong?
________________________________________________________
Nuno Pereira
ManagementScope scope = new
ManagementScope(@."\\localhost\root\Microsoft\SqlServer\ReportServer\v9");
scope.Connect();
ManagementPath path = new
ManagementPath("MSReportServerReportManager_ConfigurationSetting");
ObjectGetOptions options = new ObjectGetOptions();
ManagementClass serverClass = new ManagementClass(scope, path, options);
serverClass.Get(); // throws a "Not Found" error...
________________________________________________________________I am now encountering a similar problem as you. I am looking into the sample
provided by MS on Using Forms Authentication in Reporting Services (this is
in SQL2K) and trying to replicate it using SQL 2005 and VS2005.
But I have problems accessing the PathName property of
MSReportServer_ConfigurationSetting, which i need to point to the installed
path for the Report Server. Can any one help to explain more on this area?
Thanks for any assistance.
"Nuno" wrote:
> I have SQL Server 2005 + Reporting Services 2005 installed on a machine. I've
> implemented Custom Forms Security Extension. When I run the code below I get
> a WMI Exception "Not Found"? I think maybe I have the namespace or class name
> wrong... The documentation has both "MSReportManager_ConfigurationSetting"
> and "MSReportServerReportManager_ConfigurationSetting" but neither seem to
> work. The only WMI class that works properly is "MSReportServer_Instance".
> What am I doing wrong?
> ________________________________________________________
> Nuno Pereira
> ManagementScope scope = new
> ManagementScope(@."\\localhost\root\Microsoft\SqlServer\ReportServer\v9");
> scope.Connect();
> ManagementPath path = new
> ManagementPath("MSReportServerReportManager_ConfigurationSetting");
> ObjectGetOptions options = new ObjectGetOptions();
> ManagementClass serverClass = new ManagementClass(scope, path, options);
> serverClass.Get(); // throws a "Not Found" error...
> ________________________________________________________________
>
>|||I am also encountering similar problems trying to retrieve the RS Web Service
from the following constants in Utils.cs provided in the RS 2000 Forms
Authentication example:
// WMI constants
const string WmiNamespace =@."\\localhost\root\Microsoft\SqlServer\ReportingServices\v8";
const string WmiRSClass = @."MSReportServerReportManager_ConfigurationSetting";
I've had to hardcode the Web Service URL (server.Url = "https://<server
name>/reportserver/reportservice.asmx";) in my UILogon.aspx.cs file to make
it work but this obviously isn't a solution since we have multiple test and
production enviornments.
"ice" wrote:
> I am now encountering a similar problem as you. I am looking into the sample
> provided by MS on Using Forms Authentication in Reporting Services (this is
> in SQL2K) and trying to replicate it using SQL 2005 and VS2005.
> But I have problems accessing the PathName property of
> MSReportServer_ConfigurationSetting, which i need to point to the installed
> path for the Report Server. Can any one help to explain more on this area?
> Thanks for any assistance.
> "Nuno" wrote:
> > I have SQL Server 2005 + Reporting Services 2005 installed on a machine. I've
> > implemented Custom Forms Security Extension. When I run the code below I get
> > a WMI Exception "Not Found"? I think maybe I have the namespace or class name
> > wrong... The documentation has both "MSReportManager_ConfigurationSetting"
> > and "MSReportServerReportManager_ConfigurationSetting" but neither seem to
> > work. The only WMI class that works properly is "MSReportServer_Instance".
> >
> > What am I doing wrong?
> >
> > ________________________________________________________
> >
> > Nuno Pereira
> > ManagementScope scope = new
> > ManagementScope(@."\\localhost\root\Microsoft\SqlServer\ReportServer\v9");
> >
> > scope.Connect();
> >
> > ManagementPath path = new
> > ManagementPath("MSReportServerReportManager_ConfigurationSetting");
> > ObjectGetOptions options = new ObjectGetOptions();
> > ManagementClass serverClass = new ManagementClass(scope, path, options);
> >
> > serverClass.Get(); // throws a "Not Found" error...
> > ________________________________________________________________
> >
> >
> >|||Is anybody from Microsoft listening? What's the answer to this question? What
are the equivalent constants for RS 2005 that were documented in the RS 2000
security extension example?
// RS 2000 Code
// WMI constants
const string WmiNamespace = @."\\localhost\root\Microsoft\SqlServer\ReportingServices\v8";
const string WmiRSClass = @."MSReportServerReportManager_ConfigurationSetting";
"JSI" wrote:
> I am also encountering similar problems trying to retrieve the RS Web Service
> from the following constants in Utils.cs provided in the RS 2000 Forms
> Authentication example:
> // WMI constants
> const string WmiNamespace => @."\\localhost\root\Microsoft\SqlServer\ReportingServices\v8";
> const string WmiRSClass = @."MSReportServerReportManager_ConfigurationSetting";
> I've had to hardcode the Web Service URL (server.Url = "https://<server
> name>/reportserver/reportservice.asmx";) in my UILogon.aspx.cs file to make
> it work but this obviously isn't a solution since we have multiple test and
> production enviornments.
> "ice" wrote:
> > I am now encountering a similar problem as you. I am looking into the sample
> > provided by MS on Using Forms Authentication in Reporting Services (this is
> > in SQL2K) and trying to replicate it using SQL 2005 and VS2005.
> >
> > But I have problems accessing the PathName property of
> > MSReportServer_ConfigurationSetting, which i need to point to the installed
> > path for the Report Server. Can any one help to explain more on this area?
> >
> > Thanks for any assistance.
> >
> > "Nuno" wrote:
> >
> > > I have SQL Server 2005 + Reporting Services 2005 installed on a machine. I've
> > > implemented Custom Forms Security Extension. When I run the code below I get
> > > a WMI Exception "Not Found"? I think maybe I have the namespace or class name
> > > wrong... The documentation has both "MSReportManager_ConfigurationSetting"
> > > and "MSReportServerReportManager_ConfigurationSetting" but neither seem to
> > > work. The only WMI class that works properly is "MSReportServer_Instance".
> > >
> > > What am I doing wrong?
> > >
> > > ________________________________________________________
> > >
> > > Nuno Pereira
> > > ManagementScope scope = new
> > > ManagementScope(@."\\localhost\root\Microsoft\SqlServer\ReportServer\v9");
> > >
> > > scope.Connect();
> > >
> > > ManagementPath path = new
> > > ManagementPath("MSReportServerReportManager_ConfigurationSetting");
> > > ObjectGetOptions options = new ObjectGetOptions();
> > > ManagementClass serverClass = new ManagementClass(scope, path, options);
> > >
> > > serverClass.Get(); // throws a "Not Found" error...
> > > ________________________________________________________________
> > >
> > >
> > >|||For those of you who are still looking for the answer. The namespace in sql server 2005 is: "\\localhost\root\Microsoft\SqlServer\ReportServer\v9\Admin" while the class for report manager instance is: "MSReportManager_ConfigurationSetting". For more details please refer to: http://msdn2.microsoft.com/en-us/library/ms153571.aspx
From http://www.developmentnow.com/g/115_2006_2_0_0_693931/Reporting-Services-2005-WMI-documentation-inccorect.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Reporting Services 2005 on a separate server

I recently installed an instance of SQL Server 2005 on a server that didn't have IIS. I received an error notification in the install logs that some components of SQL Server would not work. This lead me to wonder if Reporting Services 2005 truly can be installed on a separate server and run efficiently, so I pose the question to anyone out there who has had success doing so. Does IIS need to be installed on a server running an instance of SQL Server 2005 even if Reporting Services is not installed and is intended to be installed on a separate server? Any installation recommendations in installing RS 2005 on a separate server?Hi, some short answers, I hope they are suffiecient to your questions:

RS needs IIS to run. SQL Server 2005 does not.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Reporting Services 2005 in VS.2005?

We are on SQL server 2000 (sp4).
We have upgraded to Visual Studio 2005 (from .NET 2003)
We installed SQL server 2005 reporting services,
on a separate machine (separate from the machine that has
sql server 2000.
But when we open our Visual Studio 2005 IDE,
on a client machine, we can't find any template for creating a reporting
services project.
Microsoft's site has nothing but ads, I couldn't find
anything there on what to do
What do we do?
Thanks in Advance,
Laurence Nuttall
Programmer Analyst III
UCLA - Division of Continuing EducationHave you tried running the setup.exe in the tools directory of your SQL2005
CD? That should have all the desktop tools you need.
"Larry" wrote:
> We are on SQL server 2000 (sp4).
> We have upgraded to Visual Studio 2005 (from .NET 2003)
> We installed SQL server 2005 reporting services,
> on a separate machine (separate from the machine that has
> sql server 2000.
> But when we open our Visual Studio 2005 IDE,
> on a client machine, we can't find any template for creating a reporting
> services project.
> Microsoft's site has nothing but ads, I couldn't find
> anything there on what to do
> What do we do?
> Thanks in Advance,
> Laurence Nuttall
> Programmer Analyst III
> UCLA - Division of Continuing Education
>
>
>

Reporting Services 2005 in SharePoint Integrated mode with formsauthentication problem

Well, I have reporting services 2005 installed and configured in
sharepoint integrated mode, so I am deploying reports in sharepoint
libraries. After that I configured sharepoint to use forms
authentication with builtin AspNetSqlMembership provider, but this
action caused reports to not execute. I searched and found hotfix 3186
for this issue and applied it, but nothing has changed!
Error I have been experiencing is following:
An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode. --> The request failed with the error
message:
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl=
%2f_vti_bin
%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>
anyone can help? maybe i have not configured something correctly...
Irakli
It would be better of you post that question in .reportrtingsvcs or
sharepoint user group.
"Irakli" <Irakli.Rostiashvili@.gmail.com> wrote in message
news:5e330a25-f9bb-4657-9e26-e00a0ab96f6f@.m34g2000hsf.googlegroups.com...
> Well, I have reporting services 2005 installed and configured in
> sharepoint integrated mode, so I am deploying reports in sharepoint
> libraries. After that I configured sharepoint to use forms
> authentication with builtin AspNetSqlMembership provider, but this
> action caused reports to not execute. I searched and found hotfix 3186
> for this issue and applied it, but nothing has changed!
> Error I have been experiencing is following:
> An unexpected error occurred while connecting to the report server.
> Verify that the report server is available and configured for
> SharePoint integrated mode. --> The request failed with the error
> message:
> --
> <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl=
> %2f_vti_bin
> %2fReportServer%2fReportService2006.asmx">here</a>.</h2>
> </body></html>
> anyone can help? maybe i have not configured something correctly...

Reporting Services 2005 in SharePoint Integrated mode with forms

Well, I have reporting services 2005 installed and configured in
sharepoint integrated mode, so I am deploying reports in sharepoint
libraries. After that I configured sharepoint to use forms
authentication with builtin AspNetSqlMembership provider, but this
action caused reports to not execute. I searched and found hotfix 3186
for this issue and applied it, but nothing has changed!
Error I have been experiencing is following:
An unexpected error occurred while connecting to the report server.
Verify that the report server is available and configured for
SharePoint integrated mode. --> The request failed with the error
message:
--
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl= %2f_vti_bin
%2fReportServer%2fReportService2006.asmx">here</a>.</h2>
</body></html>
anyone can help? maybe i have not configured something correctly...Irakli
It would be better of you post that question in .reportrtingsvcs or
sharepoint user group.
"Irakli" <Irakli.Rostiashvili@.gmail.com> wrote in message
news:5e330a25-f9bb-4657-9e26-e00a0ab96f6f@.m34g2000hsf.googlegroups.com...
> Well, I have reporting services 2005 installed and configured in
> sharepoint integrated mode, so I am deploying reports in sharepoint
> libraries. After that I configured sharepoint to use forms
> authentication with builtin AspNetSqlMembership provider, but this
> action caused reports to not execute. I searched and found hotfix 3186
> for this issue and applied it, but nothing has changed!
> Error I have been experiencing is following:
> An unexpected error occurred while connecting to the report server.
> Verify that the report server is available and configured for
> SharePoint integrated mode. --> The request failed with the error
> message:
> --
> <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a href="http://links.10026.com/?link=/_layouts/login.aspx?ReturnUrl=> %2f_vti_bin
> %2fReportServer%2fReportService2006.asmx">here</a>.</h2>
> </body></html>
> anyone can help? maybe i have not configured something correctly...

Reporting services 2005 extremely slow performance

I have installed Reporting 2005 as a part of SQL Server 2005 setup ( SQL
Server got upgraded from 2000 to 2005)
The general web interface is completely unresponsive!
It takes 5-10 seconds just to move between the tabs, not talking about
running reports.
I have dual Xeon 2.8Ghz machine with 3Gb of memory available - it should
respond momentarily.
Anyone with the same problem? Any ideas?
TIA.I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
a different port). SPS 2003 is very fast, but I need to wait 30s when I
click on a folder (just browse). My server is a HP 360 with 2 CPU +
4Go, I really don't understand :-(|||The first time RS starts up after a lag you will get a long pause like that.
This is an IIS thing. You can set timeout on the IIS application pools.
Go to IIS Manager, under Applocation Pools node, right click
"DefaultAppPool" in which the Reporting Server work process is running,
select properties. On "Performace" tag, you will see, by default, the app
pool will shut down if > being idle for 20 min. You can extend this time to
8x60min 480min, so that the app pool will not shut down for a regular
working day. However, the first report reader of the day, will hit the
delay. You may schedule a dummy report at beginning of a work day for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<pascal.brel@.gmail.com> wrote in message
news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
> a different port). SPS 2003 is very fast, but I need to wait 30s when I
> click on a folder (just browse). My server is a HP 360 with 2 CPU +
> 4Go, I really don't understand :-(
>|||That is not the case.
I tried everything - so far no luck.
Yes, it takes a while to load the CLR for the first time.
But the reposnse after that is still slow.
I can see a message on status bar - "downloading picture ..." of a really
small gif file for a few seconds and that is in a local mode!
Any other ideas?
Thanks.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
> The first time RS starts up after a lag you will get a long pause like
> that. This is an IIS thing. You can set timeout on the IIS application
> pools.
> Go to IIS Manager, under Applocation Pools node, right click
> "DefaultAppPool" in which the Reporting Server work process is running,
> select properties. On "Performace" tag, you will see, by default, the app
> pool will shut down if > being idle for 20 min. You can extend this time
> to 8x60min 480min, so that the app pool will not shut down for a regular
> working day. However, the first report reader of the day, will hit the
> delay. You may schedule a dummy report at beginning of a work day for
> this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <pascal.brel@.gmail.com> wrote in message
> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>|||OK, two different people on this thread. For Pascal I think it is the IIS
issue.
Oleg, is it only reports with an image? If so, where is the image stored
(database or external)? Also, initially you said just seeing the reports,
not running them. Once RS is spun up you should see the report listing
pretty instantaneously on your configuration. RS 2005 is faster than RS
2000, both for displaying report list and running the reports.
Just to make sure, this is from Report Manager, not from your own app?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
> That is not the case.
> I tried everything - so far no luck.
> Yes, it takes a while to load the CLR for the first time.
> But the reposnse after that is still slow.
> I can see a message on status bar - "downloading picture ..." of a really
> small gif file for a few seconds and that is in a local mode!
> Any other ideas?
> Thanks.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is running,
>> select properties. On "Performace" tag, you will see, by default, the
>> app pool will shut down if > being idle for 20 min. You can extend this
>> time to 8x60min 480min, so that the app pool will not shut down for a
>> regular working day. However, the first report reader of the day, will
>> hit the delay. You may schedule a dummy report at beginning of a work day
>> for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>|||My issue is the same as Pascal's one - slow Report Manager performance.
As mentioned before - the Report manager is slow. I'm not running any
reports yet.
It is very, very slow, when moving between pages within Report Manager
interface.
Even Report Manager's own small image files are loading extremely slow,
until they are cached.
I suspect it is an IIS issue. There are a lot of other web applications
running on the same IIS server, but they are fast.
The only problem is RS 2005.
Thanks.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
> OK, two different people on this thread. For Pascal I think it is the IIS
> issue.
> Oleg, is it only reports with an image? If so, where is the image stored
> (database or external)? Also, initially you said just seeing the reports,
> not running them. Once RS is spun up you should see the report listing
> pretty instantaneously on your configuration. RS 2005 is faster than RS
> 2000, both for displaying report list and running the reports.
> Just to make sure, this is from Report Manager, not from your own app?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is running,
>> select properties. On "Performace" tag, you will see, by default, the
>> app pool will shut down if > being idle for 20 min. You can extend this
>> time to 8x60min 480min, so that the app pool will not shut down for a
>> regular working day. However, the first report reader of the day, will
>> hit the delay. You may schedule a dummy report at beginning of a work
>> day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005 (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>|||It should be subsecond. Is this the only 2.0 framework app on your web
server?
The other possibility might be authentication. Still, you would think that
would only be right when you first connect.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
> My issue is the same as Pascal's one - slow Report Manager performance.
> As mentioned before - the Report manager is slow. I'm not running any
> reports yet.
> It is very, very slow, when moving between pages within Report Manager
> interface.
> Even Report Manager's own small image files are loading extremely slow,
> until they are cached.
> I suspect it is an IIS issue. There are a lot of other web applications
> running on the same IIS server, but they are fast.
> The only problem is RS 2005.
> Thanks.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the IIS
>> issue.
>> Oleg, is it only reports with an image? If so, where is the image stored
>> (database or external)? Also, initially you said just seeing the reports,
>> not running them. Once RS is spun up you should see the report listing
>> pretty instantaneously on your configuration. RS 2005 is faster than RS
>> 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is
>> running, select properties. On "Performace" tag, you will see, by
>> default, the app pool will shut down if > being idle for 20 min. You
>> can extend this time to 8x60min 480min, so that the app pool will not
>> shut down for a regular working day. However, the first report reader
>> of the day, will hit the delay. You may schedule a dummy report at
>> beginning of a work day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>> (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when
>> I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>>
>|||Posted initially in a wrong thread.
That is the only 2.0 app in the system yet.
Uninstalled SQL Server 2005, reinstalled it completely from scratch - same
problem.
In addition to the problem description I'd like to list some verbose logs of
simply changing pages within a Report manager
w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetProperties"
w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties('/')
w3wp!library!1!02/27/2006-11:55:26:: i INFO: Catalog SQL Server Edition =Enterprise
w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties
completed.
w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetSystemPermissions"
w3wp!library!1!02/27/2006-11:59:34:: i INFO: Call to GetSystemPermissions
As you see:
11:55:24 - SoapAction...
11:55:26:: v VERBOSE: Call to GetProperties('/')
took two seconds to execute
11:55:26:: v VERBOSE: Call to GetProperties completed.
11:59:34:: v VERBOSE: User map'<Users>.....
8 seconds beween calls.
from another log file:
w3wp!runningrequests!1!02/27/2006-11:59:28:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListSecureMethods"
w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: User
map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: SoapAction:
"http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetPolicies"
SoapAction ... -- took 7 seconds to execute
Seems like any SoapAction calls take a long time to execute in a local mode
on a very powerfull machine.
Question is why?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uTjABy9OGHA.1132@.TK2MSFTNGP10.phx.gbl...
> It should be subsecond. Is this the only 2.0 framework app on your web
> server?
> The other possibility might be authentication. Still, you would think that
> would only be right when you first connect.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
> news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
>> My issue is the same as Pascal's one - slow Report Manager performance.
>> As mentioned before - the Report manager is slow. I'm not running any
>> reports yet.
>> It is very, very slow, when moving between pages within Report Manager
>> interface.
>> Even Report Manager's own small image files are loading extremely slow,
>> until they are cached.
>> I suspect it is an IIS issue. There are a lot of other web applications
>> running on the same IIS server, but they are fast.
>> The only problem is RS 2005.
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the
>> IIS issue.
>> Oleg, is it only reports with an image? If so, where is the image stored
>> (database or external)? Also, initially you said just seeing the
>> reports, not running them. Once RS is spun up you should see the report
>> listing pretty instantaneously on your configuration. RS 2005 is faster
>> than RS 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause like
>> that. This is an IIS thing. You can set timeout on the IIS application
>> pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is
>> running, select properties. On "Performace" tag, you will see, by
>> default, the app pool will shut down if > being idle for 20 min. You
>> can extend this time to 8x60min 480min, so that the app pool will not
>> shut down for a regular working day. However, the first report reader
>> of the day, will hit the delay. You may schedule a dummy report at
>> beginning of a work day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>> (on
>> a different port). SPS 2003 is very fast, but I need to wait 30s when
>> I
>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>> 4Go, I really don't understand :-(
>>
>>
>>
>>
>|||Finally found a problem after looking into the System Event log. It was full
of complains about NETWORKSERVICE insufficient permissions.
Added Local Launch and Local Activation permissions of netman in DCOM config
screen to the NETWORKSERVICE account and it started to respond momentarily.
"Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
news:uc6exzkPGHA.2704@.TK2MSFTNGP15.phx.gbl...
> Posted initially in a wrong thread.
> That is the only 2.0 app in the system yet.
> Uninstalled SQL Server 2005, reinstalled it completely from scratch - same
> problem.
>
> In addition to the problem description I'd like to list some verbose logs
> of simply changing pages within a Report manager
> w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!1!02/27/2006-11:55:24:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetProperties"
> w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties('/')
> w3wp!library!1!02/27/2006-11:55:26:: i INFO: Catalog SQL Server Edition => Enterprise
> w3wp!library!1!02/27/2006-11:55:26:: v VERBOSE: Call to GetProperties
> completed.
> w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!1!02/27/2006-11:59:34:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetSystemPermissions"
> w3wp!library!1!02/27/2006-11:59:34:: i INFO: Call to GetSystemPermissions
> As you see:
> 11:55:24 - SoapAction...
> 11:55:26:: v VERBOSE: Call to GetProperties('/')
> took two seconds to execute
> 11:55:26:: v VERBOSE: Call to GetProperties completed.
> 11:59:34:: v VERBOSE: User map'<Users>.....
> 8 seconds beween calls.
> from another log file:
> w3wp!runningrequests!1!02/27/2006-11:59:28:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/ListSecureMethods"
> w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: User
> map'<Users><User><Name>WEB\aaa</Name><Paths><Path>http://localhost/ReportServer/ReportService2005.asmx</Path><NrReq>1</NrReq></Paths></User></Users>'
> w3wp!runningrequests!6!02/27/2006-11:59:35:: v VERBOSE: SoapAction:
> "http://schemas.microsoft.com/sqlserver/2005/06/30/reporting/reportingservices/GetPolicies"
> SoapAction ... -- took 7 seconds to execute
> Seems like any SoapAction calls take a long time to execute in a local
> mode on a very powerfull machine.
> Question is why?
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uTjABy9OGHA.1132@.TK2MSFTNGP10.phx.gbl...
>> It should be subsecond. Is this the only 2.0 framework app on your web
>> server?
>> The other possibility might be authentication. Still, you would think
>> that would only be right when you first connect.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:uQHu$L9OGHA.2704@.TK2MSFTNGP15.phx.gbl...
>> My issue is the same as Pascal's one - slow Report Manager performance.
>> As mentioned before - the Report manager is slow. I'm not running any
>> reports yet.
>> It is very, very slow, when moving between pages within Report Manager
>> interface.
>> Even Report Manager's own small image files are loading extremely slow,
>> until they are cached.
>> I suspect it is an IIS issue. There are a lot of other web applications
>> running on the same IIS server, but they are fast.
>> The only problem is RS 2005.
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwxL$diOGHA.3260@.TK2MSFTNGP11.phx.gbl...
>> OK, two different people on this thread. For Pascal I think it is the
>> IIS issue.
>> Oleg, is it only reports with an image? If so, where is the image
>> stored (database or external)? Also, initially you said just seeing the
>> reports, not running them. Once RS is spun up you should see the report
>> listing pretty instantaneously on your configuration. RS 2005 is faster
>> than RS 2000, both for displaying report list and running the reports.
>> Just to make sure, this is from Report Manager, not from your own app?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Oleg Yevteyev" <myfirstname001atgmaildotcom> wrote in message
>> news:O0d4L5ZOGHA.3284@.TK2MSFTNGP14.phx.gbl...
>> That is not the case.
>> I tried everything - so far no luck.
>> Yes, it takes a while to load the CLR for the first time.
>> But the reposnse after that is still slow.
>> I can see a message on status bar - "downloading picture ..." of a
>> really small gif file for a few seconds and that is in a local mode!
>> Any other ideas?
>> Thanks.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:eYsfgK%23NGHA.140@.TK2MSFTNGP12.phx.gbl...
>> The first time RS starts up after a lag you will get a long pause
>> like that. This is an IIS thing. You can set timeout on the IIS
>> application pools.
>> Go to IIS Manager, under Applocation Pools node, right click
>> "DefaultAppPool" in which the Reporting Server work process is
>> running, select properties. On "Performace" tag, you will see, by
>> default, the app pool will shut down if > being idle for 20 min. You
>> can extend this time to 8x60min 480min, so that the app pool will
>> not shut down for a regular working day. However, the first report
>> reader of the day, will hit the delay. You may schedule a dummy
>> report at beginning of a work day for this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <pascal.brel@.gmail.com> wrote in message
>> news:1140631396.770354.207790@.g44g2000cwa.googlegroups.com...
>>> I've the same problem. I have a server 2003 with SPS 2003 + RS 2005
>>> (on
>>> a different port). SPS 2003 is very fast, but I need to wait 30s
>>> when I
>>> click on a folder (just browse). My server is a HP 360 with 2 CPU +
>>> 4Go, I really don't understand :-(
>>>
>>
>>
>>
>>
>>
>

Reporting Services 2005 Error Creating Report Server Virtual Directory

Hi all,
I have SQL 2005 and WIndows 2003 Server, I am an adminsitrator and have
installed SQL 2005 Reporting Services. However when I got to configure
the reporting services the following happens
When creating a new report server virtual directory on our server, (I
am installing to the default web site and the default virtual directory
name 'ReportServer'.)
1) It creates the virtual directory and says The virtual directory was
created and assigned
2) this is followed by a green tick next to 'Change Secure Connection
Level'
3) This is immediatly followed by a message coming up stating
'ReportServicesConfigUI has encountered a problem and needs to close.
We are sorry for the inconvenience.'.
I cant help feeling that it hasnt finished this correctly as the
'Report Manager Virtual Directory' section is still greyed out and I
cannot enter it.
Any help would be greatly appreciated.
TomHi,
This sounds like a permission error. In addition, what version of Windows
2003 are you running?
Have you checked the Event Log? If so, what other possible errors do you see?
Thanks,
Phillip
"tom@.isolditonline.co.uk" wrote:
> Hi all,
> I have SQL 2005 and WIndows 2003 Server, I am an adminsitrator and have
> installed SQL 2005 Reporting Services. However when I got to configure
> the reporting services the following happens
> When creating a new report server virtual directory on our server, (I
> am installing to the default web site and the default virtual directory
> name 'ReportServer'.)
> 1) It creates the virtual directory and says The virtual directory was
> created and assigned
> 2) this is followed by a green tick next to 'Change Secure Connection
> Level'
> 3) This is immediatly followed by a message coming up stating
> 'ReportServicesConfigUI has encountered a problem and needs to close.
> We are sorry for the inconvenience.'.
> I cant help feeling that it hasnt finished this correctly as the
> 'Report Manager Virtual Directory' section is still greyed out and I
> cannot enter it.
> Any help would be greatly appreciated.
> Tom
>|||If I use IE 6 I have no problems. I can access and view parts of the date
with IE7, but the controls do not come up in the reports.
"Phillip MacPherson-Cox" <PhillipMacPhersonCox@.discussions.microsoft.com>
wrote in message news:1FD05115-7F89-470F-AF3E-4866154C7B53@.microsoft.com...
> Hi,
> This sounds like a permission error. In addition, what version of Windows
> 2003 are you running?
> Have you checked the Event Log? If so, what other possible errors do you
see?
> Thanks,
> Phillip
> "tom@.isolditonline.co.uk" wrote:
> > Hi all,
> >
> > I have SQL 2005 and WIndows 2003 Server, I am an adminsitrator and have
> > installed SQL 2005 Reporting Services. However when I got to configure
> > the reporting services the following happens
> >
> > When creating a new report server virtual directory on our server, (I
> > am installing to the default web site and the default virtual directory
> > name 'ReportServer'.)
> >
> > 1) It creates the virtual directory and says The virtual directory was
> > created and assigned
> > 2) this is followed by a green tick next to 'Change Secure Connection
> > Level'
> > 3) This is immediatly followed by a message coming up stating
> > 'ReportServicesConfigUI has encountered a problem and needs to close.
> > We are sorry for the inconvenience.'.
> >
> > I cant help feeling that it hasnt finished this correctly as the
> > 'Report Manager Virtual Directory' section is still greyed out and I
> > cannot enter it.
> >
> > Any help would be greatly appreciated.
> > Tom
> >
> >|||In the Event Log, I just get the following:
Source - NET Runtime 2.0 Error Reporting
Event ID - 5000
EventType clr20r3, P1 rsconfigtool.exe, P2 9.0.242.0, P3 443f597d, P4
rsconfigtool, P5 9.0.242.0, P6 443f597d, P7 154, P8 5, P9
system.nullreferenceexception, P10 NIL.
I am running on the local machine as an administrator.
The Windows 2003 Edition is Standard Edition.
Tom|||A uninstall of reporting services and re-install did the trick.
Tom
tom@.isolditonline.co.uk wrote:
> In the Event Log, I just get the following:
> Source - NET Runtime 2.0 Error Reporting
> Event ID - 5000
> EventType clr20r3, P1 rsconfigtool.exe, P2 9.0.242.0, P3 443f597d, P4
> rsconfigtool, P5 9.0.242.0, P6 443f597d, P7 154, P8 5, P9
> system.nullreferenceexception, P10 NIL.
> I am running on the local machine as an administrator.
> The Windows 2003 Edition is Standard Edition.
> Tom

Reporting services 2005 crashes

Hi All ,
I installed SQL server 2005 Enterprise edition 64 bit on windows server 2003
enterprise edition 64 bit machine.
I created a project and using a wizard created a report with Analysis
services cube as a datasource.Preview works fine but when I try to fix the
fonts or add elements and try to save it it crashes.How ever with out saving
I build the report or use the debug it works fine for the first time the next
time all the columns are deleted from the dataset.
I reproduced this problem thrice using diffrent prifile logons and creating
the project in different drives.
Thank you .
Rose.Applied Service pack noweverything seems good.
"Rose" wrote:
> Hi All ,
> I installed SQL server 2005 Enterprise edition 64 bit on windows server 2003
> enterprise edition 64 bit machine.
> I created a project and using a wizard created a report with Analysis
> services cube as a datasource.Preview works fine but when I try to fix the
> fonts or add elements and try to save it it crashes.How ever with out saving
> I build the report or use the debug it works fine for the first time the next
> time all the columns are deleted from the dataset.
> I reproduced this problem thrice using diffrent prifile logons and creating
> the project in different drives.
>
> Thank you .
> Rose.

Reporting Services 2005 and SQL Server 2000

Can you use SQL Server Reporting Services that comes with SQL Server 2005 and
have that be the only thing that is installed on a SQL Server 2000 box? I
need to use reporting services with Whidbey but want to use them against a
SQL Server 2000 machine.
Thanks!Yes you can
It's the same format
"Raventhorn" <Raventhorn@.discussions.microsoft.com> a écrit dans le message
de news: 24F341CB-AFD9-4CE2-AF81-4D55C2521B73@.microsoft.com...
> Can you use SQL Server Reporting Services that comes with SQL Server 2005
> and
> have that be the only thing that is installed on a SQL Server 2000 box? I
> need to use reporting services with Whidbey but want to use them against a
> SQL Server 2000 machine.
> Thanks!

Reporting services 2005

Hello,

I installed SQL Server 2005 into a Windows 2005 Pro machine, I have following question:

1. will I be able to use Reporting services to deploy the reports to the same machine as a report server?

2. Can I modify and deploy mo old reports written in RS2000

3. Is there any web site that show step by step how I can work with RS2005?

Thanks,

for the first question, of course, you can
for the third question, you can view the tutorial on reporting servicein sqlserver2005 help, first you should install both 'adventurework'database and 'adventureworkdw'database which are used in the tutorial.The install manual is also in sqlserver2005 help

Reporting services 2005

Hi,
I've installed SQL server 2005 with both service packs on my std 2003
server. The application I'm using requires reporting services 2005 as
well but I can't find it within SQL. Is it part of the SQL 2005 suite as
I couldn't find it within the standard intstall? Do I need to install
seperately from the installation disk?
Thanks,
AndrewWhat version of SQL Server are you installing. For 2005 it is on the
installation disks.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Andrew" <andrew@.rd.com> wrote in message
news:OS6PflVyHHA.3364@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I've installed SQL server 2005 with both service packs on my std 2003
> server. The application I'm using requires reporting services 2005 as well
> but I can't find it within SQL. Is it part of the SQL 2005 suite as I
> couldn't find it within the standard intstall? Do I need to install
> seperately from the installation disk?
> Thanks,
> Andrew

Reporting Services 2000 SP2 fails

I have installed SP2 successfully a number of times before, but always where the Report Server and the Report Server databases were on the same box. This is the first time trying to install the Service Pack where the Report Server is on server X and the databases are on server Y.

When I try to run the SP (on server X), I get the following message:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I am logged in using a domain account that is a local admin on both servers (and also the SQL Server startup account on server Y). It is also the account used by the Report Server to connect to the RS databases. The startup account for the Report Server service is 'NT AUTHORITY\NETWORK SERVICE'.

Hi,

Try to change the SSRS service account to a domain account, and add this account to your SSRS database server and map to your SSRS database. Also, you should add this account to the RsExecRole role.

I hope it helps.

Regards,

Janos

Reporting Services 2000 Requirement for Visual Studio

I have a client who already has SQL-2000 SP4 installed and now wishes
to have reporting services installed.
The installation indicates a pre-requisite of Visual Sudio .Net 2003.
Further investigation on Microsoft web site reveals that VS would have
to be version "Enterprise Developer" or "Enterprise Architect."
I know in SQL 2005 that VS is included. One option presented to the
client would be to upgrade.
My question is, was any form of visual studio included with SQL 2000
or will the client need to purchase a license for Visual Studio .Net
2003? Is VS .Net 2003 even still available?
Thanks in advance.
DanThat is some information which is not quite true...
> The installation indicates a pre-requisite of Visual Sudio .Net 2003.
> Further investigation on Microsoft web site reveals that VS would have
> to be version "Enterprise Developer" or "Enterprise Architect."
No, you will just need a one-language version of Visual Studio, thats
all, without nailing me down on the price, that should be around 100$.
> I know in SQL 2005 that VS is included. One option presented to the
> client would be to upgrade.
Sort of. You will be able to create Report / Analysis and SSIS
projects with the "small" edition of this studio.
> My question is, was any form of visual studio included with SQL 2000
> or will the client need to purchase a license for Visual Studio .Net
> 2003?
No, there was non included. Yes, he would have to buy a licencse for
that, see the above mentioned answer.
> Is VS .Net 2003 even still available?
-Yes, it is. I assume that not all vendors of your choice will still
have it, but it is available in some places. Perhaps you might find a
version on ebay which was exchanged by someone with the 2k5 version.
HTH, Jens K. Suessmeyer
--
http://www.sqlserver2005.de
--|||First off, you need any product that has VS 2003, it definitely does NOT
need to be Enterprise Developer or Enterprise Architect. Very definitely
not. The cheapest way is to get VB.Net 2003, it used to cost about $100.
However, I don't know how you go about finding a copy to buy.
Now, if Enterprise Developer is the only one that you can find to purchase
it will work but any product that comes with VS 2003 will work.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<dan.dunkin@.at-net.net> wrote in message
news:dn34t25397nlkhi59fb3sgjn21qh8kdfan@.4ax.com...
>I have a client who already has SQL-2000 SP4 installed and now wishes
> to have reporting services installed.
> The installation indicates a pre-requisite of Visual Sudio .Net 2003.
> Further investigation on Microsoft web site reveals that VS would have
> to be version "Enterprise Developer" or "Enterprise Architect."
> I know in SQL 2005 that VS is included. One option presented to the
> client would be to upgrade.
> My question is, was any form of visual studio included with SQL 2000
> or will the client need to purchase a license for Visual Studio .Net
> 2003? Is VS .Net 2003 even still available?
> Thanks in advance.
> Dan|||The MS web site says enterprise developer or architect are the only
ones that talk to SQL Server as opposed to destop databases (Access,
SQL Desktop). Do they mean something else (like you only need
enterprise for applications that directly access the database not
reports that will be run through report writer)?
On a side note, will Visual Studio 2005 Express (the free one) work?
Will any version of Visual Studio 2005 work?
Thanks!
On Tue, 13 Feb 2007 13:40:52 -0600, "Bruce L-C [MVP]"
<bruce_lcNOSPAM@.hotmail.com> wrote:
>First off, you need any product that has VS 2003, it definitely does NOT
>need to be Enterprise Developer or Enterprise Architect. Very definitely
>not. The cheapest way is to get VB.Net 2003, it used to cost about $100.
>However, I don't know how you go about finding a copy to buy.
>Now, if Enterprise Developer is the only one that you can find to purchase
>it will work but any product that comes with VS 2003 will work.|||Don=B4t know, but the information given by Bruce and me is valid. You
might want to share the link with us where this statement resides.
-Jens.
--
http://www.sqlserver2005.de
--|||In this case it is a little different. You are only using VS to have
something to install the report designer into. So in this case what you are
reading about is something else entirely.
RS 2000 requires some version of VS 2003. Neither of the two you mention
will work. They use a different version of the framework (2.0 instead of 1.1
that RS 2000 uses).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<dan.dunkin@.at-net.net> wrote in message
news:gu64t21phn1tcq8mga7kprscoii7u9jfm2@.4ax.com...
> The MS web site says enterprise developer or architect are the only
> ones that talk to SQL Server as opposed to destop databases (Access,
> SQL Desktop). Do they mean something else (like you only need
> enterprise for applications that directly access the database not
> reports that will be run through report writer)?
> On a side note, will Visual Studio 2005 Express (the free one) work?
> Will any version of Visual Studio 2005 work?
> Thanks!
> On Tue, 13 Feb 2007 13:40:52 -0600, "Bruce L-C [MVP]"
> <bruce_lcNOSPAM@.hotmail.com> wrote:
>>First off, you need any product that has VS 2003, it definitely does NOT
>>need to be Enterprise Developer or Enterprise Architect. Very definitely
>>not. The cheapest way is to get VB.Net 2003, it used to cost about $100.
>>However, I don't know how you go about finding a copy to buy.
>>Now, if Enterprise Developer is the only one that you can find to purchase
>>it will work but any product that comes with VS 2003 will work.|||THANK YOU! for everyone's help.
Dan

reporting services 2000 installation problem

Hi all, I recently installed Reporting Services 2000 on my server for the
first time and it caused my existing web apps to stop functioning. I have a
few custom dlls in the GAC and I had to end up re-registering them in the
GAC and restart iis services. That fixed my apps not working. But now, for
some reason Report Manager will not work. Here is what I get:-
Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: Required permissions cannot be acquired.
Source Error:
Line 256: <add assembly="System.EnterpriseServices,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 257: <add assembly="System.Web.Mobile,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
Line 258: <add assembly="Appone.Data.Services,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=1949095674c58f09" />
Line 259: <add assembly="Appone.Web.Security,
Version=1.0.0.0, Culture=neutral, PublicKeyToken=7b58630078eb0f75" />
Line 260: <add assembly="Appone.Web.Config, Version=1.0.0.0,
Culture=neutral, PublicKeyToken=01a8235a19f330a7" />
Source File:
c:\windows\microsoft.net\framework\v1.1.4322\Config\machine.config Line:
258
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032
Any ideas? What can I do to fix this?
TIA,
ParamOK just came in this morning and everything was down. Had to re-register
dlls into GAC and restart again and now seems to be back up. Except Report
Manager still does not work.
thanks
"Param R." <pr@.nospam.com> wrote in message
news:uENazG6BFHA.2012@.TK2MSFTNGP15.phx.gbl...
> Hi all, I recently installed Reporting Services 2000 on my server for the
> first time and it caused my existing web apps to stop functioning. I have
> a few custom dlls in the GAC and I had to end up re-registering them in
> the GAC and restart iis services. That fixed my apps not working. But now,
> for some reason Report Manager will not work. Here is what I get:-
> Configuration Error
> Description: An error occurred during the processing of a configuration
> file required to service this request. Please review the specific error
> details below and modify your configuration file appropriately.
> Parser Error Message: Required permissions cannot be acquired.
> Source Error:
>
> Line 256: <add assembly="System.EnterpriseServices,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> Line 257: <add assembly="System.Web.Mobile,
> Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
> Line 258: <add assembly="Appone.Data.Services,
> Version=2.0.0.0, Culture=neutral, PublicKeyToken=1949095674c58f09" />
> Line 259: <add assembly="Appone.Web.Security,
> Version=1.0.0.0, Culture=neutral, PublicKeyToken=7b58630078eb0f75" />
> Line 260: <add assembly="Appone.Web.Config,
> Version=1.0.0.0, Culture=neutral, PublicKeyToken=01a8235a19f330a7" />
>
> Source File:
> c:\windows\microsoft.net\framework\v1.1.4322\Config\machine.config
> Line: 258
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
> ASP.NET Version:1.1.4322.2032
> Any ideas? What can I do to fix this?
> TIA,
> Param
>sql