connection failure during OLAP model generation in RS

#1

I created an OLAP data source and used windows integrated security option,
when I tried to generate model, I got the following error:

Cannot create a connection to data source ''. (rsErrorOpeningConnection) Get
Online Help The connection either timed out or was lost.
Unable to read data from the transport connection: An existing connection
was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host

Any idea what went wrong. So far the only work around I find is to use:
crentials stored secured in report server, which is not an very elegant
solution.

Thanks,

#2

yongli wrote:

Quote:

I created an OLAP data source and used windows integrated security option,
when I tried to generate model, I got the following error:

Cannot create a connection to data source ''. (rsErrorOpeningConnection) Get
Online Help The connection either timed out or was lost.
Unable to read data from the transport connection: An existing connection
was forcibly closed by the remote host.
An existing connection was forcibly closed by the remote host

Any idea what went wrong. So far the only work around I find is to use:
crentials stored secured in report server, which is not an very elegant
solution.

Thanks,

I have a similar problem also. So how did you solve it?

Thanks,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

connection failure during OLAP model generation in RS

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

connection failure during OLAP model generation in RS - 06-08-2006 , 01:26 PM

Re: connection failure during OLAP model generation in RS - 07-07-2006 , 02:01 PM