분석서버 연결된 서버 생성 후 에러 메세지
연결된 서버 ""의 OLE DB 공급자 "MSOLAP" 이(가) 메시지 "피어에서 연결을 중간에 닫았습니다" 을(를) 반환했습니다. (Microsoft SQL Server, Error: 7303)
메세지 창
영문메세지
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Connectionlnfo)
Cannot initialize the data source object of OLE DB provider MSOLAP’ For linked server " ",
OLE DB provider “MSOLAP” For linked server “ ” returned message “An error was encountered in the transport layer.”.
OLE DB provider “MSOLAP” for linked server “ ’ returned message “The peer prematurely closed the connection.”. (Microsoft SQL Server, Error: 7303)
EXEC MASTER.DBO.SP_ADDLINKEDSERVER
@server = N'LinkedServerName',
@srvproduct=N'MSOLAP',
@provider=N'MSOLAP',
@datasrc=N'domainName',
@catalog=N'catalogName'
EXEC MASTER.DBO.SP_ADDLINKEDSRVLOGIN
@rmtsrvname=N'LinkedServerName',
@useself=N'False',
@locallogin=NULL,
@rmtuser=N'domainName\administrator',
@rmtpassword='password'
@server = N'LinkedServerName',
@srvproduct=N'MSOLAP',
@provider=N'MSOLAP',
@datasrc=N'domainName',
@catalog=N'catalogName'
EXEC MASTER.DBO.SP_ADDLINKEDSRVLOGIN
@rmtsrvname=N'LinkedServerName',
@useself=N'False',
@locallogin=NULL,
@rmtuser=N'domainName\administrator',
@rmtpassword='password'
댓글 없음:
댓글 쓰기