Can't send out mail if Outlook not open ?

Dear experts,
In my server, I have created a scheduled task that use SENDMAIL to send some
reports to my boss email ... but I find that if the mail cannot send out if
the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
we have a few days holiday) ...
So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
is closed ' if so, can someone tell me how to solve this problem (except
ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
!!!Some versions of Outlook require keeping Outlook open for
SQL Mail to work correctly. You may also want to refer to
the following articles:
INF: How to Configure SQL Mail
http://support.microsoft.com/?id=263556
INF: Common SQL Mail Problems
http://support.microsoft.com/?id=315886
One way around this is to not use Outlook, MAPI for mail and
just use smtp. You can download an extended stored procedure
to send mail using SMTP. You can find the download and more
information at:
http://www.sqldev.net/xp/xpsmtp.htm
-Sue
On Sun, 3 Oct 2004 19:31:09 -0700, "Devil Garfield"
<DevilGarfield@.discussions.microsoft.com> wrote:
>Dear experts,
>In my server, I have created a scheduled task that use SENDMAIL to send some
>reports to my boss email ... but I find that if the mail cannot send out if
>the OUTLOOK in the server was closed ... everytime I need to open the OUTLOOK
>and press SEND/RECEIVE to send those mail out. (It will be a big trouble if
>we have a few days holiday) ...
>So can anyone know why the SENDMAIL function cannot operate when the OUTLOOK
>is closed ' if so, can someone tell me how to solve this problem (except
>ALWAYS OPEN THE OUTLOOK), thanks very much for all of your concern & helping
>!!!

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

cant see Report manager page

Hi Friends
we've report server (sql server 2005 standard edi) on win 2003 server. i can see report manager page (i.e. http://servername/reports) from my machine but some of out users cant see this page !!
all they can see is "sql server reporting services" text nothing else. no reports and no models ertc.,

i assume its something to do with rights issue. where can i set these rights so that all users within our domain can see and create reports off report server page.
Thanks for your help.From the main page, select the properties tab, then select the security sub-tab. You can grant the necessary permissions to any group or user there.|||Thanks for that Brian. I just tried that but did not work.
our domain name is "yabba.co.nz" so i added domain by clicking "new role assignment" but to no avail.
so i tried add one of users ,who is having this problem like "yabba.co.nz\Peter" but got following error
The user or group name 'yabba.co.nz/Peter' is not recognized. (rsUnknownUserName)

any ideas please.
Thanks for your help|||You should be specifying the user or group name the same way you would for an ACL, such as for the file system. If you are using a domain user, the report server machine must be a part of that domain.|||Thank you very much Brian.
That really helped . now all our users could view report manager page and they can view and run reports now :)

one thing remained though, they cant see "Report builder" link .i tried to assign all roles (i.e. browser,content manager etc.,) but still did not help.
any ideas on this one.
Thanks for your help again :)|||

The user must have "Execute Report Definition" permission. This is a system level permission that can be configured from the "Site Settings" link at the top of Report Manager.

|||Thank you very much Brian.
That worked like a charm. Thanks for all your help :)

Can't run reports in Report Builder

I've followed the Adventure Works tutorial for Report Builder, but when I click Run Report I get this error message:

Report execution error
The report might not be valid or the server could not process the data.

Input string was not in a correct format.
-
Remote GDI stream version: 10.0.1. Expected version: 10.0.1.

Any ideas?

Most likely this is happening because you're running with regional settings on the client not equal to US English.

I'm always getting this error after a new installation, but when I switch from Norwegian to US English Regional Settings, the error disappears.

Trond

|||

Yes, switching the regional settings to US English should work for CTP builds.
Note: the underlying issue is fixed for the final SQL Server 2005 RTM release.

-- Robert

|||Thanks guys, that worked.

/Jonas|||Hello

I have a similar problem, but when I create a pivot table connecting to an OLAP cube in SQL2005. This does not work and I get an error message saying: XML for analysis parser: The lovalidentifier property is not overwriteable .....

If I change my settings from swedish to American English it works.
Can I say to my customer that Ii also will be fixed in the final release?

Thanks
/Martin

Can't run deployed report that runs in development (BIDS)

I have a number of reports that use one of two shared data sources. All of
these reports used to work/run fine in both BIDS and on the server after
deployment. However, recently I cannot run any of them from the
reportserver - but they still all work fine in BIDS.
One datasoure is a SQL2005 database and the other is an older Gupta SQLBase
database (via OLEDB).
The error I get in the report window is bad username or password.
The only thing that's changed recently is that I was forced to change my
domain password. But I also changed any reporting reference to the
username/password as well - and like I said all runs well from BIDS.
I've fiddled with the shared datasource properties/security - trying out
different options but I still can't get this to work. Can anyone provide
some pointers/insight?
Thanks.Michael,
The default behavior in Visual Studio (BIDS) is not to push a datasource if
one already exists with the same name. Thus if you make a change in BIDS, it
will not get updated to the server if it already exists, unless you change
the default behavior.
Right click on the Project icon in Solution Explorer and select Properties,
and then change the OverwriteDataSources to true and re-deploy the datasource
with the updates.
I suggest changing it back when you are done. This is a great option for
deployments into different environments.
Reeves
"Michael K. Walter" wrote:
> I have a number of reports that use one of two shared data sources. All of
> these reports used to work/run fine in both BIDS and on the server after
> deployment. However, recently I cannot run any of them from the
> reportserver - but they still all work fine in BIDS.
> One datasoure is a SQL2005 database and the other is an older Gupta SQLBase
> database (via OLEDB).
> The error I get in the report window is bad username or password.
> The only thing that's changed recently is that I was forced to change my
> domain password. But I also changed any reporting reference to the
> username/password as well - and like I said all runs well from BIDS.
> I've fiddled with the shared datasource properties/security - trying out
> different options but I still can't get this to work. Can anyone provide
> some pointers/insight?
> Thanks.
>
>|||Thanks Reeves.
However, I'm pretty sure I tried that already. I'll go back into the
projects and double check though.
Michael
"Reeves Smith" <ReevesSmith@.discussions.microsoft.com> wrote in message
news:F378170C-9297-4177-9BAF-7ACD30ACE5E3@.microsoft.com...
> Michael,
> The default behavior in Visual Studio (BIDS) is not to push a datasource
> if
> one already exists with the same name. Thus if you make a change in BIDS,
> it
> will not get updated to the server if it already exists, unless you change
> the default behavior.
> Right click on the Project icon in Solution Explorer and select
> Properties,
> and then change the OverwriteDataSources to true and re-deploy the
> datasource
> with the updates.
> I suggest changing it back when you are done. This is a great option for
> deployments into different environments.
> Reeves
> "Michael K. Walter" wrote:
>> I have a number of reports that use one of two shared data sources. All
>> of
>> these reports used to work/run fine in both BIDS and on the server after
>> deployment. However, recently I cannot run any of them from the
>> reportserver - but they still all work fine in BIDS.
>> One datasoure is a SQL2005 database and the other is an older Gupta
>> SQLBase
>> database (via OLEDB).
>> The error I get in the report window is bad username or password.
>> The only thing that's changed recently is that I was forced to change my
>> domain password. But I also changed any reporting reference to the
>> username/password as well - and like I said all runs well from BIDS.
>> I've fiddled with the shared datasource properties/security - trying out
>> different options but I still can't get this to work. Can anyone provide
>> some pointers/insight?
>> Thanks.
>>

Cant PREVIEW SAMPLE REPORTS

Hi,
I tried to view the sample reports provided by microsoft, but I cant even
preview them...I get the error::
AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION TO
THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
DENIED...
But the wierd thing is that I CAN PREVIEW THE FOODMART SALES REPORT!... Why
is that?
Also, when I tried to create a subscription as in their walkthrough I get
the error:
"The dataset cannot be generated. An error occurred while connecting to a
data source, or the query is not valid for the data source.
(rsCannotPrepareQuery)
SQL Server does not exist or access denied. A valid query must be
specified. "
But the query is simply Select * from table...
Any idea why these things are happening? Also, the reports are already
successfully deployed to the server...
Plz help...Thanks
--
pmudAs part of setup did you choose to install the AdventureWorks2000 database?
If so did you make sure the AdventureWorks shared datasource was pointed to
wherever that database was installed?
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
> Hi,
> I tried to view the sample reports provided by microsoft, but I cant even
> preview them...I get the error::
> AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION TO
> THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
> DENIED...
> But the wierd thing is that I CAN PREVIEW THE FOODMART SALES REPORT!...
> Why
> is that?
> Also, when I tried to create a subscription as in their walkthrough I get
> the error:
> "The dataset cannot be generated. An error occurred while connecting to a
> data source, or the query is not valid for the data source.
> (rsCannotPrepareQuery)
> SQL Server does not exist or access denied. A valid query must be
> specified. "
> But the query is simply Select * from table...
> Any idea why these things are happening? Also, the reports are already
> successfully deployed to the server...
> Plz help...Thanks
> --
> pmud|||Hi Douglas,
the adventure works database is installed bcoz the forrdmart sales report is
using it & i can preview that sample report... But how to make sure that
adventuer works databse was pointed to '
Thanks
"Douglas McDowell" wrote:
> As part of setup did you choose to install the AdventureWorks2000 database?
> If so did you make sure the AdventureWorks shared datasource was pointed to
> wherever that database was installed?
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
> > Hi,
> >
> > I tried to view the sample reports provided by microsoft, but I cant even
> > preview them...I get the error::
> >
> > AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION TO
> > THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
> > DENIED...
> >
> > But the wierd thing is that I CAN PREVIEW THE FOODMART SALES REPORT!...
> > Why
> > is that?
> >
> > Also, when I tried to create a subscription as in their walkthrough I get
> > the error:
> >
> > "The dataset cannot be generated. An error occurred while connecting to a
> > data source, or the query is not valid for the data source.
> > (rsCannotPrepareQuery)
> > SQL Server does not exist or access denied. A valid query must be
> > specified. "
> >
> > But the query is simply Select * from table...
> >
> > Any idea why these things are happening? Also, the reports are already
> > successfully deployed to the server...
> >
> > Plz help...Thanks
> > --
> > pmud
>
>|||Foodmart Sales is the only report that does not use AdventureWorks2000, it
uses FoodMart, the default Analysis Services OLAP database. Open Enterprise
manager on the SQL Server instance that you are pointing your shared
datasource to and see if it has an AdventureWorks2000 database.
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:4B67C061-122A-42F6-BF3F-58DBC3539326@.microsoft.com...
> Hi Douglas,
> the adventure works database is installed bcoz the forrdmart sales report
> is
> using it & i can preview that sample report... But how to make sure that
> adventuer works databse was pointed to '
> Thanks
> "Douglas McDowell" wrote:
>> As part of setup did you choose to install the AdventureWorks2000
>> database?
>> If so did you make sure the AdventureWorks shared datasource was pointed
>> to
>> wherever that database was installed?
>> --
>> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>>
>> "pmud" <pmud@.discussions.microsoft.com> wrote in message
>> news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
>> > Hi,
>> >
>> > I tried to view the sample reports provided by microsoft, but I cant
>> > even
>> > preview them...I get the error::
>> >
>> > AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION
>> > TO
>> > THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
>> > DENIED...
>> >
>> > But the wierd thing is that I CAN PREVIEW THE FOODMART SALES
>> > REPORT!...
>> > Why
>> > is that?
>> >
>> > Also, when I tried to create a subscription as in their walkthrough I
>> > get
>> > the error:
>> >
>> > "The dataset cannot be generated. An error occurred while connecting to
>> > a
>> > data source, or the query is not valid for the data source.
>> > (rsCannotPrepareQuery)
>> > SQL Server does not exist or access denied. A valid query must be
>> > specified. "
>> >
>> > But the query is simply Select * from table...
>> >
>> > Any idea why these things are happening? Also, the reports are already
>> > successfully deployed to the server...
>> >
>> > Plz help...Thanks
>> > --
>> > pmud
>>|||Hi Douglas,
I checked the enterprise manager, it has the Adventure works database...
Also, I faced a similar problem just now.. I think it has smthg to do with
analysis manager & enterprise manager... I bought the book by
Microsoft..."SQL service sreporting services 2000 Step by Step" & installed
the samples from CD... It had a sample database called rs2000DW which got
restored to the ANALYSIS MANAGER...
Now I tried to create a report using this data source.... But i get the
error :: Connection open...SQL server doesnt exist or access denied... In
the server name i had typed localhost....I even tried typing the IP address
there & the Computer name... But it gives the same error msg...
Can it be bcoz In my enterprise manager... the SQL server instance name is
DEVELOPMENT\DEV & in the ANALYSIS MANAGER its called DEVELOPMENT '
It doesnt see the data source from ANALYSIS Mgr . but sees from enterprise
manager when i use the server name as DEVELPOMENT\DEV..'
Whats wrong? Plz help...
Thanks
"Douglas McDowell" wrote:
> Foodmart Sales is the only report that does not use AdventureWorks2000, it
> uses FoodMart, the default Analysis Services OLAP database. Open Enterprise
> manager on the SQL Server instance that you are pointing your shared
> datasource to and see if it has an AdventureWorks2000 database.
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:4B67C061-122A-42F6-BF3F-58DBC3539326@.microsoft.com...
> > Hi Douglas,
> >
> > the adventure works database is installed bcoz the forrdmart sales report
> > is
> > using it & i can preview that sample report... But how to make sure that
> > adventuer works databse was pointed to '
> >
> > Thanks
> >
> > "Douglas McDowell" wrote:
> >
> >> As part of setup did you choose to install the AdventureWorks2000
> >> database?
> >> If so did you make sure the AdventureWorks shared datasource was pointed
> >> to
> >> wherever that database was installed?
> >> --
> >> Douglas McDowell douglas@.nospam.solidqualitylearning.com
> >>
> >>
> >> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> >> news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
> >> > Hi,
> >> >
> >> > I tried to view the sample reports provided by microsoft, but I cant
> >> > even
> >> > preview them...I get the error::
> >> >
> >> > AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE CONNCTION
> >> > TO
> >> > THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
> >> > DENIED...
> >> >
> >> > But the wierd thing is that I CAN PREVIEW THE FOODMART SALES
> >> > REPORT!...
> >> > Why
> >> > is that?
> >> >
> >> > Also, when I tried to create a subscription as in their walkthrough I
> >> > get
> >> > the error:
> >> >
> >> > "The dataset cannot be generated. An error occurred while connecting to
> >> > a
> >> > data source, or the query is not valid for the data source.
> >> > (rsCannotPrepareQuery)
> >> > SQL Server does not exist or access denied. A valid query must be
> >> > specified. "
> >> >
> >> > But the query is simply Select * from table...
> >> >
> >> > Any idea why these things are happening? Also, the reports are already
> >> > successfully deployed to the server...
> >> >
> >> > Plz help...Thanks
> >> > --
> >> > pmud
> >>
> >>
> >>
>
>|||Looks like you have a named instance of SQL Server, so in your SQL Server
connection string for your datasource you need to specify DEVELOPMENT\DEV
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:7E49FB2F-C9D3-49F8-A3CD-FA4CF586C2DE@.microsoft.com...
> Hi Douglas,
> I checked the enterprise manager, it has the Adventure works database...
> Also, I faced a similar problem just now.. I think it has smthg to do with
> analysis manager & enterprise manager... I bought the book by
> Microsoft..."SQL service sreporting services 2000 Step by Step" &
> installed
> the samples from CD... It had a sample database called rs2000DW which got
> restored to the ANALYSIS MANAGER...
> Now I tried to create a report using this data source.... But i get the
> error :: Connection open...SQL server doesnt exist or access denied... In
> the server name i had typed localhost....I even tried typing the IP
> address
> there & the Computer name... But it gives the same error msg...
> Can it be bcoz In my enterprise manager... the SQL server instance name is
> DEVELOPMENT\DEV & in the ANALYSIS MANAGER its called DEVELOPMENT '
> It doesnt see the data source from ANALYSIS Mgr . but sees from enterprise
> manager when i use the server name as DEVELPOMENT\DEV..'
> Whats wrong? Plz help...
> Thanks
> "Douglas McDowell" wrote:
>> Foodmart Sales is the only report that does not use AdventureWorks2000,
>> it
>> uses FoodMart, the default Analysis Services OLAP database. Open
>> Enterprise
>> manager on the SQL Server instance that you are pointing your shared
>> datasource to and see if it has an AdventureWorks2000 database.
>> --
>> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>>
>> "pmud" <pmud@.discussions.microsoft.com> wrote in message
>> news:4B67C061-122A-42F6-BF3F-58DBC3539326@.microsoft.com...
>> > Hi Douglas,
>> >
>> > the adventure works database is installed bcoz the forrdmart sales
>> > report
>> > is
>> > using it & i can preview that sample report... But how to make sure
>> > that
>> > adventuer works databse was pointed to '
>> >
>> > Thanks
>> >
>> > "Douglas McDowell" wrote:
>> >
>> >> As part of setup did you choose to install the AdventureWorks2000
>> >> database?
>> >> If so did you make sure the AdventureWorks shared datasource was
>> >> pointed
>> >> to
>> >> wherever that database was installed?
>> >> --
>> >> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>> >>
>> >>
>> >> "pmud" <pmud@.discussions.microsoft.com> wrote in message
>> >> news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
>> >> > Hi,
>> >> >
>> >> > I tried to view the sample reports provided by microsoft, but I cant
>> >> > even
>> >> > preview them...I get the error::
>> >> >
>> >> > AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE
>> >> > CONNCTION
>> >> > TO
>> >> > THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
>> >> > DENIED...
>> >> >
>> >> > But the wierd thing is that I CAN PREVIEW THE FOODMART SALES
>> >> > REPORT!...
>> >> > Why
>> >> > is that?
>> >> >
>> >> > Also, when I tried to create a subscription as in their walkthrough
>> >> > I
>> >> > get
>> >> > the error:
>> >> >
>> >> > "The dataset cannot be generated. An error occurred while connecting
>> >> > to
>> >> > a
>> >> > data source, or the query is not valid for the data source.
>> >> > (rsCannotPrepareQuery)
>> >> > SQL Server does not exist or access denied. A valid query must be
>> >> > specified. "
>> >> >
>> >> > But the query is simply Select * from table...
>> >> >
>> >> > Any idea why these things are happening? Also, the reports are
>> >> > already
>> >> > successfully deployed to the server...
>> >> >
>> >> > Plz help...Thanks
>> >> > --
>> >> > pmud
>> >>
>> >>
>> >>
>>|||Thanks Douglas , that solves one of my problems. I can preview th sample
reports now... Thanks... I guess my other doubts should be aske din the next
question...
Thanks again...
"Douglas McDowell" wrote:
> Looks like you have a named instance of SQL Server, so in your SQL Server
> connection string for your datasource you need to specify DEVELOPMENT\DEV
> --
> Douglas McDowell douglas@.nospam.solidqualitylearning.com
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:7E49FB2F-C9D3-49F8-A3CD-FA4CF586C2DE@.microsoft.com...
> > Hi Douglas,
> >
> > I checked the enterprise manager, it has the Adventure works database...
> >
> > Also, I faced a similar problem just now.. I think it has smthg to do with
> > analysis manager & enterprise manager... I bought the book by
> > Microsoft..."SQL service sreporting services 2000 Step by Step" &
> > installed
> > the samples from CD... It had a sample database called rs2000DW which got
> > restored to the ANALYSIS MANAGER...
> >
> > Now I tried to create a report using this data source.... But i get the
> > error :: Connection open...SQL server doesnt exist or access denied... In
> > the server name i had typed localhost....I even tried typing the IP
> > address
> > there & the Computer name... But it gives the same error msg...
> >
> > Can it be bcoz In my enterprise manager... the SQL server instance name is
> > DEVELOPMENT\DEV & in the ANALYSIS MANAGER its called DEVELOPMENT '
> >
> > It doesnt see the data source from ANALYSIS Mgr . but sees from enterprise
> > manager when i use the server name as DEVELPOMENT\DEV..'
> >
> > Whats wrong? Plz help...
> >
> > Thanks
> > "Douglas McDowell" wrote:
> >
> >> Foodmart Sales is the only report that does not use AdventureWorks2000,
> >> it
> >> uses FoodMart, the default Analysis Services OLAP database. Open
> >> Enterprise
> >> manager on the SQL Server instance that you are pointing your shared
> >> datasource to and see if it has an AdventureWorks2000 database.
> >> --
> >> Douglas McDowell douglas@.nospam.solidqualitylearning.com
> >>
> >>
> >> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> >> news:4B67C061-122A-42F6-BF3F-58DBC3539326@.microsoft.com...
> >> > Hi Douglas,
> >> >
> >> > the adventure works database is installed bcoz the forrdmart sales
> >> > report
> >> > is
> >> > using it & i can preview that sample report... But how to make sure
> >> > that
> >> > adventuer works databse was pointed to '
> >> >
> >> > Thanks
> >> >
> >> > "Douglas McDowell" wrote:
> >> >
> >> >> As part of setup did you choose to install the AdventureWorks2000
> >> >> database?
> >> >> If so did you make sure the AdventureWorks shared datasource was
> >> >> pointed
> >> >> to
> >> >> wherever that database was installed?
> >> >> --
> >> >> Douglas McDowell douglas@.nospam.solidqualitylearning.com
> >> >>
> >> >>
> >> >> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> >> >> news:0EA50AAF-11C8-4CAE-AD1C-E3E03522115F@.microsoft.com...
> >> >> > Hi,
> >> >> >
> >> >> > I tried to view the sample reports provided by microsoft, but I cant
> >> >> > even
> >> >> > preview them...I get the error::
> >> >> >
> >> >> > AN ERROR HAS OCCURED DURING REPORT PROCESSING. CANNOY CREATE
> >> >> > CONNCTION
> >> >> > TO
> >> >> > THE DATA SOURCE 'ADVENTURE WORKS'. SQL SERVER DOESNT EXIST or ACCESS
> >> >> > DENIED...
> >> >> >
> >> >> > But the wierd thing is that I CAN PREVIEW THE FOODMART SALES
> >> >> > REPORT!...
> >> >> > Why
> >> >> > is that?
> >> >> >
> >> >> > Also, when I tried to create a subscription as in their walkthrough
> >> >> > I
> >> >> > get
> >> >> > the error:
> >> >> >
> >> >> > "The dataset cannot be generated. An error occurred while connecting
> >> >> > to
> >> >> > a
> >> >> > data source, or the query is not valid for the data source.
> >> >> > (rsCannotPrepareQuery)
> >> >> > SQL Server does not exist or access denied. A valid query must be
> >> >> > specified. "
> >> >> >
> >> >> > But the query is simply Select * from table...
> >> >> >
> >> >> > Any idea why these things are happening? Also, the reports are
> >> >> > already
> >> >> > successfully deployed to the server...
> >> >> >
> >> >> > Plz help...Thanks
> >> >> > --
> >> >> > pmud
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

Can't open reports with Intranet user

Hi,
I made some reports and I deployed them on my local report server. I want
someone in the Intranet to be able to view them. I did set up the role to
make the intranet group to be able to browse my reports. They can view the
list of the report when they access it from http://server/ReportServer But
they just can't view it when they click on a report. It says they don't have
permissions to open ReportViewer.aspx.
I wonder why it is the problem.Ok I found the problem. The file ReportViewer.aspx didn't gave the
authorization to my Intranet group.

Can''t open reports page?

I have problem and I can't open http://localhost/reports. I get error "The request failed with HTTP status 400: Bad Request." When I try open page http://localhost/reportserver he open OK.

Lp,

Hello,

Check your RSWebApplication.config and insure that the URL listed for ReportServerUrl is correct. Check your IIS logs and see details about the error.

Larry Smithmier

Can''t open reports page?

I have problem and I can't open http://localhost/reports. I get error "The request failed with HTTP status 400: Bad Request." When I try open page http://localhost/reportserver he open OK.

Lp,

Hello,

Check your RSWebApplication.config and insure that the URL listed for ReportServerUrl is correct. Check your IIS logs and see details about the error.

Larry Smithmier

Can't open reports or reportserver from ie

When I open reports or reportserver from my browser ie, I get these error :c:\windows\system32\inetsrv> "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\csc.exe" /t:library /utf8output /R:"C:\WINDOWS\assembly\GAC_32\System.Web\2.0.0.0__b03f5f7f11d50a3a\System.Web.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll" /R:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\55a9c3a5\2dd8b450\assembly\dl3\78d258ab\001b93a3_c59ec501\ReportingServicesWebServer.DLL" /out:"C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\55a9c3a5\2dd8b450\App_global.asax.ggydouar.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699 "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\55a9c3a5\2dd8b450\App_global.asax.ggydouar.0.cs" "C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\55a9c3a5\2dd8b450\App_global.asax.ggydouar.1.cs"
Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.7
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.

error CS0016: Could not write to output file 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\55a9c3a5\2dd8b450\App_global.asax.ggydouar.dll' -- 'Access is denied. '
SQL Server 2005 pre-sept build 1306 install with win2k3 english.The user who is trying to access these reports donot appear to have access to the reporting folders on the reporting server. Please take a look at the role based security and allow either browse or contect security etc depending on your situation and what best fits the role for the user.|||I found this from event viewer:
Event code: 3007
Event message: A compilation error has occurred.
Event time: 2005-9-9 15:09:05
Event time (UTC): 2005-9-9 7:09:05
Event ID: 2ffe05bcfac741fe8474778ceeb33d9e
Event sequence: 3
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/ReportServer-1-127707233419132704
Trust level: RosettaSrv
Application Virtual Path: /ReportServer
Application Path: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\
Machine name: ****
Process information:
Process ID: 2948
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: HttpCompileException
Exception message: (0): error CS0016: Could not write to output file 'c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\reportserver\55a9c3a5\2dd8b450|||Try this:
* run iisreset
* access the /reportserver or /reports virtual roots with a user that is a local administrator on the server
-- Robert

Can't get to where to manage roles

Yesterday, I was able to go to http://localhost/reports and manage roles and
users in those roles.
Today, that page looks different. I'm not sure if anyone ran anything or
what, but I now just see links for various projects.
I noticed in IIS that there is a pages/roles.aspx page so I typed
http://localhost/reports/pages/roles.aspx and I did see the list of roles.
But when I click on "Browsers" it tells me the IUSR account does not have
permissions.
What's going on? Shouldn't I be able to get to roles without having to know
the .aspx page? Where are the links for this?
I'm so confused. Thanks for any help.
RonNevermind. I needed to set anonymous access to off in both Reports and
ReportServer.
"Ronald S. Cook" <rcook@.westinis.com> wrote in message
news:%23oPNn$pWHHA.600@.TK2MSFTNGP05.phx.gbl...
> Yesterday, I was able to go to http://localhost/reports and manage roles
> and users in those roles.
> Today, that page looks different. I'm not sure if anyone ran anything or
> what, but I now just see links for various projects.
> I noticed in IIS that there is a pages/roles.aspx page so I typed
> http://localhost/reports/pages/roles.aspx and I did see the list of roles.
> But when I click on "Browsers" it tells me the IUSR account does not have
> permissions.
> What's going on? Shouldn't I be able to get to roles without having to
> know the .aspx page? Where are the links for this?
> I'm so confused. Thanks for any help.
> Ron
>
>

can't get to report manager

My company recently upgraded to CRM 3.0 and i was trying to get to the report
manager page in my browser to make custom reports. Unfortunately, whenever i
try to go to the report manager page i get the error listed below. Has anyone
ever seen this before? Thanks in advance for any help you can give me.
Server Error in '/ReportMgr' Application.
----
Configuration Error
Description: An error occurred during the processing of a configuration file
required to service this request. Please review the specific error details
below and modify your configuration file appropriately.
Parser Error Message: Assembly microsoft.crm.platform.proxy.dll security
permission grant set is incompatible between appdomains.
Source Error:
Line 15: <add assembly="Microsoft.Crm.ObjectModel, Version=3.0.5300.0,
Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
Line 16: <add assembly="Microsoft.Crm.Platform.ComProxy,
Version=3.0.5300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
Line 17: <add assembly="Microsoft.Crm.Platform.Proxy,
Version=3.0.5300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
Line 18: <add assembly="Microsoft.Crm.Platform.Server,
Version=3.0.5300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
Line 19: <add assembly="Microsoft.Crm.Platform.Sdk, Version=3.0.5300.0,
Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
Source File: c:\inetpub\wwwroot\web.config Line: 17
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300did you solve this problem I am seeing something similar?
"ACreel" wrote:
> My company recently upgraded to CRM 3.0 and i was trying to get to the report
> manager page in my browser to make custom reports. Unfortunately, whenever i
> try to go to the report manager page i get the error listed below. Has anyone
> ever seen this before? Thanks in advance for any help you can give me.
> Server Error in '/ReportMgr' Application.
> ----
> Configuration Error
> Description: An error occurred during the processing of a configuration file
> required to service this request. Please review the specific error details
> below and modify your configuration file appropriately.
> Parser Error Message: Assembly microsoft.crm.platform.proxy.dll security
> permission grant set is incompatible between appdomains.
> Source Error:
>
> Line 15: <add assembly="Microsoft.Crm.ObjectModel, Version=3.0.5300.0,
> Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
> Line 16: <add assembly="Microsoft.Crm.Platform.ComProxy,
> Version=3.0.5300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
> Line 17: <add assembly="Microsoft.Crm.Platform.Proxy,
> Version=3.0.5300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
> Line 18: <add assembly="Microsoft.Crm.Platform.Server,
> Version=3.0.5300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
> Line 19: <add assembly="Microsoft.Crm.Platform.Sdk, Version=3.0.5300.0,
> Culture=neutral, PublicKeyToken=31bf3856ad364e35" />
>
> Source File: c:\inetpub\wwwroot\web.config Line: 17
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
> Version:1.1.4322.2300

Can't get reports to print

Hello,
We have never been able to get the printing to work on any of our reports
using SQL Server Reporting Services SP2.
During the time we have been fighting to get this to work we had added on
the SP, so we totally rebuilt the machine from scratch, that didn't help. In
addition a couple of months ago we bought a totally new machine to host our
reports and the fresh install on that machine didn't yeild any results.
At some point I found some posts in the newsgroup about needing to uninstall
an old ActiveX control used for printing, I did this and installed the new
one but that didn't help either.
We can print to things like the "Microsoft Office Document Image Writer"
without problem, only when we try to print to a real printer does it bomb out.
It doesn't matter how big the report is, 100 pages or 1/4 of a page, same
problem.
We do the following:
Run the report
Click the print button
Select a printer and press ok
"Printing Now..." dialog box appears
"Print Error" dialog appears showing "An error occured during printing.
(0x80004005). The misspelling of "occured" is how it is displayed in the
message.
Click OK and you get a JS error dialog "Line: 19. Error: Unspecifiied Error".
This is the result on every computer we have ever used in trying to access
the report server.
Any help?Are you printing to a local or network printer? Printing from IE, Firefox,
<insert other browser here>? I've had the best luck printing from IE to a
local printer.
--
Floyd
"msmolarek@.community.nospam"
<msmolarek@.community.nospam@.discussions.microsoft.com> wrote in message
news:C3830BDC-C2E0-4F82-85B8-101949ED1B5D@.microsoft.com...
> Hello,
> We have never been able to get the printing to work on any of our reports
> using SQL Server Reporting Services SP2.
> During the time we have been fighting to get this to work we had added on
> the SP, so we totally rebuilt the machine from scratch, that didn't help.
> In
> addition a couple of months ago we bought a totally new machine to host
> our
> reports and the fresh install on that machine didn't yeild any results.
> At some point I found some posts in the newsgroup about needing to
> uninstall
> an old ActiveX control used for printing, I did this and installed the new
> one but that didn't help either.
> We can print to things like the "Microsoft Office Document Image Writer"
> without problem, only when we try to print to a real printer does it bomb
> out.
> It doesn't matter how big the report is, 100 pages or 1/4 of a page, same
> problem.
> We do the following:
> Run the report
> Click the print button
> Select a printer and press ok
> "Printing Now..." dialog box appears
> "Print Error" dialog appears showing "An error occured during printing.
> (0x80004005). The misspelling of "occured" is how it is displayed in the
> message.
> Click OK and you get a JS error dialog "Line: 19. Error: Unspecifiied
> Error".
>
> This is the result on every computer we have ever used in trying to access
> the report server.
> Any help?|||We are printing to network printers from IE.
I hooked up a local printer to a computer just to try, and it prints the
first page OK, and then pops up the same error message as usual: "0x80004005"
Even if it worked on a local printer, this is supposed to be an enterprise
solution. 99% of our employees print to network printers.
"Floyd Burger" wrote:
> Are you printing to a local or network printer? Printing from IE, Firefox,
> <insert other browser here>? I've had the best luck printing from IE to a
> local printer.
> --
> Floyd
> "msmolarek@.community.nospam"
> <msmolarek@.community.nospam@.discussions.microsoft.com> wrote in message
> news:C3830BDC-C2E0-4F82-85B8-101949ED1B5D@.microsoft.com...
> > Hello,
> >
> > We have never been able to get the printing to work on any of our reports
> > using SQL Server Reporting Services SP2.
> >
> > During the time we have been fighting to get this to work we had added on
> > the SP, so we totally rebuilt the machine from scratch, that didn't help.
> > In
> > addition a couple of months ago we bought a totally new machine to host
> > our
> > reports and the fresh install on that machine didn't yeild any results.
> >
> > At some point I found some posts in the newsgroup about needing to
> > uninstall
> > an old ActiveX control used for printing, I did this and installed the new
> > one but that didn't help either.
> >
> > We can print to things like the "Microsoft Office Document Image Writer"
> > without problem, only when we try to print to a real printer does it bomb
> > out.
> >
> > It doesn't matter how big the report is, 100 pages or 1/4 of a page, same
> > problem.
> >
> > We do the following:
> >
> > Run the report
> > Click the print button
> > Select a printer and press ok
> > "Printing Now..." dialog box appears
> > "Print Error" dialog appears showing "An error occured during printing.
> > (0x80004005). The misspelling of "occured" is how it is displayed in the
> > message.
> > Click OK and you get a JS error dialog "Line: 19. Error: Unspecifiied
> > Error".
> >
> >
> > This is the result on every computer we have ever used in trying to access
> > the report server.
> >
> > Any help?
>
>|||I print exclusively to network printers. We do not have local printers at
work.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"msmolarek@.community.nospam"
<msmolarekcommunitynospam@.discussions.microsoft.com> wrote in message
news:5378230C-8CCE-43BE-9868-D1BC12940358@.microsoft.com...
> We are printing to network printers from IE.
> I hooked up a local printer to a computer just to try, and it prints the
> first page OK, and then pops up the same error message as usual:
> "0x80004005"
> Even if it worked on a local printer, this is supposed to be an enterprise
> solution. 99% of our employees print to network printers.
>
> "Floyd Burger" wrote:
>> Are you printing to a local or network printer? Printing from IE,
>> Firefox,
>> <insert other browser here>? I've had the best luck printing from IE to
>> a
>> local printer.
>> --
>> Floyd
>> "msmolarek@.community.nospam"
>> <msmolarek@.community.nospam@.discussions.microsoft.com> wrote in message
>> news:C3830BDC-C2E0-4F82-85B8-101949ED1B5D@.microsoft.com...
>> > Hello,
>> >
>> > We have never been able to get the printing to work on any of our
>> > reports
>> > using SQL Server Reporting Services SP2.
>> >
>> > During the time we have been fighting to get this to work we had added
>> > on
>> > the SP, so we totally rebuilt the machine from scratch, that didn't
>> > help.
>> > In
>> > addition a couple of months ago we bought a totally new machine to host
>> > our
>> > reports and the fresh install on that machine didn't yeild any results.
>> >
>> > At some point I found some posts in the newsgroup about needing to
>> > uninstall
>> > an old ActiveX control used for printing, I did this and installed the
>> > new
>> > one but that didn't help either.
>> >
>> > We can print to things like the "Microsoft Office Document Image
>> > Writer"
>> > without problem, only when we try to print to a real printer does it
>> > bomb
>> > out.
>> >
>> > It doesn't matter how big the report is, 100 pages or 1/4 of a page,
>> > same
>> > problem.
>> >
>> > We do the following:
>> >
>> > Run the report
>> > Click the print button
>> > Select a printer and press ok
>> > "Printing Now..." dialog box appears
>> > "Print Error" dialog appears showing "An error occured during printing.
>> > (0x80004005). The misspelling of "occured" is how it is displayed in
>> > the
>> > message.
>> > Click OK and you get a JS error dialog "Line: 19. Error: Unspecifiied
>> > Error".
>> >
>> >
>> > This is the result on every computer we have ever used in trying to
>> > access
>> > the report server.
>> >
>> > Any help?
>>|||How can I find the disconnect here then?
I have read that this error indicates "Access is denied", and others have
mentioned that maybe I don't have printer rights.
I am logged into my machine as a domain admin. I have no printing problems
in any program to any printer, except when using Reporting Services.
"Bruce L-C [MVP]" wrote:
> I print exclusively to network printers. We do not have local printers at
> work.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "msmolarek@.community.nospam"
> <msmolarekcommunitynospam@.discussions.microsoft.com> wrote in message
> news:5378230C-8CCE-43BE-9868-D1BC12940358@.microsoft.com...
> > We are printing to network printers from IE.
> >
> > I hooked up a local printer to a computer just to try, and it prints the
> > first page OK, and then pops up the same error message as usual:
> > "0x80004005"
> >
> > Even if it worked on a local printer, this is supposed to be an enterprise
> > solution. 99% of our employees print to network printers.
> >
> >
> > "Floyd Burger" wrote:
> >
> >> Are you printing to a local or network printer? Printing from IE,
> >> Firefox,
> >> <insert other browser here>? I've had the best luck printing from IE to
> >> a
> >> local printer.
> >>
> >> --
> >> Floyd
> >>
> >> "msmolarek@.community.nospam"
> >> <msmolarek@.community.nospam@.discussions.microsoft.com> wrote in message
> >> news:C3830BDC-C2E0-4F82-85B8-101949ED1B5D@.microsoft.com...
> >> > Hello,
> >> >
> >> > We have never been able to get the printing to work on any of our
> >> > reports
> >> > using SQL Server Reporting Services SP2.
> >> >
> >> > During the time we have been fighting to get this to work we had added
> >> > on
> >> > the SP, so we totally rebuilt the machine from scratch, that didn't
> >> > help.
> >> > In
> >> > addition a couple of months ago we bought a totally new machine to host
> >> > our
> >> > reports and the fresh install on that machine didn't yeild any results.
> >> >
> >> > At some point I found some posts in the newsgroup about needing to
> >> > uninstall
> >> > an old ActiveX control used for printing, I did this and installed the
> >> > new
> >> > one but that didn't help either.
> >> >
> >> > We can print to things like the "Microsoft Office Document Image
> >> > Writer"
> >> > without problem, only when we try to print to a real printer does it
> >> > bomb
> >> > out.
> >> >
> >> > It doesn't matter how big the report is, 100 pages or 1/4 of a page,
> >> > same
> >> > problem.
> >> >
> >> > We do the following:
> >> >
> >> > Run the report
> >> > Click the print button
> >> > Select a printer and press ok
> >> > "Printing Now..." dialog box appears
> >> > "Print Error" dialog appears showing "An error occured during printing.
> >> > (0x80004005). The misspelling of "occured" is how it is displayed in
> >> > the
> >> > message.
> >> > Click OK and you get a JS error dialog "Line: 19. Error: Unspecifiied
> >> > Error".
> >> >
> >> >
> >> > This is the result on every computer we have ever used in trying to
> >> > access
> >> > the report server.
> >> >
> >> > Any help?
> >>
> >>
> >>
>
>|||I have the same error on network printers..Anyone have any more advise on
this issue. I can add that the event log on the machine spits out event error
3, 4,8 in order when you issue the print command.
--
Ron Hatfield
Senior Consultant
I.B.I.S., Inc.
"msmolarek@.community.nospam" wrote:
> How can I find the disconnect here then?
> I have read that this error indicates "Access is denied", and others have
> mentioned that maybe I don't have printer rights.
> I am logged into my machine as a domain admin. I have no printing problems
> in any program to any printer, except when using Reporting Services.
>
> "Bruce L-C [MVP]" wrote:
> > I print exclusively to network printers. We do not have local printers at
> > work.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "msmolarek@.community.nospam"
> > <msmolarekcommunitynospam@.discussions.microsoft.com> wrote in message
> > news:5378230C-8CCE-43BE-9868-D1BC12940358@.microsoft.com...
> > > We are printing to network printers from IE.
> > >
> > > I hooked up a local printer to a computer just to try, and it prints the
> > > first page OK, and then pops up the same error message as usual:
> > > "0x80004005"
> > >
> > > Even if it worked on a local printer, this is supposed to be an enterprise
> > > solution. 99% of our employees print to network printers.
> > >
> > >
> > > "Floyd Burger" wrote:
> > >
> > >> Are you printing to a local or network printer? Printing from IE,
> > >> Firefox,
> > >> <insert other browser here>? I've had the best luck printing from IE to
> > >> a
> > >> local printer.
> > >>
> > >> --
> > >> Floyd
> > >>
> > >> "msmolarek@.community.nospam"
> > >> <msmolarek@.community.nospam@.discussions.microsoft.com> wrote in message
> > >> news:C3830BDC-C2E0-4F82-85B8-101949ED1B5D@.microsoft.com...
> > >> > Hello,
> > >> >
> > >> > We have never been able to get the printing to work on any of our
> > >> > reports
> > >> > using SQL Server Reporting Services SP2.
> > >> >
> > >> > During the time we have been fighting to get this to work we had added
> > >> > on
> > >> > the SP, so we totally rebuilt the machine from scratch, that didn't
> > >> > help.
> > >> > In
> > >> > addition a couple of months ago we bought a totally new machine to host
> > >> > our
> > >> > reports and the fresh install on that machine didn't yeild any results.
> > >> >
> > >> > At some point I found some posts in the newsgroup about needing to
> > >> > uninstall
> > >> > an old ActiveX control used for printing, I did this and installed the
> > >> > new
> > >> > one but that didn't help either.
> > >> >
> > >> > We can print to things like the "Microsoft Office Document Image
> > >> > Writer"
> > >> > without problem, only when we try to print to a real printer does it
> > >> > bomb
> > >> > out.
> > >> >
> > >> > It doesn't matter how big the report is, 100 pages or 1/4 of a page,
> > >> > same
> > >> > problem.
> > >> >
> > >> > We do the following:
> > >> >
> > >> > Run the report
> > >> > Click the print button
> > >> > Select a printer and press ok
> > >> > "Printing Now..." dialog box appears
> > >> > "Print Error" dialog appears showing "An error occured during printing.
> > >> > (0x80004005). The misspelling of "occured" is how it is displayed in
> > >> > the
> > >> > message.
> > >> > Click OK and you get a JS error dialog "Line: 19. Error: Unspecifiied
> > >> > Error".
> > >> >
> > >> >
> > >> > This is the result on every computer we have ever used in trying to
> > >> > access
> > >> > the report server.
> > >> >
> > >> > Any help?
> > >>
> > >>
> > >>
> >
> >
> >