Report Portal

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='########' etc

Read more...

Tags: management

 

2007-2015 VidasSoft Systems Inc.