| T O P I C R E V I E W |
| sefer |
Posted - 02/22/2006 : 10:10:37
Hi,
because of security problems in SQL Server 2000 i use now SQL Server 2005.
RP worked very fin with 2000 and it was very easy to get a connection to OWC.
Now I installed 2005 and RP 2.1 build 100, all things works fine but i am now not able to get a connection over OWC.
I dont use the AS Security. All default settings after setup are in use.
I changed only ADMIN-->Settings-->OWC-Settings : http://<myserver>/demo/msolap
HTTP:
If i try to"connect to cube" Following Internet-Explorer Error message appears:
1.)
Row 168
sign 3
code 0
url:connect.aspx
if i click YES then the second error appears .
2.)
row 20
sign 1
code 0
url:connect.aspx
HTTPS:
If i connecto over https,
i am able to see the Pivot-table but i cant connect to a cube!
The Error message in pivot-tabele said:"Their are no more error messages from data provider"
What can i do, to use owc?
Sefer
|
| 10 L A T E S T R E P L I E S (Newest First) |
| sefer |
Posted - 03/15/2006 : 14:11:12
Thank you admin,
so easy for you and so hard for me.
Sefer |
| admin |
Posted - 03/14/2006 : 19:41:11
Please select HTTP for the "Connection Type" |
| sefer |
Posted - 03/14/2006 : 04:07:14
Hi,
in the following screenshot you can see the connection string:
http://sefer-derya.de/download/connection%20string.JPG
OWC-Translation:
The query could not executed!
Systemfailure:"The given host is unknown""
The test with test.udl works fine from desktop to server over OLEDB AS 9.0 and string "http://sefer-derya.de/xmla/msmdpump.dll"
What shall i do? |
| admin |
Posted - 03/13/2006 : 23:13:45
What does the connection dialog has in the “Sever” dropdown?
Try testing the connection to your server using a udl file. Just create a test file on your desktop and rename it to test.udl. Double click test.udl. Under the provider tab choose: OLEDB Provider of Analysis Services 9.0 and test the connection |
| sefer |
Posted - 03/13/2006 : 08:19:18
Hi,
i installed now
1.)MSXML 6.0
2.)Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
I get now following error:
Systemfailure:"The given host is unknown"
I am only able to get a owc-connection from localhost, but not over internet!
what shall i do? |
| marco |
Posted - 03/11/2006 : 14:23:28
Hi Sefer,
You need on any client:
Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider
You can download this free from the SQL Server 2005 Feature Pack:
http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc
Don't forget to download also: Microsoft Core XML Services (MSXML) 6.0
Regards, Marco |
| sefer |
Posted - 03/11/2006 : 00:01:33
Hi Marco,
which client components?
I didnt hear about before!
I only installed OWC11.exe!!
The client components are on the SQL Server 2005 CD?
Sefer |
| marco |
Posted - 03/10/2006 : 12:16:46
Hi,
Did you install the needed software components on the client to have access to SSAS 2005. It is different than with SSAS 2000.
Marco |
| sefer |
Posted - 03/10/2006 : 04:12:13
Hi,
no hint to solve this problem.
I installed now B101 but owc doesnt work, the rest works fine!
Sefer |
| marco |
Posted - 02/22/2006 : 14:55:22
Hi,
I didn't install any special msolap and with Windows 2003 Server, MS SQL Server 2005 Developer and RP 2.1 build 100 OLAP was working in a direct way. Maybe you should delete the msolap in admin setting. By the way did you changed the security of server/demo in IIS Windows 2003 Server is working different and maybe you don't have access t this folder.
Can i visit your RP on internet ?
Marco
www.gmsbv.nl |
Report Portal
