TITLE: Microsoft SQL Server Management Studio
------------------------------

The linked server has been created but failed a connection test. Do you want
to keep the linked server?

------------------------------
...

------------------------------

Cannot initialize the data source object of OLE DB provider "MSOLAP" for
linked server "PRODSSAS08R2".
OLE DB provider "MSOLAP" for linked server "PRODSSAS08R2" returned
message "XML for Analysis parser: The MSOLAP property was not recognized.".
OLE DB provider "MSOLAP" for linked server "PRODSSAS08R2" returned
message "Errors in the OLE DB provider. An error occurred while named
instance information was being retrieved from the SQLBrowser service on the
'PROD' server.". (Microsoft SQL Server, Error: 7303)

EXEC master.dbo.sp_addlinkedserver @server = N'PRODSSAS08R2'
, @srvproduct=N'MSOLAP'
, @provider=N'MSOLAP'
, @datasrc=N'PRODSSAS08R2'
, @provstr=N'MSOLAP'
, @catalog=N'Prd_Analysis_Services'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'PRODSSAS08R2'
, @locallogin = NULL
, @useself = N'False'
, @rmtuser = N'WINADSrvcAcct'
, @rmtpassword = N'XXXXXX'