dbTalk Databases Forums  

can't use SQL server 2005 in AS 2000

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


Discuss can't use SQL server 2005 in AS 2000 in the microsoft.public.sqlserver.olap forum.



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

Default can't use SQL server 2005 in AS 2000 - 07-17-2006 , 01:46 AM






hello

have anybody used such configuration?

we made data source in AS 2000 - working
even can browse data in tables

but during cube process, geting this error:

"data source error: ; Time:...."

anybody have any ideas?

installation of SQL server native client didn't help, may be should install
anything else from SQL 2005?

Reply With Quote
  #2  
Old   
Jesse O.
 
Posts: n/a

Default Re: can't use SQL server 2005 in AS 2000 - 07-18-2006 , 06:20 PM






we're running fine with AS2000 going against SQL Server 2005.

using MS OLE DB Provider for SQL Server as the provider


"zmike000" <zmike000 (AT) discussions (DOT) microsoft.com> wrote

Quote:
hello

have anybody used such configuration?

we made data source in AS 2000 - working
even can browse data in tables

but during cube process, geting this error:

"data source error: ; Time:...."

anybody have any ideas?

installation of SQL server native client didn't help, may be should
install
anything else from SQL 2005?



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

Default Re: can't use SQL server 2005 in AS 2000 - 07-21-2006 , 02:23 AM



Thanks,J esse

after this knowledge i made some more tests... installed AS2000 on Win2003
and ... got the description of the error: login failed ...

looks like process of processing cube starting ander another user than AS
itself, so
Windows authorization for AS2005 does not work...

with stored login and password everything start working.



Quote:
we're running fine with AS2000 going against SQL Server 2005.

using MS OLE DB Provider for SQL Server as the provider


"zmike000" <zmike000 (AT) discussions (DOT) microsoft.com> wrote in message
news:2142542E-A51E-49AA-9121-B0B591289C26 (AT) microsoft (DOT) com...
hello

have anybody used such configuration?

we made data source in AS 2000 - working
even can browse data in tables

but during cube process, geting this error:

"data source error: ; Time:...."

anybody have any ideas?

installation of SQL server native client didn't help, may be should
install
anything else from SQL 2005?




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.