Problema con link server MSOLAP

Last post 05-05-2009 14.49 by dmauri. 3 replies.

Page 1 of 1 (4 items)
	Sort Posts: Previous Next

04-03-2009 11.38

Massimo56
Joined on 04-03-2009
Posts 11
Points 190

Problema con link server MSOLAP

Reply Contact

Ciao, ho questa query:

Select 'admin','aidswi2zs4jfasb0hslkkj45',2,'Aereoporto','04/03/2009', *

from OpenRowSet('MSOLAP','DATASOURCE=CUBECURV-650196\SQL2005;

Initial Catalog=TIDManagerCUBE;'

,'SELECT [Measures].[Importo Totale Speso - FLIGHT] on 0,

topcount([Aereoporto].[nome].ALLMEMBERS,4,[Measures].[Importo Totale Speso - FLIGHT]) on 1

FROM [FLIGHT] WHERE ({[Tempo].[Data].&[2009-02-01T00:00:00]:[Tempo].[Data].&[2009-02-28T00:00:00]})'

)

ma se la eseguo mi genera il seguente errore:

OLE DB provider "MSOLAP" for linked server "(null)" returned message "Errors in the OLE DB provider. The Extended Properties property is set to a value that is not supported.".

Msg 7373, Level 16, State 2, Line 1

Cannot set the initialization properties for OLE DB provider "MSOLAP" for linked server "(null)".

mi sapete aiutare, grazie mille

ciao

Filed under: Analysys Services

Post Points: 20

04-03-2009 15.24 In reply to

fdechirico
Joined on 05-15-2007
Milano
Posts 84
Points 975

Re: Problema con link server MSOLAP

Reply Contact

Ciao,

prova banalmente ad eliminare il "ritorno a capo" prima di "Initial Catalog".

Per capirci la tua stringa diventa:

Select 'admin','aidswi2zs4jfasb0hslkkj45',2,'Aereoporto','04/03/2009', *

from OpenRowSet('MSOLAP','DATASOURCE=CUBECURV-650196\SQL2005;Initial Catalog=TIDManagerCUBE;'

,'SELECT [Measures].[Importo Totale Speso - FLIGHT] on 0,

topcount([Aereoporto].[nome].ALLMEMBERS,4,[Measures].[Importo Totale Speso - FLIGHT]) on 1

FROM [FLIGHT] WHERE ({[Tempo].[Data].&[2009-02-01T00:00:00]:[Tempo].[Data].&[2009-02-28T00:00:00]})'

)

Fammi sapere!

Francesco

Francesco De Chirico
SQL Server MCP, MCTS, MCITP, MCT
http://community.ugiss.org/blogs/fdechirico/
BI Architect @ Solid Quality Learning Italy - http://www.solidq.com

Post Points: 20

04-03-2009 16.55 In reply to

Massimo56
Joined on 04-03-2009
Posts 11
Points 190

Re: Problema con link server MSOLAP

Reply Contact

Cia Francesco, grazie per l'interesse

ho modificato come mi hai detto ma l'errore permate, anche se si è trasformato in

OLE DB provider "MSOLAP" for linked server "(null)" returned message "L'utente CUBECURV-650196\user non ha accesso al database TIDManagerCUBE oppure il database non esiste.".

Msg 7303, Level 16, State 1, Line 1

Cannot initialize the data source object of OLE DB provider "MSOLAP" for linked server "(null)".

L'utente user è amministratore in tutto e per tutto, tanto più che user si connette al cubo senza alcun problema.

Tutto ciò avviene solo tramite l'uso del link MSOLAP.

Grazie in anticipo per suggerimenti.

sql2005 sp3

mdac versione 2000.085.1132

ciao

Filed under: Analysys Services

Post Points: 20

05-05-2009 14.49 In reply to

dmauri
Joined on 05-14-2007
Novate Milanese
Posts 1.907
Points 24.955

Re: Problema con link server MSOLAP

Reply Contact

Ciao massimo56

hai già verificato che non sia un problema di delega?

Il BOL, infatti, riportano quanto segue

"When accessing remote OLE DB data sources, the login identity of trusted connections is not automatically delegated from the server on which the client is connected to the server that is being queried. Authentication delegation must be configured. For more information, see Configuring Linked Servers for Delegation."

Controlla quindi questa pagina:

http://msdn.microsoft.com/en-us/library/ms189580.aspx

Davide Mauri
Microsoft MVP - SQL Server, MCP, MCAD, MCDBA, MCT - http://www.davidemauri.it
Socio Fondatore e Mentor di Solid Quality Learning Italy - http://www.solidq.com
Presidente di UGISS: User Group Italiano Sql Server - http://www.ugiss.org

Post Points: 5

Page 1 of 1 (4 items)

UGISS Community