Showing posts with label successfully. Show all posts
Showing posts with label successfully. Show all posts

Monday, March 26, 2012

Report deployment connection error

Hi,

I'm using the reports designer in Visual Studio 2005 Professional and have successfully been deploying reports to my client's server for several months. Now I can't deploy any reports, when I try Visual Studio almost hangs, tries for about 5 minutes to deploy a single report and then fails with an error message:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://winserver/ReportServer.


ADDITIONAL INFORMATION:

The operation has timed out (System.Web.Services)


BUTTONS:

OK

It used to ask me for username/password for the server (credentials), now it doesn't do that. I can go to the reports server and reports interface pages in my browser OK. The reports build without any errors.

Has anyone experienced this? Any ideas on how to get it working again?

Regards,

Greg

Check for your IE settings. I think that must have changed.

In the client machine, IE Options -> Connection -> LAN settings that - check if both these 2
options were checked/enabled -
1. Automatically detect settings
2. Use Automatic Configuration Script
The option #2 was causing HTTP request from VS go through the proxy server and
passing anonymous request (401)

Or any other Security settings from a machine where deployment works fine.


|||

Hi,

Thanks for your response. I checked the settings in IE and all LAN Settings options are unchecked. Is this correct?

I am connecting through a VPN so that might be causing a problem (all options unchecked for VPN connection settings in IE). I will try directly connecting to the client's LAN and see if it works.

Regards,

Greg

Report deployment connection error

Hi,

I'm using the reports designer in Visual Studio 2005 Professional and have successfully been deploying reports to my client's server for several months. Now I can't deploy any reports, when I try Visual Studio almost hangs, tries for about 5 minutes to deploy a single report and then fails with an error message:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://winserver/ReportServer.


ADDITIONAL INFORMATION:

The operation has timed out (System.Web.Services)


BUTTONS:

OK

It used to ask me for username/password for the server (credentials), now it doesn't do that. I can go to the reports server and reports interface pages in my browser OK. The reports build without any errors.

Has anyone experienced this? Any ideas on how to get it working again?

Regards,

Greg

Check for your IE settings. I think that must have changed.

In the client machine, IE Options -> Connection -> LAN settings that - check if both these 2
options were checked/enabled -
1. Automatically detect settings
2. Use Automatic Configuration Script
The option #2 was causing HTTP request from VS go through the proxy server and
passing anonymous request (401)

Or any other Security settings from a machine where deployment works fine.


|||

Hi,

Thanks for your response. I checked the settings in IE and all LAN Settings options are unchecked. Is this correct?

I am connecting through a VPN so that might be causing a problem (all options unchecked for VPN connection settings in IE). I will try directly connecting to the client's LAN and see if it works.

Regards,

Greg

sql

Wednesday, March 21, 2012

Report Builder not working with Forms Authentication

We have successfully implemented forms authentication. The ReportServer and Report Manager both are working fine. However, when we launch the ReportBuilder using the url http://<server-name>/ReportServer/ReportBuilder/ReportBuilder.application or from the Report Manager, it prompts for user name and password. On entering the valid user-name and password, it gives the following error.

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.

It doesnt accept any user-name, password (neither forms one, nor windows). This error is when we are trying to access Report Builder on the server (not tried on the client machine). The user-name has been given System Administrator and System User role. We have also given the Content Manager, Browser, ... etc all roles to the user.

However, we are testing this on June CTP. Is this a problem ?

This is very urgent as the rest all is working fine. Any suggestions ?

Thanks in advance.

Is there any solution? Does Report Builder work with Forms Authentication ?|||

If I remember correctly, this was a bug that we fixed before the RTM release of RS 2005. If you upgrade to RTM - or better yet, to SP1, this should work.

Thanks

Tudor

Tuesday, March 20, 2012

Report Builder load failure on WAN-side of firewall

All,

Can anyone shed some light on this problem:

Using the same laptop and credentials I can successfully load Report Builder ONLY from the LAN-side of the firewall. However, if I reconnect using my Sprint AirCard I cannot load Report Builder; I get the now infamous "The remote server returned an error: (401) Unauthorized."

What ports are used by Reporting Service?

Thanks,

Brian

I'm not sure what's up with the AirCard connection, but I think I can explain the WAN/LAN difference. On the LAN side your default Windows credentials are sufficient to access the Report Builder files at http://hostname/reportserver/reportbuilder. On the WAN side, Windows integrated authentication doesn't work, so you get no Report Builder. The reason is that ClickOnce (which is responsible for downloading the application files to the client) cannot prompt for credentials, and it doesn't get any from IE, so if default Windows credentials don't work, you get nothing. The solution is to configure IIS on the report server to allow anonymous access to the virtual directory I mentioned above.

|||Does this work with port 443 also?

Report Builder load failure on WAN-side of firewall

All,

Can anyone shed some light on this problem:

Using the same laptop and credentials I can successfully load Report Builder ONLY from the LAN-side of the firewall. However, if I reconnect using my Sprint AirCard I cannot load Report Builder; I get the now infamous "The remote server returned an error: (401) Unauthorized."

What ports are used by Reporting Service?

Thanks,

Brian

I'm not sure what's up with the AirCard connection, but I think I can explain the WAN/LAN difference. On the LAN side your default Windows credentials are sufficient to access the Report Builder files at http://hostname/reportserver/reportbuilder. On the WAN side, Windows integrated authentication doesn't work, so you get no Report Builder. The reason is that ClickOnce (which is responsible for downloading the application files to the client) cannot prompt for credentials, and it doesn't get any from IE, so if default Windows credentials don't work, you get nothing. The solution is to configure IIS on the report server to allow anonymous access to the virtual directory I mentioned above.

|||Does this work with port 443 also?

Report Builder error with Cubes

Hi,
I am receiving the following error when I run the report builder query. I am
able to successfully select the dimensions and measures that I am interested
in but when I run the report I get the error message.
The 'PerspectiveID' custom property for the 'query' perspective is either
not set or is not set to the string data type.
--
Semantic query execution failed.
--
Query execution failed for data set 'dataSet'.
--
An error has occurred during report processing.
I am testing this against both Adventureworks standard and enterprise cubes.
Additionally I saw this post in another forum
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
that seemed related but I am using reporting services in sharepoint
integrated mode so I am having a hard time trying to troubleshoot this.
Thanks for your help!On Dec 14, 2:14 am, Kodi <K...@.discussions.microsoft.com> wrote:
Hi
Whats your query ? Seems like you are using parameters which have not
been set.
Cheers
Shai
> Hi,
> I am receiving the following error when I run the report builder query. I am
> able to successfully select the dimensions and measures that I am interested
> in but when I run the report I get the error message.
> The 'PerspectiveID' custom property for the 'query' perspective is either
> not set or is not set to the string data type.
> --
> Semantic query execution failed.
> --
> Query execution failed for data set 'dataSet'.
> --
> An error has occurred during report processing.
> I am testing this against both Adventureworks standard and enterprise cubes.
> Additionally I saw this post in another forumhttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
> that seemed related but I am using reporting services in sharepoint
> integrated mode so I am having a hard time trying to troubleshoot this.
> Thanks for your help!|||Hi,
I work with kodi and he posted this for me while my subscription was in
progress.
When using Cubes with report builder the report model is generated
automatically by clicking generate a model from the data source (RDS) working
in Sharepoint in my case, Then you load that report model which opens up the
report builder and it is drag and drop from there. There are no parameter in
report builder that I know of, it is all add-hoc and you would use filters to
act like parameters.
Larry
"shaikat.das@.gmail.com" wrote:
> On Dec 14, 2:14 am, Kodi <K...@.discussions.microsoft.com> wrote:
> Hi
> Whats your query ? Seems like you are using parameters which have not
> been set.
> Cheers
> Shai
> > Hi,
> >
> > I am receiving the following error when I run the report builder query. I am
> > able to successfully select the dimensions and measures that I am interested
> > in but when I run the report I get the error message.
> >
> > The 'PerspectiveID' custom property for the 'query' perspective is either
> > not set or is not set to the string data type.
> > --
> > Semantic query execution failed.
> > --
> > Query execution failed for data set 'dataSet'.
> > --
> > An error has occurred during report processing.
> >
> > I am testing this against both Adventureworks standard and enterprise cubes.
> > Additionally I saw this post in another forumhttp://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=368962&SiteID=1
> > that seemed related but I am using reporting services in sharepoint
> > integrated mode so I am having a hard time trying to troubleshoot this.
> >
> > Thanks for your help!
>

Monday, March 12, 2012

Report Builder Cube deploys to the wrong location!!

I have built a cube successfully however, it deploys succcessfully but to the wrong location. I have MSSQL.1, MSSQL.2 and MSSQL.3 and I Reporting Services in is MSSQL.3 but the cube is deploying to MSSQL.2/OLAP and I can't access it from there. I have tried changing the server name and specifiying the server/instance but it fails. I'm at my wits end! HELP!

Debra

The directories you've outlined are all correct and the cube has deployed to the correct location. With all components installed the locations should be as follows:

MSSQL - SQL 2000 Database Engine|||I am trying to access it by clicking on "report builder" from the reports webpage http://localhost/reports. Instead of seeing the cube in the selection box, there is a message saying therre are no cubes available and that in order to use report builder at least one cube must be published to the report server. Again, I am able to "successfully" deploy (using either localhost or my server name) but for some reason report builder can't "see" it. Are there some setting I need to modify for report builder?|||

Report builder does not connect directly to a cube. It connects to a Report Model which is different.

Once you've created a cube you first need to create a data source to point to that cube. you can do this by clicking the "New Data Source" button on the toolbar in report manager. Give it a name, select "Microsoft Analysis Services" as the connection type and put something like

Initial Catalog=Adventure Works DW;Data Source=<server>[\<instance>];

in the connection string box. Once you click ok to create the data source go to the properties page of the data source and click the "Generate Model" button. Once you've created the default model you'll be able to launch report builder and access the cube using the model.

Report models can also be created an modified using the BI development studio.

Friday, March 9, 2012

Report Builder 401 Errors since SP1

I have been accessing SSRS and Report Builder on a SQL 2005 from the
Internet successfully for some time now but today I am receiving 401 errors
when I try to launch Report Builder. The details show a 401 error
"Unauthorized". This all worked fine until I installed SQL 2005 SP1.
Has anybody run into this before or any suggestions. I can still run saved
reports just fine, it is only the launch of Report Builder that fails.
Thanks, MikeWe got this from Report Manager after we installed Microsoft Windows
Server 2003 Service Pack 1 (SP1).
http://support.microsoft.com/Default.aspx?kbid=896861 solved our
problem.
Neil
Mike Morisoli wrote:
> I have been accessing SSRS and Report Builder on a SQL 2005 from the
> Internet successfully for some time now but today I am receiving 401 errors
> when I try to launch Report Builder. The details show a 401 error
> "Unauthorized". This all worked fine until I installed SQL 2005 SP1.
>
>
> Has anybody run into this before or any suggestions. I can still run saved
> reports just fine, it is only the launch of Report Builder that fails.
>
>
> Thanks, Mike