SQL Linked Server

Results 1 to 2 of 2

Thread: SQL Linked Server

  1. #1
    Join Date
    Dec 1969

    Default SQL Linked Server

    I&#039;m having difficulty connecting to a linked server. I created a linked server in SQL, and under administrator I can view it fine, but under a normal login I get the following error.<BR><BR>[OLE/DB provider returned message: Client unable to establish connection]<BR>[DBNMPNTW]ConnectionOpen (CreateFile()).<BR><BR><BR>I know it&#039;s a permissions problem, but I&#039;m unsure which permissions need to be changed. Any help would be appreciated.<BR><BR>Thank You

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default I would GUESS

    that the login that you are trying does not have the permission to connect to that linked server<BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts