Re: linking server

Hi
http://dimantdatabasesolutions.blogspot.com/2007/06/is-linked-server-available.html



"Gautam" <Gautam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:81BF7A0F-F89F-4DFA-9802-CCF9F22B36C3@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • 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)