Re: create linked server for an SQL instance failed

From: John Bell (jrm_bell@hotmail.com)
Date: 09/22/02 

From: John Bell <jrm_bell@hotmail.com>
Date: Sun, 22 Sep 2002 20:11:22 +0100

Have you cbecked service packs?

John
On Fri, 20 Sep 2002 14:01:25 -0700, "JW" <juanaonline@yahoo.ca> wrote:

>Thanks, Linda.
>Actually, I used the same statement in another
>server, it works perfect. I guess there is some
>server settings should be changed. But I don't
>know which one. Could you think of anything?
>
>JW
>>-----Original Message-----
>>Hi JW,
>>
>>I have performed a test on this issue with the statements
>you have pasted
>>in your previous post, but this problem cannot be
>reproduced on my machine
>>and I can create a new linked server between my SQL
>Server to a SQL named
>>instance on another machine.
>>
>>Please try the following steps.
>>1. Make sure the instance name you have specified is
>correct.
>>2. Create a server alias for this named instance and then
>use this alias to
>>create a linked server.
>>
>>Sincerely,
>>
>>Linda Deng
>>Microsoft Support Engineer
>>
>>This posting is provided "AS IS" with no warranties, and
>confers no rights.
>>
>>.
>>

Relevant Pages

  • Re: Linked server name
    ... You can create a server alias, with any name you like, and specify the IP ... Then create a linked server specifying ... I've created a linked server in SQL 2005 Studio to another SQL 2005 ...
    (microsoft.public.sqlserver.connect)
  • Re: server question
    ... Linda wrote: ... Subject: server question ... web server requests to annas-web-server and the emails to anything to ...
    (Ubuntu)
  • RE: SMTP issue.
    ... Yes Linda, I did that. ... when I build new server there. ... Do we have to do something like that on SMTP mail sever to accept the post ... from biztalk machine? ...
    (microsoft.public.biztalk.general)
  • Re: Equus hardware
    ... Linda wrote: ... > I did not get a response in the hardware group to this question. ... > as a server? ...
    (microsoft.public.windows.server.general)
  • Re: backup clients data from server,
    ... Hi Linda, you should do as Lanwench suggested below, however, if you ... locally on the client and push the backup file to the server. ...
    (microsoft.public.windows.server.sbs)