Hi,
I am using sqlserver2005. During the making linked server between two
server. I am using the connection option is "Be made using this security
connection "
I got an error : OLE DB provider "SQLNCLI" for linked server returned
message "Unable to complete login process due to delay in opening server
connection".in sqlserver2005.
so, please elaborate this error ?
and
Give me a proper solution
.
Re: linking server ... During the making linked server between two ... I am using the connection option is "Be made using this security... OLE DB provider "SQLNCLI" for linked server returned... (microsoft.public.sqlserver.security)
Update ... Seems to have something to do with security....Windows NT user activated by SETUSER. ... I gather that the SQL Agent Job...>linked server, and these work via Query Analyzer. ... (microsoft.public.sqlserver.security)
Update ... queries against a linked server (DB2 UDB)....Servers security properties,... ID and password for the linked server.... to be that the job owner is a SQL Server login that is not ... (microsoft.public.sqlserver.security)
Re: jobs for a linked server in a different domain? ... Some time last week I had tried to adjust the security settings for the ...linked server but that presumes that there is a username and password on the ... > Mark Allison, SQL Server MVP... (microsoft.public.sqlserver.server)
RE: Linked server 7302 error ... Under the linked server security tab, nothing is entered except the last ... I still have a problem with my linked server and I still need some support.... > This issue looks strange because the error message... (microsoft.public.sqlserver.connect)
