Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts

Friday, March 30, 2012

report does not come up in remote machine

Hello,
I embedded the report I developed to my asp.net web page,
when I run it in my development computer it is running
fine but I the report does not come up when I call web
page in a remote machine. The rest of web page is working
only report object is not coming. What might the problem
be?
Thanks,
Jim.The account used to access report may not have sufficient permissions to
access the report. You may need to give it sufficient privileges from Report
Manager UI.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JIM.H." <anonymous@.discussions.microsoft.com> wrote in message
news:a12801c48721$62e79070$a501280a@.phx.gbl...
> Hello,
> I embedded the report I developed to my asp.net web page,
> when I run it in my development computer it is running
> fine but I the report does not come up when I call web
> page in a remote machine. The rest of web page is working
> only report object is not coming. What might the problem
> be?
> Thanks,
> Jim.
>|||I am actually using the same user. Is report manager
Prograns-> Sql server-> Reporting Services -> Report
Manager? If yes, when I click that it goes to
Http://mylocalhost/Reports and it says "You are not
authorized to view this page"
Any solution?
>--Original Message--
>The account used to access report may not have sufficient
permissions to
>access the report. You may need to give it sufficient
privileges from Report
>Manager UI.
>--
>Ravi Mumulla (Microsoft)
>SQL Server Reporting Services
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"JIM.H." <anonymous@.discussions.microsoft.com> wrote in
message
>news:a12801c48721$62e79070$a501280a@.phx.gbl...
>> Hello,
>> I embedded the report I developed to my asp.net web
page,
>> when I run it in my development computer it is running
>> fine but I the report does not come up when I call web
>> page in a remote machine. The rest of web page is
working
>> only report object is not coming. What might the problem
>> be?
>> Thanks,
>> Jim.
>
>.
>

Wednesday, March 28, 2012

Report Designer Installation

We already have the Report Server installed. However, I am trying to find the software that needs to be installed on the client (development) machine that has VS.NET 2003. I have been searching the web but in vain?.

Does it come only as a part of the server version. Or Is there a Report Designer add-in available for VS.NET 2003 that could be downloaded seperately.


Sathya

what are you trying to do ?

all you would need to develop reports using RS is VS.NET. You would however need IIS,SQL Server to deploy them.

|||

Well but were do you get or download the add-in to setup the Report Designer in VS.NET 2003 (development machine). I dont think, the report designer gets installed by default when VS.NET 2003 is installed.

Sathya

Report Designer Install

I am trying to add report designer to a new development machine (XP
professional sp2) that has VS 2003 installed. The machine does not have IIS
installed. I am using the MSDN August 2005 DVD 2432.10 that has SQL &
Reporting Services. I keep getting the dialog box indicating a missing IIS
and ASP.net then an abend. I used to get a dialog box where I could select
the client options, but the install stops before presenting the options.
Anyone else encountering this condition?
TIA - RonWhat is happening is that you are trying to install everything, not just the
designer. RS requires IIS to be installed. The designer does not.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
news:Om%23r5rdqFHA.3064@.TK2MSFTNGP15.phx.gbl...
>I am trying to add report designer to a new development machine (XP
>professional sp2) that has VS 2003 installed. The machine does not have
>IIS installed. I am using the MSDN August 2005 DVD 2432.10 that has SQL &
>Reporting Services. I keep getting the dialog box indicating a missing IIS
>and ASP.net then an abend. I used to get a dialog box where I could select
>the client options, but the install stops before presenting the options.
>Anyone else encountering this condition?
> TIA - Ron
>|||Thanks for the reply.
But where do I designate to just install the designer? It stops before
there is any "selection" screen.
TIA -- Ron
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:egOY5vjqFHA.3016@.TK2MSFTNGP12.phx.gbl...
> What is happening is that you are trying to install everything, not just
> the designer. RS requires IIS to be installed. The designer does not.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
> news:Om%23r5rdqFHA.3064@.TK2MSFTNGP15.phx.gbl...
>>I am trying to add report designer to a new development machine (XP
>>professional sp2) that has VS 2003 installed. The machine does not have
>>IIS installed. I am using the MSDN August 2005 DVD 2432.10 that has SQL
>>& Reporting Services. I keep getting the dialog box indicating a missing
>>IIS and ASP.net then an abend. I used to get a dialog box where I could
>>select the client options, but the install stops before presenting the
>>options. Anyone else encountering this condition?
>> TIA - Ron
>|||When setup runs it first checks your machine. I just tried this and it tells
me I don't have IIS, asp.net etc (which I don't on my development machine a
XP Pro SP2). However you can keep clicking next. There is one place where it
takes awhile for the next button to appear. After that I was told I already
have it installed so I could not get to the screen you would want. If setup
is crashing after you leave the spot where it tells you that you are missing
IIS and asp.net then I don't know what to tell you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
news:OSPQqykqFHA.3160@.TK2MSFTNGP14.phx.gbl...
> Thanks for the reply.
> But where do I designate to just install the designer? It stops before
> there is any "selection" screen.
> TIA -- Ron
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:egOY5vjqFHA.3016@.TK2MSFTNGP12.phx.gbl...
>> What is happening is that you are trying to install everything, not just
>> the designer. RS requires IIS to be installed. The designer does not.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
>> news:Om%23r5rdqFHA.3064@.TK2MSFTNGP15.phx.gbl...
>>I am trying to add report designer to a new development machine (XP
>>professional sp2) that has VS 2003 installed. The machine does not have
>>IIS installed. I am using the MSDN August 2005 DVD 2432.10 that has SQL
>>& Reporting Services. I keep getting the dialog box indicating a missing
>>IIS and ASP.net then an abend. I used to get a dialog box where I could
>>select the client options, but the install stops before presenting the
>>options. Anyone else encountering this condition?
>> TIA - Ron
>>
>|||Thanks for the help.
Yes, those are the messages I get, and when I press next I only get a
sccreen where cancel is the only option. I just don't get the "selection"
screen.
Thanks for looking. Ron
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23jI9Y4kqFHA.3540@.TK2MSFTNGP14.phx.gbl...
> When setup runs it first checks your machine. I just tried this and it
> tells me I don't have IIS, asp.net etc (which I don't on my development
> machine a XP Pro SP2). However you can keep clicking next. There is one
> place where it takes awhile for the next button to appear. After that I
> was told I already have it installed so I could not get to the screen you
> would want. If setup is crashing after you leave the spot where it tells
> you that you are missing IIS and asp.net then I don't know what to tell
> you.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
> news:OSPQqykqFHA.3160@.TK2MSFTNGP14.phx.gbl...
>> Thanks for the reply.
>> But where do I designate to just install the designer? It stops before
>> there is any "selection" screen.
>> TIA -- Ron
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:egOY5vjqFHA.3016@.TK2MSFTNGP12.phx.gbl...
>> What is happening is that you are trying to install everything, not just
>> the designer. RS requires IIS to be installed. The designer does not.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
>> news:Om%23r5rdqFHA.3064@.TK2MSFTNGP15.phx.gbl...
>>I am trying to add report designer to a new development machine (XP
>>professional sp2) that has VS 2003 installed. The machine does not have
>>IIS installed. I am using the MSDN August 2005 DVD 2432.10 that has
>>SQL & Reporting Services. I keep getting the dialog box indicating a
>>missing IIS and ASP.net then an abend. I used to get a dialog box where
>>I could select the client options, but the install stops before
>>presenting the options. Anyone else encountering this condition?
>> TIA - Ron
>>
>>
>|||How long did you wait? This screen takes (for whatever reason) a long time
for the next button to show up. Did you wait a few minutes. I know I waited
at least a minute. It is doing something in the background and eventually
the next button shows up.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
news:uajGVKmqFHA.3016@.TK2MSFTNGP12.phx.gbl...
> Thanks for the help.
> Yes, those are the messages I get, and when I press next I only get a
> sccreen where cancel is the only option. I just don't get the "selection"
> screen.
> Thanks for looking. Ron
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23jI9Y4kqFHA.3540@.TK2MSFTNGP14.phx.gbl...
>> When setup runs it first checks your machine. I just tried this and it
>> tells me I don't have IIS, asp.net etc (which I don't on my development
>> machine a XP Pro SP2). However you can keep clicking next. There is one
>> place where it takes awhile for the next button to appear. After that I
>> was told I already have it installed so I could not get to the screen you
>> would want. If setup is crashing after you leave the spot where it tells
>> you that you are missing IIS and asp.net then I don't know what to tell
>> you.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
>> news:OSPQqykqFHA.3160@.TK2MSFTNGP14.phx.gbl...
>> Thanks for the reply.
>> But where do I designate to just install the designer? It stops before
>> there is any "selection" screen.
>> TIA -- Ron
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:egOY5vjqFHA.3016@.TK2MSFTNGP12.phx.gbl...
>> What is happening is that you are trying to install everything, not
>> just the designer. RS requires IIS to be installed. The designer does
>> not.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Ron Schmidt" <Schmidt.ronald@.mayo.edu> wrote in message
>> news:Om%23r5rdqFHA.3064@.TK2MSFTNGP15.phx.gbl...
>>I am trying to add report designer to a new development machine (XP
>>professional sp2) that has VS 2003 installed. The machine does not
>>have IIS installed. I am using the MSDN August 2005 DVD 2432.10 that
>>has SQL & Reporting Services. I keep getting the dialog box indicating
>>a missing IIS and ASP.net then an abend. I used to get a dialog box
>>where I could select the client options, but the install stops before
>>presenting the options. Anyone else encountering this condition?
>> TIA - Ron
>>
>>
>>
>

Report Designer for Reporting Services

Sorry if this is well known now but...

If a customer of ours installed Reporting Services on their SQL Server 2000 machine how do they design reports, assuming they do not own a copy of Visual Studio .NET 2003? Is there some form of report designer?

It is my understanding that Sql 2005 DOES come with a report designer is VS is not installed.

Regards
GrahamIn SQL Server 2000 Reporting Services, there is no Report Designer outside of the one hosted in VS 2003 (VB Standard will do). SQL 2005 comes with a version of the Visual Studio shell to host Report Designer. It also comes with Report Builder, which does not require VS at all.|||Having the components used withing Report Builder would be nice. Or being able to modify Report Builder (given the source) would even be nicer.|||

Is it possible to host the Report Designer in a custom application ? Maby like hosting the Forms Designer in a custom application.

http://msdn.microsoft.com/msdnmag/issues/06/03/DesignerHosting/default.aspx

|||Yes, yes, I've seen examples like this. But without spending an inordinate amount of time to research and test, is it possible to host the report designer in the same way? The Winforms designer, yes. But the report designer?

Report Designer for Reporting Services

Sorry if this is well known now but...

If a customer of ours installed Reporting Services on their SQL Server 2000 machine how do they design reports, assuming they do not own a copy of Visual Studio .NET 2003? Is there some form of report designer?

It is my understanding that Sql 2005 DOES come with a report designer is VS is not installed.

Regards
GrahamIn SQL Server 2000 Reporting Services, there is no Report Designer outside of the one hosted in VS 2003 (VB Standard will do). SQL 2005 comes with a version of the Visual Studio shell to host Report Designer. It also comes with Report Builder, which does not require VS at all.|||Having the components used withing Report Builder would be nice. Or being able to modify Report Builder (given the source) would even be nicer.|||

Is it possible to host the Report Designer in a custom application ? Maby like hosting the Forms Designer in a custom application.

http://msdn.microsoft.com/msdnmag/issues/06/03/DesignerHosting/default.aspx

|||Yes, yes, I've seen examples like this. But without spending an inordinate amount of time to research and test, is it possible to host the report designer in the same way? The Winforms designer, yes. But the report designer?

Report Designer for Reporting Services

Sorry if this is well known now but...

If a customer of ours installed Reporting Services on their SQL Server 2000 machine how do they design reports, assuming they do not own a copy of Visual Studio .NET 2003? Is there some form of report designer?

It is my understanding that Sql 2005 DOES come with a report designer is VS is not installed.

Regards
GrahamIn SQL Server 2000 Reporting Services, there is no Report Designer outside of the one hosted in VS 2003 (VB Standard will do). SQL 2005 comes with a version of the Visual Studio shell to host Report Designer. It also comes with Report Builder, which does not require VS at all.|||Having the components used withing Report Builder would be nice. Or being able to modify Report Builder (given the source) would even be nicer.|||

Is it possible to host the Report Designer in a custom application ? Maby like hosting the Forms Designer in a custom application.

http://msdn.microsoft.com/msdnmag/issues/06/03/DesignerHosting/default.aspx

|||Yes, yes, I've seen examples like this. But without spending an inordinate amount of time to research and test, is it possible to host the report designer in the same way? The Winforms designer, yes. But the report designer?

Report Designer 2005 and 2003 side by side?

When I installed SQL Server 2005 on my machine, VisualStudio 2005 was also
installed. I now have both 2003 and 2005 running. However, reporting service
projects are no longer available in the VS 2003 environment. Is it possible
to use both side by side?
TIA
HowardYes you can use VS2005 and VS2003 side by side. When you install VS2005
all the VS2003 project files icons turned into VS2005 icons but no
worrys. When you open your VS2003 solution file it opens in VS2003.
As far as the reports is it Crystal Reports that no longer exists?
Thanks
-L
My Quote : Trouble brings experience and experience wisdom.|||Yes you can use VS2005 and VS2003 side by side. When you install VS2005
all the VS2003 project files icons turned into VS2005 icons but no
worrys. When you open your VS2003 solution file it opens in VS2003.
As far as the reports is it Crystal Reports that no longer exists?
Thanks
-L
My Quote : Trouble brings experience and experience wisdom.|||Yes you can use VS2005 and VS2003 side by side. When you install VS2005
all the VS2003 project files icons turned into VS2005 icons but no
worrys. When you open your VS2003 solution file it opens in VS2003.
As far as the reports is it Crystal Reports that no longer exists?
Thanks
-L
My Quote : Trouble brings experience and experience wisdom.|||No it is the reporting services projects that are no longer available in
VS2003. Now I can only create / edit .rdl files with VS2005. Since it is
using a different version of the report designer I can no longer work on
reporting service projects without upgrading them. This is unacceptable for
a particular project on which I am working. I was hoping there might be a
way to run old version and new version side by side.
<pradev@.gmail.com> wrote in message
news:1138917796.740022.70600@.g49g2000cwa.googlegroups.com...
> Yes you can use VS2005 and VS2003 side by side. When you install VS2005
> all the VS2003 project files icons turned into VS2005 icons but no
> worrys. When you open your VS2003 solution file it opens in VS2003.
>
> As far as the reports is it Crystal Reports that no longer exists?
> Thanks
> -L
> My Quote : Trouble brings experience and experience wisdom.
>|||You can definitely do this. I just doubled checked. As long as you do not
open and convert the rdl files in RS 2005 designer you can still open and
edit them. What is happening is that the extensions are being registered for
RS 2005 designer. If you just double click on the solution or the project it
will open up RS 2005 designer. However, if you open up VS 2003 and select
open project and go to your project you can open and edit RS 2000 reports.
What I did was leave my RS 2000 project alone. Copied them over to another
directory and then opened all the reports and converted them to RS 2005.
Side by side definitely works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Howard Swope" <swopehATgigamotoDOTcom> wrote in message
news:uES3Zv0KGHA.3164@.TK2MSFTNGP11.phx.gbl...
> No it is the reporting services projects that are no longer available in
> VS2003. Now I can only create / edit .rdl files with VS2005. Since it is
> using a different version of the report designer I can no longer work on
> reporting service projects without upgrading them. This is unacceptable
> for a particular project on which I am working. I was hoping there might
> be a way to run old version and new version side by side.
> <pradev@.gmail.com> wrote in message
> news:1138917796.740022.70600@.g49g2000cwa.googlegroups.com...
>> Yes you can use VS2005 and VS2003 side by side. When you install VS2005
>> all the VS2003 project files icons turned into VS2005 icons but no
>> worrys. When you open your VS2003 solution file it opens in VS2003.
>>
>> As far as the reports is it Crystal Reports that no longer exists?
>> Thanks
>> -L
>> My Quote : Trouble brings experience and experience wisdom.
>|||The Reporting Services 2005 install seemed to remove the Report
Designer in Visual Studio 2003.
So I just re-installed this designer after installing Visual Studio
2005.
Now to Design for SQL 2000 you use VS2003 and for SQL 2005 use VS 2005
all on the same box.
Have been successfully writing SQL 2000 reports in VS2003 since.
Having a nightmare trying to run the report manager for 2005 on my PC
after all of this as it won't let me deploy report models!
One of the other guys at work reckon it's due to sp2 for XP but have
tried and googled all ov er the place...|||Sorry, can't help you there.
Hmm, not sure why you ended up with the 2000 report designer removed. I
didn't have any of that happen to me.
Sorry, I can't help you with the report models. It very well could be
something with the firewall in SP2 on XP.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"SmartbizAustralia" <tom@.smartbiz.com.au> wrote in message
news:1139307968.314418.149120@.o13g2000cwo.googlegroups.com...
> The Reporting Services 2005 install seemed to remove the Report
> Designer in Visual Studio 2003.
> So I just re-installed this designer after installing Visual Studio
> 2005.
> Now to Design for SQL 2000 you use VS2003 and for SQL 2005 use VS 2005
> all on the same box.
> Have been successfully writing SQL 2000 reports in VS2003 since.
> Having a nightmare trying to run the report manager for 2005 on my PC
> after all of this as it won't let me deploy report models!
> One of the other guys at work reckon it's due to sp2 for XP but have
> tried and googled all ov er the place...
>|||I reinstalled the client portion of the sql 2000 reporting services and
everything is working well.
Thanks
"Howard Swope" <swopehATgigamotoDOTcom> wrote in message
news:ONce2MEKGHA.3200@.tk2msftngp13.phx.gbl...
> When I installed SQL Server 2005 on my machine, VisualStudio 2005 was also
> installed. I now have both 2003 and 2005 running. However, reporting
> service projects are no longer available in the VS 2003 environment. Is it
> possible to use both side by side?
> TIA
> Howard
>

Report Deployment Problem on SQL 2005

Hi everyone,
I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error:
"The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file."
Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still facing the same problem :s.
Any idea what so ever?
ThanksI was hoping someone would reply to you on this problem. I am having a very similar problem of not being able to deploy reports to the Report Server, using the June SQL Server CTP.

When trying to deploy Company Sales.rdl or any of the other sample reports to the Report Server, from Visual Studio 2005, this error message appears (see below). Where should I start to troubleshoot the problem? Thank you.

A connection could not be made to the report server http://localhost/reportserver. (Microsoft Report Designer)

===================================

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)


Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

===================================

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)


|||Hi everyone,

I managed to solve the problem at my side, this post was very helpfull:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=58665

For my case, the easiest way was to reinstall SQL 2005 CTP again in one shot, as installing it in multiple phases caused the problem that I faced.
In addition, I had to give write authority to the (Network Services) to the ASP.NET Temporary files directory.

Hope this will be helpfull.|||I also had the same problem and it was resolved by reinstalling all components of SQL 2005 CTP in one go.|||
Solution to this problem is

1) Open Configure Report Server Tool
2) Update 'Web Service Identity' tab to reflect Asp .Net account on the machine.
For Eg. machineName\ASPNET
3) Click Apply Button, This will update WebServiceAccount tag in your report server configuration file 'rsreportserver.config'.

Hope this helps.

Thanks,

Report Deployment Problem on SQL 2005

Hi everyone,
I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error:
"The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file."
Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still facing the same problem :s.
Any idea what so ever?
ThanksI was hoping someone would reply to you on this problem. I am having a very similar problem of not being able to deploy reports to the Report Server, using the June SQL Server CTP.

When trying to deploy Company Sales.rdl or any of the other sample reports to the Report Server, from Visual Studio 2005, this error message appears (see below). Where should I start to troubleshoot the problem? Thank you.

A connection could not be made to the report server http://localhost/reportserver. (Microsoft Report Designer)

===================================

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)


Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportDesigner.Project.ReportClientManager.GetCredentials(String url)
at Microsoft.ReportDesigner.Project.ReportProjectDeployer.PrepareDeploy()

===================================

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)


|||Hi everyone,

I managed to solve the problem at my side, this post was very helpfull:
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=58665

For my case, the easiest way was to reinstall SQL 2005 CTP again in one shot, as installing it in multiple phases caused the problem that I faced.
In addition, I had to give write authority to the (Network Services) to the ASP.NET Temporary files directory.

Hope this will be helpfull.|||I also had the same problem and it was resolved by reinstalling all components of SQL 2005 CTP in one go.|||
Solution to this problem is

1) Open Configure Report Server Tool
2) Update 'Web Service Identity' tab to reflect Asp .Net account on the machine.
For Eg. machineName\ASPNET
3) Click Apply Button, This will update WebServiceAccount tag in your report server configuration file 'rsreportserver.config'.

Hope this helps.

Thanks,

Monday, March 26, 2012

Report Deployment

We have a "Change Management" Dept that MUST deploy all reports into
Production. I have the same ability from my machine and I can deploy the
solution (or each individual project) without problems (but they don't like
it since I am just a developer).
When CM deploys (they take my solution file and hit "Deploy") the
credentials to all of the data sources is removed so that we have to go into
Report Viewer and add back in the credentials.
So basically, why do I NOT have any problems deploying the solution and data
sources (credentials = a service account), yet CM takes a copy of my solution
and they cannot deploy the data sources with credentials?
Any thoughs appreciated.It is how it is configured in VS. They have it to overwrite data sources and
you do not. They should not be configured this way and they can change it.
Right mouse click on each project, properties, set the overwritedatasources
property to false (if you look for yours it is set to false). That is the
default so they must have changed it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:42674178-04C7-444B-B010-DFB59FD59373@.microsoft.com...
> We have a "Change Management" Dept that MUST deploy all reports into
> Production. I have the same ability from my machine and I can deploy the
> solution (or each individual project) without problems (but they don't
> like
> it since I am just a developer).
> When CM deploys (they take my solution file and hit "Deploy") the
> credentials to all of the data sources is removed so that we have to go
> into
> Report Viewer and add back in the credentials.
> So basically, why do I NOT have any problems deploying the solution and
> data
> sources (credentials = a service account), yet CM takes a copy of my
> solution
> and they cannot deploy the data sources with credentials?
> Any thoughs appreciated.

Report connection fails with DNS name

Hi,

I am facing problem while setting connection string in Report Service project.
Problem is when I specify DNS name instead of machine name as the Server in the connection string.

When I specify DNS name in the connection string it gives error that "A connection cannot be made.Ensure that the server is running" on click of "Test Connection"
Also I am not able to view reports directly through IE. I.e. http://<DNS_NAME>/Reports.
When I access Reports, it prompts me to enter username/password. Even after specifying valid username, it shows me the prompt again n again.

Is there some known issue with Reporting Service or with IIS setting not able to connect to a DNS name? I did not face with any issue when
I specified DNS name in the connection string of Analysis Service project.

Did anyone encountered DNS related problem with SQL Server 2005 Reporting Service?

We also verified that:
1: Ping with both machine name and DNS name returns same result.
2: nslookup with both machine name and DNS name resolves to same IP.

3: Tried putting the DNS name in the hosts file.

Eagerly awaiting some positive reply.

Note: I am working with SQL Server 2005 Standard Edition.

No replies yetSad

We are stuck up with this issue since quite some time.

still waiting for some positive inputs.

|||

After doing some investigation, I have found that the issue is with Analysis server not able to connect using the DNS name (Note: my Reporting Service proj is connecting to Analysis services datasource). When I connect to Analysis server through SQL Server management studio (by def which uses Win authentication), and specify machine name (ABC) in Server then it connects but if I give DNS name (XYZ.PWR.COM) it gives me the following error:

************************************************************************************************************
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)


Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)


Program Location:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()


************************************************************************************************************

If I connect to Reporting Service using DNS name then I get the following error:


************************************************************************************************************
===================================

Cannot connect to XYZ.PWR.COM.

===================================

A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using a report server URL for the Server name, or if the Distributed COM Users group exists on the remote computer, verify that you are a member. (Microsoft.SqlServer.Management.UI.RSClient)


Program Location:

at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
************************************************************************************************************

When I ping with machine name (ABC) and DNS name (XYZ.PWR.COM), both resolves to the same IP.
C:\Documents and Settings\Administrator>ping ABC

Pinging ABC.corp.abctech.com [xx.x.xx.xx] with 32 bytes of d


C:\Documents and Settings\Administrator>ping XYZ.PWR.COM

Pinging XYZ.PWR.COM [xx.x.xx.xx] with 32 bytes of data:


Is this problem because of the kerberos authentication that Analysis server uses to authenticate?

I am able to connect to the Database engine using DNS name (but using SQL Server authentication).
Also I was able to view the reportserver and reports page by changing the IIS authentication to NTLM.
But finally I am not able to view the reports.

Can anyone please help me in solving this issue.

Awatiitng some positive reply.

Report connection fails with DNS name

Hi,

I am facing problem while setting connection string in Report Service project.
Problem is when I specify DNS name instead of machine name as the Server in the connection string.

When I specify DNS name in the connection string it gives error that "A connection cannot be made.Ensure that the server is running" on click of "Test Connection"
Also I am not able to view reports directly through IE. I.e. http://<DNS_NAME>/Reports.
When I access Reports, it prompts me to enter username/password. Even after specifying valid username, it shows me the prompt again n again.

Is there some known issue with Reporting Service or with IIS setting not able to connect to a DNS name? I did not face with any issue when
I specified DNS name in the connection string of Analysis Service project.

Did anyone encountered DNS related problem with SQL Server 2005 Reporting Service?

We also verified that:
1: Ping with both machine name and DNS name returns same result.
2: nslookup with both machine name and DNS name resolves to same IP.

3: Tried putting the DNS name in the hosts file.

Eagerly awaiting some positive reply.

Note: I am working with SQL Server 2005 Standard Edition.

No replies yetSad

We are stuck up with this issue since quite some time.

still waiting for some positive inputs.

|||

After doing some investigation, I have found that the issue is with Analysis server not able to connect using the DNS name (Note: my Reporting Service proj is connecting to Analysis services datasource). When I connect to Analysis server through SQL Server management studio (by def which uses Win authentication), and specify machine name (ABC) in Server then it connects but if I give DNS name (XYZ.PWR.COM) it gives me the following error:

************************************************************************************************************
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)


Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)


Program Location:

at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ForceRead(Stream stream, Byte[] buffer, Int32 length)
at Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadHeader()
at Microsoft.AnalysisServices.AdomdClient.DimeRecord..ctor(Stream stream)
at Microsoft.AnalysisServices.AdomdClient.DimeReader.ReadRecord()
at Microsoft.AnalysisServices.AdomdClient.TcpStream.GetResponseDataType()


************************************************************************************************************

If I connect to Reporting Service using DNS name then I get the following error:


************************************************************************************************************
===================================

Cannot connect to XYZ.PWR.COM.

===================================

A connection to the report server failed. Most likely, you do not have permission to connect to the computer. You should either try to connect using a report server URL for the Server name, or if the Distributed COM Users group exists on the remote computer, verify that you are a member. (Microsoft.SqlServer.Management.UI.RSClient)


Program Location:

at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.CreateSqlOlapConnectionInfoBase(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
************************************************************************************************************

When I ping with machine name (ABC) and DNS name (XYZ.PWR.COM), both resolves to the same IP.
C:\Documents and Settings\Administrator>ping ABC

Pinging ABC.corp.abctech.com [xx.x.xx.xx] with 32 bytes of d


C:\Documents and Settings\Administrator>ping XYZ.PWR.COM

Pinging XYZ.PWR.COM [xx.x.xx.xx] with 32 bytes of data:


Is this problem because of the kerberos authentication that Analysis server uses to authenticate?

I am able to connect to the Database engine using DNS name (but using SQL Server authentication).
Also I was able to view the reportserver and reports page by changing the IIS authentication to NTLM.
But finally I am not able to view the reports.

Can anyone please help me in solving this issue.

Awatiitng some positive reply.

Monday, March 12, 2012

Report Builder and Report Server cross domain communication

I have client machine in one domain, say A domain , on which I have installed .net 2.0 without any problem. I have report server running in other domain (B domain) where I have deployed few models which will be used from domain A to create ad hoc reports by launching Report Builder. I can access other reports in domain B from A

But when I click on Report Builder ..it tries to connect to server in domain B but fails to connect and shows following log in a text pop up

I know, problem is because of cross domain communication but question is then how to fix it ? what changes I need to do for that in firewall, domain etc etc settings?

Here is the error, I have highlighted lines which might give some clue:

PLATFORM VERSION INFO
Windows : 5.2.3790.65536 (Win32NT)
Common Language Runtime : 2.0.50727.42
System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200)
mscorwks.dll : 2.0.50727.42 (RTM.050727-4200)
dfdll.dll : 2.0.50727.42 (RTM.050727-4200)
dfshim.dll : 2.0.50727.42 (RTM.050727-4200)

SOURCES
Deployment url : http://192.168.1.197/ReportServer/ReportBuilder/ReportBuilder.application

ERROR SUMMARY
Below is a summary of the errors, details of these errors are listed later in the log.
* Activation of http://192.168.1.197/ReportServer/ReportBuilder/ReportBuilder.application resulted in exception. Following failure messages were detected:
+ Downloading
http://192.168.1.197/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
+ The remote server returned an error: (500) Internal Server Error.

COMPONENT STORE TRANSACTION FAILURE SUMMARY
No transaction error was detected.

WARNINGS
There were no warnings during this operation.

OPERATION PROGRESS STATUS
* [12/19/2006 6:49:58 AM] : Activation of http://192.168.1.197/ReportServer/ReportBuilder/ReportBuilder.application has started.

ERROR DETAILS
Following errors were detected during this operation.
* [12/19/2006 6:50:14 AM] System.Deployment.Application.DeploymentDownloadException (Unknown subtype)
- Downloading http://192.168.1.197/ReportServer/ReportBuilder/ReportBuilder.application did not succeed.
- Source: System.Deployment
- Stack trace:
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)
at System.Deployment.Application.SystemNetDownloader.DownloadAllFiles()
at System.Deployment.Application.FileDownloader.Download(SubscriptionState subState)
at System.Deployment.Application.DownloadManager.DownloadManifestAsRawFile(Uri& sourceUri, String targetPath, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestDirectBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options, ServerInformation& serverInformation)
at System.Deployment.Application.DownloadManager.DownloadDeploymentManifestBypass(SubscriptionStore subStore, Uri& sourceUri, TempFile& tempFile, SubscriptionState& subState, IDownloadNotification notification, DownloadOptions options)
at System.Deployment.Application.ApplicationActivator.PerformDeploymentActivation(Uri activationUri, Boolean isShortcut)
at System.Deployment.Application.ApplicationActivator.ActivateDeploymentWorker(Object state)
Inner Exception
System.Net.WebException
- The remote server returned an error: (500) Internal Server Error.
- Source: System
- Stack trace:
at System.Net.HttpWebRequest.GetResponse()
at System.Deployment.Application.SystemNetDownloader.DownloadSingleFile(DownloadQueueItem next)

COMPONENT STORE TRANSACTION DETAILS
No transaction information is available.

After spending one night, I have fixed this problem myself

In IIS you should allow anonymous access to folder ReportServer/ReportBuilder folder and thats it....

One night's effort to fix a bug in 30 seconds...what a waste :-(

Prashant

Saturday, February 25, 2012

Report Authenication

Hi,
I have the following scenario:
1) A database server (machine A, Windows 2000 Server Standard) within a
domain
2) A Reporting Server (machine B, Windows 2003 Server Standard) within the
same domain; the Reporting-Services-Database is also on the Database-server
3) My Client (windows XP) within the same domain.
My Problem: When I publisch a Report to the Reporting Server and I use
"Windows integrated Authentication", I get an error "NT-Authority/Anonymous
User" cant access the database. That's right, but why wouldn't be used my
Username/password instead of Anonymous? What have I to do, to pass my
Logonuser form XP over the Reporting-Services to the Database ? A always
thought "windows integrated authentication" in the shared Connection object
would be enough?
Thanks
HansIt sounds to me like you have IIS setup for anonymous access. When you do
this all users are the same user (the anonymous user as you see below). You
should only be doing this if you are implementing custom authorization.
Otherwise this is a really bad idea.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Hans" <sqlserver@.strengberg.net> wrote in message
news:O0FIBcazEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have the following scenario:
> 1) A database server (machine A, Windows 2000 Server Standard) within a
> domain
> 2) A Reporting Server (machine B, Windows 2003 Server Standard) within the
> same domain; the Reporting-Services-Database is also on the
Database-server
> 3) My Client (windows XP) within the same domain.
> My Problem: When I publisch a Report to the Reporting Server and I use
> "Windows integrated Authentication", I get an error
"NT-Authority/Anonymous
> User" cant access the database. That's right, but why wouldn't be used my
> Username/password instead of Anonymous? What have I to do, to pass my
> Logonuser form XP over the Reporting-Services to the Database ? A always
> thought "windows integrated authentication" in the shared Connection
object
> would be enough?
> Thanks
> Hans
>|||If you are trying to authenticate in a scenerio which involves more than two
endpoints eg: client connects to remote RS web service which connects to a
remote database (3 endpoints) and tou're using Integrated security, NTLM
authentication will not work, you will have to setup a delegation scenerio
using kerberos authentication which supports more than one network hop. Look
here for help about setting up a asp.net app for delegation.
http://support.microsoft.com/default.aspx?scid=kb;en-us;810572
To test that this is your problem first access the report from the reporting
services console, this seems to cache your credential locally, now try from
your remote client try the same report, it should work until you log off the
rs server.
HTH,
Dan
"Hans" wrote:
> Hi,
> I have the following scenario:
> 1) A database server (machine A, Windows 2000 Server Standard) within a
> domain
> 2) A Reporting Server (machine B, Windows 2003 Server Standard) within the
> same domain; the Reporting-Services-Database is also on the Database-server
> 3) My Client (windows XP) within the same domain.
> My Problem: When I publisch a Report to the Reporting Server and I use
> "Windows integrated Authentication", I get an error "NT-Authority/Anonymous
> User" cant access the database. That's right, but why wouldn't be used my
> Username/password instead of Anonymous? What have I to do, to pass my
> Logonuser form XP over the Reporting-Services to the Database ? A always
> thought "windows integrated authentication" in the shared Connection object
> would be enough?
> Thanks
> Hans
>
>|||Thanks to all for the answers. I have disabled all anonymous and I think,
its the problem, Dan reports, because I have 3 Endpoints. I will test this.
Thanks again.
Hans
"Hans" <sqlserver@.strengberg.net> schrieb im Newsbeitrag
news:O0FIBcazEHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have the following scenario:
> 1) A database server (machine A, Windows 2000 Server Standard) within a
> domain
> 2) A Reporting Server (machine B, Windows 2003 Server Standard) within the
> same domain; the Reporting-Services-Database is also on the
> Database-server
> 3) My Client (windows XP) within the same domain.
> My Problem: When I publisch a Report to the Reporting Server and I use
> "Windows integrated Authentication", I get an error
> "NT-Authority/Anonymous User" cant access the database. That's right, but
> why wouldn't be used my Username/password instead of Anonymous? What have
> I to do, to pass my Logonuser form XP over the Reporting-Services to the
> Database ? A always thought "windows integrated authentication" in the
> shared Connection object would be enough?
> Thanks
> Hans
>