| Author |
 Topic  |
|
|
tres_ross
USA
28 Posts |
 Posted - 04/16/2011 : 08:15:54
|
I am getting an error that says that
"No connection could be made because the target machine actively refused it."
ReportPortal used to work fine on my 64-bit machine running SQL Server 2008 R2. When I updated my cube, I'm now getting this error. The cube works fine within SQL Server 2008 R2 Management Studio and in Visual Studio.
Does anyone have an idea on how to address this? Thanks. |
|
|
admin
1637 Posts |
Posted - 04/18/2011 : 19:08:54
|
| Are you able to connect from your web server to SSAS server using a UDL? On the web server create a test file, change its extension to UDL and double click to open it. Use Microsoft OLE DB Provider for Analysis Services. |
 |
|
|
tres_ross
USA
28 Posts |
Posted - 04/27/2011 : 06:41:35
|
I tested the udl file and it first says that there were some errors, though then says test succeeded. I also tried to connect to my cube after not using it for about a week. It now seems to connect fine.
One challenge I just noticed is that data from measures that are secondary to the main table are now not showing any information. Information from the main table is fine. When I go into Visual Studio, everything works fine. Any ideas why this is an issue? Thanks. |
|
|
|
marco
Netherlands
588 Posts |
Posted - 04/27/2011 : 07:12:48
|
is it a security issue ?
is all data available and visible for the user on the server or by web ?
marco |
|
|
|
tres_ross
USA
28 Posts |
Posted - 04/27/2011 : 11:50:06
|
| I do not have users defined right now. Where do I set measures / dimensions so they are visible for the web. |
|
|
|
tres_ross
USA
28 Posts |
Posted - 04/28/2011 : 13:25:13
|
I do have the measures and dimensions set to visible under the AttributeHierarchyVisible Attribute setting, which is set to True.
On another note, I again have the error connecting to the cube saying that the target machine actively refused it. It seems to be a random issue. The cube works fine in Visual Studio and Management Studio. The UDL file still says that test succeeded though with some errors. Any ideas on how to address this? |
|
|
|
admin
1637 Posts |
Posted - 04/28/2011 : 20:18:44
|
| Which Authentication method (Windows, Basic, Anonymous) do you have set for the XMLA virtual directory? |
|
|
|
tres_ross
USA
28 Posts |
Posted - 04/29/2011 : 06:10:30
|
| I fixed the issue. It was because I have two instances of SQL Server. One as the Default and the other one as a named instance. The Default was turned off causing the error. I'm now working on the named instance. I went into msmdpump.ini and modified the server from localhost to the named instance. I thought I made this change through a UDL file, though guess it did not change it. To make the change take affect, I had to restart the web server. |
|
|
| |
Topic |
|
Report Portal
msmdpump.dll - actively refused it
