dbTalk Databases Forums  

A connection cannot be made. Ensure that the server is running.

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


Discuss A connection cannot be made. Ensure that the server is running. in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default A connection cannot be made. Ensure that the server is running. - 07-10-2006 , 04:06 PM






I am using VISUAL STUDIO 2005 and I have followed all steps on the
readme file. I dropped a CellSetGrid control on a web page and used
this connstring = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=R-FEORVWUG7AJFA;Initial
Catalog=CMV_BI;Client Cache Size=25;Auto Synch Period=10000", pointing
to a cube in the catalog. What´s wrong?


Reply With Quote
  #2  
Old   
Jeje
 
Posts: n/a

Default Re: A connection cannot be made. Ensure that the server is running. - 07-10-2006 , 05:36 PM






do you use 2 servers and the NTLM authentication?
if yes, search to setup the kerberos delegation (search "iis kerberos" on
the MS web site)

<Betydossantos (AT) yahoo (DOT) com.br> wrote

I am using VISUAL STUDIO 2005 and I have followed all steps on the
readme file. I dropped a CellSetGrid control on a web page and used
this connstring = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=R-FEORVWUG7AJFA;Initial
Catalog=CMV_BI;Client Cache Size=25;Auto Synch Period=10000", pointing
to a cube in the catalog. What´s wrong?



Reply With Quote
  #3  
Old   
AT
 
Posts: n/a

Default Re: A connection cannot be made. Ensure that the server is running. - 07-11-2006 , 06:04 AM




Jeje wrote:
Quote:
do you use 2 servers and the NTLM authentication?
if yes, search to setup the kerberos delegation (search "iis kerberos" on
the MS web site)

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152565582.238143.170130 (AT) m73g2000cwd (DOT) googlegroups.com...
I am using VISUAL STUDIO 2005 and I have followed all steps on the
readme file. I dropped a CellSetGrid control on a web page and used
this connstring = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=R-FEORVWUG7AJFA;Initial
Catalog=CMV_BI;Client Cache Size=25;Auto Synch Period=10000", pointing
to a cube in the catalog. What´s wrong?
I´m running it in the Visual Studio Server. I´ve found it two days
ago on the web and liked it too much. I´m trying to understanding how
it works for using it later.



Reply With Quote
  #4  
Old   
Jéjé
 
Posts: n/a

Default Re: A connection cannot be made. Ensure that the server is running. - 07-11-2006 , 07:24 AM



Cellsetgrid use the ADOMD.Net API to access the cubes.
if you can't connect it to your cube server is more a security and/or
authentication issue.

can you explain your environement?
have you 2 separated servers? (1web, 1olap)
do you use AS2000 or AS2005?
do you use NTLM or basic authentication?
have you activated the impersonation in the web.config file of your web
application?

<Betydossantos (AT) yahoo (DOT) com.br> wrote


Jeje wrote:
Quote:
do you use 2 servers and the NTLM authentication?
if yes, search to setup the kerberos delegation (search "iis kerberos" on
the MS web site)

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152565582.238143.170130 (AT) m73g2000cwd (DOT) googlegroups.com...
I am using VISUAL STUDIO 2005 and I have followed all steps on the
readme file. I dropped a CellSetGrid control on a web page and used
this connstring = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=R-FEORVWUG7AJFA;Initial
Catalog=CMV_BI;Client Cache Size=25;Auto Synch Period=10000", pointing
to a cube in the catalog. What´s wrong?
I´m running it in the Visual Studio Server. I´ve found it two days
ago on the web and liked it too much. I´m trying to understanding how
it works for using it later.




Reply With Quote
  #5  
Old   
AT
 
Posts: n/a

Default Re: A connection cannot be made. Ensure that the server is running. - 07-11-2006 , 02:09 PM



Yes - I have 2 servers. I use AS2000 and basic authentication. Yes, for
the last question.
<identity impersonate="true"/>
Is there any problem if I am using .net framework 2.0?


Jéjé wrote:
Quote:
Cellsetgrid use the ADOMD.Net API to access the cubes.
if you can't connect it to your cube server is more a security and/or
authentication issue.

can you explain your environement?
have you 2 separated servers? (1web, 1olap)
do you use AS2000 or AS2005?
do you use NTLM or basic authentication?
have you activated the impersonation in the web.config file of your web
application?

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152615875.045059.193050 (AT) 35g2000cwc (DOT) googlegroups.com...

Jeje wrote:
do you use 2 servers and the NTLM authentication?
if yes, search to setup the kerberos delegation (search "iis kerberos" on
the MS web site)

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152565582.238143.170130 (AT) m73g2000cwd (DOT) googlegroups.com...
I am using VISUAL STUDIO 2005 and I have followed all steps on the
readme file. I dropped a CellSetGrid control on a web page and used
this connstring = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=R-FEORVWUG7AJFA;Initial
Catalog=CMV_BI;Client Cache Size=25;Auto Synch Period=10000", pointing
to a cube in the catalog. What´s wrong?

I´m running it in the Visual Studio Server. I´ve found it two days
ago on the web and liked it too much. I´m trying to understanding how
it works for using it later.


Reply With Quote
  #6  
Old   
Jéjé
 
Posts: n/a

Default Re: A connection cannot be made. Ensure that the server is running. - 07-11-2006 , 02:34 PM



try to add this option in the connection string:
connectto=8.0

this option force the API to access the server using a direct connection, if
not specified, the system try to access the server using the HTTP
connection.


<Betydossantos (AT) yahoo (DOT) com.br> wrote

Yes - I have 2 servers. I use AS2000 and basic authentication. Yes, for
the last question.
<identity impersonate="true"/>
Is there any problem if I am using .net framework 2.0?


Jéjé wrote:
Quote:
Cellsetgrid use the ADOMD.Net API to access the cubes.
if you can't connect it to your cube server is more a security and/or
authentication issue.

can you explain your environement?
have you 2 separated servers? (1web, 1olap)
do you use AS2000 or AS2005?
do you use NTLM or basic authentication?
have you activated the impersonation in the web.config file of your web
application?

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152615875.045059.193050 (AT) 35g2000cwc (DOT) googlegroups.com...

Jeje wrote:
do you use 2 servers and the NTLM authentication?
if yes, search to setup the kerberos delegation (search "iis kerberos"
on
the MS web site)

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152565582.238143.170130 (AT) m73g2000cwd (DOT) googlegroups.com...
I am using VISUAL STUDIO 2005 and I have followed all steps on the
readme file. I dropped a CellSetGrid control on a web page and used
this connstring = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=R-FEORVWUG7AJFA;Initial
Catalog=CMV_BI;Client Cache Size=25;Auto Synch Period=10000", pointing
to a cube in the catalog. What´s wrong?

I´m running it in the Visual Studio Server. I´ve found it two days
ago on the web and liked it too much. I´m trying to understanding how
it works for using it later.



Reply With Quote
  #7  
Old   
AT
 
Posts: n/a

Default Re: A connection cannot be made. Ensure that the server is running. - 07-11-2006 , 03:42 PM



Well! It works! One more question, the connection is ok, but it was
unable to open my cube. Why? My cube is too large? Is there any limit
to open a cube?

Jéjé wrote:
Quote:
try to add this option in the connection string:
connectto=8.0

this option force the API to access the server using a direct connection,if
not specified, the system try to access the server using the HTTP
connection.


Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152644943.711576.314460 (AT) 35g2000cwc (DOT) googlegroups.com...
Yes - I have 2 servers. I use AS2000 and basic authentication. Yes, for
the last question.
identity impersonate="true"/
Is there any problem if I am using .net framework 2.0?


Jéjé wrote:
Cellsetgrid use the ADOMD.Net API to access the cubes.
if you can't connect it to your cube server is more a security and/or
authentication issue.

can you explain your environement?
have you 2 separated servers? (1web, 1olap)
do you use AS2000 or AS2005?
do you use NTLM or basic authentication?
have you activated the impersonation in the web.config file of your web
application?

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152615875.045059.193050 (AT) 35g2000cwc (DOT) googlegroups.com...

Jeje wrote:
do you use 2 servers and the NTLM authentication?
if yes, search to setup the kerberos delegation (search "iis kerberos"
on
the MS web site)

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152565582.238143.170130 (AT) m73g2000cwd (DOT) googlegroups.com...
I am using VISUAL STUDIO 2005 and I have followed all steps on the
readme file. I dropped a CellSetGrid control on a web page and used
this connstring = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=R-FEORVWUG7AJFA;Initial
Catalog=CMV_BI;Client Cache Size=25;Auto Synch Period=10000", pointing
to a cube in the catalog. What´s wrong?

I´m running it in the Visual Studio Server. I´ve found it two days
ago on the web and liked it too much. I´m trying to understanding how
it works for using it later.


Reply With Quote
  #8  
Old   
AT
 
Posts: n/a

Default Re: A connection cannot be made. Ensure that the server is running. - 07-11-2006 , 03:43 PM



One more thing - thank you very, very much!

Betydossantos (AT) yahoo (DOT) com.br wrote:
Quote:
I am using VISUAL STUDIO 2005 and I have followed all steps on the
readme file. I dropped a CellSetGrid control on a web page and used
this connstring = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=R-FEORVWUG7AJFA;Initial
Catalog=CMV_BI;Client Cache Size=25;Auto Synch Period=10000", pointing
to a cube in the catalog. What´s wrong?


Reply With Quote
  #9  
Old   
Jeje
 
Posts: n/a

Default Re: A connection cannot be made. Ensure that the server is running. - 07-11-2006 , 05:16 PM



mmm...
its difficult to say something.

I know that cellsetgrid has problems with IE7

can you, at least, display the metadata? (dimension list and level list)

<Betydossantos (AT) yahoo (DOT) com.br> wrote

Well! It works! One more question, the connection is ok, but it was
unable to open my cube. Why? My cube is too large? Is there any limit
to open a cube?

Jéjé wrote:
Quote:
try to add this option in the connection string:
connectto=8.0

this option force the API to access the server using a direct connection,
if
not specified, the system try to access the server using the HTTP
connection.


Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152644943.711576.314460 (AT) 35g2000cwc (DOT) googlegroups.com...
Yes - I have 2 servers. I use AS2000 and basic authentication. Yes, for
the last question.
identity impersonate="true"/
Is there any problem if I am using .net framework 2.0?


Jéjé wrote:
Cellsetgrid use the ADOMD.Net API to access the cubes.
if you can't connect it to your cube server is more a security and/or
authentication issue.

can you explain your environement?
have you 2 separated servers? (1web, 1olap)
do you use AS2000 or AS2005?
do you use NTLM or basic authentication?
have you activated the impersonation in the web.config file of your web
application?

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152615875.045059.193050 (AT) 35g2000cwc (DOT) googlegroups.com...

Jeje wrote:
do you use 2 servers and the NTLM authentication?
if yes, search to setup the kerberos delegation (search "iis kerberos"
on
the MS web site)

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152565582.238143.170130 (AT) m73g2000cwd (DOT) googlegroups.com...
I am using VISUAL STUDIO 2005 and I have followed all steps on the
readme file. I dropped a CellSetGrid control on a web page and used
this connstring = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=R-FEORVWUG7AJFA;Initial
Catalog=CMV_BI;Client Cache Size=25;Auto Synch Period=10000", pointing
to a cube in the catalog. What´s wrong?

I´m running it in the Visual Studio Server. I´ve found it two days
ago on the web and liked it too much. I´m trying to understanding how
it works for using it later.



Reply With Quote
  #10  
Old   
AT
 
Posts: n/a

Default Re: A connection cannot be made. Ensure that the server is running. - 07-11-2006 , 06:04 PM



No, nothing happens.

Jeje wrote:
Quote:
mmm...
its difficult to say something.

I know that cellsetgrid has problems with IE7

can you, at least, display the metadata? (dimension list and level list)

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152650532.931200.114250 (AT) h48g2000cwc (DOT) googlegroups.com...
Well! It works! One more question, the connection is ok, but it was
unable to open my cube. Why? My cube is too large? Is there any limit
to open a cube?

Jéjé wrote:
try to add this option in the connection string:
connectto=8.0

this option force the API to access the server using a direct connection,
if
not specified, the system try to access the server using the HTTP
connection.


Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152644943.711576.314460 (AT) 35g2000cwc (DOT) googlegroups.com...
Yes - I have 2 servers. I use AS2000 and basic authentication. Yes, for
the last question.
identity impersonate="true"/
Is there any problem if I am using .net framework 2.0?


Jéjé wrote:
Cellsetgrid use the ADOMD.Net API to access the cubes.
if you can't connect it to your cube server is more a security and/or
authentication issue.

can you explain your environement?
have you 2 separated servers? (1web, 1olap)
do you use AS2000 or AS2005?
do you use NTLM or basic authentication?
have you activated the impersonation in the web.config file of your web
application?

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152615875.045059.193050 (AT) 35g2000cwc (DOT) googlegroups.com...

Jeje wrote:
do you use 2 servers and the NTLM authentication?
if yes, search to setup the kerberos delegation (search "iis kerberos"
on
the MS web site)

Betydossantos (AT) yahoo (DOT) com.br> wrote in message
news:1152565582.238143.170130 (AT) m73g2000cwd (DOT) googlegroups.com...
I am using VISUAL STUDIO 2005 and I have followed all steps on the
readme file. I dropped a CellSetGrid control on a web page and used
this connstring = "Provider=MSOLAP.2;Integrated Security=SSPI;Persist
Security Info=False;Data Source=R-FEORVWUG7AJFA;Initial
Catalog=CMV_BI;Client Cache Size=25;Auto Synch Period=10000",pointing
to a cube in the catalog. What´s wrong?

I´m running it in the Visual Studio Server. I´ve found it two days
ago on the web and liked it too much. I´m trying to understanding how
it works for using it later.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.