Showing posts with label accessing. Show all posts
Showing posts with label accessing. Show all posts

Friday, March 23, 2012

ReportServer Problem

Hi!
I get suddenly the following error when accessing the error:
"The underlying connection was closed: Unable to connect to the remote
server."
The configuration has not been changed.....!?!
Greets
ChrisHello'
Noone knows an answer?
greetz
chris
"Christian Weber" <avbc.def@.ghi.de> wrote in message
news:cdqjei$1a7$1@.papyrus.erlm.siemens.de...
> Hi!
> I get suddenly the following error when accessing the error:
> "The underlying connection was closed: Unable to connect to the remote
> server."
> The configuration has not been changed.....!?!
> Greets
> Chris
>|||Sorry, I will be no help here. I have the same problem. It just magically
happened when I came to work this Monday. Everything was working normally
when I left Friday. No configuration changes have been done.
The only good thing is I can still render reports through the web service.
So this is an annoyance but thankfully my application is still working for
now.
If I go to:
http://reportserver/reports/
I get the exact same error you got.
If I go to:
http://reportserver/reportserver/
everything works fine and I see folders and links to previously uploaded
reports. I can also run reports from here.
My reporting services app runs on Windows 2003 Server. It is on a separate
server from SQL Server 2000 Standard which is also a Windows 2003 Server. I
have been running Reporting Services SP1 for a few weeks now. I do not think
that Windows XP SP2 has been applied to the servers by the sysadmins yet.
If you solve this yourself or find the solution could you please reply to
this thread. I will do that same for you.
Jeff
"Christian Weber" wrote:
> Hello'
> Noone knows an answer?
> greetz
> chris
> "Christian Weber" <avbc.def@.ghi.de> wrote in message
> news:cdqjei$1a7$1@.papyrus.erlm.siemens.de...
> > Hi!
> >
> > I get suddenly the following error when accessing the error:
> >
> > "The underlying connection was closed: Unable to connect to the remote
> > server."
> >
> > The configuration has not been changed.....!?!
> >
> > Greets
> >
> > Chris
> >
> >
>
>sql

ReportServer directory not available outside firewall

We are attempting to expose our reports to the internet without much luck.
The domain name is not set up yet, so we are accessing by IP. There are 2
virtual folders - Reports and ReportServer are set up with Windows
authentication. When I go to http://xxx.xxx.xxx.xxx/ReportServer, I get
prompted, login and then see the list of reports. When I click on a report,
I get prompted again, but login fails and I get 401. Where should I start
looking? Most problems I see from others have to do with the Reports
directory, but their ReportServer directory works.I think 401 is an 'Unauthorised' error. Check your firewall settings, but
pay specific attention to the IIS and .NET authentication as well. Are you
using windows or forms based authentication?
"danb" wrote:
> We are attempting to expose our reports to the internet without much luck.
> The domain name is not set up yet, so we are accessing by IP. There are 2
> virtual folders - Reports and ReportServer are set up with Windows
> authentication. When I go to http://xxx.xxx.xxx.xxx/ReportServer, I get
> prompted, login and then see the list of reports. When I click on a report,
> I get prompted again, but login fails and I get 401. Where should I start
> looking? Most problems I see from others have to do with the Reports
> directory, but their ReportServer directory works.|||Yes, 401 wit h a message about invalid credentials, but as I said, I was able
to log in to the /ReportServer folder successfully and then it prompted me
again for some reason when I clicked on any report.
Check the firewall for what?
Windows authentication is being used on both Reports and ReportServer folders.
Server is Windows 2003 Server.
"CraigyBoop" wrote:
> I think 401 is an 'Unauthorised' error. Check your firewall settings, but
> pay specific attention to the IIS and .NET authentication as well. Are you
> using windows or forms based authentication?
> "danb" wrote:
> > We are attempting to expose our reports to the internet without much luck.
> > The domain name is not set up yet, so we are accessing by IP. There are 2
> > virtual folders - Reports and ReportServer are set up with Windows
> > authentication. When I go to http://xxx.xxx.xxx.xxx/ReportServer, I get
> > prompted, login and then see the list of reports. When I click on a report,
> > I get prompted again, but login fails and I get 401. Where should I start
> > looking? Most problems I see from others have to do with the Reports
> > directory, but their ReportServer directory works.

Wednesday, March 21, 2012

Reports with "Multi Parameters" Accessing Analysis Services Cube (MDX calls)?

I have an OLAP Cube that is being accessed by Reporting services reports
with MDX syntax. I am successful so far in having one parameter set. I need
to know if it is possible to have more than one to set and get the desired
results accordingly. Here is what I have so far:
Data Source:
="Select NON EMPTY{ {[Geo1].[Div].members}*{[Dept1].[Department].members}*
{ [Employee].[All Employee].children}} On ROWS,
NON EMPTY {[Measures].[Percent Complete]} ON COLUMNS
FROM [My Cube1]
WHERE ([" + Parameters!pCurr.Value + "])"
pCurr data set :
SELECT { [Measures].[Percent Complete]} ON Columns,NON EMPTY [Curriculum].
[Curriculum].Members ON ROWS FROM [My Cube1]
So, thus Far I can control the result set by Choosing the Curriculum only.
I need to be able to have another parameter set, besides Curriculum, for
instance Department, where I would choose department, then curriculum,
then the result set would be the outcome needed? Is it feasible and how?
Thanks so much in advance.
--
Message posted via http://www.sqlmonster.com="SELECT NON EMPTY { {[Geo1].[Div].members } * {[Dept1].[Department].[" +
Parameters!pDept.Value + "] } * { [Employee].[All Employee].children}} On
ROWS,
NON EMPTY {[Measures].[Percent Complete]} ON COLUMNS
FROM [My Cube1]
WHERE ([" + Parameters!pCurr.Value + "])"
btw, i usually don't use the where clause, i just put parameter into the
select dimensions.
"Hobie via SQLMonster.com" wrote:
> I have an OLAP Cube that is being accessed by Reporting services reports
> with MDX syntax. I am successful so far in having one parameter set. I need
> to know if it is possible to have more than one to set and get the desired
> results accordingly. Here is what I have so far:
> Data Source:
> ="Select NON EMPTY{ {[Geo1].[Div].members}*{[Dept1].[Department].members}*
> { [Employee].[All Employee].children}} On ROWS,
> NON EMPTY {[Measures].[Percent Complete]} ON COLUMNS
> FROM [My Cube1]
> WHERE ([" + Parameters!pCurr.Value + "])"
> pCurr data set :
> SELECT { [Measures].[Percent Complete]} ON Columns,NON EMPTY [Curriculum].
> [Curriculum].Members ON ROWS FROM [My Cube1]
> So, thus Far I can control the result set by Choosing the Curriculum only.
> I need to be able to have another parameter set, besides Curriculum, for
> instance Department, where I would choose department, then curriculum,
> then the result set would be the outcome needed? Is it feasible and how?
> Thanks so much in advance.
> --
> Message posted via http://www.sqlmonster.com
>|||Great. it worked with few glitches that I am working on correcting.
However, I do not want to include my parameters in the select. see I would
like the below format:
Select Select Select
Division: Services Department:Acounting Curriculum: Excel (as params)
_________________________________________________________________
Employee Percent Complete
John 40%
Amy 20%
Kerry 90%
That is why I was adding the where clause. If I can say in the WHERE:
WHERE ([" + Parameters!pDiv.Value + "] AND [" + Parameters!pDept.Value + "]
" AND [" + Parameters!pCurr.Value + "] ),
But I know there is no AND in this fasion in MDX. Any suggestions!
Again thanks in advance for the help!!!
--
Message posted via http://www.sqlmonster.com|||WEll - I solved my own problem, but thanks to mike for the tip; No more
WHERE statement in MDX for params specifications here is what mike
suggested and how I implemented it. :) .
--
DataSource1:
="SELECT NON EMPTY { {[Geo1].[Div].[" + Parameters!pDiv.Value + "]} * {
[Dept1].[Department].[" + Parameters!pDept.Value + "] }*{[Curriculum].
[Curriculum].[" + Parameters!pCurr.Value + "] }*{ [Employee].[All Employee]
.children} } On ROWS, NON EMPTY {[Measures].[Curr Percent Complete]} ON
COLUMNS FROM [CertificationsDB]"
--
DataSet pCurr:
SELECT { [Measures].[Curr percent Complete]} ON Columns,NON EMPTY
[Curriculum].[Curriculum].Members ON ROWS FROM [CertificationsDB]
DataSet pDept:
SELECT { [Measures].[Curr percent Complete]} ON Columns,NON EMPTY [Dept1].
[Department].Members ON ROWS FROM [CertificationsDB]
DataSet pDiv:
SELECT { [Measures].[Curr percent Complete]} ON Columns,NON EMPTY [Geo1].
[Div].Members ON ROWS FROM [CertificationsDB]
Enjoy y'all
--
Message posted via http://www.sqlmonster.comsql

Monday, March 12, 2012

Reports Authentication

Hi All,

I am writing an Web Application accessing the Reports, that will be hosted in web (not in Intranet). (Win 2003 + VS 2005 Environment)

1) I am not sure to pick the authentication (Forms (or) Windows).

2) Also the requirement is that the user name / password should not be hard coded anywhere in the application

Can any one advice me on the above mentioned issues.

Regards,

Coras

Hi Corcas,

Use Forms Authentication.

Store the UserId and Password in Sql Database/ web config and read the values to access the Report Server.

Regards,

shanthi

Wednesday, March 7, 2012

ReportingServices - global access problem.

Hi, experts.
I have a strange problem with accessing Analysis Services from
Reporting
Services.
Our client needs to public reports in the web site and to make them
accessible for everybody. In order to achieve it, I did the following:
1. In IIS I put the anonymous access for the virtual directory
ReportServer. (the user IWAM_hostname)
2. I granted the explorer right to the user IWAM_hostname from the web
application that permits the reports to be managed.
3. In the same application I changed the credentials for the dataset
that pointed to analysis services. I chose the "stored credentials"
(the user I specified had access rights in the corresponding cube).
Once the configuration was established, I tried to access our reports
via web. I could see reporting services interface but it was not
possible to view the data from analysis services. There was an error:
"dimension not known."
Seeing this, I decided to give analysis services rights for the
IWAM_hostname user, but it brought the same result.
When I changed the configuration of Report Server virtual directory
(instead of anonymous access, I put the windows authorization again),
everything worked fine.
I have an impression that credentials specified in the web application
are ignored.
The question is, which user is used to access the Analysis Services
from the Reporting Services when the anonymous user is set in the IIS
ReportServer directory.
All relevant information will be appreciated.
One more thing: Reporting Services has the servicepack 1 installed.
Thanks in advance
Maciej KiewraHi Maciej,
I have the exact same problem as you. I was told to try and add entry to
the RSWebApplication.config file. It is
<ReportServerExternalUrl>http://yourwebservername/ReportServer</ReportServerExternalUrl>
add this right after the <ReportServerUrl> entry. This didn't work for me
but I am interested in if it works for you. Let me know.
Thanks,
JJ
"Maciej Kiewra" wrote:
> Hi, experts.
>
> I have a strange problem with accessing Analysis Services from
> Reporting
> Services.
> Our client needs to public reports in the web site and to make them
> accessible for everybody. In order to achieve it, I did the following:
> 1. In IIS I put the anonymous access for the virtual directory
> ReportServer. (the user IWAM_hostname)
> 2. I granted the explorer right to the user IWAM_hostname from the web
> application that permits the reports to be managed.
> 3. In the same application I changed the credentials for the dataset
> that pointed to analysis services. I chose the "stored credentials"
> (the user I specified had access rights in the corresponding cube).
> Once the configuration was established, I tried to access our reports
> via web. I could see reporting services interface but it was not
> possible to view the data from analysis services. There was an error:
> "dimension not known."
> Seeing this, I decided to give analysis services rights for the
> IWAM_hostname user, but it brought the same result.
> When I changed the configuration of Report Server virtual directory
> (instead of anonymous access, I put the windows authorization again),
> everything worked fine.
> I have an impression that credentials specified in the web application
> are ignored.
> The question is, which user is used to access the Analysis Services
> from the Reporting Services when the anonymous user is set in the IIS
> ReportServer directory.
> All relevant information will be appreciated.
> One more thing: Reporting Services has the servicepack 1 installed.
>
> Thanks in advance
> Maciej Kiewra
>