MS SQL Server 2008 x64 SP2 (Database Engine, Analysis Services)
Создаю linked server с сервера, где установлен Database Engine, на сервер с Analysis Services в пределах одного домена.
Вот скрипт из окна создания Linked Server:
EXEC master.dbo.sp_addlinkedserver @server = N'TEST', @srvproduct=N'MSOLAP', @provider=N'MSOLAP', @datasrc=N'MyCubeServerName', @catalog=N'MyCubeDatabaseName'
GO
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'use remote collation', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'TEST', @optname=N'remote proc transaction promotion', @optvalue=N'true'
GO
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'TEST', @locallogin = NULL , @useself = N'False', @rmtuser = N'X\Mylogin', @rmtpassword = N'mypassword'
GO
Получаю сообщение:
The linked server has been created but failed a connection test. Do you want to keep the linked server?
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot set the initialization properties for OLE DB provider "MSOLAP" for linked server "TEST".
OLE DB provider "MSOLAP" for linked server "TEST" returned message "The following system error occurred: .". (Microsoft SQL Server, Error: 7373)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.4000&EvtSrc=MSSQLServer&EvtID=7373&LinkId=20476
------------------------------
Подключение к локальному сервису Analysis Services работает отлично.
Пробовал, но не помогло:
1) Подключиться к Analysis Service 2008 x32.
2) Отключить Firewall на обоих серверах.
Что и как надо настроить для подключения?
