| T O P I C R E V I E W |
| sefer |
Posted - 10/26/2005 : 13:04:24
Hi,
i cant install RP2.
This problem occurs on my Notebook and on my dedicated Server.
Let's solve the Problem on my Notebook:
My Software:
Windows XP Prof. SP2 (German)
Visual Studio.Net 2003 (MS.NET Framework 1.1) (German)
MS SQL Server 2000 Standard Edition and SP4 (English)
Analysis Server 2000 and SP4 (English)
IIS 5.1
MY Accountname: sefer (with Administrator permissions)
I have downloaded from your Server:
# XMLA SDK 1.1
# MSXML 4.0
# RP2
I Followed the install-Steps from your Site http://www.reportportal.com/help.asp (INSTALLATION)
"Please follow the following steps to install the application:
1) Make sure that "Microsoft OLE DB Provider for OLAP Services 8.0" is installed on the web server.
* Open test.udl file. Click on the Provider tab to see if the "Microsoft OLE DB Provider for OLAP Services 8.0" is installed.
* If it is not installed, install the provider by running PTSFULL.EXE from the SQL Server 2000 CD"
-->OK
"2) Install XML for Analysis SDK 1.1
* Download the "XML for Analysis SDK version 1.1" from http://www.microsoft.com
* Install the SDK
* Create virtual directory "xmla" that points to the "C:\Program Files\Microsoft XML For Analysis SDK\isapi" folder
* Change the execute permissions for the "XMLA" virtual directory to "Script and Executables""
-->OK
-->blue is Changed by me-->
" * Update the datasources.xml to point to your OLAP Server. You should change <DataSource> for each node following this pattern: <DataSourceName>Local Analysis Server</DataSourceName>
<DataSourceDescription>Microsoft Analysis Server 2000 on local machine</DataSourceDescription>
<URL>http://localhost/xmla/msxisapi.dll</URL>
<DataSourceInfo>Provider=MSOLAP.2;Data Source=localhost</DataSourceInfo>
<ProviderName>Microsoft XML for Analysis</ProviderName>. Create<DataSource> node for each server you would liketo connect to."
I tested this configuration with the samples.net from xmla--> it works.
For this step i opened sample.sln from the Folder Sample.Net with VS2003 and created the SAMPLE.EXE
URL:http://localhost/xmla/msxisapi.dll
DATA SOURCES: Local Analysis Server
I have only a connecton to a cube which has following permissions "All Users"
RESULT: XMLA WORKS FINE !!!
3) Install program files
* Create a virtual directory (ReportPortal for example). Double click the Virtual.vbs script file to automate the process. It is important to create a new virtual directory and not just a folder under wwwroot. In the IIS console right click the "Default Web Site" > New > Virtual Directory...
* Unzip all of the files into the directory
My problems are in Step 3:
At first, there is no Virtual.vbs script anywhere
Second, because the installation needs a database, i prefered the Step 4(Setup Database)
-I Created a DB called "ReportPortal"-->OK
-I used the script "tables.sql" in DB "ReportPortal"-->OK
Then I went back to STEP 3:
-I created a Folder in inetub\wwwroot\ReportPortal
-I created A Virtual Directory called "ReportPortal" in IIS
-->permissions in IIS: READ+Scripts(ASP) and "ANONYMOUS+Windows integrated Security"
-I copied the installation files into the directory inetub\wwwroot\ReportPortal
-I started SETUP.EXE (Build 83)
---SQL SERVER 2000
-----Servername: localhost or (local) both doesnt work
-----Database name: ReportPortal
-----Username: sefer or sa both doesnt work
-----Password: ***** (myPassword)or nothing both doesnt work
--Virtual Directory name: xmla
--Analysis Services Server Name:Local Analysis Server
--NT Username: Administrator or sefer both doesnt work
--Password: "blank" or "***** (myPassword)" both doesnt work
-Virtual Directory: ReportPortal
-Port: 80
FAILURE:<DBDeploy>
"Could not connect to database. Please correct the information and try again"
<SQLServer Information>
if i change something, it seems so that it has no effect!
-IF i CLICK <OK or CANCEL> then
*"Could not connect to database. Please correct the information and try again"
*<Report Portal 2.0> (Prompt is in German, i try to translate)
Ger#Fehler bei der Anmeldung für den Benutzer 'test'.
Ger#Ursache: Keiner vertrauten SQL-Server-Verbindung zugeordnet.
Eng#Error during the registration for the user ' test '.
Eng#A cause: No familiar SQL server connection assigned.
-->The installer was interrupted before ReportPortal 2.0 could be insatlled.
What can i do?
Best regards from Hannover/Germany
Sefer
|
| 13 L A T E S T R E P L I E S (Newest First) |
| marco |
Posted - 11/03/2005 : 15:16:02
Hi,
If you have for example a client with Windows 2000 Pro / Windows XP with IIS on than you have a local server and sometimes reference of localhost on a server from a client is watching the local client and not the server. so try to have always a servername or pc name as reference instead of local or localhost.
Regards, Marco
www.gmsbv.nl |
| sefer |
Posted - 11/03/2005 : 05:14:44
Hi,
i think the last hint solves the problem, but i dont know why?
I changed the Data Source=
localhost
to
servername
and now it works!
thx
Sefer |
| marco |
Posted - 10/30/2005 : 14:44:49
Hi,
Why not use your servername instead of Data Source=localhost ?
I think that is the problem
Regards, Marco
|
| sefer |
Posted - 10/29/2005 : 03:49:31
@Igor "to allow all unknown ISAPI extensions" doesnt works!
I try to start from the beginning.
Installed Programs in these sequence!(if necessary, after installation allways Restart)
1.)MY Server is a dedicated pre configured MS windows Server 2003 (SP1).
2.) SQL Server 2000 standard
2.1)SP4
2.2.)sa Passwort is "******"
2.3.)Mixed Mode
3.)Analysis Server 2000 Standard
3.1)SP4
3.2)Foodmart has permissions "All users"
4.)MSXML4
5.)XMLA SDK 1.1
6.)IIS
6.1)Virtual Directory for "xmla"
6.1.1)only ANONYMOUS users
6.1.2)allowed: READ / Scriptpermission / SCRIPTS and EXECUTABLES
6.2)webservices allowed "Msxisapi.dll"
6.3)All unknown ISAPI extensions allowed
7.)web.config created in virtual directory "xmla"
<pre class="code"><configuration>
<system.web>
<webServices>
<protocols>
<add name="HttpGet"/>
<add name="HttpPost"/>
This is required from this Site (search for "post" please)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/implementxap.asp
and see here
http://support.microsoft.com/default.aspx?scid=kb;en-us;819267
but they say "that is only necessary for remote PC", but i did it nevertheless!
</protocols>
</webServices>
</system.web>
</configuration></pre>
8.)Datasources.Xml changed
8.1)Data Source=localhost
9.)XMLA Sample APP
9.1.)URL: http://localhost/xmla/msxisapi.dll --> UPDATE
9.2.)Fault Code: 0
10.)Internet Explorer
10.1.)URL: http://localhost/xmla/msxisapi.dll --> GO
10.2.)ERROR: HTTP 400
THATS ALL!
What have i done wrong?
On my ClientPC (Windows XP Prof) the connection works fine!
thx Sefer |
| admin |
Posted - 10/28/2005 : 18:21:58
Please try to allow all unknown ISAPI extensions.
http://h572642.serverkompetenz.net/download/JPG/2-ISAPI.jpg
|
| sefer |
Posted - 10/28/2005 : 10:51:09
Sorry,
there were some errors on my Server.
I think it functions now.
Sefer
My Software:
Windows XP Prof. SP2 (German)
Visual Studio.Net 2003 (MS.NET Framework 1.1) (German)
MS SQL Server 2000 Standard Edition and SP4 (English)
Analysis Server 2000 and SP4 (English)
IIS 5.1 |
| admin |
Posted - 10/28/2005 : 09:47:44
Sorry, I can’t access any of your pictures. |
| sefer |
Posted - 10/28/2005 : 02:12:50
Hi,
the steps you say has done already before. I did snapshots of it. Maybe i make somewhere a mistake.
1) The anonymous user for the XMLA virtual directory has full access to your analysis services database.
MY Pic: http://h572642.serverkompetenz.net/download/JPG/1-ANONYMOUS.jpg
2) You will also need to explicitly enable ISAPI extensions for XML/A to work.
http://www.reportportal.com/images/ISAPI.gif
MY Pic: http://h572642.serverkompetenz.net/download/JPG/2-ISAPI.jpg
3) Install the XMLA SDK sample Application (http://www.reportportal.com/download/XmlaSampleApp.zip) on your local computer and point it to your server to test the XMLA service.
MY Pic: http://h572642.serverkompetenz.net/download/JPG/3-XMLA%20Sample%20App.jpg
4)Also the latest build has a Application Setup utility that you can open by going to Programs > Report Portal > Application Setup
MY Pic: http://h572642.serverkompetenz.net/download/JPG/4-XMLA%20Setup.jpg
and
MY Pic: http://h572642.serverkompetenz.net/download/JPG/4_1-XMLA%20Setup%20DatasourcesXML.jpg
All MY Pics in ZIP: http://h572642.serverkompetenz.net/download/JPG/All%20My%20Pics.ZIP
thats all
thx Sefer |
| admin |
Posted - 10/27/2005 : 23:55:57
Please make sure that
1) The anonymous user for the XMLA virtual directory has full access to your analysis services database.
2) You will also need to explicitly enable ISAPI extensions for XML/A to work.
http://www.reportportal.com/images/ISAPI.gif
3) Install the XMLA SDK sample Application (http://www.reportportal.com/download/XmlaSampleApp.zip) on your local computer and point it to your server to test the XMLA service.
Also the latest build has a Application Setup utility that you can open by going to Programs > Report Portal > Application Setup |
| sefer |
Posted - 10/27/2005 : 06:12:12
Hi I installed RP2 now on my SERVER!
Windows Server 2003 Standard
IIS 6.0
SQL 2000 Standard (SP4)
AS 2000 (SP4)
1.)No Visual Studio.Net, is that a problem?
Because at the installation there occures an ERROR like" JIT- Debugger is not available"!
2.)What is JIT-Debugger?
I changed the security options in SQL Server from Windows to MIXED!
The Installation was OK. (Only the JIT-Debugger Error)
I am able to connect to "http://MyWebsite.com/reportportal/login.aspx"
but not to "http://localhost/reportportal/login.aspx"
3.)is that normally?
I can LOGIN with admin/admin and create new user and so on, all seems to work.
But i can't get a connection to "http://localhost/xmla/msxisapi.dll"
I followed the Steps in you FAQ:
Q: The Report Portal does not seem to work under Windows Server 2003.
A: You will need to enable ASP’s "parent paths" for a Web Site or application when using relative paths in include statements. This is disabled by default in IIS 6. Make sure that Active Server Pages are allowed in the IIS 6 console. Please refer to this Microsoft knowledge base article. You will also need to explicitly enable ISAPI extensions for XML/A to work.
Something is a little bit strange, the virtual Directory for xmla on my Notebook has this ANONYMOUS Account:IUSR_MyComputerName
and on my Server this one: MyDomainName\IUSR_ANONYMOUS
I cant choose on my server a account like IUSR_MyComputerName
4.)what is the problem with xmla?
thx Sefer |
| sefer |
Posted - 10/27/2005 : 03:20:39
Hi,
at first
@igor
you were in right, the SQL Server Windows Security were activated.
I changed it to the mixed Mode.
I created the test.udl and now i have a connection with the User "sa" Pswd "MySaPswd"!
Still i have another problem.
If i installed all and i start Internet Explorer with
"http://localhost/reportportal/default.aspx" nothing happens.
There are no Error descriptions, because the site is allways loading...
My Steps:
1.)I uninstalled all Programs, the Database "ReportPortal" and removed all things from IIS
2.)Restart
3.)I installed "XMLASDK.msi"
4.)I installed "msxml.msi" (4.0 SP2 and SDK)
4.1)custom install (Standard)
4.1.1.)"checked" MSXML(global)
4.1.2.)"checked" MSXML(parallel)
4.1.3.)"unchecked" XML SDK
5.)Added "xmla" in IIS ,only ANONYMOUS and checked "Script and Executables"
6.)Connection to XMLA works FINE
7.)Restart
8.)Insatlled RP2 (Setup.Exe)
8.1.)SQL Server Connection: "sa" "mySaPswd"
8.2.)XMLA Setup:"sefer" " MyNtPswd"
8.3.)Database Created
8.4.)IIS:Virtual Directory Created!
8.5.)RP2...successfully installed!
9.)XMLA Manual Setup
9.1.)Start-->All Programs-->ReportPortal-->Application Setup
9.2.)SQL Server 2000
9.3.)TEST: Successfully connected...
10.) Opening the Site "http://localhost/reportportal/default.aspx" in IE doesnt work!!!
I tried various of changings but all doesnt work too!
Any idea?
thx Sefer
My Software:
Windows XP Prof. SP2 (German)
Visual Studio.Net 2003 (MS.NET Framework 1.1) (German)
MS SQL Server 2000 Standard Edition and SP4 (English)
Analysis Server 2000 and SP4 (English)
IIS 5.1 |
| marco |
Posted - 10/26/2005 : 21:55:06
Hi Sefer,
The installation is straight forward. Just see if your .uld in RP isntallaed directory is working and / or change the password of the connection and test it.
I would advise you following:
Just uninstall all xmla, msxml4.0 and rp 2.0 inbcl database.
Install first xmla and msxml4. Add/chmage the IIS rights for XMLA as ANONYMOUS without int security. test XMLA working. Restart.
Download build 83 and install RP with setup.exe and install database and at the end say xmla manual setup.
That is all there is and it should be working withour problems with SQL Server 2000 / Analysis Services 2000
Best regards,
Marco Groeneveld
www.gmsbv.nl
|
| admin |
Posted - 10/26/2005 : 20:57:59
Sefer,
The installation help page (http://www.reportportal.com/help/install.htm) is only relevant for manual installation (non MSI). The evaluation copy comes in MSI format only.
A) It seems that your problem is related to connecting to your SQL server database. To test you connections please try the following:
1) Create a new text document on your desktop and rename it to test.udl. (Make sure that your windows folder options let you modify the file extension)
2) Double click test.udl you created.
3) Select “Microsoft OLEDB provider for SQL Server on your”
4) Click “Next”
5) Enter your server name, “Use specific user name and password”, user name and password and test the connection.
B) Please make sure that your SQL Server is in the MIXED (SQL Server AND Windows) security mode:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xpehelp/html/xeconAuthenticationMode.asp
|
Report Portal
