I have a report in SQL 2000 Reporting Services with several tables.
The only thing showing in these tables are the group footers because
the detail data is not needed.
I am needing to add a total for a column in each table and then add
those totals together in a text box.
When ever I do this I am getting the following errors:
The value expression for the text box 'textbox58' uses an aggregate
function on a report item. Aggregate functions can be used only on
report items contained in page headers and footers.
The value expression for the text box 'textbox37' uses an aggregate
expression without a scope. A scope is required for all aggregates
used outside of a data region unless the report contains exactly one
data set.
I've tried several different ways and still can't figure it out, PLEASE
HELP!!A few design suggestions. If you don't need the detail then don't return it.
Let SQL Server do the work. But, let's say you continue the way you are
today. What I do sometimes is to add a colum to the result set and make it
calculated, then using the expression editor make it the sum of the two
fields. This makes things a whole lot easier at times.
Once you have done this you can use the expression editor, base it on the
dataset and sum up the column.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<jasper.frazee@.gmail.com> wrote in message
news:1162406083.894334.80910@.k70g2000cwa.googlegroups.com...
>I have a report in SQL 2000 Reporting Services with several tables.
> The only thing showing in these tables are the group footers because
> the detail data is not needed.
> I am needing to add a total for a column in each table and then add
> those totals together in a text box.
> When ever I do this I am getting the following errors:
> The value expression for the text box 'textbox58' uses an aggregate
> function on a report item. Aggregate functions can be used only on
> report items contained in page headers and footers.
> The value expression for the text box 'textbox37' uses an aggregate
> expression without a scope. A scope is required for all aggregates
> used outside of a data region unless the report contains exactly one
> data set.
> I've tried several different ways and still can't figure it out, PLEASE
> HELP!!
>|||Thanks for the Responce Bruce!
In my dataset there are 5 columns that will alwayse have the same
result and one column that has detail data that needs to be summed. If
I sum that one column in SQL I have to have the other columns in an
aggregate function as well. In SQL 2000 the "First" function is not
supported. Any ways around that?
Once I get the totals in each table on my report how can I grab those
totals and sum them in a textbox? It keeps telling me that "Aggregate
functions can be used only on
report items contained in page headers and footers."
Thanks A Lot!
Jasper
Bruce L-C [MVP] wrote:
> A few design suggestions. If you don't need the detail then don't return it.
> Let SQL Server do the work. But, let's say you continue the way you are
> today. What I do sometimes is to add a colum to the result set and make it
> calculated, then using the expression editor make it the sum of the two
> fields. This makes things a whole lot easier at times.
> Once you have done this you can use the expression editor, base it on the
> dataset and sum up the column.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <jasper.frazee@.gmail.com> wrote in message
> news:1162406083.894334.80910@.k70g2000cwa.googlegroups.com...
> >I have a report in SQL 2000 Reporting Services with several tables.
> > The only thing showing in these tables are the group footers because
> > the detail data is not needed.
> > I am needing to add a total for a column in each table and then add
> > those totals together in a text box.
> > When ever I do this I am getting the following errors:
> >
> > The value expression for the text box 'textbox58' uses an aggregate
> > function on a report item. Aggregate functions can be used only on
> > report items contained in page headers and footers.
> >
> > The value expression for the text box 'textbox37' uses an aggregate
> > expression without a scope. A scope is required for all aggregates
> > used outside of a data region unless the report contains exactly one
> > data set.
> >
> > I've tried several different ways and still can't figure it out, PLEASE
> > HELP!!
> >|||You can sum the numbers by summing =ReportItems("textbox1").Value +
ReportItems("textbox2").Value etc.
You need to know the names of the textboxes, so you might want to name the
textboxes with something more descriptive than textbox1 etc before you start
summing. :)
(Not sure if it's ReportItems or ReportItem, so you might have to try both.)
Kaisa M. Lindahl Lervik
<jasper.frazee@.gmail.com> wrote in message
news:1162417277.149051.147270@.f16g2000cwb.googlegroups.com...
> Thanks for the Responce Bruce!
> In my dataset there are 5 columns that will alwayse have the same
> result and one column that has detail data that needs to be summed. If
> I sum that one column in SQL I have to have the other columns in an
> aggregate function as well. In SQL 2000 the "First" function is not
> supported. Any ways around that?
> Once I get the totals in each table on my report how can I grab those
> totals and sum them in a textbox? It keeps telling me that "Aggregate
> functions can be used only on
> report items contained in page headers and footers."
> Thanks A Lot!
> Jasper
> Bruce L-C [MVP] wrote:
>> A few design suggestions. If you don't need the detail then don't return
>> it.
>> Let SQL Server do the work. But, let's say you continue the way you are
>> today. What I do sometimes is to add a colum to the result set and make
>> it
>> calculated, then using the expression editor make it the sum of the two
>> fields. This makes things a whole lot easier at times.
>> Once you have done this you can use the expression editor, base it on the
>> dataset and sum up the column.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <jasper.frazee@.gmail.com> wrote in message
>> news:1162406083.894334.80910@.k70g2000cwa.googlegroups.com...
>> >I have a report in SQL 2000 Reporting Services with several tables.
>> > The only thing showing in these tables are the group footers because
>> > the detail data is not needed.
>> > I am needing to add a total for a column in each table and then add
>> > those totals together in a text box.
>> > When ever I do this I am getting the following errors:
>> >
>> > The value expression for the text box 'textbox58' uses an aggregate
>> > function on a report item. Aggregate functions can be used only on
>> > report items contained in page headers and footers.
>> >
>> > The value expression for the text box 'textbox37' uses an aggregate
>> > expression without a scope. A scope is required for all aggregates
>> > used outside of a data region unless the report contains exactly one
>> > data set.
>> >
>> > I've tried several different ways and still can't figure it out, PLEASE
>> > HELP!!
>> >
>sql
Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts
Thursday, March 29, 2012
Can't start transactional replication SQL 2005. System.OutOfMemory Exception during start
We currently use log shipping to 2 other servers for reporting. We
want to use transactional replication instead, so that our reporting
databases are always available (when the restore agent runs the
database is unavailable for a few seconds) and to reduce the latency
between changes in the main database appearing in our reporting
database.
I've successfully got replication to work on a test scenario (with
only a few thousand rows) but when I try and get transactional
replication going on our production site I get a System.OutOfMemory
exception when performing the snapshot. It fails at about 40 percent
of one of our larger tables (157 million rows.) The database backup
is about 27GB.
The hardware has 4GB memory, 2 dual core x86 running 32bit Windows
Server 2003.
We are running SQL2005 Standard edtion SP2, but I had the same problem
on SP1.
I've tried the /3GB switch.
I've tried putting the distrubutor on the main server, and on a
seperate server, and on the reporting box.
I've tried pull and push subscriptions.
I'm going to try a row filter to pull only the most recent data (to
drop the number of rows) and see at what point it fails, but this is a
fairly long interative process. And we do need all the data in the
end.
I'm looking for advice, has anybody else had similar problems?
Is there a way to start replication from a restored database?
I'm considering installing more Memory - but am unsure how to estimate
how much more memory we need. Also our machines run fine with 4GB of
memory normally; I can't really afford to buy more memory just to
"start" the replication process going (but of course I guess this
depends on how much more I would need!)
Daniel Bryars
This is something that I would really like to have a closer look so let me
ask you a few questions:
1) Is snapshot.exe consuming a large amount of memory according to taskmgr?
2) Do you have a pagefile configured on the distributor machine? I have
heard of one case where disabling the pagefile seemed to be the cause of OOM
error in the snapshot agent. I suspect that this may have something to do
with the use of memory mapped file in the underlying BCP api but I was never
able to prove one way or another.
3) Do you have a large amount of blob column data?
If possible, you may also want to consider upgrading your software stack at
your distributor (OS + SQL Server) to 64bit as it is quite possible that you
are running out of address space range. Most dual-core processors should
already be capable of running in 64bit mode.
-Raymond
<bryars@.hotmail.com> wrote in message
news:1174821642.773195.15500@.e65g2000hsc.googlegro ups.com...
> We currently use log shipping to 2 other servers for reporting. We
> want to use transactional replication instead, so that our reporting
> databases are always available (when the restore agent runs the
> database is unavailable for a few seconds) and to reduce the latency
> between changes in the main database appearing in our reporting
> database.
> I've successfully got replication to work on a test scenario (with
> only a few thousand rows) but when I try and get transactional
> replication going on our production site I get a System.OutOfMemory
> exception when performing the snapshot. It fails at about 40 percent
> of one of our larger tables (157 million rows.) The database backup
> is about 27GB.
> The hardware has 4GB memory, 2 dual core x86 running 32bit Windows
> Server 2003.
> We are running SQL2005 Standard edtion SP2, but I had the same problem
> on SP1.
> I've tried the /3GB switch.
> I've tried putting the distrubutor on the main server, and on a
> seperate server, and on the reporting box.
> I've tried pull and push subscriptions.
> I'm going to try a row filter to pull only the most recent data (to
> drop the number of rows) and see at what point it fails, but this is a
> fairly long interative process. And we do need all the data in the
> end.
> I'm looking for advice, has anybody else had similar problems?
> Is there a way to start replication from a restored database?
> I'm considering installing more Memory - but am unsure how to estimate
> how much more memory we need. Also our machines run fine with 4GB of
> memory normally; I can't really afford to buy more memory just to
> "start" the replication process going (but of course I guess this
> depends on how much more I would need!)
> Daniel Bryars
>
want to use transactional replication instead, so that our reporting
databases are always available (when the restore agent runs the
database is unavailable for a few seconds) and to reduce the latency
between changes in the main database appearing in our reporting
database.
I've successfully got replication to work on a test scenario (with
only a few thousand rows) but when I try and get transactional
replication going on our production site I get a System.OutOfMemory
exception when performing the snapshot. It fails at about 40 percent
of one of our larger tables (157 million rows.) The database backup
is about 27GB.
The hardware has 4GB memory, 2 dual core x86 running 32bit Windows
Server 2003.
We are running SQL2005 Standard edtion SP2, but I had the same problem
on SP1.
I've tried the /3GB switch.
I've tried putting the distrubutor on the main server, and on a
seperate server, and on the reporting box.
I've tried pull and push subscriptions.
I'm going to try a row filter to pull only the most recent data (to
drop the number of rows) and see at what point it fails, but this is a
fairly long interative process. And we do need all the data in the
end.
I'm looking for advice, has anybody else had similar problems?
Is there a way to start replication from a restored database?
I'm considering installing more Memory - but am unsure how to estimate
how much more memory we need. Also our machines run fine with 4GB of
memory normally; I can't really afford to buy more memory just to
"start" the replication process going (but of course I guess this
depends on how much more I would need!)
Daniel Bryars
This is something that I would really like to have a closer look so let me
ask you a few questions:
1) Is snapshot.exe consuming a large amount of memory according to taskmgr?
2) Do you have a pagefile configured on the distributor machine? I have
heard of one case where disabling the pagefile seemed to be the cause of OOM
error in the snapshot agent. I suspect that this may have something to do
with the use of memory mapped file in the underlying BCP api but I was never
able to prove one way or another.
3) Do you have a large amount of blob column data?
If possible, you may also want to consider upgrading your software stack at
your distributor (OS + SQL Server) to 64bit as it is quite possible that you
are running out of address space range. Most dual-core processors should
already be capable of running in 64bit mode.
-Raymond
<bryars@.hotmail.com> wrote in message
news:1174821642.773195.15500@.e65g2000hsc.googlegro ups.com...
> We currently use log shipping to 2 other servers for reporting. We
> want to use transactional replication instead, so that our reporting
> databases are always available (when the restore agent runs the
> database is unavailable for a few seconds) and to reduce the latency
> between changes in the main database appearing in our reporting
> database.
> I've successfully got replication to work on a test scenario (with
> only a few thousand rows) but when I try and get transactional
> replication going on our production site I get a System.OutOfMemory
> exception when performing the snapshot. It fails at about 40 percent
> of one of our larger tables (157 million rows.) The database backup
> is about 27GB.
> The hardware has 4GB memory, 2 dual core x86 running 32bit Windows
> Server 2003.
> We are running SQL2005 Standard edtion SP2, but I had the same problem
> on SP1.
> I've tried the /3GB switch.
> I've tried putting the distrubutor on the main server, and on a
> seperate server, and on the reporting box.
> I've tried pull and push subscriptions.
> I'm going to try a row filter to pull only the most recent data (to
> drop the number of rows) and see at what point it fails, but this is a
> fairly long interative process. And we do need all the data in the
> end.
> I'm looking for advice, has anybody else had similar problems?
> Is there a way to start replication from a restored database?
> I'm considering installing more Memory - but am unsure how to estimate
> how much more memory we need. Also our machines run fine with 4GB of
> memory normally; I can't really afford to buy more memory just to
> "start" the replication process going (but of course I guess this
> depends on how much more I would need!)
> Daniel Bryars
>
Tuesday, March 27, 2012
Can't start ReportServer service
Hello
I having problem to start ReportServer service after our Network administrator reboot the reporting server. Getting an error: "Error 1075: The dependency service does not exist or has been marked for deletion."
This is an error message from Event Viewer: "The ReportServer service depends on the following nonexistent service: mssqlserver"
First there are no explicit dependencies, second we have sql server installed on different machine. Any ideas how to fix it? Would appriciate any help.
Is this RS 2005? Early versions of RS2000 had a dependency on SQL Server, but this has not been the case for sometime and never in a released version. Is it possible this was an upgrade from an early 2000 beta?
The best option might be to uninstall RS then reinstall, hooking up to the old DB. Make sure you back up your symmetric key first or you will have to reenter all credentials.
Cant start report server
Hey all. I'm using SQL server Express and I've installed the Report service. When I go into the reporting services configuration manager and I want to start the service, the system won't let me. Here is the error
System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
I just can't seem to be able to start the service.
Can you plz help?
Thanks
Hi,
Based on my understanding, this error message is caused by the permission issue. You should take a look at the Report Server logs, and make sure you are configuring locally and you are administrator on the machine. And re-modify your reporting service configuration in the following way:
1. Created ReportService database using Report Service Configuration
2. Edited your personal account to Web Service Account in rsreportserver.config
3. Used rsconfig utility to encrypt the connection and account information
4. Edited your personal account to <processModel userName=" " >
If the problem still exists, you should try the following methods.
Set the Report Server Web service and Report Manager to use the same application pool.
|||Thank you for your answer. But how can I create a reportservice database if I can't connect to the service?
++ Where do I go to
Set the Report Server Web service and Report Manager to use the same application pool.
Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.
|||Hi,
Set the Report Server Web service and Report Manager to use the same application pool.
Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.
Sunday, March 25, 2012
Can't start 2005 Report Services on XP SP2
Hej,
I am attempting to get a test environment up and running on my XP SP2
machine but I can't start reporting services. I found the following log in
the Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles directory:
ReportingServicesService!servicecontroller!4!28-03-2006-09:27:22:: e ERROR:
Exception caught starting RPC server:
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
The user or group name 'ANEISHA\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean
firstTime)
Anybody have any clues?
Thanks in advance,
Antony C. Roberts.In desperation, I created an ASPNET user and gave it all possible roles.
That solved the problem... What is the CORRECT solution to this problem?
Thanks!
/Ant.
"Antony C. Roberts" <acr@.no.way.com> wrote in message
news:ONFgYrjUGHA.1444@.TK2MSFTNGP11.phx.gbl...
> Hej,
> I am attempting to get a test environment up and running on my XP SP2
> machine but I can't start reporting services. I found the following log in
> the Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles directory:
> ReportingServicesService!servicecontroller!4!28-03-2006-09:27:22:: e
> ERROR: Exception caught starting RPC server:
> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
> The user or group name 'ANEISHA\ASPNET' is not recognized.
> at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
> at
> Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean
> firstTime)
> Anybody have any clues?
> Thanks in advance,
> Antony C. Roberts.
>
I am attempting to get a test environment up and running on my XP SP2
machine but I can't start reporting services. I found the following log in
the Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles directory:
ReportingServicesService!servicecontroller!4!28-03-2006-09:27:22:: e ERROR:
Exception caught starting RPC server:
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
The user or group name 'ANEISHA\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean
firstTime)
Anybody have any clues?
Thanks in advance,
Antony C. Roberts.In desperation, I created an ASPNET user and gave it all possible roles.
That solved the problem... What is the CORRECT solution to this problem?
Thanks!
/Ant.
"Antony C. Roberts" <acr@.no.way.com> wrote in message
news:ONFgYrjUGHA.1444@.TK2MSFTNGP11.phx.gbl...
> Hej,
> I am attempting to get a test environment up and running on my XP SP2
> machine but I can't start reporting services. I found the following log in
> the Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles directory:
> ReportingServicesService!servicecontroller!4!28-03-2006-09:27:22:: e
> ERROR: Exception caught starting RPC server:
> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
> The user or group name 'ANEISHA\ASPNET' is not recognized.
> at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
> at
> Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean
> firstTime)
> Anybody have any clues?
> Thanks in advance,
> Antony C. Roberts.
>
Tuesday, March 20, 2012
Can't see the Report Manager page
Hi There,
I have installed the Sql Server 2005 reporting services and I see that two default directories being created in IIS (Report and ReportServer..). For some reason, if I type http://localhost/reports, I am unable to see the report manager homepage. Can anybody suggest me if I need to configure any more stuff to see the report manager?
I enabled the anonymous authentication and still cannot see....
I can see the webservice however by typing http://localhost/reportserver...
Any suggestions are greatly apprecaited...
Thanks.
Sam.
I got it. I had to set up the reportserver to be accessible anonymous along with Reports.
Thanks.
Can't see reportserver and reports applications
I'm trying to use Reporting Services 2005. The service is running, but if I
type http://192.168.1.49:8888/reportserver I see the directory list.
With http://192.1681.49:8888/reports, I see an error: The request failed
with HTTP status 503: Service Unavailable.The error is in URL.
http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
inside the application.
I'm completely stuck. What can I do or where can I search?
--
Regards,
Diego F.Google is your friend. Type in "reporting services" 503 "service
unavailable" and you'll get quite a lot of info. Not all of it is directly
connected to Reporting Services, but you should be able to pick up some info
on the 503 problem in general. It seems that there's a problem with the
Reporting Services web service.
Are you allowed to log on to the actual server and try running Report
Manager from that box?
What sort of authentication is set?
Try adding the report server site to your Trusted sites in IE, and then
change the Security Settings for Trusted Sites to "Prompt for user name and
password" in User Authentication - Logon. Type in your username and
password. If it fails, that might be what causes the problem. In that case,
you need to figure out what rights are needed for you to access the reports.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
> I'm trying to use Reporting Services 2005. The service is running, but if
> I type http://192.168.1.49:8888/reportserver I see the directory list.
> With http://192.1681.49:8888/reports, I see an error: The request failed
> with HTTP status 503: Service Unavailable.The error is in URL.
> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
> inside the application.
> I'm completely stuck. What can I do or where can I search?
> --
> Regards,
> Diego F.
>|||Hi again.
I installed again the whole server: Window 2003 and SQL Server 2005 full.
Now I finally see the reports site :-)
There is a Visual Studio installed with SQL 2005 and I can design reports
there. But now I don't know how to configure the project to deploy
correctly.
I get that error:
A connection could not be made to the report server http://localhost/reports
Additional information:
The attempt to connect to the report server failed. Check your connection
information and the report server is a compatible version.
(Microsoft.ReportingServices.Designer).
If I try with: http://localhost/reportserver then I get a compilation error:
The Report Server Windows Service ReportServer is not running. The service
must be running to use the Report Server.
How can I solve that?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
> Google is your friend. Type in "reporting services" 503 "service
> unavailable" and you'll get quite a lot of info. Not all of it is directly
> connected to Reporting Services, but you should be able to pick up some
> info on the 503 problem in general. It seems that there's a problem with
> the Reporting Services web service.
> Are you allowed to log on to the actual server and try running Report
> Manager from that box?
> What sort of authentication is set?
> Try adding the report server site to your Trusted sites in IE, and then
> change the Security Settings for Trusted Sites to "Prompt for user name
> and password" in User Authentication - Logon. Type in your username and
> password. If it fails, that might be what causes the problem. In that
> case, you need to figure out what rights are needed for you to access the
> reports.
> Kaisa M. Lindahl
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but if
>> I type http://192.168.1.49:8888/reportserver I see the directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request failed
>> with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
>> inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>|||Open IIS, a.k.a Internet Information Services Manager
Open your Reports site, is probably under Web SItes - Default Web Site.
RIght click and choose Browse. Does it open correctly?
If it does, what is the URL? I did a test install of the 2005 edition, and I
think you might get some extra "name" or something, like
http://localhost/reports$instancename
Which means that the reports are still there, but the URL might have
changed. Or something.
Also, with Sql Server 2005 there's an nice Reporting Services configuration
tool. Start it and look to see if there are any things that needs to be
started.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
> Hi again.
> I installed again the whole server: Window 2003 and SQL Server 2005 full.
> Now I finally see the reports site :-)
> There is a Visual Studio installed with SQL 2005 and I can design reports
> there. But now I don't know how to configure the project to deploy
> correctly.
> I get that error:
> A connection could not be made to the report server
> http://localhost/reports
> Additional information:
> The attempt to connect to the report server failed. Check your
> connection information and the report server is a compatible version.
> (Microsoft.ReportingServices.Designer).
> If I try with: http://localhost/reportserver then I get a compilation
> error:
> The Report Server Windows Service ReportServer is not running. The service
> must be running to use the Report Server.
> How can I solve that?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to pick
>> up some info on the 503 problem in general. It seems that there's a
>> problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access the
>> reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request failed
>> with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>|||I finally uploaded a report. I made it with Visual Studio 2005 installed by
SQL Server 2005. I made a report and deployed it, and in the Report Manager
shows the new report, but I can't see it because:
- 'The report server cannot process the report. The data source connection
information has been deleted. (rsInvalidDataSourceReference).
I made the connection with the project.
If I'm understanding something, is it the idea to have all the reports in
the server, and the applications should link to that URL to load the report?
Thanks a lot for your help. I really appreciate.
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
> Open IIS, a.k.a Internet Information Services Manager
> Open your Reports site, is probably under Web SItes - Default Web Site.
> RIght click and choose Browse. Does it open correctly?
> If it does, what is the URL? I did a test install of the 2005 edition, and
> I think you might get some extra "name" or something, like
> http://localhost/reports$instancename
> Which means that the reports are still there, but the URL might have
> changed. Or something.
> Also, with Sql Server 2005 there's an nice Reporting Services
> configuration tool. Start it and look to see if there are any things that
> needs to be started.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005 full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design reports
>> there. But now I don't know how to configure the project to deploy
>> correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to pick
>> up some info on the 503 problem in general. It seems that there's a
>> problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access
>> the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>|||I did the process again and now -don't ask me why- it shows the report.
Then, as I asked you before, is the idea to create all the reports I need
and upload to the server?
My idea is to intergate that in a web application, so I expected to show
just the report by clicking a button. Is that possible?
And last but not least ;-), is it possible to dinamically -by code- generate
the reports temporally? I have all my queries as stored procedures.
Thanks a lot!
--
Regards,
Diego F.
"Diego F." <diegofrNO@.terra.es> escribió en el mensaje
news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>I finally uploaded a report. I made it with Visual Studio 2005 installed by
>SQL Server 2005. I made a report and deployed it, and in the Report Manager
>shows the new report, but I can't see it because:
> - 'The report server cannot process the report. The data source connection
> information has been deleted. (rsInvalidDataSourceReference).
> I made the connection with the project.
> If I'm understanding something, is it the idea to have all the reports in
> the server, and the applications should link to that URL to load the
> report?
> Thanks a lot for your help. I really appreciate.
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things that
>> needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access
>> the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>|||There are three ways to integrate with RS 2005.
1. URL Integration
2. Web Services
3. Visual Studio 2005 Reporting Control
The reporting control has a local mode, you get it a datatable and a report.
I suggest you back up and learn how to create reports before you deal with
integration. There is a lot more that you have to do in local mode.
Normal function is to create a report and deploy it. Make sure it works from
the shipping portal (Report Manager web site).
Have your queries as stored procedures is great. No reason to create the RDL
on the fly. Just pass parameters to the report and use your stored
procedure.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I did the process again and now -don't ask me why- it shows the report.
> Then, as I asked you before, is the idea to create all the reports I need
> and upload to the server?
> My idea is to intergate that in a web application, so I expected to show
> just the report by clicking a button. Is that possible?
> And last but not least ;-), is it possible to dinamically -by code-
> generate the reports temporally? I have all my queries as stored
> procedures.
> Thanks a lot!
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports in
>> the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running,
>> but if I type http://192.168.1.49:8888/reportserver I see the
>> directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I
>> know is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||Bruce already answered some of your questions, I'll just add something.
- Create your reports locally, deploy to the server.
- When it comes to webapplications, you can either link directly to each
report, with parameters and everything else, or you can create an iFrame and
make the Report Manager show up inside. (Look for tips on integrating with
SharePoint, even if you're not using SharePoint, as you can use some of the
info in your web app.)
http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
The beauty of using an iFrame against Report Manager, is that Report Manager
will still deal with authentication for the different reports.
- Make sure to test your reports with user accounts with less priveleges
than yourself, before allowing your users to try them out. SOmetimes setting
the rights values in the datasource can be a bit tricky.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I did the process again and now -don't ask me why- it shows the report.
> Then, as I asked you before, is the idea to create all the reports I need
> and upload to the server?
> My idea is to intergate that in a web application, so I expected to show
> just the report by clicking a button. Is that possible?
> And last but not least ;-), is it possible to dinamically -by code-
> generate the reports temporally? I have all my queries as stored
> procedures.
> Thanks a lot!
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports in
>> the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running,
>> but if I type http://192.168.1.49:8888/reportserver I see the
>> directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I
>> know is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||Thank you. I'm trying to use just the URL to see the report, so it
integrates easily with my application.
I tried with a test server I installed just to make tests with that. The
only problem I met is that I have to put user and password, but I hope that
doing from the same domain avoids that.
Anyway, it's a lot of work to manually create each report from a whole
application.
--
Regards,
Diego F.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
news:usBxTgsFGHA.1192@.TK2MSFTNGP11.phx.gbl...
> There are three ways to integrate with RS 2005.
> 1. URL Integration
> 2. Web Services
> 3. Visual Studio 2005 Reporting Control
> The reporting control has a local mode, you get it a datatable and a
> report.
> I suggest you back up and learn how to create reports before you deal with
> integration. There is a lot more that you have to do in local mode.
> Normal function is to create a report and deploy it. Make sure it works
> from the shipping portal (Report Manager web site).
> Have your queries as stored procedures is great. No reason to create the
> RDL on the fly. Just pass parameters to the report and use your stored
> procedure.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I need
>> and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that
>> there's a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least
>>> I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>
>>
>>
>>
>>
>|||I'll also use SharePoint to integrate the whole application, so I'll check
that.
Where can I set the reports permissions?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:uF8RP1sFGHA.532@.TK2MSFTNGP15.phx.gbl...
> Bruce already answered some of your questions, I'll just add something.
> - Create your reports locally, deploy to the server.
> - When it comes to webapplications, you can either link directly to each
> report, with parameters and everything else, or you can create an iFrame
> and make the Report Manager show up inside. (Look for tips on integrating
> with SharePoint, even if you're not using SharePoint, as you can use some
> of the info in your web app.)
> http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
> The beauty of using an iFrame against Report Manager, is that Report
> Manager will still deal with authentication for the different reports.
> - Make sure to test your reports with user accounts with less priveleges
> than yourself, before allowing your users to try them out. SOmetimes
> setting the rights values in the datasource can be a bit tricky.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I need
>> and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that
>> there's a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least
>>> I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>
>>
>>
>>
>>
>|||On either a folder or a single report: Click Properties and the Security.
ANd then you can add what users and groups are allowed to see or update
reports.
Kaisa
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ToFp6sFGHA.916@.TK2MSFTNGP10.phx.gbl...
> I'll also use SharePoint to integrate the whole application, so I'll check
> that.
> Where can I set the reports permissions?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:uF8RP1sFGHA.532@.TK2MSFTNGP15.phx.gbl...
>> Bruce already answered some of your questions, I'll just add something.
>> - Create your reports locally, deploy to the server.
>> - When it comes to webapplications, you can either link directly to each
>> report, with parameters and everything else, or you can create an iFrame
>> and make the Report Manager show up inside. (Look for tips on integrating
>> with SharePoint, even if you're not using SharePoint, as you can use some
>> of the info in your web app.)
>> http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
>> The beauty of using an iFrame against Report Manager, is that Report
>> Manager will still deal with authentication for the different reports.
>> - Make sure to test your reports with user accounts with less priveleges
>> than yourself, before allowing your users to try them out. SOmetimes
>> setting the rights values in the datasource can be a bit tricky.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I
>> need and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted.
>> (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web
>> Site. RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>>> Google is your friend. Type in "reporting services" 503 "service
>>> unavailable" and you'll get quite a lot of info. Not all of it is
>>> directly connected to Reporting Services, but you should be able to
>>> pick up some info on the 503 problem in general. It seems that
>>> there's a problem with the Reporting Services web service.
>>>
>>> Are you allowed to log on to the actual server and try running
>>> Report Manager from that box?
>>> What sort of authentication is set?
>>> Try adding the report server site to your Trusted sites in IE, and
>>> then change the Security Settings for Trusted Sites to "Prompt for
>>> user name and password" in User Authentication - Logon. Type in your
>>> username and password. If it fails, that might be what causes the
>>> problem. In that case, you need to figure out what rights are needed
>>> for you to access the reports.
>>>
>>> Kaisa M. Lindahl
>>>
>>>
>>> "Diego F." <diegofrNO@.terra.es> wrote in message
>>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at
>>> least I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>>
>>>
>>
>>
>>
>>
>>
>sql
type http://192.168.1.49:8888/reportserver I see the directory list.
With http://192.1681.49:8888/reports, I see an error: The request failed
with HTTP status 503: Service Unavailable.The error is in URL.
http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
inside the application.
I'm completely stuck. What can I do or where can I search?
--
Regards,
Diego F.Google is your friend. Type in "reporting services" 503 "service
unavailable" and you'll get quite a lot of info. Not all of it is directly
connected to Reporting Services, but you should be able to pick up some info
on the 503 problem in general. It seems that there's a problem with the
Reporting Services web service.
Are you allowed to log on to the actual server and try running Report
Manager from that box?
What sort of authentication is set?
Try adding the report server site to your Trusted sites in IE, and then
change the Security Settings for Trusted Sites to "Prompt for user name and
password" in User Authentication - Logon. Type in your username and
password. If it fails, that might be what causes the problem. In that case,
you need to figure out what rights are needed for you to access the reports.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
> I'm trying to use Reporting Services 2005. The service is running, but if
> I type http://192.168.1.49:8888/reportserver I see the directory list.
> With http://192.1681.49:8888/reports, I see an error: The request failed
> with HTTP status 503: Service Unavailable.The error is in URL.
> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
> inside the application.
> I'm completely stuck. What can I do or where can I search?
> --
> Regards,
> Diego F.
>|||Hi again.
I installed again the whole server: Window 2003 and SQL Server 2005 full.
Now I finally see the reports site :-)
There is a Visual Studio installed with SQL 2005 and I can design reports
there. But now I don't know how to configure the project to deploy
correctly.
I get that error:
A connection could not be made to the report server http://localhost/reports
Additional information:
The attempt to connect to the report server failed. Check your connection
information and the report server is a compatible version.
(Microsoft.ReportingServices.Designer).
If I try with: http://localhost/reportserver then I get a compilation error:
The Report Server Windows Service ReportServer is not running. The service
must be running to use the Report Server.
How can I solve that?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
> Google is your friend. Type in "reporting services" 503 "service
> unavailable" and you'll get quite a lot of info. Not all of it is directly
> connected to Reporting Services, but you should be able to pick up some
> info on the 503 problem in general. It seems that there's a problem with
> the Reporting Services web service.
> Are you allowed to log on to the actual server and try running Report
> Manager from that box?
> What sort of authentication is set?
> Try adding the report server site to your Trusted sites in IE, and then
> change the Security Settings for Trusted Sites to "Prompt for user name
> and password" in User Authentication - Logon. Type in your username and
> password. If it fails, that might be what causes the problem. In that
> case, you need to figure out what rights are needed for you to access the
> reports.
> Kaisa M. Lindahl
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but if
>> I type http://192.168.1.49:8888/reportserver I see the directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request failed
>> with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know is
>> inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>|||Open IIS, a.k.a Internet Information Services Manager
Open your Reports site, is probably under Web SItes - Default Web Site.
RIght click and choose Browse. Does it open correctly?
If it does, what is the URL? I did a test install of the 2005 edition, and I
think you might get some extra "name" or something, like
http://localhost/reports$instancename
Which means that the reports are still there, but the URL might have
changed. Or something.
Also, with Sql Server 2005 there's an nice Reporting Services configuration
tool. Start it and look to see if there are any things that needs to be
started.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
> Hi again.
> I installed again the whole server: Window 2003 and SQL Server 2005 full.
> Now I finally see the reports site :-)
> There is a Visual Studio installed with SQL 2005 and I can design reports
> there. But now I don't know how to configure the project to deploy
> correctly.
> I get that error:
> A connection could not be made to the report server
> http://localhost/reports
> Additional information:
> The attempt to connect to the report server failed. Check your
> connection information and the report server is a compatible version.
> (Microsoft.ReportingServices.Designer).
> If I try with: http://localhost/reportserver then I get a compilation
> error:
> The Report Server Windows Service ReportServer is not running. The service
> must be running to use the Report Server.
> How can I solve that?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to pick
>> up some info on the 503 problem in general. It seems that there's a
>> problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access the
>> reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request failed
>> with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>|||I finally uploaded a report. I made it with Visual Studio 2005 installed by
SQL Server 2005. I made a report and deployed it, and in the Report Manager
shows the new report, but I can't see it because:
- 'The report server cannot process the report. The data source connection
information has been deleted. (rsInvalidDataSourceReference).
I made the connection with the project.
If I'm understanding something, is it the idea to have all the reports in
the server, and the applications should link to that URL to load the report?
Thanks a lot for your help. I really appreciate.
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
> Open IIS, a.k.a Internet Information Services Manager
> Open your Reports site, is probably under Web SItes - Default Web Site.
> RIght click and choose Browse. Does it open correctly?
> If it does, what is the URL? I did a test install of the 2005 edition, and
> I think you might get some extra "name" or something, like
> http://localhost/reports$instancename
> Which means that the reports are still there, but the URL might have
> changed. Or something.
> Also, with Sql Server 2005 there's an nice Reporting Services
> configuration tool. Start it and look to see if there are any things that
> needs to be started.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005 full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design reports
>> there. But now I don't know how to configure the project to deploy
>> correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to pick
>> up some info on the 503 problem in general. It seems that there's a
>> problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access
>> the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>|||I did the process again and now -don't ask me why- it shows the report.
Then, as I asked you before, is the idea to create all the reports I need
and upload to the server?
My idea is to intergate that in a web application, so I expected to show
just the report by clicking a button. Is that possible?
And last but not least ;-), is it possible to dinamically -by code- generate
the reports temporally? I have all my queries as stored procedures.
Thanks a lot!
--
Regards,
Diego F.
"Diego F." <diegofrNO@.terra.es> escribió en el mensaje
news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>I finally uploaded a report. I made it with Visual Studio 2005 installed by
>SQL Server 2005. I made a report and deployed it, and in the Report Manager
>shows the new report, but I can't see it because:
> - 'The report server cannot process the report. The data source connection
> information has been deleted. (rsInvalidDataSourceReference).
> I made the connection with the project.
> If I'm understanding something, is it the idea to have all the reports in
> the server, and the applications should link to that URL to load the
> report?
> Thanks a lot for your help. I really appreciate.
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things that
>> needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and then
>> change the Security Settings for Trusted Sites to "Prompt for user name
>> and password" in User Authentication - Logon. Type in your username and
>> password. If it fails, that might be what causes the problem. In that
>> case, you need to figure out what rights are needed for you to access
>> the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running, but
>> if I type http://192.168.1.49:8888/reportserver I see the directory
>> list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I know
>> is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>|||There are three ways to integrate with RS 2005.
1. URL Integration
2. Web Services
3. Visual Studio 2005 Reporting Control
The reporting control has a local mode, you get it a datatable and a report.
I suggest you back up and learn how to create reports before you deal with
integration. There is a lot more that you have to do in local mode.
Normal function is to create a report and deploy it. Make sure it works from
the shipping portal (Report Manager web site).
Have your queries as stored procedures is great. No reason to create the RDL
on the fly. Just pass parameters to the report and use your stored
procedure.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I did the process again and now -don't ask me why- it shows the report.
> Then, as I asked you before, is the idea to create all the reports I need
> and upload to the server?
> My idea is to intergate that in a web application, so I expected to show
> just the report by clicking a button. Is that possible?
> And last but not least ;-), is it possible to dinamically -by code-
> generate the reports temporally? I have all my queries as stored
> procedures.
> Thanks a lot!
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports in
>> the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running,
>> but if I type http://192.168.1.49:8888/reportserver I see the
>> directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I
>> know is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||Bruce already answered some of your questions, I'll just add something.
- Create your reports locally, deploy to the server.
- When it comes to webapplications, you can either link directly to each
report, with parameters and everything else, or you can create an iFrame and
make the Report Manager show up inside. (Look for tips on integrating with
SharePoint, even if you're not using SharePoint, as you can use some of the
info in your web app.)
http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
The beauty of using an iFrame against Report Manager, is that Report Manager
will still deal with authentication for the different reports.
- Make sure to test your reports with user accounts with less priveleges
than yourself, before allowing your users to try them out. SOmetimes setting
the rights values in the datasource can be a bit tricky.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>I did the process again and now -don't ask me why- it shows the report.
> Then, as I asked you before, is the idea to create all the reports I need
> and upload to the server?
> My idea is to intergate that in a web application, so I expected to show
> just the report by clicking a button. Is that possible?
> And last but not least ;-), is it possible to dinamically -by code-
> generate the reports temporally? I have all my queries as stored
> procedures.
> Thanks a lot!
> --
> Regards,
> Diego F.
>
> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports in
>> the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that there's
>> a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>> I'm trying to use Reporting Services 2005. The service is running,
>> but if I type http://192.168.1.49:8888/reportserver I see the
>> directory list.
>> With http://192.1681.49:8888/reports, I see an error: The request
>> failed with HTTP status 503: Service Unavailable.The error is in URL.
>> http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least I
>> know is inside the application.
>> I'm completely stuck. What can I do or where can I search?
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||Thank you. I'm trying to use just the URL to see the report, so it
integrates easily with my application.
I tried with a test server I installed just to make tests with that. The
only problem I met is that I have to put user and password, but I hope that
doing from the same domain avoids that.
Anyway, it's a lot of work to manually create each report from a whole
application.
--
Regards,
Diego F.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
news:usBxTgsFGHA.1192@.TK2MSFTNGP11.phx.gbl...
> There are three ways to integrate with RS 2005.
> 1. URL Integration
> 2. Web Services
> 3. Visual Studio 2005 Reporting Control
> The reporting control has a local mode, you get it a datatable and a
> report.
> I suggest you back up and learn how to create reports before you deal with
> integration. There is a lot more that you have to do in local mode.
> Normal function is to create a report and deploy it. Make sure it works
> from the shipping portal (Report Manager web site).
> Have your queries as stored procedures is great. No reason to create the
> RDL on the fly. Just pass parameters to the report and use your stored
> procedure.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I need
>> and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that
>> there's a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least
>>> I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>
>>
>>
>>
>>
>|||I'll also use SharePoint to integrate the whole application, so I'll check
that.
Where can I set the reports permissions?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:uF8RP1sFGHA.532@.TK2MSFTNGP15.phx.gbl...
> Bruce already answered some of your questions, I'll just add something.
> - Create your reports locally, deploy to the server.
> - When it comes to webapplications, you can either link directly to each
> report, with parameters and everything else, or you can create an iFrame
> and make the Report Manager show up inside. (Look for tips on integrating
> with SharePoint, even if you're not using SharePoint, as you can use some
> of the info in your web app.)
> http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
> The beauty of using an iFrame against Report Manager, is that Report
> Manager will still deal with authentication for the different reports.
> - Make sure to test your reports with user accounts with less priveleges
> than yourself, before allowing your users to try them out. SOmetimes
> setting the rights values in the datasource can be a bit tricky.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I need
>> and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted. (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web Site.
>> RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>> Google is your friend. Type in "reporting services" 503 "service
>> unavailable" and you'll get quite a lot of info. Not all of it is
>> directly connected to Reporting Services, but you should be able to
>> pick up some info on the 503 problem in general. It seems that
>> there's a problem with the Reporting Services web service.
>> Are you allowed to log on to the actual server and try running Report
>> Manager from that box?
>> What sort of authentication is set?
>> Try adding the report server site to your Trusted sites in IE, and
>> then change the Security Settings for Trusted Sites to "Prompt for
>> user name and password" in User Authentication - Logon. Type in your
>> username and password. If it fails, that might be what causes the
>> problem. In that case, you need to figure out what rights are needed
>> for you to access the reports.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at least
>>> I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>
>>
>>
>>
>>
>|||On either a folder or a single report: Click Properties and the Security.
ANd then you can add what users and groups are allowed to see or update
reports.
Kaisa
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23ToFp6sFGHA.916@.TK2MSFTNGP10.phx.gbl...
> I'll also use SharePoint to integrate the whole application, so I'll check
> that.
> Where can I set the reports permissions?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:uF8RP1sFGHA.532@.TK2MSFTNGP15.phx.gbl...
>> Bruce already answered some of your questions, I'll just add something.
>> - Create your reports locally, deploy to the server.
>> - When it comes to webapplications, you can either link directly to each
>> report, with parameters and everything else, or you can create an iFrame
>> and make the Report Manager show up inside. (Look for tips on integrating
>> with SharePoint, even if you're not using SharePoint, as you can use some
>> of the info in your web app.)
>> http://blogs.spipp.net/kaisa/archive/2005/09/27/1185.aspx
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx
>> The beauty of using an iFrame against Report Manager, is that Report
>> Manager will still deal with authentication for the different reports.
>> - Make sure to test your reports with user accounts with less priveleges
>> than yourself, before allowing your users to try them out. SOmetimes
>> setting the rights values in the datasource can be a bit tricky.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:%23ejqOcsFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>>I did the process again and now -don't ask me why- it shows the report.
>> Then, as I asked you before, is the idea to create all the reports I
>> need and upload to the server?
>> My idea is to intergate that in a web application, so I expected to show
>> just the report by clicking a button. Is that possible?
>> And last but not least ;-), is it possible to dinamically -by code-
>> generate the reports temporally? I have all my queries as stored
>> procedures.
>> Thanks a lot!
>> --
>> Regards,
>> Diego F.
>>
>> "Diego F." <diegofrNO@.terra.es> escribió en el mensaje
>> news:OI94mSsFGHA.752@.TK2MSFTNGP12.phx.gbl...
>>I finally uploaded a report. I made it with Visual Studio 2005 installed
>>by SQL Server 2005. I made a report and deployed it, and in the Report
>>Manager shows the new report, but I can't see it because:
>> - 'The report server cannot process the report. The data source
>> connection information has been deleted.
>> (rsInvalidDataSourceReference).
>> I made the connection with the project.
>> If I'm understanding something, is it the idea to have all the reports
>> in the server, and the applications should link to that URL to load the
>> report?
>> Thanks a lot for your help. I really appreciate.
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:umHKqBsFGHA.2084@.TK2MSFTNGP09.phx.gbl...
>> Open IIS, a.k.a Internet Information Services Manager
>> Open your Reports site, is probably under Web SItes - Default Web
>> Site. RIght click and choose Browse. Does it open correctly?
>> If it does, what is the URL? I did a test install of the 2005 edition,
>> and I think you might get some extra "name" or something, like
>> http://localhost/reports$instancename
>> Which means that the reports are still there, but the URL might have
>> changed. Or something.
>> Also, with Sql Server 2005 there's an nice Reporting Services
>> configuration tool. Start it and look to see if there are any things
>> that needs to be started.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:usLfZ8rFGHA.208@.tk2msftngp13.phx.gbl...
>> Hi again.
>> I installed again the whole server: Window 2003 and SQL Server 2005
>> full.
>> Now I finally see the reports site :-)
>> There is a Visual Studio installed with SQL 2005 and I can design
>> reports there. But now I don't know how to configure the project to
>> deploy correctly.
>> I get that error:
>> A connection could not be made to the report server
>> http://localhost/reports
>> Additional information:
>> The attempt to connect to the report server failed. Check your
>> connection information and the report server is a compatible version.
>> (Microsoft.ReportingServices.Designer).
>> If I try with: http://localhost/reportserver then I get a compilation
>> error:
>> The Report Server Windows Service ReportServer is not running. The
>> service must be running to use the Report Server.
>> How can I solve that?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:exkoPudFGHA.3280@.TK2MSFTNGP10.phx.gbl...
>>> Google is your friend. Type in "reporting services" 503 "service
>>> unavailable" and you'll get quite a lot of info. Not all of it is
>>> directly connected to Reporting Services, but you should be able to
>>> pick up some info on the 503 problem in general. It seems that
>>> there's a problem with the Reporting Services web service.
>>>
>>> Are you allowed to log on to the actual server and try running
>>> Report Manager from that box?
>>> What sort of authentication is set?
>>> Try adding the report server site to your Trusted sites in IE, and
>>> then change the Security Settings for Trusted Sites to "Prompt for
>>> user name and password" in User Authentication - Logon. Type in your
>>> username and password. If it fails, that might be what causes the
>>> problem. In that case, you need to figure out what rights are needed
>>> for you to access the reports.
>>>
>>> Kaisa M. Lindahl
>>>
>>>
>>> "Diego F." <diegofrNO@.terra.es> wrote in message
>>> news:OnBvOWdFGHA.3036@.tk2msftngp13.phx.gbl...
>>> I'm trying to use Reporting Services 2005. The service is running,
>>> but if I type http://192.168.1.49:8888/reportserver I see the
>>> directory list.
>>> With http://192.1681.49:8888/reports, I see an error: The request
>>> failed with HTTP status 503: Service Unavailable.The error is in
>>> URL. http://192.168.1.49:8888/reports/Pages/Folder.aspx, so at
>>> least I know is inside the application.
>>>
>>> I'm completely stuck. What can I do or where can I search?
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>>
>>>
>>
>>
>>
>>
>>
>sql
Can't see print button
Hi. I'm starting with Reporting Services 2005 and I need to use it in a web
application.
I followed the steps I found in the MSDN. I create a datasource, create the
report and then I use it in a report viewer control.
I found some problems:
1) I see no print button, and it's set to true in the viewer
2) I only can export to Excel. No other alternatives are possible.
3) I have compilation errors adding some columns from the dataset.
Can you help me to solve some of these problems?
Thank you in advance.
--
Regards,
Diego F.For #1, print is not supported in local mode processing, that is why there
is no button.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23kin1HREGHA.344@.TK2MSFTNGP11.phx.gbl...
> Hi. I'm starting with Reporting Services 2005 and I need to use it in a
> web application.
> I followed the steps I found in the MSDN. I create a datasource, create
> the report and then I use it in a report viewer control.
> I found some problems:
> 1) I see no print button, and it's set to true in the viewer
> 2) I only can export to Excel. No other alternatives are possible.
> 3) I have compilation errors adding some columns from the dataset.
> Can you help me to solve some of these problems?
> Thank you in advance.
> --
> Regards,
> Diego F.
>
>
application.
I followed the steps I found in the MSDN. I create a datasource, create the
report and then I use it in a report viewer control.
I found some problems:
1) I see no print button, and it's set to true in the viewer
2) I only can export to Excel. No other alternatives are possible.
3) I have compilation errors adding some columns from the dataset.
Can you help me to solve some of these problems?
Thank you in advance.
--
Regards,
Diego F.For #1, print is not supported in local mode processing, that is why there
is no button.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23kin1HREGHA.344@.TK2MSFTNGP11.phx.gbl...
> Hi. I'm starting with Reporting Services 2005 and I need to use it in a
> web application.
> I followed the steps I found in the MSDN. I create a datasource, create
> the report and then I use it in a report viewer control.
> I found some problems:
> 1) I see no print button, and it's set to true in the viewer
> 2) I only can export to Excel. No other alternatives are possible.
> 3) I have compilation errors adding some columns from the dataset.
> Can you help me to solve some of these problems?
> Thank you in advance.
> --
> Regards,
> Diego F.
>
>
Monday, March 19, 2012
Can't see content tab or properties tab.
An administrator installed reporting services. I went to the url to the
report manager, I cannot see anything on the home page, no tabs at all. How
do I set it up to show me these tabs?
Thanks,
Rick.Log into the machine locally as a member of the local administartor's group.
You'll be able to assign permissions either using the SiteSettings-->Manage
site wide security or through the properties tab
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rick" <noodle@.noodle.com> wrote in message
news:%23cSbAlPaEHA.644@.tk2msftngp13.phx.gbl...
> An administrator installed reporting services. I went to the url to the
> report manager, I cannot see anything on the home page, no tabs at all.
> How
> do I set it up to show me these tabs?
> Thanks,
> Rick.
>
report manager, I cannot see anything on the home page, no tabs at all. How
do I set it up to show me these tabs?
Thanks,
Rick.Log into the machine locally as a member of the local administartor's group.
You'll be able to assign permissions either using the SiteSettings-->Manage
site wide security or through the properties tab
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rick" <noodle@.noodle.com> wrote in message
news:%23cSbAlPaEHA.644@.tk2msftngp13.phx.gbl...
> An administrator installed reporting services. I went to the url to the
> report manager, I cannot see anything on the home page, no tabs at all.
> How
> do I set it up to show me these tabs?
> Thanks,
> Rick.
>
Can't run under the Eval version of Sql2000
I install the evaluation version of SQL Server 2000.
When I install the evaluation version of Reporting Service, the Installer
require me a SqlServer with Server pack 3a
But the Server pack 3a can't install with evaluation version of SQL Server
2000
How can I do?I guess theres nothing much you can do in this case :(
>--Original Message--
>I install the evaluation version of SQL Server 2000.
>When I install the evaluation version of Reporting
Service, the Installer
>require me a SqlServer with Server pack 3a
>But the Server pack 3a can't install with evaluation
version of SQL Server
>2000
>How can I do?
>
>.
>|||Actually, that's not correct. You can install SQL Server 2000 Service Pack
3a on the Evaluation Edition. See
http://www.microsoft.com/sql/downloads/2000/sp3.asp, a section of which is
copied below:
SQL Server 2000 SP3a:
a.. Improves serviceability for SQL Server 2000 Evaluation Edition. SP3a
enables service pack upgrades for trial software. In the past, service packs
have not been applicable to trial software.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:u1hHCavjEHA.2652@.TK2MSFTNGP15.phx.gbl...
>I install the evaluation version of SQL Server 2000.
> When I install the evaluation version of Reporting Service, the Installer
> require me a SqlServer with Server pack 3a
> But the Server pack 3a can't install with evaluation version of SQL Server
> 2000
> How can I do?
>
When I install the evaluation version of Reporting Service, the Installer
require me a SqlServer with Server pack 3a
But the Server pack 3a can't install with evaluation version of SQL Server
2000
How can I do?I guess theres nothing much you can do in this case :(
>--Original Message--
>I install the evaluation version of SQL Server 2000.
>When I install the evaluation version of Reporting
Service, the Installer
>require me a SqlServer with Server pack 3a
>But the Server pack 3a can't install with evaluation
version of SQL Server
>2000
>How can I do?
>
>.
>|||Actually, that's not correct. You can install SQL Server 2000 Service Pack
3a on the Evaluation Edition. See
http://www.microsoft.com/sql/downloads/2000/sp3.asp, a section of which is
copied below:
SQL Server 2000 SP3a:
a.. Improves serviceability for SQL Server 2000 Evaluation Edition. SP3a
enables service pack upgrades for trial software. In the past, service packs
have not been applicable to trial software.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"ad" <ad@.wfes.tcc.edu.tw> wrote in message
news:u1hHCavjEHA.2652@.TK2MSFTNGP15.phx.gbl...
>I install the evaluation version of SQL Server 2000.
> When I install the evaluation version of Reporting Service, the Installer
> require me a SqlServer with Server pack 3a
> But the Server pack 3a can't install with evaluation version of SQL Server
> 2000
> How can I do?
>
Can't run SSRS Projects SSBIDS
I'm trying to open an Reporting Services project in Sql Server Business Intelligence Development Studio (which looks a lot like Visual Studio 2005). This project was copied from another computer where it runs normally. I get the following error when trying to open it...
Package Load Failure
Package 'DataWarehouse VSIntegration layer' has failed t load peoperly (guid = etc..). Please contact package vendor for assistance. Application restart is recommended, due to possible enfvironment corruption. Would you like to disable loadinug for this package in the future? you may use 'devenv /resetskippkgs' to re-enable package loading.
I also tried to create a new Reporting services project and I got the following error....
Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=9.0.242.0...blah blah.
Some of my research so far says the first message could be related to having ran a beta version of vs2005 on this system which I did. However the ordinary vs2005 asp.net project appear to run normally.
How can I fix this problem?
Thanks,
Gary
First thing would be for me trying to reinstall the Reporting Services package. If that doen not help, reinstall VS and the reporting package with prior removing all related stuff from the server. if you had beta products from VS / SQL Server installed use the cleanup utility from Microsoft. That often helps more than getting the old installation to work properly.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||"cleanup utility from Microsoft" ? What is that? How would I get it?
Thanks,
Gary
|||http://support.microsoft.com/default.aspx?scid=kb;en-us;290301-Jens.|||
Found it. Ran it. found install of beta vs2005 version and ran it on that. Didn't make any difference. Still have same error.
|||I had the same error messages (wouldn't let me open an existing BI project or create a new one). I spent at least 4 hours struggling with this and various other posts on this issue. I found it strange that microsoft's forums are full will this question but there is no official solution from them on this issue. I wish they published a knowledgebase article on this that took care of the issue for once and for all.
Anyway! What worked for me is that I installed Microsoft SqlServer Express client tools. I already had SqlServer 2005 (client tools) , Sqlserver 2005 express (database only), and Visual Studio 2005 professional installed. The order I had initially installed was that I had first installed VS.Net 2003, then installed SqlServer 2005 (client tools), then Visual Studio 2005, and inally SqlServer 2005 Express (database only). Somewhere in between I had installed the reporting services, however I don't remember exactly the sequence for this. To make the matter wors, I had installed some of these on D drive (to save on C space), as many of the posters have reported that this can also cause the issue.
Its unlikely that you may have the same problem as I, but just in case!
Can't run SSRS Projects SSBIDS
I'm trying to open an Reporting Services project in Sql Server Business Intelligence Development Studio (which looks a lot like Visual Studio 2005). This project was copied from another computer where it runs normally. I get the following error when trying to open it...
Package Load Failure
Package 'DataWarehouse VSIntegration layer' has failed t load peoperly (guid = etc..). Please contact package vendor for assistance. Application restart is recommended, due to possible enfvironment corruption. Would you like to disable loadinug for this package in the future? you may use 'devenv /resetskippkgs' to re-enable package loading.
I also tried to create a new Reporting services project and I got the following error....
Could not load file or assembly 'Microsoft.ReportingServices.Designer, Version=9.0.242.0...blah blah.
Some of my research so far says the first message could be related to having ran a beta version of vs2005 on this system which I did. However the ordinary vs2005 asp.net project appear to run normally.
How can I fix this problem?
Thanks,
Gary
First thing would be for me trying to reinstall the Reporting Services package. If that doen not help, reinstall VS and the reporting package with prior removing all related stuff from the server. if you had beta products from VS / SQL Server installed use the cleanup utility from Microsoft. That often helps more than getting the old installation to work properly.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||"cleanup utility from Microsoft" ? What is that? How would I get it?
Thanks,
Gary
|||http://support.microsoft.com/default.aspx?scid=kb;en-us;290301-Jens.|||
Found it. Ran it. found install of beta vs2005 version and ran it on that. Didn't make any difference. Still have same error.
|||I had the same error messages (wouldn't let me open an existing BI project or create a new one). I spent at least 4 hours struggling with this and various other posts on this issue. I found it strange that microsoft's forums are full will this question but there is no official solution from them on this issue. I wish they published a knowledgebase article on this that took care of the issue for once and for all.
Anyway! What worked for me is that I installed Microsoft SqlServer Express client tools. I already had SqlServer 2005 (client tools) , Sqlserver 2005 express (database only), and Visual Studio 2005 professional installed. The order I had initially installed was that I had first installed VS.Net 2003, then installed SqlServer 2005 (client tools), then Visual Studio 2005, and inally SqlServer 2005 Express (database only). Somewhere in between I had installed the reporting services, however I don't remember exactly the sequence for this. To make the matter wors, I had installed some of these on D drive (to save on C space), as many of the posters have reported that this can also cause the issue.
Its unlikely that you may have the same problem as I, but just in case!
Sunday, March 11, 2012
Can't run SSRS projects on SSBIDS
I'm trying to open an Reporting Services project in Sql Server Business
Intelligence Development Studio (which looks a lot like Visual Studio 2005).
This project was copied from another computer where it runs normally. I get
the following error when trying to open it...
Package Load Failure
Package 'DataWarehouse VSIntegration layer' has failed t load peoperly (guid
= etc..). Please contact package vendor for assistance. Application
restart is recommended, due to possible enfvironment corruption. Would you
like to disable loadinug for this package in the future? you may use
'devenv /resetskippkgs' to re-enable package loading.
I also tried to create a new Reporting services project and I got the
following error...
Could not load file or assembly 'Microsoft.ReportingServices.Designer,
Version=9.0.242.0...blah blah.
Some of my research so far says the first message could be related to having
ran a beta version of vs2005 on this system which I did. However the
ordinary vs2005 asp.net project appear to run normally.
How can I fix this problem?
I have heard there is some cleanup utility. does anyone know how to get
that?
Thanks,
GaryI get this to everytime I open any project in BIDS.
Don't know how to fix...
"GaryDean" <GaryDean@.nospam.net> wrote in message
news:OjgnAc4oGHA.1440@.TK2MSFTNGP03.phx.gbl...
> I'm trying to open an Reporting Services project in Sql Server Business
> Intelligence Development Studio (which looks a lot like Visual Studio
> 2005). This project was copied from another computer where it runs
> normally. I get the following error when trying to open it...
> Package Load Failure
> Package 'DataWarehouse VSIntegration layer' has failed t load peoperly
> (guid = etc..). Please contact package vendor for assistance.
> Application restart is recommended, due to possible enfvironment
> corruption. Would you like to disable loadinug for this package in the
> future? you may use 'devenv /resetskippkgs' to re-enable package loading.
> I also tried to create a new Reporting services project and I got the
> following error...
> Could not load file or assembly 'Microsoft.ReportingServices.Designer,
> Version=9.0.242.0...blah blah.
> Some of my research so far says the first message could be related to
> having ran a beta version of vs2005 on this system which I did. However
> the ordinary vs2005 asp.net project appear to run normally.
> How can I fix this problem?
> I have heard there is some cleanup utility. does anyone know how to get
> that?
> Thanks,
> Gary
>
Intelligence Development Studio (which looks a lot like Visual Studio 2005).
This project was copied from another computer where it runs normally. I get
the following error when trying to open it...
Package Load Failure
Package 'DataWarehouse VSIntegration layer' has failed t load peoperly (guid
= etc..). Please contact package vendor for assistance. Application
restart is recommended, due to possible enfvironment corruption. Would you
like to disable loadinug for this package in the future? you may use
'devenv /resetskippkgs' to re-enable package loading.
I also tried to create a new Reporting services project and I got the
following error...
Could not load file or assembly 'Microsoft.ReportingServices.Designer,
Version=9.0.242.0...blah blah.
Some of my research so far says the first message could be related to having
ran a beta version of vs2005 on this system which I did. However the
ordinary vs2005 asp.net project appear to run normally.
How can I fix this problem?
I have heard there is some cleanup utility. does anyone know how to get
that?
Thanks,
GaryI get this to everytime I open any project in BIDS.
Don't know how to fix...
"GaryDean" <GaryDean@.nospam.net> wrote in message
news:OjgnAc4oGHA.1440@.TK2MSFTNGP03.phx.gbl...
> I'm trying to open an Reporting Services project in Sql Server Business
> Intelligence Development Studio (which looks a lot like Visual Studio
> 2005). This project was copied from another computer where it runs
> normally. I get the following error when trying to open it...
> Package Load Failure
> Package 'DataWarehouse VSIntegration layer' has failed t load peoperly
> (guid = etc..). Please contact package vendor for assistance.
> Application restart is recommended, due to possible enfvironment
> corruption. Would you like to disable loadinug for this package in the
> future? you may use 'devenv /resetskippkgs' to re-enable package loading.
> I also tried to create a new Reporting services project and I got the
> following error...
> Could not load file or assembly 'Microsoft.ReportingServices.Designer,
> Version=9.0.242.0...blah blah.
> Some of my research so far says the first message could be related to
> having ran a beta version of vs2005 on this system which I did. However
> the ordinary vs2005 asp.net project appear to run normally.
> How can I fix this problem?
> I have heard there is some cleanup utility. does anyone know how to get
> that?
> Thanks,
> Gary
>
Saturday, February 25, 2012
can't open Report Manager
Greetings,
I can't open Report Manager (sql Server 2000, win 2003 server). I log into
our server as SA where Reporting Services is/was installed (I did not perform
the install). I go to start/Programs/Microsoft Sql Server/Reporting
Services/Report Manager. This brings up a page that has an http error of
403. It says that IE can connect to the website but that IE doesn't have the
permission to access the webpage (http://myserver/Reports).
I looked at IIS and see the Reports virtual directory under Default
Websites (and the pages virtual dir, Folder.aspx...). The directory security
is set for Integrated Windows Security.
What can I do or what do I need to do so that I can access the Report
Manager webpage? Do I need to configure something in IE or IIS? Or is it
possible that the page isn't really there (bad install)?
Thanks
RichFirst off. Win 2003 server has extra security as far as IE is concerned.
This can make it problematic to connect via IE to the report server when you
are physically on the server. You are better off to do the following.
1. Add your account to the local administrator group
2. From your computer use http://yourserver.blah.com/reports and see what
comes up.
RS is an asp.net application. That is what you are logging into, NOT SQL
Server. So logging in with SA only works if the local administrator group on
the server has a user called SA. Otherwise, it knows nothing about SA. If
your local group has that in it then the issue is the added IE security. You
need to add the computer to the list of safe groups (I haven't done this for
awhile). You really are better off to not do this from the server. It is
better and easier to do it from your own PC.
RS uses Role based security. Initially you have a single role of which the
local administrator group is in it (the administrator group).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> Greetings,
> I can't open Report Manager (sql Server 2000, win 2003 server). I log
> into
> our server as SA where Reporting Services is/was installed (I did not
> perform
> the install). I go to start/Programs/Microsoft Sql Server/Reporting
> Services/Report Manager. This brings up a page that has an http error of
> 403. It says that IE can connect to the website but that IE doesn't have
> the
> permission to access the webpage (http://myserver/Reports).
> I looked at IIS and see the Reports virtual directory under Default
> Websites (and the pages virtual dir, Folder.aspx...). The directory
> security
> is set for Integrated Windows Security.
> What can I do or what do I need to do so that I can access the Report
> Manager webpage? Do I need to configure something in IE or IIS? Or is it
> possible that the page isn't really there (bad install)?
> Thanks
> Rich|||Thank you very much for getting back to me on this. I am just a little
confused though. Last week, I posted a question about caching and execution,
and I was directed to the Report Manager (which - up to that time I knew
nothing about). The instructions were
http://myserver/Reports/Pages/Folder.aspx
Now, you are suggesting that I add my account to the local administrator
group. By my account do you mean my login account that I log into my
workstation or server with - my network account? My account for loging into
the workstation is in the administrator group on the server. Say my network
login is joe123. May I request if you could specify what I have to do to
joe123 so that I can use him as you suggest?
http://joe123.../reports
I appologize in advance for my lack of intuition on this and am very
thankful for your reply and suggestions.
Thanks,
Rich
"Bruce L-C [MVP]" wrote:
> First off. Win 2003 server has extra security as far as IE is concerned.
> This can make it problematic to connect via IE to the report server when you
> are physically on the server. You are better off to do the following.
> 1. Add your account to the local administrator group
> 2. From your computer use http://yourserver.blah.com/reports and see what
> comes up.
> RS is an asp.net application. That is what you are logging into, NOT SQL
> Server. So logging in with SA only works if the local administrator group on
> the server has a user called SA. Otherwise, it knows nothing about SA. If
> your local group has that in it then the issue is the added IE security. You
> need to add the computer to the list of safe groups (I haven't done this for
> awhile). You really are better off to not do this from the server. It is
> better and easier to do it from your own PC.
> RS uses Role based security. Initially you have a single role of which the
> local administrator group is in it (the administrator group).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> > Greetings,
> >
> > I can't open Report Manager (sql Server 2000, win 2003 server). I log
> > into
> > our server as SA where Reporting Services is/was installed (I did not
> > perform
> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> > Services/Report Manager. This brings up a page that has an http error of
> > 403. It says that IE can connect to the website but that IE doesn't have
> > the
> > permission to access the webpage (http://myserver/Reports).
> >
> > I looked at IIS and see the Reports virtual directory under Default
> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> > security
> > is set for Integrated Windows Security.
> >
> > What can I do or what do I need to do so that I can access the Report
> > Manager webpage? Do I need to configure something in IE or IIS? Or is it
> > possible that the page isn't really there (bad install)?
> >
> > Thanks
> > Rich
>
>|||Yes you need to use Report Manager but Report Manager is just a asp.net
application that is available from any PC. You do not need to be on the
server itself.
I do mean your login account that you use to log into your server. If your
account is already in the adminstrator group then you are good to go. From
your PC just put this into the URL
http://myserver/Reports/Pages/Folder.aspx
Note, depending on your network you might need to fully qualify the server
as myserver.whatever.com, you can also put the IP address directly like this
http://IPAddress/Pages/Folder.aspx
I very seldom login to my server directly. Either I am deploying reports
from my PC to the server or I am using Report Manager from my PC.
If you login to your server using your network login you can use IE there to
get to report manager but the enhanced security with 2003 server could cause
issues and you need to add the server (yes it is itself but the added
security doesn't know this) to approved security list. That is why I suggest
just doing this from your PC, not from the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> Thank you very much for getting back to me on this. I am just a little
> confused though. Last week, I posted a question about caching and
> execution,
> and I was directed to the Report Manager (which - up to that time I knew
> nothing about). The instructions were
> http://myserver/Reports/Pages/Folder.aspx
> Now, you are suggesting that I add my account to the local administrator
> group. By my account do you mean my login account that I log into my
> workstation or server with - my network account? My account for loging
> into
> the workstation is in the administrator group on the server. Say my
> network
> login is joe123. May I request if you could specify what I have to do to
> joe123 so that I can use him as you suggest?
> http://joe123.../reports
> I appologize in advance for my lack of intuition on this and am very
> thankful for your reply and suggestions.
> Thanks,
> Rich
> "Bruce L-C [MVP]" wrote:
>> First off. Win 2003 server has extra security as far as IE is concerned.
>> This can make it problematic to connect via IE to the report server when
>> you
>> are physically on the server. You are better off to do the following.
>> 1. Add your account to the local administrator group
>> 2. From your computer use http://yourserver.blah.com/reports and see what
>> comes up.
>> RS is an asp.net application. That is what you are logging into, NOT SQL
>> Server. So logging in with SA only works if the local administrator group
>> on
>> the server has a user called SA. Otherwise, it knows nothing about SA. If
>> your local group has that in it then the issue is the added IE security.
>> You
>> need to add the computer to the list of safe groups (I haven't done this
>> for
>> awhile). You really are better off to not do this from the server. It is
>> better and easier to do it from your own PC.
>> RS uses Role based security. Initially you have a single role of which
>> the
>> local administrator group is in it (the administrator group).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> > Greetings,
>> >
>> > I can't open Report Manager (sql Server 2000, win 2003 server). I log
>> > into
>> > our server as SA where Reporting Services is/was installed (I did not
>> > perform
>> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
>> > Services/Report Manager. This brings up a page that has an http error
>> > of
>> > 403. It says that IE can connect to the website but that IE doesn't
>> > have
>> > the
>> > permission to access the webpage (http://myserver/Reports).
>> >
>> > I looked at IIS and see the Reports virtual directory under Default
>> > Websites (and the pages virtual dir, Folder.aspx...). The directory
>> > security
>> > is set for Integrated Windows Security.
>> >
>> > What can I do or what do I need to do so that I can access the Report
>> > Manager webpage? Do I need to configure something in IE or IIS? Or is
>> > it
>> > possible that the page isn't really there (bad install)?
>> >
>> > Thanks
>> > Rich
>>|||Well, I tried
http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
unauthorized
I also tried the qualified server name
http://myqualifiedserver.net/Reports/Pages/Folder.aspx
and
http://myqualifiedserver.net/Pages/Folder.aspx
with the same 401 error code
If people are able to get into Report Manager, then I should be able to get
in also. But what is the trick for me? Well, I thank you again for getting
back to me and with your suggestions. Just What is the trick?
Rich
"Bruce L-C [MVP]" wrote:
> Yes you need to use Report Manager but Report Manager is just a asp.net
> application that is available from any PC. You do not need to be on the
> server itself.
> I do mean your login account that you use to log into your server. If your
> account is already in the adminstrator group then you are good to go. From
> your PC just put this into the URL
> http://myserver/Reports/Pages/Folder.aspx
> Note, depending on your network you might need to fully qualify the server
> as myserver.whatever.com, you can also put the IP address directly like this
> http://IPAddress/Pages/Folder.aspx
> I very seldom login to my server directly. Either I am deploying reports
> from my PC to the server or I am using Report Manager from my PC.
> If you login to your server using your network login you can use IE there to
> get to report manager but the enhanced security with 2003 server could cause
> issues and you need to add the server (yes it is itself but the added
> security doesn't know this) to approved security list. That is why I suggest
> just doing this from your PC, not from the server.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> > Thank you very much for getting back to me on this. I am just a little
> > confused though. Last week, I posted a question about caching and
> > execution,
> > and I was directed to the Report Manager (which - up to that time I knew
> > nothing about). The instructions were
> >
> > http://myserver/Reports/Pages/Folder.aspx
> >
> > Now, you are suggesting that I add my account to the local administrator
> > group. By my account do you mean my login account that I log into my
> > workstation or server with - my network account? My account for loging
> > into
> > the workstation is in the administrator group on the server. Say my
> > network
> > login is joe123. May I request if you could specify what I have to do to
> > joe123 so that I can use him as you suggest?
> >
> > http://joe123.../reports
> >
> > I appologize in advance for my lack of intuition on this and am very
> > thankful for your reply and suggestions.
> >
> > Thanks,
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> First off. Win 2003 server has extra security as far as IE is concerned.
> >> This can make it problematic to connect via IE to the report server when
> >> you
> >> are physically on the server. You are better off to do the following.
> >> 1. Add your account to the local administrator group
> >> 2. From your computer use http://yourserver.blah.com/reports and see what
> >> comes up.
> >>
> >> RS is an asp.net application. That is what you are logging into, NOT SQL
> >> Server. So logging in with SA only works if the local administrator group
> >> on
> >> the server has a user called SA. Otherwise, it knows nothing about SA. If
> >> your local group has that in it then the issue is the added IE security.
> >> You
> >> need to add the computer to the list of safe groups (I haven't done this
> >> for
> >> awhile). You really are better off to not do this from the server. It is
> >> better and easier to do it from your own PC.
> >>
> >> RS uses Role based security. Initially you have a single role of which
> >> the
> >> local administrator group is in it (the administrator group).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> > Greetings,
> >> >
> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I log
> >> > into
> >> > our server as SA where Reporting Services is/was installed (I did not
> >> > perform
> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> >> > Services/Report Manager. This brings up a page that has an http error
> >> > of
> >> > 403. It says that IE can connect to the website but that IE doesn't
> >> > have
> >> > the
> >> > permission to access the webpage (http://myserver/Reports).
> >> >
> >> > I looked at IIS and see the Reports virtual directory under Default
> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> >> > security
> >> > is set for Integrated Windows Security.
> >> >
> >> > What can I do or what do I need to do so that I can access the Report
> >> > Manager webpage? Do I need to configure something in IE or IIS? Or is
> >> > it
> >> > possible that the page isn't really there (bad install)?
> >> >
> >> > Thanks
> >> > Rich
> >>
> >>
> >>
>
>|||My guess is that you might be in a administrators group but that group has
not been give administrative rights on the server. Login to that server as
you, check out the local administrators group. If it doesn't let you in to
view it or add to it then you do not have rights on that server. Get someone
who does to either add your specific domain\username to the local
administrator group or add the network administrator group to the local
administrator group.
I bet you don't have the rights to the server that you think you do. By
default, anyone in the local administrators group is in the RS administrator
role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> Well, I tried
> http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
> unauthorized
> I also tried the qualified server name
> http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> and
> http://myqualifiedserver.net/Pages/Folder.aspx
> with the same 401 error code
> If people are able to get into Report Manager, then I should be able to
> get
> in also. But what is the trick for me? Well, I thank you again for
> getting
> back to me and with your suggestions. Just What is the trick?
> Rich
> "Bruce L-C [MVP]" wrote:
>> Yes you need to use Report Manager but Report Manager is just a asp.net
>> application that is available from any PC. You do not need to be on the
>> server itself.
>> I do mean your login account that you use to log into your server. If
>> your
>> account is already in the adminstrator group then you are good to go.
>> From
>> your PC just put this into the URL
>> http://myserver/Reports/Pages/Folder.aspx
>> Note, depending on your network you might need to fully qualify the
>> server
>> as myserver.whatever.com, you can also put the IP address directly like
>> this
>> http://IPAddress/Pages/Folder.aspx
>> I very seldom login to my server directly. Either I am deploying reports
>> from my PC to the server or I am using Report Manager from my PC.
>> If you login to your server using your network login you can use IE there
>> to
>> get to report manager but the enhanced security with 2003 server could
>> cause
>> issues and you need to add the server (yes it is itself but the added
>> security doesn't know this) to approved security list. That is why I
>> suggest
>> just doing this from your PC, not from the server.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
>> > Thank you very much for getting back to me on this. I am just a little
>> > confused though. Last week, I posted a question about caching and
>> > execution,
>> > and I was directed to the Report Manager (which - up to that time I
>> > knew
>> > nothing about). The instructions were
>> >
>> > http://myserver/Reports/Pages/Folder.aspx
>> >
>> > Now, you are suggesting that I add my account to the local
>> > administrator
>> > group. By my account do you mean my login account that I log into my
>> > workstation or server with - my network account? My account for loging
>> > into
>> > the workstation is in the administrator group on the server. Say my
>> > network
>> > login is joe123. May I request if you could specify what I have to do
>> > to
>> > joe123 so that I can use him as you suggest?
>> >
>> > http://joe123.../reports
>> >
>> > I appologize in advance for my lack of intuition on this and am very
>> > thankful for your reply and suggestions.
>> >
>> > Thanks,
>> > Rich
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> First off. Win 2003 server has extra security as far as IE is
>> >> concerned.
>> >> This can make it problematic to connect via IE to the report server
>> >> when
>> >> you
>> >> are physically on the server. You are better off to do the following.
>> >> 1. Add your account to the local administrator group
>> >> 2. From your computer use http://yourserver.blah.com/reports and see
>> >> what
>> >> comes up.
>> >>
>> >> RS is an asp.net application. That is what you are logging into, NOT
>> >> SQL
>> >> Server. So logging in with SA only works if the local administrator
>> >> group
>> >> on
>> >> the server has a user called SA. Otherwise, it knows nothing about SA.
>> >> If
>> >> your local group has that in it then the issue is the added IE
>> >> security.
>> >> You
>> >> need to add the computer to the list of safe groups (I haven't done
>> >> this
>> >> for
>> >> awhile). You really are better off to not do this from the server. It
>> >> is
>> >> better and easier to do it from your own PC.
>> >>
>> >> RS uses Role based security. Initially you have a single role of which
>> >> the
>> >> local administrator group is in it (the administrator group).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> >> > Greetings,
>> >> >
>> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I
>> >> > log
>> >> > into
>> >> > our server as SA where Reporting Services is/was installed (I did
>> >> > not
>> >> > perform
>> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
>> >> > Services/Report Manager. This brings up a page that has an http
>> >> > error
>> >> > of
>> >> > 403. It says that IE can connect to the website but that IE doesn't
>> >> > have
>> >> > the
>> >> > permission to access the webpage (http://myserver/Reports).
>> >> >
>> >> > I looked at IIS and see the Reports virtual directory under Default
>> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
>> >> > security
>> >> > is set for Integrated Windows Security.
>> >> >
>> >> > What can I do or what do I need to do so that I can access the
>> >> > Report
>> >> > Manager webpage? Do I need to configure something in IE or IIS? Or
>> >> > is
>> >> > it
>> >> > possible that the page isn't really there (bad install)?
>> >> >
>> >> > Thanks
>> >> > Rich
>> >>
>> >>
>> >>
>>|||Man, I sure hope that is it. The guy that owns the network, of course, is
not available right now. So when I see him, I will ask him to access report
manager from his workstation using his logon and not SA.
Rich
"Bruce L-C [MVP]" wrote:
> My guess is that you might be in a administrators group but that group has
> not been give administrative rights on the server. Login to that server as
> you, check out the local administrators group. If it doesn't let you in to
> view it or add to it then you do not have rights on that server. Get someone
> who does to either add your specific domain\username to the local
> administrator group or add the network administrator group to the local
> administrator group.
> I bet you don't have the rights to the server that you think you do. By
> default, anyone in the local administrators group is in the RS administrator
> role.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> > Well, I tried
> >
> > http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
> > unauthorized
> >
> > I also tried the qualified server name
> >
> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> > and
> > http://myqualifiedserver.net/Pages/Folder.aspx
> >
> > with the same 401 error code
> >
> > If people are able to get into Report Manager, then I should be able to
> > get
> > in also. But what is the trick for me? Well, I thank you again for
> > getting
> > back to me and with your suggestions. Just What is the trick?
> >
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Yes you need to use Report Manager but Report Manager is just a asp.net
> >> application that is available from any PC. You do not need to be on the
> >> server itself.
> >>
> >> I do mean your login account that you use to log into your server. If
> >> your
> >> account is already in the adminstrator group then you are good to go.
> >> From
> >> your PC just put this into the URL
> >> http://myserver/Reports/Pages/Folder.aspx
> >>
> >> Note, depending on your network you might need to fully qualify the
> >> server
> >> as myserver.whatever.com, you can also put the IP address directly like
> >> this
> >> http://IPAddress/Pages/Folder.aspx
> >>
> >> I very seldom login to my server directly. Either I am deploying reports
> >> from my PC to the server or I am using Report Manager from my PC.
> >>
> >> If you login to your server using your network login you can use IE there
> >> to
> >> get to report manager but the enhanced security with 2003 server could
> >> cause
> >> issues and you need to add the server (yes it is itself but the added
> >> security doesn't know this) to approved security list. That is why I
> >> suggest
> >> just doing this from your PC, not from the server.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> >> > Thank you very much for getting back to me on this. I am just a little
> >> > confused though. Last week, I posted a question about caching and
> >> > execution,
> >> > and I was directed to the Report Manager (which - up to that time I
> >> > knew
> >> > nothing about). The instructions were
> >> >
> >> > http://myserver/Reports/Pages/Folder.aspx
> >> >
> >> > Now, you are suggesting that I add my account to the local
> >> > administrator
> >> > group. By my account do you mean my login account that I log into my
> >> > workstation or server with - my network account? My account for loging
> >> > into
> >> > the workstation is in the administrator group on the server. Say my
> >> > network
> >> > login is joe123. May I request if you could specify what I have to do
> >> > to
> >> > joe123 so that I can use him as you suggest?
> >> >
> >> > http://joe123.../reports
> >> >
> >> > I appologize in advance for my lack of intuition on this and am very
> >> > thankful for your reply and suggestions.
> >> >
> >> > Thanks,
> >> > Rich
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> First off. Win 2003 server has extra security as far as IE is
> >> >> concerned.
> >> >> This can make it problematic to connect via IE to the report server
> >> >> when
> >> >> you
> >> >> are physically on the server. You are better off to do the following.
> >> >> 1. Add your account to the local administrator group
> >> >> 2. From your computer use http://yourserver.blah.com/reports and see
> >> >> what
> >> >> comes up.
> >> >>
> >> >> RS is an asp.net application. That is what you are logging into, NOT
> >> >> SQL
> >> >> Server. So logging in with SA only works if the local administrator
> >> >> group
> >> >> on
> >> >> the server has a user called SA. Otherwise, it knows nothing about SA.
> >> >> If
> >> >> your local group has that in it then the issue is the added IE
> >> >> security.
> >> >> You
> >> >> need to add the computer to the list of safe groups (I haven't done
> >> >> this
> >> >> for
> >> >> awhile). You really are better off to not do this from the server. It
> >> >> is
> >> >> better and easier to do it from your own PC.
> >> >>
> >> >> RS uses Role based security. Initially you have a single role of which
> >> >> the
> >> >> local administrator group is in it (the administrator group).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> >> > Greetings,
> >> >> >
> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I
> >> >> > log
> >> >> > into
> >> >> > our server as SA where Reporting Services is/was installed (I did
> >> >> > not
> >> >> > perform
> >> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> >> >> > Services/Report Manager. This brings up a page that has an http
> >> >> > error
> >> >> > of
> >> >> > 403. It says that IE can connect to the website but that IE doesn't
> >> >> > have
> >> >> > the
> >> >> > permission to access the webpage (http://myserver/Reports).
> >> >> >
> >> >> > I looked at IIS and see the Reports virtual directory under Default
> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> >> >> > security
> >> >> > is set for Integrated Windows Security.
> >> >> >
> >> >> > What can I do or what do I need to do so that I can access the
> >> >> > Report
> >> >> > Manager webpage? Do I need to configure something in IE or IIS? Or
> >> >> > is
> >> >> > it
> >> >> > possible that the page isn't really there (bad install)?
> >> >> >
> >> >> > Thanks
> >> >> > Rich
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||The owner got back and tried opening Report manager with no success except
for one interesting error message - the message said something about looking
for .Net Framework 1.1.
We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
Visual Studio 2005. Would this be an issue for Report Manager for RS2003?
We are still using Sql Server 2000.
"Bruce L-C [MVP]" wrote:
> My guess is that you might be in a administrators group but that group has
> not been give administrative rights on the server. Login to that server as
> you, check out the local administrators group. If it doesn't let you in to
> view it or add to it then you do not have rights on that server. Get someone
> who does to either add your specific domain\username to the local
> administrator group or add the network administrator group to the local
> administrator group.
> I bet you don't have the rights to the server that you think you do. By
> default, anyone in the local administrators group is in the RS administrator
> role.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> > Well, I tried
> >
> > http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
> > unauthorized
> >
> > I also tried the qualified server name
> >
> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> > and
> > http://myqualifiedserver.net/Pages/Folder.aspx
> >
> > with the same 401 error code
> >
> > If people are able to get into Report Manager, then I should be able to
> > get
> > in also. But what is the trick for me? Well, I thank you again for
> > getting
> > back to me and with your suggestions. Just What is the trick?
> >
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Yes you need to use Report Manager but Report Manager is just a asp.net
> >> application that is available from any PC. You do not need to be on the
> >> server itself.
> >>
> >> I do mean your login account that you use to log into your server. If
> >> your
> >> account is already in the adminstrator group then you are good to go.
> >> From
> >> your PC just put this into the URL
> >> http://myserver/Reports/Pages/Folder.aspx
> >>
> >> Note, depending on your network you might need to fully qualify the
> >> server
> >> as myserver.whatever.com, you can also put the IP address directly like
> >> this
> >> http://IPAddress/Pages/Folder.aspx
> >>
> >> I very seldom login to my server directly. Either I am deploying reports
> >> from my PC to the server or I am using Report Manager from my PC.
> >>
> >> If you login to your server using your network login you can use IE there
> >> to
> >> get to report manager but the enhanced security with 2003 server could
> >> cause
> >> issues and you need to add the server (yes it is itself but the added
> >> security doesn't know this) to approved security list. That is why I
> >> suggest
> >> just doing this from your PC, not from the server.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> >> > Thank you very much for getting back to me on this. I am just a little
> >> > confused though. Last week, I posted a question about caching and
> >> > execution,
> >> > and I was directed to the Report Manager (which - up to that time I
> >> > knew
> >> > nothing about). The instructions were
> >> >
> >> > http://myserver/Reports/Pages/Folder.aspx
> >> >
> >> > Now, you are suggesting that I add my account to the local
> >> > administrator
> >> > group. By my account do you mean my login account that I log into my
> >> > workstation or server with - my network account? My account for loging
> >> > into
> >> > the workstation is in the administrator group on the server. Say my
> >> > network
> >> > login is joe123. May I request if you could specify what I have to do
> >> > to
> >> > joe123 so that I can use him as you suggest?
> >> >
> >> > http://joe123.../reports
> >> >
> >> > I appologize in advance for my lack of intuition on this and am very
> >> > thankful for your reply and suggestions.
> >> >
> >> > Thanks,
> >> > Rich
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> First off. Win 2003 server has extra security as far as IE is
> >> >> concerned.
> >> >> This can make it problematic to connect via IE to the report server
> >> >> when
> >> >> you
> >> >> are physically on the server. You are better off to do the following.
> >> >> 1. Add your account to the local administrator group
> >> >> 2. From your computer use http://yourserver.blah.com/reports and see
> >> >> what
> >> >> comes up.
> >> >>
> >> >> RS is an asp.net application. That is what you are logging into, NOT
> >> >> SQL
> >> >> Server. So logging in with SA only works if the local administrator
> >> >> group
> >> >> on
> >> >> the server has a user called SA. Otherwise, it knows nothing about SA.
> >> >> If
> >> >> your local group has that in it then the issue is the added IE
> >> >> security.
> >> >> You
> >> >> need to add the computer to the list of safe groups (I haven't done
> >> >> this
> >> >> for
> >> >> awhile). You really are better off to not do this from the server. It
> >> >> is
> >> >> better and easier to do it from your own PC.
> >> >>
> >> >> RS uses Role based security. Initially you have a single role of which
> >> >> the
> >> >> local administrator group is in it (the administrator group).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> >> > Greetings,
> >> >> >
> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I
> >> >> > log
> >> >> > into
> >> >> > our server as SA where Reporting Services is/was installed (I did
> >> >> > not
> >> >> > perform
> >> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> >> >> > Services/Report Manager. This brings up a page that has an http
> >> >> > error
> >> >> > of
> >> >> > 403. It says that IE can connect to the website but that IE doesn't
> >> >> > have
> >> >> > the
> >> >> > permission to access the webpage (http://myserver/Reports).
> >> >> >
> >> >> > I looked at IIS and see the Reports virtual directory under Default
> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> >> >> > security
> >> >> > is set for Integrated Windows Security.
> >> >> >
> >> >> > What can I do or what do I need to do so that I can access the
> >> >> > Report
> >> >> > Manager webpage? Do I need to configure something in IE or IIS? Or
> >> >> > is
> >> >> > it
> >> >> > possible that the page isn't really there (bad install)?
> >> >> >
> >> >> > Thanks
> >> >> > Rich
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Yes.
RS 2000 is a 1.1 framework app. RS 2005 is a 2.0 framework app. It is fine
that you upgraded to 2.0 BUT you have to have Reports and ReportServer webs
be at 1.1 (IIS will support both but you have to configure the sites to be
1.1).
Not sure if this is all the reason but it is definitely a problem. Get the
owner to work first and then get back to your problem. You might have more
than one problem going on.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:FA0B37D6-B5D1-4C13-B0F4-8AAF9D39974D@.microsoft.com...
> The owner got back and tried opening Report manager with no success except
> for one interesting error message - the message said something about
> looking
> for .Net Framework 1.1.
> We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
> Visual Studio 2005. Would this be an issue for Report Manager for
> RS2003?
> We are still using Sql Server 2000.
> "Bruce L-C [MVP]" wrote:
>> My guess is that you might be in a administrators group but that group
>> has
>> not been give administrative rights on the server. Login to that server
>> as
>> you, check out the local administrators group. If it doesn't let you in
>> to
>> view it or add to it then you do not have rights on that server. Get
>> someone
>> who does to either add your specific domain\username to the local
>> administrator group or add the network administrator group to the local
>> administrator group.
>> I bet you don't have the rights to the server that you think you do. By
>> default, anyone in the local administrators group is in the RS
>> administrator
>> role.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
>> > Well, I tried
>> >
>> > http://myservername/Reports/Pages/Folder.aspx and got the http 401
>> > error -
>> > unauthorized
>> >
>> > I also tried the qualified server name
>> >
>> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
>> > and
>> > http://myqualifiedserver.net/Pages/Folder.aspx
>> >
>> > with the same 401 error code
>> >
>> > If people are able to get into Report Manager, then I should be able to
>> > get
>> > in also. But what is the trick for me? Well, I thank you again for
>> > getting
>> > back to me and with your suggestions. Just What is the trick?
>> >
>> > Rich
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Yes you need to use Report Manager but Report Manager is just a
>> >> asp.net
>> >> application that is available from any PC. You do not need to be on
>> >> the
>> >> server itself.
>> >>
>> >> I do mean your login account that you use to log into your server. If
>> >> your
>> >> account is already in the adminstrator group then you are good to go.
>> >> From
>> >> your PC just put this into the URL
>> >> http://myserver/Reports/Pages/Folder.aspx
>> >>
>> >> Note, depending on your network you might need to fully qualify the
>> >> server
>> >> as myserver.whatever.com, you can also put the IP address directly
>> >> like
>> >> this
>> >> http://IPAddress/Pages/Folder.aspx
>> >>
>> >> I very seldom login to my server directly. Either I am deploying
>> >> reports
>> >> from my PC to the server or I am using Report Manager from my PC.
>> >>
>> >> If you login to your server using your network login you can use IE
>> >> there
>> >> to
>> >> get to report manager but the enhanced security with 2003 server could
>> >> cause
>> >> issues and you need to add the server (yes it is itself but the added
>> >> security doesn't know this) to approved security list. That is why I
>> >> suggest
>> >> just doing this from your PC, not from the server.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
>> >> > Thank you very much for getting back to me on this. I am just a
>> >> > little
>> >> > confused though. Last week, I posted a question about caching and
>> >> > execution,
>> >> > and I was directed to the Report Manager (which - up to that time I
>> >> > knew
>> >> > nothing about). The instructions were
>> >> >
>> >> > http://myserver/Reports/Pages/Folder.aspx
>> >> >
>> >> > Now, you are suggesting that I add my account to the local
>> >> > administrator
>> >> > group. By my account do you mean my login account that I log into
>> >> > my
>> >> > workstation or server with - my network account? My account for
>> >> > loging
>> >> > into
>> >> > the workstation is in the administrator group on the server. Say my
>> >> > network
>> >> > login is joe123. May I request if you could specify what I have to
>> >> > do
>> >> > to
>> >> > joe123 so that I can use him as you suggest?
>> >> >
>> >> > http://joe123.../reports
>> >> >
>> >> > I appologize in advance for my lack of intuition on this and am very
>> >> > thankful for your reply and suggestions.
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> First off. Win 2003 server has extra security as far as IE is
>> >> >> concerned.
>> >> >> This can make it problematic to connect via IE to the report server
>> >> >> when
>> >> >> you
>> >> >> are physically on the server. You are better off to do the
>> >> >> following.
>> >> >> 1. Add your account to the local administrator group
>> >> >> 2. From your computer use http://yourserver.blah.com/reports and
>> >> >> see
>> >> >> what
>> >> >> comes up.
>> >> >>
>> >> >> RS is an asp.net application. That is what you are logging into,
>> >> >> NOT
>> >> >> SQL
>> >> >> Server. So logging in with SA only works if the local administrator
>> >> >> group
>> >> >> on
>> >> >> the server has a user called SA. Otherwise, it knows nothing about
>> >> >> SA.
>> >> >> If
>> >> >> your local group has that in it then the issue is the added IE
>> >> >> security.
>> >> >> You
>> >> >> need to add the computer to the list of safe groups (I haven't done
>> >> >> this
>> >> >> for
>> >> >> awhile). You really are better off to not do this from the server.
>> >> >> It
>> >> >> is
>> >> >> better and easier to do it from your own PC.
>> >> >>
>> >> >> RS uses Role based security. Initially you have a single role of
>> >> >> which
>> >> >> the
>> >> >> local administrator group is in it (the administrator group).
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> >> >> > Greetings,
>> >> >> >
>> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server).
>> >> >> > I
>> >> >> > log
>> >> >> > into
>> >> >> > our server as SA where Reporting Services is/was installed (I did
>> >> >> > not
>> >> >> > perform
>> >> >> > the install). I go to start/Programs/Microsoft Sql
>> >> >> > Server/Reporting
>> >> >> > Services/Report Manager. This brings up a page that has an http
>> >> >> > error
>> >> >> > of
>> >> >> > 403. It says that IE can connect to the website but that IE
>> >> >> > doesn't
>> >> >> > have
>> >> >> > the
>> >> >> > permission to access the webpage (http://myserver/Reports).
>> >> >> >
>> >> >> > I looked at IIS and see the Reports virtual directory under
>> >> >> > Default
>> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The
>> >> >> > directory
>> >> >> > security
>> >> >> > is set for Integrated Windows Security.
>> >> >> >
>> >> >> > What can I do or what do I need to do so that I can access the
>> >> >> > Report
>> >> >> > Manager webpage? Do I need to configure something in IE or IIS?
>> >> >> > Or
>> >> >> > is
>> >> >> > it
>> >> >> > possible that the page isn't really there (bad install)?
>> >> >> >
>> >> >> > Thanks
>> >> >> > Rich
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks. We have a web guy at my place that I have apprised about the
situation. Hopefully, he can figure out how to configure the sites for .net
framework 1.1.
Note: I can deploy reports with my current setup and things work OK except
for the caching thing - which is why I need to get into Report Manager in the
first place.
Rich
"Bruce L-C [MVP]" wrote:
> Yes.
> RS 2000 is a 1.1 framework app. RS 2005 is a 2.0 framework app. It is fine
> that you upgraded to 2.0 BUT you have to have Reports and ReportServer webs
> be at 1.1 (IIS will support both but you have to configure the sites to be
> 1.1).
> Not sure if this is all the reason but it is definitely a problem. Get the
> owner to work first and then get back to your problem. You might have more
> than one problem going on.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:FA0B37D6-B5D1-4C13-B0F4-8AAF9D39974D@.microsoft.com...
> > The owner got back and tried opening Report manager with no success except
> > for one interesting error message - the message said something about
> > looking
> > for .Net Framework 1.1.
> >
> > We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
> > Visual Studio 2005. Would this be an issue for Report Manager for
> > RS2003?
> > We are still using Sql Server 2000.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> My guess is that you might be in a administrators group but that group
> >> has
> >> not been give administrative rights on the server. Login to that server
> >> as
> >> you, check out the local administrators group. If it doesn't let you in
> >> to
> >> view it or add to it then you do not have rights on that server. Get
> >> someone
> >> who does to either add your specific domain\username to the local
> >> administrator group or add the network administrator group to the local
> >> administrator group.
> >>
> >> I bet you don't have the rights to the server that you think you do. By
> >> default, anyone in the local administrators group is in the RS
> >> administrator
> >> role.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> >> > Well, I tried
> >> >
> >> > http://myservername/Reports/Pages/Folder.aspx and got the http 401
> >> > error -
> >> > unauthorized
> >> >
> >> > I also tried the qualified server name
> >> >
> >> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> >> > and
> >> > http://myqualifiedserver.net/Pages/Folder.aspx
> >> >
> >> > with the same 401 error code
> >> >
> >> > If people are able to get into Report Manager, then I should be able to
> >> > get
> >> > in also. But what is the trick for me? Well, I thank you again for
> >> > getting
> >> > back to me and with your suggestions. Just What is the trick?
> >> >
> >> > Rich
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Yes you need to use Report Manager but Report Manager is just a
> >> >> asp.net
> >> >> application that is available from any PC. You do not need to be on
> >> >> the
> >> >> server itself.
> >> >>
> >> >> I do mean your login account that you use to log into your server. If
> >> >> your
> >> >> account is already in the adminstrator group then you are good to go.
> >> >> From
> >> >> your PC just put this into the URL
> >> >> http://myserver/Reports/Pages/Folder.aspx
> >> >>
> >> >> Note, depending on your network you might need to fully qualify the
> >> >> server
> >> >> as myserver.whatever.com, you can also put the IP address directly
> >> >> like
> >> >> this
> >> >> http://IPAddress/Pages/Folder.aspx
> >> >>
> >> >> I very seldom login to my server directly. Either I am deploying
> >> >> reports
> >> >> from my PC to the server or I am using Report Manager from my PC.
> >> >>
> >> >> If you login to your server using your network login you can use IE
> >> >> there
> >> >> to
> >> >> get to report manager but the enhanced security with 2003 server could
> >> >> cause
> >> >> issues and you need to add the server (yes it is itself but the added
> >> >> security doesn't know this) to approved security list. That is why I
> >> >> suggest
> >> >> just doing this from your PC, not from the server.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> >> >> > Thank you very much for getting back to me on this. I am just a
> >> >> > little
> >> >> > confused though. Last week, I posted a question about caching and
> >> >> > execution,
> >> >> > and I was directed to the Report Manager (which - up to that time I
> >> >> > knew
> >> >> > nothing about). The instructions were
> >> >> >
> >> >> > http://myserver/Reports/Pages/Folder.aspx
> >> >> >
> >> >> > Now, you are suggesting that I add my account to the local
> >> >> > administrator
> >> >> > group. By my account do you mean my login account that I log into
> >> >> > my
> >> >> > workstation or server with - my network account? My account for
> >> >> > loging
> >> >> > into
> >> >> > the workstation is in the administrator group on the server. Say my
> >> >> > network
> >> >> > login is joe123. May I request if you could specify what I have to
> >> >> > do
> >> >> > to
> >> >> > joe123 so that I can use him as you suggest?
> >> >> >
> >> >> > http://joe123.../reports
> >> >> >
> >> >> > I appologize in advance for my lack of intuition on this and am very
> >> >> > thankful for your reply and suggestions.
> >> >> >
> >> >> > Thanks,
> >> >> > Rich
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> First off. Win 2003 server has extra security as far as IE is
> >> >> >> concerned.
> >> >> >> This can make it problematic to connect via IE to the report server
> >> >> >> when
> >> >> >> you
> >> >> >> are physically on the server. You are better off to do the
> >> >> >> following.
> >> >> >> 1. Add your account to the local administrator group
> >> >> >> 2. From your computer use http://yourserver.blah.com/reports and
> >> >> >> see
> >> >> >> what
> >> >> >> comes up.
> >> >> >>
> >> >> >> RS is an asp.net application. That is what you are logging into,
> >> >> >> NOT
> >> >> >> SQL
> >> >> >> Server. So logging in with SA only works if the local administrator
> >> >> >> group
> >> >> >> on
> >> >> >> the server has a user called SA. Otherwise, it knows nothing about
> >> >> >> SA.
> >> >> >> If
> >> >> >> your local group has that in it then the issue is the added IE
> >> >> >> security.
> >> >> >> You
> >> >> >> need to add the computer to the list of safe groups (I haven't done
> >> >> >> this
> >> >> >> for
> >> >> >> awhile). You really are better off to not do this from the server.
> >> >> >> It
> >> >> >> is
> >> >> >> better and easier to do it from your own PC.
> >> >> >>
> >> >> >> RS uses Role based security. Initially you have a single role of
> >> >> >> which
> >> >> >> the
> >> >> >> local administrator group is in it (the administrator group).
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> >> >> > Greetings,
> >> >> >> >
> >> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server).
> >> >> >> > I
> >> >> >> > log
> >> >> >> > into
> >> >> >> > our server as SA where Reporting Services is/was installed (I did
> >> >> >> > not
> >> >> >> > perform
> >> >> >> > the install). I go to start/Programs/Microsoft Sql
> >> >> >> > Server/Reporting
> >> >> >> > Services/Report Manager. This brings up a page that has an http
> >> >> >> > error
> >> >> >> > of
> >> >> >> > 403. It says that IE can connect to the website but that IE
> >> >> >> > doesn't
> >> >> >> > have
> >> >> >> > the
> >> >> >> > permission to access the webpage (http://myserver/Reports).
> >> >> >> >
> >> >> >> > I looked at IIS and see the Reports virtual directory under
> >> >> >> > Default
> >> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The
> >> >> >> > directory
> >> >> >> > security
> >> >> >> > is set for Integrated Windows Security.
> >> >> >> >
> >> >> >> > What can I do or what do I need to do so that I can access the
> >> >> >> > Report
> >> >> >> > Manager webpage? Do I need to configure something in IE or IIS?
> >> >> >> > Or
> >> >> >> > is
> >> >> >> > it
> >> >> >> > possible that the page isn't really there (bad install)?
> >> >> >> >
> >> >> >> > Thanks
> >> >> >> > Rich
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I'm surprised you can deploy. It could be that reportserver website is still
1.1 and reports website (which is the report manager app) was set to 2.0
(but needs to be 1.1).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:1F8AC4CC-86E0-4124-8C8A-84FA8D25744D@.microsoft.com...
> Thanks. We have a web guy at my place that I have apprised about the
> situation. Hopefully, he can figure out how to configure the sites for
> .net
> framework 1.1.
> Note: I can deploy reports with my current setup and things work OK
> except
> for the caching thing - which is why I need to get into Report Manager in
> the
> first place.
> Rich
> "Bruce L-C [MVP]" wrote:
>> Yes.
>> RS 2000 is a 1.1 framework app. RS 2005 is a 2.0 framework app. It is
>> fine
>> that you upgraded to 2.0 BUT you have to have Reports and ReportServer
>> webs
>> be at 1.1 (IIS will support both but you have to configure the sites to
>> be
>> 1.1).
>> Not sure if this is all the reason but it is definitely a problem. Get
>> the
>> owner to work first and then get back to your problem. You might have
>> more
>> than one problem going on.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:FA0B37D6-B5D1-4C13-B0F4-8AAF9D39974D@.microsoft.com...
>> > The owner got back and tried opening Report manager with no success
>> > except
>> > for one interesting error message - the message said something about
>> > looking
>> > for .Net Framework 1.1.
>> >
>> > We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
>> > Visual Studio 2005. Would this be an issue for Report Manager for
>> > RS2003?
>> > We are still using Sql Server 2000.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> My guess is that you might be in a administrators group but that group
>> >> has
>> >> not been give administrative rights on the server. Login to that
>> >> server
>> >> as
>> >> you, check out the local administrators group. If it doesn't let you
>> >> in
>> >> to
>> >> view it or add to it then you do not have rights on that server. Get
>> >> someone
>> >> who does to either add your specific domain\username to the local
>> >> administrator group or add the network administrator group to the
>> >> local
>> >> administrator group.
>> >>
>> >> I bet you don't have the rights to the server that you think you do.
>> >> By
>> >> default, anyone in the local administrators group is in the RS
>> >> administrator
>> >> role.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
>> >> > Well, I tried
>> >> >
>> >> > http://myservername/Reports/Pages/Folder.aspx and got the http 401
>> >> > error -
>> >> > unauthorized
>> >> >
>> >> > I also tried the qualified server name
>> >> >
>> >> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
>> >> > and
>> >> > http://myqualifiedserver.net/Pages/Folder.aspx
>> >> >
>> >> > with the same 401 error code
>> >> >
>> >> > If people are able to get into Report Manager, then I should be able
>> >> > to
>> >> > get
>> >> > in also. But what is the trick for me? Well, I thank you again for
>> >> > getting
>> >> > back to me and with your suggestions. Just What is the trick?
>> >> >
>> >> > Rich
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Yes you need to use Report Manager but Report Manager is just a
>> >> >> asp.net
>> >> >> application that is available from any PC. You do not need to be on
>> >> >> the
>> >> >> server itself.
>> >> >>
>> >> >> I do mean your login account that you use to log into your server.
>> >> >> If
>> >> >> your
>> >> >> account is already in the adminstrator group then you are good to
>> >> >> go.
>> >> >> From
>> >> >> your PC just put this into the URL
>> >> >> http://myserver/Reports/Pages/Folder.aspx
>> >> >>
>> >> >> Note, depending on your network you might need to fully qualify the
>> >> >> server
>> >> >> as myserver.whatever.com, you can also put the IP address directly
>> >> >> like
>> >> >> this
>> >> >> http://IPAddress/Pages/Folder.aspx
>> >> >>
>> >> >> I very seldom login to my server directly. Either I am deploying
>> >> >> reports
>> >> >> from my PC to the server or I am using Report Manager from my PC.
>> >> >>
>> >> >> If you login to your server using your network login you can use IE
>> >> >> there
>> >> >> to
>> >> >> get to report manager but the enhanced security with 2003 server
>> >> >> could
>> >> >> cause
>> >> >> issues and you need to add the server (yes it is itself but the
>> >> >> added
>> >> >> security doesn't know this) to approved security list. That is why
>> >> >> I
>> >> >> suggest
>> >> >> just doing this from your PC, not from the server.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
>> >> >> > Thank you very much for getting back to me on this. I am just a
>> >> >> > little
>> >> >> > confused though. Last week, I posted a question about caching
>> >> >> > and
>> >> >> > execution,
>> >> >> > and I was directed to the Report Manager (which - up to that time
>> >> >> > I
>> >> >> > knew
>> >> >> > nothing about). The instructions were
>> >> >> >
>> >> >> > http://myserver/Reports/Pages/Folder.aspx
>> >> >> >
>> >> >> > Now, you are suggesting that I add my account to the local
>> >> >> > administrator
>> >> >> > group. By my account do you mean my login account that I log
>> >> >> > into
>> >> >> > my
>> >> >> > workstation or server with - my network account? My account for
>> >> >> > loging
>> >> >> > into
>> >> >> > the workstation is in the administrator group on the server. Say
>> >> >> > my
>> >> >> > network
>> >> >> > login is joe123. May I request if you could specify what I have
>> >> >> > to
>> >> >> > do
>> >> >> > to
>> >> >> > joe123 so that I can use him as you suggest?
>> >> >> >
>> >> >> > http://joe123.../reports
>> >> >> >
>> >> >> > I appologize in advance for my lack of intuition on this and am
>> >> >> > very
>> >> >> > thankful for your reply and suggestions.
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Rich
>> >> >> >
>> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >
>> >> >> >> First off. Win 2003 server has extra security as far as IE is
>> >> >> >> concerned.
>> >> >> >> This can make it problematic to connect via IE to the report
>> >> >> >> server
>> >> >> >> when
>> >> >> >> you
>> >> >> >> are physically on the server. You are better off to do the
>> >> >> >> following.
>> >> >> >> 1. Add your account to the local administrator group
>> >> >> >> 2. From your computer use http://yourserver.blah.com/reports and
>> >> >> >> see
>> >> >> >> what
>> >> >> >> comes up.
>> >> >> >>
>> >> >> >> RS is an asp.net application. That is what you are logging into,
>> >> >> >> NOT
>> >> >> >> SQL
>> >> >> >> Server. So logging in with SA only works if the local
>> >> >> >> administrator
>> >> >> >> group
>> >> >> >> on
>> >> >> >> the server has a user called SA. Otherwise, it knows nothing
>> >> >> >> about
>> >> >> >> SA.
>> >> >> >> If
>> >> >> >> your local group has that in it then the issue is the added IE
>> >> >> >> security.
>> >> >> >> You
>> >> >> >> need to add the computer to the list of safe groups (I haven't
>> >> >> >> done
>> >> >> >> this
>> >> >> >> for
>> >> >> >> awhile). You really are better off to not do this from the
>> >> >> >> server.
>> >> >> >> It
>> >> >> >> is
>> >> >> >> better and easier to do it from your own PC.
>> >> >> >>
>> >> >> >> RS uses Role based security. Initially you have a single role of
>> >> >> >> which
>> >> >> >> the
>> >> >> >> local administrator group is in it (the administrator group).
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> Bruce Loehle-Conger
>> >> >> >> MVP SQL Server Reporting Services
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> >> >> >> > Greetings,
>> >> >> >> >
>> >> >> >> > I can't open Report Manager (sql Server 2000, win 2003
>> >> >> >> > server).
>> >> >> >> > I
>> >> >> >> > log
>> >> >> >> > into
>> >> >> >> > our server as SA where Reporting Services is/was installed (I
>> >> >> >> > did
>> >> >> >> > not
>> >> >> >> > perform
>> >> >> >> > the install). I go to start/Programs/Microsoft Sql
>> >> >> >> > Server/Reporting
>> >> >> >> > Services/Report Manager. This brings up a page that has an
>> >> >> >> > http
>> >> >> >> > error
>> >> >> >> > of
>> >> >> >> > 403. It says that IE can connect to the website but that IE
>> >> >> >> > doesn't
>> >> >> >> > have
>> >> >> >> > the
>> >> >> >> > permission to access the webpage (http://myserver/Reports).
>> >> >> >> >
>> >> >> >> > I looked at IIS and see the Reports virtual directory under
>> >> >> >> > Default
>> >> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The
>> >> >> >> > directory
>> >> >> >> > security
>> >> >> >> > is set for Integrated Windows Security.
>> >> >> >> >
>> >> >> >> > What can I do or what do I need to do so that I can access the
>> >> >> >> > Report
>> >> >> >> > Manager webpage? Do I need to configure something in IE or
>> >> >> >> > IIS?
>> >> >> >> > Or
>> >> >> >> > is
>> >> >> >> > it
>> >> >> >> > possible that the page isn't really there (bad install)?
>> >> >> >> >
>> >> >> >> > Thanks
>> >> >> >> > Rich
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
I can't open Report Manager (sql Server 2000, win 2003 server). I log into
our server as SA where Reporting Services is/was installed (I did not perform
the install). I go to start/Programs/Microsoft Sql Server/Reporting
Services/Report Manager. This brings up a page that has an http error of
403. It says that IE can connect to the website but that IE doesn't have the
permission to access the webpage (http://myserver/Reports).
I looked at IIS and see the Reports virtual directory under Default
Websites (and the pages virtual dir, Folder.aspx...). The directory security
is set for Integrated Windows Security.
What can I do or what do I need to do so that I can access the Report
Manager webpage? Do I need to configure something in IE or IIS? Or is it
possible that the page isn't really there (bad install)?
Thanks
RichFirst off. Win 2003 server has extra security as far as IE is concerned.
This can make it problematic to connect via IE to the report server when you
are physically on the server. You are better off to do the following.
1. Add your account to the local administrator group
2. From your computer use http://yourserver.blah.com/reports and see what
comes up.
RS is an asp.net application. That is what you are logging into, NOT SQL
Server. So logging in with SA only works if the local administrator group on
the server has a user called SA. Otherwise, it knows nothing about SA. If
your local group has that in it then the issue is the added IE security. You
need to add the computer to the list of safe groups (I haven't done this for
awhile). You really are better off to not do this from the server. It is
better and easier to do it from your own PC.
RS uses Role based security. Initially you have a single role of which the
local administrator group is in it (the administrator group).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> Greetings,
> I can't open Report Manager (sql Server 2000, win 2003 server). I log
> into
> our server as SA where Reporting Services is/was installed (I did not
> perform
> the install). I go to start/Programs/Microsoft Sql Server/Reporting
> Services/Report Manager. This brings up a page that has an http error of
> 403. It says that IE can connect to the website but that IE doesn't have
> the
> permission to access the webpage (http://myserver/Reports).
> I looked at IIS and see the Reports virtual directory under Default
> Websites (and the pages virtual dir, Folder.aspx...). The directory
> security
> is set for Integrated Windows Security.
> What can I do or what do I need to do so that I can access the Report
> Manager webpage? Do I need to configure something in IE or IIS? Or is it
> possible that the page isn't really there (bad install)?
> Thanks
> Rich|||Thank you very much for getting back to me on this. I am just a little
confused though. Last week, I posted a question about caching and execution,
and I was directed to the Report Manager (which - up to that time I knew
nothing about). The instructions were
http://myserver/Reports/Pages/Folder.aspx
Now, you are suggesting that I add my account to the local administrator
group. By my account do you mean my login account that I log into my
workstation or server with - my network account? My account for loging into
the workstation is in the administrator group on the server. Say my network
login is joe123. May I request if you could specify what I have to do to
joe123 so that I can use him as you suggest?
http://joe123.../reports
I appologize in advance for my lack of intuition on this and am very
thankful for your reply and suggestions.
Thanks,
Rich
"Bruce L-C [MVP]" wrote:
> First off. Win 2003 server has extra security as far as IE is concerned.
> This can make it problematic to connect via IE to the report server when you
> are physically on the server. You are better off to do the following.
> 1. Add your account to the local administrator group
> 2. From your computer use http://yourserver.blah.com/reports and see what
> comes up.
> RS is an asp.net application. That is what you are logging into, NOT SQL
> Server. So logging in with SA only works if the local administrator group on
> the server has a user called SA. Otherwise, it knows nothing about SA. If
> your local group has that in it then the issue is the added IE security. You
> need to add the computer to the list of safe groups (I haven't done this for
> awhile). You really are better off to not do this from the server. It is
> better and easier to do it from your own PC.
> RS uses Role based security. Initially you have a single role of which the
> local administrator group is in it (the administrator group).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> > Greetings,
> >
> > I can't open Report Manager (sql Server 2000, win 2003 server). I log
> > into
> > our server as SA where Reporting Services is/was installed (I did not
> > perform
> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> > Services/Report Manager. This brings up a page that has an http error of
> > 403. It says that IE can connect to the website but that IE doesn't have
> > the
> > permission to access the webpage (http://myserver/Reports).
> >
> > I looked at IIS and see the Reports virtual directory under Default
> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> > security
> > is set for Integrated Windows Security.
> >
> > What can I do or what do I need to do so that I can access the Report
> > Manager webpage? Do I need to configure something in IE or IIS? Or is it
> > possible that the page isn't really there (bad install)?
> >
> > Thanks
> > Rich
>
>|||Yes you need to use Report Manager but Report Manager is just a asp.net
application that is available from any PC. You do not need to be on the
server itself.
I do mean your login account that you use to log into your server. If your
account is already in the adminstrator group then you are good to go. From
your PC just put this into the URL
http://myserver/Reports/Pages/Folder.aspx
Note, depending on your network you might need to fully qualify the server
as myserver.whatever.com, you can also put the IP address directly like this
http://IPAddress/Pages/Folder.aspx
I very seldom login to my server directly. Either I am deploying reports
from my PC to the server or I am using Report Manager from my PC.
If you login to your server using your network login you can use IE there to
get to report manager but the enhanced security with 2003 server could cause
issues and you need to add the server (yes it is itself but the added
security doesn't know this) to approved security list. That is why I suggest
just doing this from your PC, not from the server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> Thank you very much for getting back to me on this. I am just a little
> confused though. Last week, I posted a question about caching and
> execution,
> and I was directed to the Report Manager (which - up to that time I knew
> nothing about). The instructions were
> http://myserver/Reports/Pages/Folder.aspx
> Now, you are suggesting that I add my account to the local administrator
> group. By my account do you mean my login account that I log into my
> workstation or server with - my network account? My account for loging
> into
> the workstation is in the administrator group on the server. Say my
> network
> login is joe123. May I request if you could specify what I have to do to
> joe123 so that I can use him as you suggest?
> http://joe123.../reports
> I appologize in advance for my lack of intuition on this and am very
> thankful for your reply and suggestions.
> Thanks,
> Rich
> "Bruce L-C [MVP]" wrote:
>> First off. Win 2003 server has extra security as far as IE is concerned.
>> This can make it problematic to connect via IE to the report server when
>> you
>> are physically on the server. You are better off to do the following.
>> 1. Add your account to the local administrator group
>> 2. From your computer use http://yourserver.blah.com/reports and see what
>> comes up.
>> RS is an asp.net application. That is what you are logging into, NOT SQL
>> Server. So logging in with SA only works if the local administrator group
>> on
>> the server has a user called SA. Otherwise, it knows nothing about SA. If
>> your local group has that in it then the issue is the added IE security.
>> You
>> need to add the computer to the list of safe groups (I haven't done this
>> for
>> awhile). You really are better off to not do this from the server. It is
>> better and easier to do it from your own PC.
>> RS uses Role based security. Initially you have a single role of which
>> the
>> local administrator group is in it (the administrator group).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> > Greetings,
>> >
>> > I can't open Report Manager (sql Server 2000, win 2003 server). I log
>> > into
>> > our server as SA where Reporting Services is/was installed (I did not
>> > perform
>> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
>> > Services/Report Manager. This brings up a page that has an http error
>> > of
>> > 403. It says that IE can connect to the website but that IE doesn't
>> > have
>> > the
>> > permission to access the webpage (http://myserver/Reports).
>> >
>> > I looked at IIS and see the Reports virtual directory under Default
>> > Websites (and the pages virtual dir, Folder.aspx...). The directory
>> > security
>> > is set for Integrated Windows Security.
>> >
>> > What can I do or what do I need to do so that I can access the Report
>> > Manager webpage? Do I need to configure something in IE or IIS? Or is
>> > it
>> > possible that the page isn't really there (bad install)?
>> >
>> > Thanks
>> > Rich
>>|||Well, I tried
http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
unauthorized
I also tried the qualified server name
http://myqualifiedserver.net/Reports/Pages/Folder.aspx
and
http://myqualifiedserver.net/Pages/Folder.aspx
with the same 401 error code
If people are able to get into Report Manager, then I should be able to get
in also. But what is the trick for me? Well, I thank you again for getting
back to me and with your suggestions. Just What is the trick?
Rich
"Bruce L-C [MVP]" wrote:
> Yes you need to use Report Manager but Report Manager is just a asp.net
> application that is available from any PC. You do not need to be on the
> server itself.
> I do mean your login account that you use to log into your server. If your
> account is already in the adminstrator group then you are good to go. From
> your PC just put this into the URL
> http://myserver/Reports/Pages/Folder.aspx
> Note, depending on your network you might need to fully qualify the server
> as myserver.whatever.com, you can also put the IP address directly like this
> http://IPAddress/Pages/Folder.aspx
> I very seldom login to my server directly. Either I am deploying reports
> from my PC to the server or I am using Report Manager from my PC.
> If you login to your server using your network login you can use IE there to
> get to report manager but the enhanced security with 2003 server could cause
> issues and you need to add the server (yes it is itself but the added
> security doesn't know this) to approved security list. That is why I suggest
> just doing this from your PC, not from the server.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
>
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> > Thank you very much for getting back to me on this. I am just a little
> > confused though. Last week, I posted a question about caching and
> > execution,
> > and I was directed to the Report Manager (which - up to that time I knew
> > nothing about). The instructions were
> >
> > http://myserver/Reports/Pages/Folder.aspx
> >
> > Now, you are suggesting that I add my account to the local administrator
> > group. By my account do you mean my login account that I log into my
> > workstation or server with - my network account? My account for loging
> > into
> > the workstation is in the administrator group on the server. Say my
> > network
> > login is joe123. May I request if you could specify what I have to do to
> > joe123 so that I can use him as you suggest?
> >
> > http://joe123.../reports
> >
> > I appologize in advance for my lack of intuition on this and am very
> > thankful for your reply and suggestions.
> >
> > Thanks,
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> First off. Win 2003 server has extra security as far as IE is concerned.
> >> This can make it problematic to connect via IE to the report server when
> >> you
> >> are physically on the server. You are better off to do the following.
> >> 1. Add your account to the local administrator group
> >> 2. From your computer use http://yourserver.blah.com/reports and see what
> >> comes up.
> >>
> >> RS is an asp.net application. That is what you are logging into, NOT SQL
> >> Server. So logging in with SA only works if the local administrator group
> >> on
> >> the server has a user called SA. Otherwise, it knows nothing about SA. If
> >> your local group has that in it then the issue is the added IE security.
> >> You
> >> need to add the computer to the list of safe groups (I haven't done this
> >> for
> >> awhile). You really are better off to not do this from the server. It is
> >> better and easier to do it from your own PC.
> >>
> >> RS uses Role based security. Initially you have a single role of which
> >> the
> >> local administrator group is in it (the administrator group).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> > Greetings,
> >> >
> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I log
> >> > into
> >> > our server as SA where Reporting Services is/was installed (I did not
> >> > perform
> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> >> > Services/Report Manager. This brings up a page that has an http error
> >> > of
> >> > 403. It says that IE can connect to the website but that IE doesn't
> >> > have
> >> > the
> >> > permission to access the webpage (http://myserver/Reports).
> >> >
> >> > I looked at IIS and see the Reports virtual directory under Default
> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> >> > security
> >> > is set for Integrated Windows Security.
> >> >
> >> > What can I do or what do I need to do so that I can access the Report
> >> > Manager webpage? Do I need to configure something in IE or IIS? Or is
> >> > it
> >> > possible that the page isn't really there (bad install)?
> >> >
> >> > Thanks
> >> > Rich
> >>
> >>
> >>
>
>|||My guess is that you might be in a administrators group but that group has
not been give administrative rights on the server. Login to that server as
you, check out the local administrators group. If it doesn't let you in to
view it or add to it then you do not have rights on that server. Get someone
who does to either add your specific domain\username to the local
administrator group or add the network administrator group to the local
administrator group.
I bet you don't have the rights to the server that you think you do. By
default, anyone in the local administrators group is in the RS administrator
role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> Well, I tried
> http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
> unauthorized
> I also tried the qualified server name
> http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> and
> http://myqualifiedserver.net/Pages/Folder.aspx
> with the same 401 error code
> If people are able to get into Report Manager, then I should be able to
> get
> in also. But what is the trick for me? Well, I thank you again for
> getting
> back to me and with your suggestions. Just What is the trick?
> Rich
> "Bruce L-C [MVP]" wrote:
>> Yes you need to use Report Manager but Report Manager is just a asp.net
>> application that is available from any PC. You do not need to be on the
>> server itself.
>> I do mean your login account that you use to log into your server. If
>> your
>> account is already in the adminstrator group then you are good to go.
>> From
>> your PC just put this into the URL
>> http://myserver/Reports/Pages/Folder.aspx
>> Note, depending on your network you might need to fully qualify the
>> server
>> as myserver.whatever.com, you can also put the IP address directly like
>> this
>> http://IPAddress/Pages/Folder.aspx
>> I very seldom login to my server directly. Either I am deploying reports
>> from my PC to the server or I am using Report Manager from my PC.
>> If you login to your server using your network login you can use IE there
>> to
>> get to report manager but the enhanced security with 2003 server could
>> cause
>> issues and you need to add the server (yes it is itself but the added
>> security doesn't know this) to approved security list. That is why I
>> suggest
>> just doing this from your PC, not from the server.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>>
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
>> > Thank you very much for getting back to me on this. I am just a little
>> > confused though. Last week, I posted a question about caching and
>> > execution,
>> > and I was directed to the Report Manager (which - up to that time I
>> > knew
>> > nothing about). The instructions were
>> >
>> > http://myserver/Reports/Pages/Folder.aspx
>> >
>> > Now, you are suggesting that I add my account to the local
>> > administrator
>> > group. By my account do you mean my login account that I log into my
>> > workstation or server with - my network account? My account for loging
>> > into
>> > the workstation is in the administrator group on the server. Say my
>> > network
>> > login is joe123. May I request if you could specify what I have to do
>> > to
>> > joe123 so that I can use him as you suggest?
>> >
>> > http://joe123.../reports
>> >
>> > I appologize in advance for my lack of intuition on this and am very
>> > thankful for your reply and suggestions.
>> >
>> > Thanks,
>> > Rich
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> First off. Win 2003 server has extra security as far as IE is
>> >> concerned.
>> >> This can make it problematic to connect via IE to the report server
>> >> when
>> >> you
>> >> are physically on the server. You are better off to do the following.
>> >> 1. Add your account to the local administrator group
>> >> 2. From your computer use http://yourserver.blah.com/reports and see
>> >> what
>> >> comes up.
>> >>
>> >> RS is an asp.net application. That is what you are logging into, NOT
>> >> SQL
>> >> Server. So logging in with SA only works if the local administrator
>> >> group
>> >> on
>> >> the server has a user called SA. Otherwise, it knows nothing about SA.
>> >> If
>> >> your local group has that in it then the issue is the added IE
>> >> security.
>> >> You
>> >> need to add the computer to the list of safe groups (I haven't done
>> >> this
>> >> for
>> >> awhile). You really are better off to not do this from the server. It
>> >> is
>> >> better and easier to do it from your own PC.
>> >>
>> >> RS uses Role based security. Initially you have a single role of which
>> >> the
>> >> local administrator group is in it (the administrator group).
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> >> > Greetings,
>> >> >
>> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I
>> >> > log
>> >> > into
>> >> > our server as SA where Reporting Services is/was installed (I did
>> >> > not
>> >> > perform
>> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
>> >> > Services/Report Manager. This brings up a page that has an http
>> >> > error
>> >> > of
>> >> > 403. It says that IE can connect to the website but that IE doesn't
>> >> > have
>> >> > the
>> >> > permission to access the webpage (http://myserver/Reports).
>> >> >
>> >> > I looked at IIS and see the Reports virtual directory under Default
>> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
>> >> > security
>> >> > is set for Integrated Windows Security.
>> >> >
>> >> > What can I do or what do I need to do so that I can access the
>> >> > Report
>> >> > Manager webpage? Do I need to configure something in IE or IIS? Or
>> >> > is
>> >> > it
>> >> > possible that the page isn't really there (bad install)?
>> >> >
>> >> > Thanks
>> >> > Rich
>> >>
>> >>
>> >>
>>|||Man, I sure hope that is it. The guy that owns the network, of course, is
not available right now. So when I see him, I will ask him to access report
manager from his workstation using his logon and not SA.
Rich
"Bruce L-C [MVP]" wrote:
> My guess is that you might be in a administrators group but that group has
> not been give administrative rights on the server. Login to that server as
> you, check out the local administrators group. If it doesn't let you in to
> view it or add to it then you do not have rights on that server. Get someone
> who does to either add your specific domain\username to the local
> administrator group or add the network administrator group to the local
> administrator group.
> I bet you don't have the rights to the server that you think you do. By
> default, anyone in the local administrators group is in the RS administrator
> role.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> > Well, I tried
> >
> > http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
> > unauthorized
> >
> > I also tried the qualified server name
> >
> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> > and
> > http://myqualifiedserver.net/Pages/Folder.aspx
> >
> > with the same 401 error code
> >
> > If people are able to get into Report Manager, then I should be able to
> > get
> > in also. But what is the trick for me? Well, I thank you again for
> > getting
> > back to me and with your suggestions. Just What is the trick?
> >
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Yes you need to use Report Manager but Report Manager is just a asp.net
> >> application that is available from any PC. You do not need to be on the
> >> server itself.
> >>
> >> I do mean your login account that you use to log into your server. If
> >> your
> >> account is already in the adminstrator group then you are good to go.
> >> From
> >> your PC just put this into the URL
> >> http://myserver/Reports/Pages/Folder.aspx
> >>
> >> Note, depending on your network you might need to fully qualify the
> >> server
> >> as myserver.whatever.com, you can also put the IP address directly like
> >> this
> >> http://IPAddress/Pages/Folder.aspx
> >>
> >> I very seldom login to my server directly. Either I am deploying reports
> >> from my PC to the server or I am using Report Manager from my PC.
> >>
> >> If you login to your server using your network login you can use IE there
> >> to
> >> get to report manager but the enhanced security with 2003 server could
> >> cause
> >> issues and you need to add the server (yes it is itself but the added
> >> security doesn't know this) to approved security list. That is why I
> >> suggest
> >> just doing this from your PC, not from the server.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> >> > Thank you very much for getting back to me on this. I am just a little
> >> > confused though. Last week, I posted a question about caching and
> >> > execution,
> >> > and I was directed to the Report Manager (which - up to that time I
> >> > knew
> >> > nothing about). The instructions were
> >> >
> >> > http://myserver/Reports/Pages/Folder.aspx
> >> >
> >> > Now, you are suggesting that I add my account to the local
> >> > administrator
> >> > group. By my account do you mean my login account that I log into my
> >> > workstation or server with - my network account? My account for loging
> >> > into
> >> > the workstation is in the administrator group on the server. Say my
> >> > network
> >> > login is joe123. May I request if you could specify what I have to do
> >> > to
> >> > joe123 so that I can use him as you suggest?
> >> >
> >> > http://joe123.../reports
> >> >
> >> > I appologize in advance for my lack of intuition on this and am very
> >> > thankful for your reply and suggestions.
> >> >
> >> > Thanks,
> >> > Rich
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> First off. Win 2003 server has extra security as far as IE is
> >> >> concerned.
> >> >> This can make it problematic to connect via IE to the report server
> >> >> when
> >> >> you
> >> >> are physically on the server. You are better off to do the following.
> >> >> 1. Add your account to the local administrator group
> >> >> 2. From your computer use http://yourserver.blah.com/reports and see
> >> >> what
> >> >> comes up.
> >> >>
> >> >> RS is an asp.net application. That is what you are logging into, NOT
> >> >> SQL
> >> >> Server. So logging in with SA only works if the local administrator
> >> >> group
> >> >> on
> >> >> the server has a user called SA. Otherwise, it knows nothing about SA.
> >> >> If
> >> >> your local group has that in it then the issue is the added IE
> >> >> security.
> >> >> You
> >> >> need to add the computer to the list of safe groups (I haven't done
> >> >> this
> >> >> for
> >> >> awhile). You really are better off to not do this from the server. It
> >> >> is
> >> >> better and easier to do it from your own PC.
> >> >>
> >> >> RS uses Role based security. Initially you have a single role of which
> >> >> the
> >> >> local administrator group is in it (the administrator group).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> >> > Greetings,
> >> >> >
> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I
> >> >> > log
> >> >> > into
> >> >> > our server as SA where Reporting Services is/was installed (I did
> >> >> > not
> >> >> > perform
> >> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> >> >> > Services/Report Manager. This brings up a page that has an http
> >> >> > error
> >> >> > of
> >> >> > 403. It says that IE can connect to the website but that IE doesn't
> >> >> > have
> >> >> > the
> >> >> > permission to access the webpage (http://myserver/Reports).
> >> >> >
> >> >> > I looked at IIS and see the Reports virtual directory under Default
> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> >> >> > security
> >> >> > is set for Integrated Windows Security.
> >> >> >
> >> >> > What can I do or what do I need to do so that I can access the
> >> >> > Report
> >> >> > Manager webpage? Do I need to configure something in IE or IIS? Or
> >> >> > is
> >> >> > it
> >> >> > possible that the page isn't really there (bad install)?
> >> >> >
> >> >> > Thanks
> >> >> > Rich
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||The owner got back and tried opening Report manager with no success except
for one interesting error message - the message said something about looking
for .Net Framework 1.1.
We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
Visual Studio 2005. Would this be an issue for Report Manager for RS2003?
We are still using Sql Server 2000.
"Bruce L-C [MVP]" wrote:
> My guess is that you might be in a administrators group but that group has
> not been give administrative rights on the server. Login to that server as
> you, check out the local administrators group. If it doesn't let you in to
> view it or add to it then you do not have rights on that server. Get someone
> who does to either add your specific domain\username to the local
> administrator group or add the network administrator group to the local
> administrator group.
> I bet you don't have the rights to the server that you think you do. By
> default, anyone in the local administrators group is in the RS administrator
> role.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> > Well, I tried
> >
> > http://myservername/Reports/Pages/Folder.aspx and got the http 401 error -
> > unauthorized
> >
> > I also tried the qualified server name
> >
> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> > and
> > http://myqualifiedserver.net/Pages/Folder.aspx
> >
> > with the same 401 error code
> >
> > If people are able to get into Report Manager, then I should be able to
> > get
> > in also. But what is the trick for me? Well, I thank you again for
> > getting
> > back to me and with your suggestions. Just What is the trick?
> >
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Yes you need to use Report Manager but Report Manager is just a asp.net
> >> application that is available from any PC. You do not need to be on the
> >> server itself.
> >>
> >> I do mean your login account that you use to log into your server. If
> >> your
> >> account is already in the adminstrator group then you are good to go.
> >> From
> >> your PC just put this into the URL
> >> http://myserver/Reports/Pages/Folder.aspx
> >>
> >> Note, depending on your network you might need to fully qualify the
> >> server
> >> as myserver.whatever.com, you can also put the IP address directly like
> >> this
> >> http://IPAddress/Pages/Folder.aspx
> >>
> >> I very seldom login to my server directly. Either I am deploying reports
> >> from my PC to the server or I am using Report Manager from my PC.
> >>
> >> If you login to your server using your network login you can use IE there
> >> to
> >> get to report manager but the enhanced security with 2003 server could
> >> cause
> >> issues and you need to add the server (yes it is itself but the added
> >> security doesn't know this) to approved security list. That is why I
> >> suggest
> >> just doing this from your PC, not from the server.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> >> > Thank you very much for getting back to me on this. I am just a little
> >> > confused though. Last week, I posted a question about caching and
> >> > execution,
> >> > and I was directed to the Report Manager (which - up to that time I
> >> > knew
> >> > nothing about). The instructions were
> >> >
> >> > http://myserver/Reports/Pages/Folder.aspx
> >> >
> >> > Now, you are suggesting that I add my account to the local
> >> > administrator
> >> > group. By my account do you mean my login account that I log into my
> >> > workstation or server with - my network account? My account for loging
> >> > into
> >> > the workstation is in the administrator group on the server. Say my
> >> > network
> >> > login is joe123. May I request if you could specify what I have to do
> >> > to
> >> > joe123 so that I can use him as you suggest?
> >> >
> >> > http://joe123.../reports
> >> >
> >> > I appologize in advance for my lack of intuition on this and am very
> >> > thankful for your reply and suggestions.
> >> >
> >> > Thanks,
> >> > Rich
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> First off. Win 2003 server has extra security as far as IE is
> >> >> concerned.
> >> >> This can make it problematic to connect via IE to the report server
> >> >> when
> >> >> you
> >> >> are physically on the server. You are better off to do the following.
> >> >> 1. Add your account to the local administrator group
> >> >> 2. From your computer use http://yourserver.blah.com/reports and see
> >> >> what
> >> >> comes up.
> >> >>
> >> >> RS is an asp.net application. That is what you are logging into, NOT
> >> >> SQL
> >> >> Server. So logging in with SA only works if the local administrator
> >> >> group
> >> >> on
> >> >> the server has a user called SA. Otherwise, it knows nothing about SA.
> >> >> If
> >> >> your local group has that in it then the issue is the added IE
> >> >> security.
> >> >> You
> >> >> need to add the computer to the list of safe groups (I haven't done
> >> >> this
> >> >> for
> >> >> awhile). You really are better off to not do this from the server. It
> >> >> is
> >> >> better and easier to do it from your own PC.
> >> >>
> >> >> RS uses Role based security. Initially you have a single role of which
> >> >> the
> >> >> local administrator group is in it (the administrator group).
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> >> > Greetings,
> >> >> >
> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server). I
> >> >> > log
> >> >> > into
> >> >> > our server as SA where Reporting Services is/was installed (I did
> >> >> > not
> >> >> > perform
> >> >> > the install). I go to start/Programs/Microsoft Sql Server/Reporting
> >> >> > Services/Report Manager. This brings up a page that has an http
> >> >> > error
> >> >> > of
> >> >> > 403. It says that IE can connect to the website but that IE doesn't
> >> >> > have
> >> >> > the
> >> >> > permission to access the webpage (http://myserver/Reports).
> >> >> >
> >> >> > I looked at IIS and see the Reports virtual directory under Default
> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The directory
> >> >> > security
> >> >> > is set for Integrated Windows Security.
> >> >> >
> >> >> > What can I do or what do I need to do so that I can access the
> >> >> > Report
> >> >> > Manager webpage? Do I need to configure something in IE or IIS? Or
> >> >> > is
> >> >> > it
> >> >> > possible that the page isn't really there (bad install)?
> >> >> >
> >> >> > Thanks
> >> >> > Rich
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||Yes.
RS 2000 is a 1.1 framework app. RS 2005 is a 2.0 framework app. It is fine
that you upgraded to 2.0 BUT you have to have Reports and ReportServer webs
be at 1.1 (IIS will support both but you have to configure the sites to be
1.1).
Not sure if this is all the reason but it is definitely a problem. Get the
owner to work first and then get back to your problem. You might have more
than one problem going on.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:FA0B37D6-B5D1-4C13-B0F4-8AAF9D39974D@.microsoft.com...
> The owner got back and tried opening Report manager with no success except
> for one interesting error message - the message said something about
> looking
> for .Net Framework 1.1.
> We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
> Visual Studio 2005. Would this be an issue for Report Manager for
> RS2003?
> We are still using Sql Server 2000.
> "Bruce L-C [MVP]" wrote:
>> My guess is that you might be in a administrators group but that group
>> has
>> not been give administrative rights on the server. Login to that server
>> as
>> you, check out the local administrators group. If it doesn't let you in
>> to
>> view it or add to it then you do not have rights on that server. Get
>> someone
>> who does to either add your specific domain\username to the local
>> administrator group or add the network administrator group to the local
>> administrator group.
>> I bet you don't have the rights to the server that you think you do. By
>> default, anyone in the local administrators group is in the RS
>> administrator
>> role.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
>> > Well, I tried
>> >
>> > http://myservername/Reports/Pages/Folder.aspx and got the http 401
>> > error -
>> > unauthorized
>> >
>> > I also tried the qualified server name
>> >
>> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
>> > and
>> > http://myqualifiedserver.net/Pages/Folder.aspx
>> >
>> > with the same 401 error code
>> >
>> > If people are able to get into Report Manager, then I should be able to
>> > get
>> > in also. But what is the trick for me? Well, I thank you again for
>> > getting
>> > back to me and with your suggestions. Just What is the trick?
>> >
>> > Rich
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Yes you need to use Report Manager but Report Manager is just a
>> >> asp.net
>> >> application that is available from any PC. You do not need to be on
>> >> the
>> >> server itself.
>> >>
>> >> I do mean your login account that you use to log into your server. If
>> >> your
>> >> account is already in the adminstrator group then you are good to go.
>> >> From
>> >> your PC just put this into the URL
>> >> http://myserver/Reports/Pages/Folder.aspx
>> >>
>> >> Note, depending on your network you might need to fully qualify the
>> >> server
>> >> as myserver.whatever.com, you can also put the IP address directly
>> >> like
>> >> this
>> >> http://IPAddress/Pages/Folder.aspx
>> >>
>> >> I very seldom login to my server directly. Either I am deploying
>> >> reports
>> >> from my PC to the server or I am using Report Manager from my PC.
>> >>
>> >> If you login to your server using your network login you can use IE
>> >> there
>> >> to
>> >> get to report manager but the enhanced security with 2003 server could
>> >> cause
>> >> issues and you need to add the server (yes it is itself but the added
>> >> security doesn't know this) to approved security list. That is why I
>> >> suggest
>> >> just doing this from your PC, not from the server.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
>> >> > Thank you very much for getting back to me on this. I am just a
>> >> > little
>> >> > confused though. Last week, I posted a question about caching and
>> >> > execution,
>> >> > and I was directed to the Report Manager (which - up to that time I
>> >> > knew
>> >> > nothing about). The instructions were
>> >> >
>> >> > http://myserver/Reports/Pages/Folder.aspx
>> >> >
>> >> > Now, you are suggesting that I add my account to the local
>> >> > administrator
>> >> > group. By my account do you mean my login account that I log into
>> >> > my
>> >> > workstation or server with - my network account? My account for
>> >> > loging
>> >> > into
>> >> > the workstation is in the administrator group on the server. Say my
>> >> > network
>> >> > login is joe123. May I request if you could specify what I have to
>> >> > do
>> >> > to
>> >> > joe123 so that I can use him as you suggest?
>> >> >
>> >> > http://joe123.../reports
>> >> >
>> >> > I appologize in advance for my lack of intuition on this and am very
>> >> > thankful for your reply and suggestions.
>> >> >
>> >> > Thanks,
>> >> > Rich
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> First off. Win 2003 server has extra security as far as IE is
>> >> >> concerned.
>> >> >> This can make it problematic to connect via IE to the report server
>> >> >> when
>> >> >> you
>> >> >> are physically on the server. You are better off to do the
>> >> >> following.
>> >> >> 1. Add your account to the local administrator group
>> >> >> 2. From your computer use http://yourserver.blah.com/reports and
>> >> >> see
>> >> >> what
>> >> >> comes up.
>> >> >>
>> >> >> RS is an asp.net application. That is what you are logging into,
>> >> >> NOT
>> >> >> SQL
>> >> >> Server. So logging in with SA only works if the local administrator
>> >> >> group
>> >> >> on
>> >> >> the server has a user called SA. Otherwise, it knows nothing about
>> >> >> SA.
>> >> >> If
>> >> >> your local group has that in it then the issue is the added IE
>> >> >> security.
>> >> >> You
>> >> >> need to add the computer to the list of safe groups (I haven't done
>> >> >> this
>> >> >> for
>> >> >> awhile). You really are better off to not do this from the server.
>> >> >> It
>> >> >> is
>> >> >> better and easier to do it from your own PC.
>> >> >>
>> >> >> RS uses Role based security. Initially you have a single role of
>> >> >> which
>> >> >> the
>> >> >> local administrator group is in it (the administrator group).
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> >> >> > Greetings,
>> >> >> >
>> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server).
>> >> >> > I
>> >> >> > log
>> >> >> > into
>> >> >> > our server as SA where Reporting Services is/was installed (I did
>> >> >> > not
>> >> >> > perform
>> >> >> > the install). I go to start/Programs/Microsoft Sql
>> >> >> > Server/Reporting
>> >> >> > Services/Report Manager. This brings up a page that has an http
>> >> >> > error
>> >> >> > of
>> >> >> > 403. It says that IE can connect to the website but that IE
>> >> >> > doesn't
>> >> >> > have
>> >> >> > the
>> >> >> > permission to access the webpage (http://myserver/Reports).
>> >> >> >
>> >> >> > I looked at IIS and see the Reports virtual directory under
>> >> >> > Default
>> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The
>> >> >> > directory
>> >> >> > security
>> >> >> > is set for Integrated Windows Security.
>> >> >> >
>> >> >> > What can I do or what do I need to do so that I can access the
>> >> >> > Report
>> >> >> > Manager webpage? Do I need to configure something in IE or IIS?
>> >> >> > Or
>> >> >> > is
>> >> >> > it
>> >> >> > possible that the page isn't really there (bad install)?
>> >> >> >
>> >> >> > Thanks
>> >> >> > Rich
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks. We have a web guy at my place that I have apprised about the
situation. Hopefully, he can figure out how to configure the sites for .net
framework 1.1.
Note: I can deploy reports with my current setup and things work OK except
for the caching thing - which is why I need to get into Report Manager in the
first place.
Rich
"Bruce L-C [MVP]" wrote:
> Yes.
> RS 2000 is a 1.1 framework app. RS 2005 is a 2.0 framework app. It is fine
> that you upgraded to 2.0 BUT you have to have Reports and ReportServer webs
> be at 1.1 (IIS will support both but you have to configure the sites to be
> 1.1).
> Not sure if this is all the reason but it is definitely a problem. Get the
> owner to work first and then get back to your problem. You might have more
> than one problem going on.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:FA0B37D6-B5D1-4C13-B0F4-8AAF9D39974D@.microsoft.com...
> > The owner got back and tried opening Report manager with no success except
> > for one interesting error message - the message said something about
> > looking
> > for .Net Framework 1.1.
> >
> > We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
> > Visual Studio 2005. Would this be an issue for Report Manager for
> > RS2003?
> > We are still using Sql Server 2000.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> My guess is that you might be in a administrators group but that group
> >> has
> >> not been give administrative rights on the server. Login to that server
> >> as
> >> you, check out the local administrators group. If it doesn't let you in
> >> to
> >> view it or add to it then you do not have rights on that server. Get
> >> someone
> >> who does to either add your specific domain\username to the local
> >> administrator group or add the network administrator group to the local
> >> administrator group.
> >>
> >> I bet you don't have the rights to the server that you think you do. By
> >> default, anyone in the local administrators group is in the RS
> >> administrator
> >> role.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
> >> > Well, I tried
> >> >
> >> > http://myservername/Reports/Pages/Folder.aspx and got the http 401
> >> > error -
> >> > unauthorized
> >> >
> >> > I also tried the qualified server name
> >> >
> >> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
> >> > and
> >> > http://myqualifiedserver.net/Pages/Folder.aspx
> >> >
> >> > with the same 401 error code
> >> >
> >> > If people are able to get into Report Manager, then I should be able to
> >> > get
> >> > in also. But what is the trick for me? Well, I thank you again for
> >> > getting
> >> > back to me and with your suggestions. Just What is the trick?
> >> >
> >> > Rich
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Yes you need to use Report Manager but Report Manager is just a
> >> >> asp.net
> >> >> application that is available from any PC. You do not need to be on
> >> >> the
> >> >> server itself.
> >> >>
> >> >> I do mean your login account that you use to log into your server. If
> >> >> your
> >> >> account is already in the adminstrator group then you are good to go.
> >> >> From
> >> >> your PC just put this into the URL
> >> >> http://myserver/Reports/Pages/Folder.aspx
> >> >>
> >> >> Note, depending on your network you might need to fully qualify the
> >> >> server
> >> >> as myserver.whatever.com, you can also put the IP address directly
> >> >> like
> >> >> this
> >> >> http://IPAddress/Pages/Folder.aspx
> >> >>
> >> >> I very seldom login to my server directly. Either I am deploying
> >> >> reports
> >> >> from my PC to the server or I am using Report Manager from my PC.
> >> >>
> >> >> If you login to your server using your network login you can use IE
> >> >> there
> >> >> to
> >> >> get to report manager but the enhanced security with 2003 server could
> >> >> cause
> >> >> issues and you need to add the server (yes it is itself but the added
> >> >> security doesn't know this) to approved security list. That is why I
> >> >> suggest
> >> >> just doing this from your PC, not from the server.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
> >> >> > Thank you very much for getting back to me on this. I am just a
> >> >> > little
> >> >> > confused though. Last week, I posted a question about caching and
> >> >> > execution,
> >> >> > and I was directed to the Report Manager (which - up to that time I
> >> >> > knew
> >> >> > nothing about). The instructions were
> >> >> >
> >> >> > http://myserver/Reports/Pages/Folder.aspx
> >> >> >
> >> >> > Now, you are suggesting that I add my account to the local
> >> >> > administrator
> >> >> > group. By my account do you mean my login account that I log into
> >> >> > my
> >> >> > workstation or server with - my network account? My account for
> >> >> > loging
> >> >> > into
> >> >> > the workstation is in the administrator group on the server. Say my
> >> >> > network
> >> >> > login is joe123. May I request if you could specify what I have to
> >> >> > do
> >> >> > to
> >> >> > joe123 so that I can use him as you suggest?
> >> >> >
> >> >> > http://joe123.../reports
> >> >> >
> >> >> > I appologize in advance for my lack of intuition on this and am very
> >> >> > thankful for your reply and suggestions.
> >> >> >
> >> >> > Thanks,
> >> >> > Rich
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> First off. Win 2003 server has extra security as far as IE is
> >> >> >> concerned.
> >> >> >> This can make it problematic to connect via IE to the report server
> >> >> >> when
> >> >> >> you
> >> >> >> are physically on the server. You are better off to do the
> >> >> >> following.
> >> >> >> 1. Add your account to the local administrator group
> >> >> >> 2. From your computer use http://yourserver.blah.com/reports and
> >> >> >> see
> >> >> >> what
> >> >> >> comes up.
> >> >> >>
> >> >> >> RS is an asp.net application. That is what you are logging into,
> >> >> >> NOT
> >> >> >> SQL
> >> >> >> Server. So logging in with SA only works if the local administrator
> >> >> >> group
> >> >> >> on
> >> >> >> the server has a user called SA. Otherwise, it knows nothing about
> >> >> >> SA.
> >> >> >> If
> >> >> >> your local group has that in it then the issue is the added IE
> >> >> >> security.
> >> >> >> You
> >> >> >> need to add the computer to the list of safe groups (I haven't done
> >> >> >> this
> >> >> >> for
> >> >> >> awhile). You really are better off to not do this from the server.
> >> >> >> It
> >> >> >> is
> >> >> >> better and easier to do it from your own PC.
> >> >> >>
> >> >> >> RS uses Role based security. Initially you have a single role of
> >> >> >> which
> >> >> >> the
> >> >> >> local administrator group is in it (the administrator group).
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
> >> >> >> > Greetings,
> >> >> >> >
> >> >> >> > I can't open Report Manager (sql Server 2000, win 2003 server).
> >> >> >> > I
> >> >> >> > log
> >> >> >> > into
> >> >> >> > our server as SA where Reporting Services is/was installed (I did
> >> >> >> > not
> >> >> >> > perform
> >> >> >> > the install). I go to start/Programs/Microsoft Sql
> >> >> >> > Server/Reporting
> >> >> >> > Services/Report Manager. This brings up a page that has an http
> >> >> >> > error
> >> >> >> > of
> >> >> >> > 403. It says that IE can connect to the website but that IE
> >> >> >> > doesn't
> >> >> >> > have
> >> >> >> > the
> >> >> >> > permission to access the webpage (http://myserver/Reports).
> >> >> >> >
> >> >> >> > I looked at IIS and see the Reports virtual directory under
> >> >> >> > Default
> >> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The
> >> >> >> > directory
> >> >> >> > security
> >> >> >> > is set for Integrated Windows Security.
> >> >> >> >
> >> >> >> > What can I do or what do I need to do so that I can access the
> >> >> >> > Report
> >> >> >> > Manager webpage? Do I need to configure something in IE or IIS?
> >> >> >> > Or
> >> >> >> > is
> >> >> >> > it
> >> >> >> > possible that the page isn't really there (bad install)?
> >> >> >> >
> >> >> >> > Thanks
> >> >> >> > Rich
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I'm surprised you can deploy. It could be that reportserver website is still
1.1 and reports website (which is the report manager app) was set to 2.0
(but needs to be 1.1).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:1F8AC4CC-86E0-4124-8C8A-84FA8D25744D@.microsoft.com...
> Thanks. We have a web guy at my place that I have apprised about the
> situation. Hopefully, he can figure out how to configure the sites for
> .net
> framework 1.1.
> Note: I can deploy reports with my current setup and things work OK
> except
> for the caching thing - which is why I need to get into Report Manager in
> the
> first place.
> Rich
> "Bruce L-C [MVP]" wrote:
>> Yes.
>> RS 2000 is a 1.1 framework app. RS 2005 is a 2.0 framework app. It is
>> fine
>> that you upgraded to 2.0 BUT you have to have Reports and ReportServer
>> webs
>> be at 1.1 (IIS will support both but you have to configure the sites to
>> be
>> 1.1).
>> Not sure if this is all the reason but it is definitely a problem. Get
>> the
>> owner to work first and then get back to your problem. You might have
>> more
>> than one problem going on.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> news:FA0B37D6-B5D1-4C13-B0F4-8AAF9D39974D@.microsoft.com...
>> > The owner got back and tried opening Report manager with no success
>> > except
>> > for one interesting error message - the message said something about
>> > looking
>> > for .Net Framework 1.1.
>> >
>> > We used to be on 1.1 but upgraded to .Net Framework 2.0 so we could use
>> > Visual Studio 2005. Would this be an issue for Report Manager for
>> > RS2003?
>> > We are still using Sql Server 2000.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> My guess is that you might be in a administrators group but that group
>> >> has
>> >> not been give administrative rights on the server. Login to that
>> >> server
>> >> as
>> >> you, check out the local administrators group. If it doesn't let you
>> >> in
>> >> to
>> >> view it or add to it then you do not have rights on that server. Get
>> >> someone
>> >> who does to either add your specific domain\username to the local
>> >> administrator group or add the network administrator group to the
>> >> local
>> >> administrator group.
>> >>
>> >> I bet you don't have the rights to the server that you think you do.
>> >> By
>> >> default, anyone in the local administrators group is in the RS
>> >> administrator
>> >> role.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> news:80CF0AE5-2E85-4709-93A5-6CAE65398E1A@.microsoft.com...
>> >> > Well, I tried
>> >> >
>> >> > http://myservername/Reports/Pages/Folder.aspx and got the http 401
>> >> > error -
>> >> > unauthorized
>> >> >
>> >> > I also tried the qualified server name
>> >> >
>> >> > http://myqualifiedserver.net/Reports/Pages/Folder.aspx
>> >> > and
>> >> > http://myqualifiedserver.net/Pages/Folder.aspx
>> >> >
>> >> > with the same 401 error code
>> >> >
>> >> > If people are able to get into Report Manager, then I should be able
>> >> > to
>> >> > get
>> >> > in also. But what is the trick for me? Well, I thank you again for
>> >> > getting
>> >> > back to me and with your suggestions. Just What is the trick?
>> >> >
>> >> > Rich
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Yes you need to use Report Manager but Report Manager is just a
>> >> >> asp.net
>> >> >> application that is available from any PC. You do not need to be on
>> >> >> the
>> >> >> server itself.
>> >> >>
>> >> >> I do mean your login account that you use to log into your server.
>> >> >> If
>> >> >> your
>> >> >> account is already in the adminstrator group then you are good to
>> >> >> go.
>> >> >> From
>> >> >> your PC just put this into the URL
>> >> >> http://myserver/Reports/Pages/Folder.aspx
>> >> >>
>> >> >> Note, depending on your network you might need to fully qualify the
>> >> >> server
>> >> >> as myserver.whatever.com, you can also put the IP address directly
>> >> >> like
>> >> >> this
>> >> >> http://IPAddress/Pages/Folder.aspx
>> >> >>
>> >> >> I very seldom login to my server directly. Either I am deploying
>> >> >> reports
>> >> >> from my PC to the server or I am using Report Manager from my PC.
>> >> >>
>> >> >> If you login to your server using your network login you can use IE
>> >> >> there
>> >> >> to
>> >> >> get to report manager but the enhanced security with 2003 server
>> >> >> could
>> >> >> cause
>> >> >> issues and you need to add the server (yes it is itself but the
>> >> >> added
>> >> >> security doesn't know this) to approved security list. That is why
>> >> >> I
>> >> >> suggest
>> >> >> just doing this from your PC, not from the server.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> news:C6628278-F12B-432D-876E-74B8F17BBC94@.microsoft.com...
>> >> >> > Thank you very much for getting back to me on this. I am just a
>> >> >> > little
>> >> >> > confused though. Last week, I posted a question about caching
>> >> >> > and
>> >> >> > execution,
>> >> >> > and I was directed to the Report Manager (which - up to that time
>> >> >> > I
>> >> >> > knew
>> >> >> > nothing about). The instructions were
>> >> >> >
>> >> >> > http://myserver/Reports/Pages/Folder.aspx
>> >> >> >
>> >> >> > Now, you are suggesting that I add my account to the local
>> >> >> > administrator
>> >> >> > group. By my account do you mean my login account that I log
>> >> >> > into
>> >> >> > my
>> >> >> > workstation or server with - my network account? My account for
>> >> >> > loging
>> >> >> > into
>> >> >> > the workstation is in the administrator group on the server. Say
>> >> >> > my
>> >> >> > network
>> >> >> > login is joe123. May I request if you could specify what I have
>> >> >> > to
>> >> >> > do
>> >> >> > to
>> >> >> > joe123 so that I can use him as you suggest?
>> >> >> >
>> >> >> > http://joe123.../reports
>> >> >> >
>> >> >> > I appologize in advance for my lack of intuition on this and am
>> >> >> > very
>> >> >> > thankful for your reply and suggestions.
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Rich
>> >> >> >
>> >> >> > "Bruce L-C [MVP]" wrote:
>> >> >> >
>> >> >> >> First off. Win 2003 server has extra security as far as IE is
>> >> >> >> concerned.
>> >> >> >> This can make it problematic to connect via IE to the report
>> >> >> >> server
>> >> >> >> when
>> >> >> >> you
>> >> >> >> are physically on the server. You are better off to do the
>> >> >> >> following.
>> >> >> >> 1. Add your account to the local administrator group
>> >> >> >> 2. From your computer use http://yourserver.blah.com/reports and
>> >> >> >> see
>> >> >> >> what
>> >> >> >> comes up.
>> >> >> >>
>> >> >> >> RS is an asp.net application. That is what you are logging into,
>> >> >> >> NOT
>> >> >> >> SQL
>> >> >> >> Server. So logging in with SA only works if the local
>> >> >> >> administrator
>> >> >> >> group
>> >> >> >> on
>> >> >> >> the server has a user called SA. Otherwise, it knows nothing
>> >> >> >> about
>> >> >> >> SA.
>> >> >> >> If
>> >> >> >> your local group has that in it then the issue is the added IE
>> >> >> >> security.
>> >> >> >> You
>> >> >> >> need to add the computer to the list of safe groups (I haven't
>> >> >> >> done
>> >> >> >> this
>> >> >> >> for
>> >> >> >> awhile). You really are better off to not do this from the
>> >> >> >> server.
>> >> >> >> It
>> >> >> >> is
>> >> >> >> better and easier to do it from your own PC.
>> >> >> >>
>> >> >> >> RS uses Role based security. Initially you have a single role of
>> >> >> >> which
>> >> >> >> the
>> >> >> >> local administrator group is in it (the administrator group).
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> Bruce Loehle-Conger
>> >> >> >> MVP SQL Server Reporting Services
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
>> >> >> >> news:EC013E36-671E-48B2-A3EF-929CF99B6B2A@.microsoft.com...
>> >> >> >> > Greetings,
>> >> >> >> >
>> >> >> >> > I can't open Report Manager (sql Server 2000, win 2003
>> >> >> >> > server).
>> >> >> >> > I
>> >> >> >> > log
>> >> >> >> > into
>> >> >> >> > our server as SA where Reporting Services is/was installed (I
>> >> >> >> > did
>> >> >> >> > not
>> >> >> >> > perform
>> >> >> >> > the install). I go to start/Programs/Microsoft Sql
>> >> >> >> > Server/Reporting
>> >> >> >> > Services/Report Manager. This brings up a page that has an
>> >> >> >> > http
>> >> >> >> > error
>> >> >> >> > of
>> >> >> >> > 403. It says that IE can connect to the website but that IE
>> >> >> >> > doesn't
>> >> >> >> > have
>> >> >> >> > the
>> >> >> >> > permission to access the webpage (http://myserver/Reports).
>> >> >> >> >
>> >> >> >> > I looked at IIS and see the Reports virtual directory under
>> >> >> >> > Default
>> >> >> >> > Websites (and the pages virtual dir, Folder.aspx...). The
>> >> >> >> > directory
>> >> >> >> > security
>> >> >> >> > is set for Integrated Windows Security.
>> >> >> >> >
>> >> >> >> > What can I do or what do I need to do so that I can access the
>> >> >> >> > Report
>> >> >> >> > Manager webpage? Do I need to configure something in IE or
>> >> >> >> > IIS?
>> >> >> >> > Or
>> >> >> >> > is
>> >> >> >> > it
>> >> >> >> > possible that the page isn't really there (bad install)?
>> >> >> >> >
>> >> >> >> > Thanks
>> >> >> >> > Rich
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
Subscribe to:
Posts (Atom)