Issues with using msolap.x provider name in linked server definition
During a recent investigation I realised that a number of people are using MSOLAP.x as the provider name for a linked server e.g. MSOLAP.4 when creating a linked server... e.g.
EXEC master.dbo.sp_addlinkedserver @server = N'lsname', @srvproduct=N'msolap', @provider=N'MSOLAP.4', @datasrc=N'serverainst', @catalog=N'SSASDBName' /* For security reasons the linked server remote logins password is changed with ######## */ EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'lsname',@useself=N'False',@locallogin=NULL,@rmtuser=N'domuser',@rmtpassword='########' etcRead more...
Tags: management