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