Showing posts with label lan. Show all posts
Showing posts with label lan. Show all posts

Monday, March 12, 2012

Reports Deploy.

Hi,
I have my report test environment in a LAN and the production
environment in another LAN in another country. The production
environment doesn't have Visual Studio.
I want to know if there's another way to deploy reports in Report
Server without to use the Visual Studio. Or, can I to deploy from my
machine with Visual Studio to Report Server in another LAN'
Thanks in advance.You could use Reporting Services Scripter (link below) to script out your
reports then they just need to run the generated batch file to load your
reports. Thet will just need RS.EXE from the client tools to be able to run
the generated sripts
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Gave" <vasgabriel@.gmail.com> wrote in message
news:1137169868.545497.262050@.g43g2000cwa.googlegroups.com...
> Hi,
> I have my report test environment in a LAN and the production
> environment in another LAN in another country. The production
> environment doesn't have Visual Studio.
> I want to know if there's another way to deploy reports in Report
> Server without to use the Visual Studio. Or, can I to deploy from my
> machine with Visual Studio to Report Server in another LAN'
> Thanks in advance.
>|||Jasper, Thanks for response.
I download the Reporting Services Scripter and I get the following
error:
The request failed with the error message:
<html><head><title>Object moved</title></head><body>
<h2>Object moved to <a
href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
</body></html>
I'm using Reporting Services with Form Authentication instead of
Windows Authentication.
Can you help me please?
Thanks a lot.|||Sorry, there's currently no support for Forms Authentication, the reason
being that RS.EXE doesn't support it and being that's the mechanism used to
deploy the scripts, it seems silly to allow the generation of scripts that
can't be run. Hopefully at a future date there will be support for non
windows authentication using RS>EXE at which time I'll add it to RSScripter.
Sorry it can't help you.
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Gave" <vasgabriel@.gmail.com> wrote in message
news:1137178511.255692.202680@.g47g2000cwa.googlegroups.com...
> Jasper, Thanks for response.
> I download the Reporting Services Scripter and I get the following
> error:
> The request failed with the error message:
> <html><head><title>Object moved</title></head><body>
> <h2>Object moved to <a
> href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>here</a>.</h2>
> </body></html>
> I'm using Reporting Services with Form Authentication instead of
> Windows Authentication.
> Can you help me please?
> Thanks a lot.
>

Reports - IE7?

Are there some major issues with the reports and IE7?
One of our systems which is attempting to access the reports via LAN is
having the following problems. The system is running IE7 Beta 3 on
WinXPPro SP2.
1) When opening report builder the progress window appears showing the
download of the application but the report builder never displays. No
errors, nothing!
2) When clicking on a report the report shows correctly but IE7 seems to be
doing something still, the icon on the tab keep flickering and most
navigation has a minute or two delay. There is also an '!' in the icon on
the status bar but where you can normally click on the icon to view it never
displays.
3) The date select buttons and drop down list from the parameters and export
selection don't work at all.
Regards,
JohnFrom other postings I gather beta2 worked OK and beta3 does not. I discussed
with internal MS person and he told me they have a commitment from the IE
team to fix the problem. There is no workaround. So, MS RS team is aware of
the issue and so is the IE 7 team.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John J. Hughes II" <no@.invalid.com> wrote in message
news:exnFYOKtGHA.3684@.TK2MSFTNGP05.phx.gbl...
> Are there some major issues with the reports and IE7?
> One of our systems which is attempting to access the reports via LAN is
> having the following problems. The system is running IE7 Beta 3 on
> WinXPPro SP2.
> 1) When opening report builder the progress window appears showing the
> download of the application but the report builder never displays. No
> errors, nothing!
> 2) When clicking on a report the report shows correctly but IE7 seems to
> be doing something still, the icon on the tab keep flickering and most
> navigation has a minute or two delay. There is also an '!' in the icon
> on the status bar but where you can normally click on the icon to view it
> never displays.
> 3) The date select buttons and drop down list from the parameters and
> export selection don't work at all.
> Regards,
> John
>|||Ok, thanks... Saves me trying to track down the problem
Regards,
John
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23oQM%23cKtGHA.4600@.TK2MSFTNGP06.phx.gbl...
> From other postings I gather beta2 worked OK and beta3 does not. I
> discussed with internal MS person and he told me they have a commitment
> from the IE team to fix the problem. There is no workaround. So, MS RS
> team is aware of the issue and so is the IE 7 team.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "John J. Hughes II" <no@.invalid.com> wrote in message
> news:exnFYOKtGHA.3684@.TK2MSFTNGP05.phx.gbl...
>> Are there some major issues with the reports and IE7?
>> One of our systems which is attempting to access the reports via LAN is
>> having the following problems. The system is running IE7 Beta 3 on
>> WinXPPro SP2.
>> 1) When opening report builder the progress window appears showing the
>> download of the application but the report builder never displays. No
>> errors, nothing!
>> 2) When clicking on a report the report shows correctly but IE7 seems to
>> be doing something still, the icon on the tab keep flickering and most
>> navigation has a minute or two delay. There is also an '!' in the icon
>> on the status bar but where you can normally click on the icon to view it
>> never displays.
>> 3) The date select buttons and drop down list from the parameters and
>> export selection don't work at all.
>> Regards,
>> John
>|||I have tried IE7 RC1 and it seems to have the same problem, can anyone
confirm this?
Regards,
John
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23oQM%23cKtGHA.4600@.TK2MSFTNGP06.phx.gbl...
> From other postings I gather beta2 worked OK and beta3 does not. I
> discussed with internal MS person and he told me they have a commitment
> from the IE team to fix the problem. There is no workaround. So, MS RS
> team is aware of the issue and so is the IE 7 team.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "John J. Hughes II" <no@.invalid.com> wrote in message
> news:exnFYOKtGHA.3684@.TK2MSFTNGP05.phx.gbl...
>> Are there some major issues with the reports and IE7?
>> One of our systems which is attempting to access the reports via LAN is
>> having the following problems. The system is running IE7 Beta 3 on
>> WinXPPro SP2.
>> 1) When opening report builder the progress window appears showing the
>> download of the application but the report builder never displays. No
>> errors, nothing!
>> 2) When clicking on a report the report shows correctly but IE7 seems to
>> be doing something still, the icon on the tab keep flickering and most
>> navigation has a minute or two delay. There is also an '!' in the icon
>> on the status bar but where you can normally click on the icon to view it
>> never displays.
>> 3) The date select buttons and drop down list from the parameters and
>> export selection don't work at all.
>> Regards,
>> John
>|||Hi John,
I was using IE 7 Beta 2 with reporting services fine. I then installed Beta
3 and was having the problem you described in your first postingand reported
it via this newsgroup. Can't recall if it was Bruce or not but a Microsoft
MVP contacted Microsoft, confirmed this was known and replied to me that
this would be fixed using essentially the identical words you quoted here.
Late last week I downloaded and installed IE 7 RC1 and was thrilled that the
problem is no longer happening.
If this is happening for you on RC1, there is something else involved.
Jon|||Thanks Jon,
Ok I will look into other issues.
Regards,
John
"Jon Limmer" <jonlimmer@.hotmail.com> wrote in message
news:eyLE43qyGHA.1536@.TK2MSFTNGP02.phx.gbl...
> Hi John,
> I was using IE 7 Beta 2 with reporting services fine. I then installed
> Beta 3 and was having the problem you described in your first postingand
> reported it via this newsgroup. Can't recall if it was Bruce or not but a
> Microsoft MVP contacted Microsoft, confirmed this was known and replied to
> me that this would be fixed using essentially the identical words you
> quoted here.
> Late last week I downloaded and installed IE 7 RC1 and was thrilled that
> the problem is no longer happening.
> If this is happening for you on RC1, there is something else involved.
> Jon
>|||I was running IE Beta 2 with no problems.
Just installed RC1 and the document map - doesn't display the content
anymore :-(|||The issue with Beta 3 was worse than that. Reports just flat out didn't
work. I'll pass this on.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"mikey" <mikey@.discussions.microsoft.com> wrote in message
news:14D9B2EB-64F5-40EC-8DD2-960B47EBAAF5@.microsoft.com...
>I was running IE Beta 2 with no problems.
> Just installed RC1 and the document map - doesn't display the content
> anymore :-(
>

Friday, March 9, 2012

Reportmanager failed to load from internet as a webapplication

I works fine when I run from our lan by a IIS virtual directory. But using
reportmanager from a IIS application outside the lan as a true
webapplication, the reportmanager produce wrong paths for controls. E.x.
http://images/48folderopen.jpg There should have been a domain in front of
/images. I haven't been able to find any parameters in config's to meet this
problem.
Regards
Henrik Juel
GBS A/S
DenmarkI have same probleme, anybody have the solution'
"Henrik Juel" <hjh@.gbs.dk> a écrit dans le message de
news:clsmdo$2bti$1@.news.cybercity.dk...
> I works fine when I run from our lan by a IIS virtual directory. But using
> reportmanager from a IIS application outside the lan as a true
> webapplication, the reportmanager produce wrong paths for controls. E.x.
> http://images/48folderopen.jpg There should have been a domain in front of
> /images. I haven't been able to find any parameters in config's to meet
this
> problem.
> Regards
> Henrik Juel
> GBS A/S
> Denmark
>|||Have you added the <ReportServerExternalURL> tag to the
c:\programfiles\microsoft sql server\mssql\reporting services\report anager\
rswebapplication.config file as below?
<Configuration>
<UI>
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
<ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExt
ernalURL>
</UI>
Ken
"Henrik Juel" <hjh@.gbs.dk> wrote in message
news:clsmdo$2bti$1@.news.cybercity.dk...
> I works fine when I run from our lan by a IIS virtual directory. But using
> reportmanager from a IIS application outside the lan as a true
> webapplication, the reportmanager produce wrong paths for controls. E.x.
> http://images/48folderopen.jpg There should have been a domain in front of
> /images. I haven't been able to find any parameters in config's to meet
this
> problem.
> Regards
> Henrik Juel
> GBS A/S
> Denmark
>|||Hello Ken
After reading others posting about this topic, I have tried the tag
<ReportServerExternalURL>. But it made no difference. I belive in this setup
there is a ok connection from the reportmanager to the reportserver.
"Ken" wrote:
> Have you added the <ReportServerExternalURL> tag to the
> c:\programfiles\microsoft sql server\mssql\reporting services\report anager\
> rswebapplication.config file as below?
> <Configuration>
> <UI>
> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> <ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExt
> ernalURL>
> </UI>
> Ken
> "Henrik Juel" <hjh@.gbs.dk> wrote in message
> news:clsmdo$2bti$1@.news.cybercity.dk...
> > I works fine when I run from our lan by a IIS virtual directory. But using
> > reportmanager from a IIS application outside the lan as a true
> > webapplication, the reportmanager produce wrong paths for controls. E.x.
> > http://images/48folderopen.jpg There should have been a domain in front of
> > /images. I haven't been able to find any parameters in config's to meet
> this
> > problem.
> >
> > Regards
> >
> > Henrik Juel
> > GBS A/S
> > Denmark
> >
> >
>
>

Reportmanager failed to load from internet as a webapplication

I works fine when I run from our lan by a IIS virtual directory. But using
reportmanager from a IIS application outside the lan as a true
webapplication, the reportmanager produce wrong paths for controls. E.x.
http://images/48folderopen.jpg There should have been a domain in front of
/images. I haven't been able to find any parameters in config's to meet this
problem.
Regards
Henrik Juel
GBS A/S
DenmarkHi Henrik,
Thanks for your post.
From your descriptions, I understood that you could not access your Report
Manager via Internet while it's OK for intrannet. Have I understood you?
Correct me if i was wrong.
Based on my scope, it seems you should modify your <ReportServerUrl> Tag
for the remote access. Go look at the Report Manager configuration
file,RSWebApplication.config. There is a UI section
<UI>
<ReportServerUrl>http://intranet-computer-name/ReportServer</ReportServerUrl
>
</UI>
Change it to
<UI>
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
</UI>
or you could find another way in charpter "Deploying a Report Server for
Internet Access" under Topic "Enterprise Deployment Model" in Reporting
Services Books Online.
Last but not the least, make sure you follow the security practices before
you opening the Internet Access:)
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hello Michael
Thanks for your instant answer. And yes you do understand me.
I haved tried the <ReportServerVirtualDirectory> tag in the
RSWebApplication.config file but it didn't made any difference to this
problem. I have read the chapter in the online book as I have read about
this topic in my Wrox book. I was not able to find this issue.
When starting the reportmanager from http://rs.gbs.dk the reportmanager
application do have connection to the reportserver, as it is able to show
folders, but fail to work with fully urls. E.x. the image problem stated
earlier.
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> Thanks for your post.
> From your descriptions, I understood that you could not access your Report
> Manager via Internet while it's OK for intrannet. Have I understood you?
> Correct me if i was wrong.
> Based on my scope, it seems you should modify your <ReportServerUrl> Tag
> for the remote access. Go look at the Report Manager configuration
> file,RSWebApplication.config. There is a UI section
> <UI>
> <ReportServerUrl>http://intranet-computer-name/ReportServer</ReportServerUrl
> >
> </UI>
> Change it to
> <UI>
> <ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
> </UI>
> or you could find another way in charpter "Deploying a Report Server for
> Internet Access" under Topic "Enterprise Deployment Model" in Reporting
> Services Books Online.
> Last but not the least, make sure you follow the security practices before
> you opening the Internet Access:)
> Hope this helps and if you have any questions or concerns, don't hesitate
> to let me know. We are always here to be of assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
>|||Hi Henrik,
If the Report Manager and Report Server are on the same machine then remove
the <ReportServerExternalUrl> and the <ReportServerUrl> from the <UI> node
in the config file - and replace with <ReportServerVirtualDirectory>
Let me know whether this works
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hello Michael
Both applications are on the same machine.
And I have only the <ReportServerVirtualDirectory> tag in the
rswebapplication.config.
<UI>
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
</UI>
I have created a virtual directory in the reportmanager root, which point to
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer
where the server originally is installed.
So I belive It doesn't work.
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> If the Report Manager and Report Server are on the same machine then remove
> the <ReportServerExternalUrl> and the <ReportServerUrl> from the <UI> node
> in the config file - and replace with <ReportServerVirtualDirectory>
> Let me know whether this works
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>
>
>
>
>|||Hi Henrik,
First of all, I need to confirm that how do get the following link. Is it
in report manager when he right click a image->Properties to see the link
of the image? http://images/48folderopen.jpg
Secondly, please make sure that 'images' are in the IIS manager the image
folder:
1). Expand IIS server->Web sites->Default Website->Reports->Images
2). Right click Images->Properties->Directory and check if "The designated
directory" is used and "reports\images" is listed.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hello Michael
1. Yes I have the http://images/48folderopen.jpg from right clicking a image
in reportmanager.
2. The IIS settings are as you describe
You are welcome to contact me on +45 20282851 or on email : hjh@.gbs.dk for a
login to http://rs.gbs.dk
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> First of all, I need to confirm that how do get the following link. Is it
> in report manager when he right click a image->Properties to see the link
> of the image? http://images/48folderopen.jpg
> Secondly, please make sure that 'images' are in the IIS manager the image
> folder:
> 1). Expand IIS server->Web sites->Default Website->Reports->Images
> 2). Right click Images->Properties->Directory and check if "The designated
> directory" is used and "reports\images" is listed.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Henrik,
Looking at the nature of this issue, I am afraid we need more time
researching on this issue and this issue was critical to your business, I
would like to suggest you open an incidnet call with Microsoft Support
Professional through Microsoft Product Support Services. You can contact
Microsoft Product Support directly to discuss additional support options
you may have available, by contacting us at 1-(800)936-5800 or by choosing
one of the options listed at
http://support.microsoft.com/directory/overview.asp
If you'd still like to continue working via the newsgroup, I want to set
your expectations that the issue might take a long time to narrow down.
During the course of troubleshooting, we may redirect you to PSS if
required.
For now, I doubt it might be a IIS issue instead of Reporting Services one
and please let me know the answers for the following questions
1. If you are browsing the Report Manager *Locally* via domain name
(http://rs.gbs.dk), will it shows as expected?
If you are browsing via domain name within the intrannet, will it shows as
expected?
2. Open the Web site property,
Click Advanced Button in Web site identification of Web Site Tab
Select Default in Multiple identities for the Web site, Click Edit...
Let me know whether there is anything in the Host Header value
3. Is it possible for you to post IIS logs here? You could also send it to
me if you think it was critical for your business. My email address was
v-mingqc@.online.microsoft.com (please remove "online", it's only for SPAM,
thanks:-)
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Henrik,
I am currently standing by for an update from you and would like to know
how things are going there. Should you have any questions or concerns on
the recent questions/ information I've posted, please don't hesitate to let
me know directly. It's my pleasure to be of assistance
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||I have sent my reponse on your emailaddres v-mingqc@.online.microsoft.com
"removed online" for some weeks ago. Looking forward to your answer.
regards Henrik
""Michael Cheng [MSFT]"" wrote:
> Hi Henrik,
> I am currently standing by for an update from you and would like to know
> how things are going there. Should you have any questions or concerns on
> the recent questions/ information I've posted, please don't hesitate to let
> me know directly. It's my pleasure to be of assistance
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Henrik,
I am sorry that I have never received email from you :-(
May I ask your favor to resend the email?
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!