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’servera\inst’, @catalog=N’SSASDBName’ /* For security reasons the linked server remote logins password is changed with ######## */ EXEC…

0