| Author |
 Topic  |
|
|
sefer
Germany
105 Posts |
 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
|
|
|
marco
Netherlands
588 Posts |
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 |
 |
|
|
sefer
Germany
105 Posts |
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
Netherlands
588 Posts |
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
Germany
105 Posts |
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
Netherlands
588 Posts |
|
|
sefer
Germany
105 Posts |
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? |
|
|
|
admin
1645 Posts |
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
Germany
105 Posts |
|
|
admin
1645 Posts |
Posted - 03/14/2006 : 19:41:11
|
| Please select HTTP for the "Connection Type" |
|
|
|
sefer
Germany
105 Posts |
Posted - 03/15/2006 : 14:11:12
|
Thank you admin,
so easy for you and so hard for me.
Sefer |
|
|
| |
Topic |
|
Report Portal
OWC doesnt work in SQL Server 2005 (RP 2.1 B100)
