Re: Strange requirement for linked server

From: Christopher Pankhurst (christopher_pankhurst_at_hotmail.com)
Date: 09/25/05

  • Next message: Praveen: "SQL Server is Not started after restarting" 
    Date: Mon, 26 Sep 2005 08:30:19 +1200

    To generate the DTS script I am just right clicking the database, clicking
    export and using the wizard. I would hope the wizard wouldn't make a typo.

    I've checked everything visible in Enterprise Manager.

    Chris Pankhurst

    "Steen Persson (DK)" <spe@REMOVEdatea.dk> wrote in message
    news:%23RmTi5DwFHA.3688@tk2msftngp13.phx.gbl...
    > Christopher Pankhurst wrote:
    > > We need to create a DTS script to push data from one sql server to
    another
    > > on a scheduled basis, changing some column names in the process (we do
    not
    > > want to do replication). I start creating the DTS script and click on
    copy
    > > tables and views and SQL server gives an error message about a server
    called
    > > PLNZ needing to be in sysservers and please exec sp_addlinkedserver.
    > >
    > > I don't understand why it is looking for a server called PLNZ. It could
    be a
    > > domain name, as the computer was once connected to a domain called PLNZ,
    > > however that was a long time ago. Now it is connected to a different
    domain.
    > > There is an sql authentication user called plnz however it does not map
    to
    > > any sort of windows authentication.
    > >
    > > There has never been a server called PLNZ and there are no users with
    > > windows authentication and a domain of PLNZ. I have narrowed the problem
    > > down to that server/database combination. It works fine even if I try a
    > > different database on the same server, however pushing from a different
    > > database would be pointless.
    > >
    > > I tried adding the server, but that just meant a slightly different
    error
    > > message (about data source doesn't support the schema needed for DTS)
    came
    > > later.
    > >
    > > I would like to know why it is looking for PLNZ and how I can stop it
    from
    > > doing so.
    > >
    > > Sorry the error messages are a bit vague, I am posting this from my
    memory,
    > > I am not near the server at the moment.
    > >
    > > Chris Pankhurst
    > >
    > >
    >
    > Somewhere in the task you are trying to create, you are referring so a
    > server named PLNZ. Without any more details, it's hard to say where it
    > is, but try to go through all the steps involved and check all places
    > where PLNZ is mentioned. It could be that you're just missing a . or
    > something else somewhere, so SQL Server interprets PLNZ as a server name
    > even though you mean something else.
    >
    > Regards
    > Steen

  • Next message: Praveen: "SQL Server is Not started after restarting"

    Relevant Pages

    • Re: Strange requirement for linked server
      ... I start creating the DTS script and click on copy tables and views and SQL server gives an error message about a server called ... I don't understand why it is looking for a server called PLNZ. ... windows authentication and a domain of PLNZ. ...
      (microsoft.public.sqlserver.dts)
    • Re: Strange requirement for linked server
      ... I start creating the DTS script and click on copy ... > tables and views and SQL server gives an error message about a server called ... > PLNZ needing to be in sysservers and please exec sp_addlinkedserver. ...
      (microsoft.public.sqlserver.security)
    • Re: Strange requirement for linked server
      ... > To generate the DTS script I am just right clicking the database, ... I would hope the wizard wouldn't make a typo. ... >> server named PLNZ. ...
      (microsoft.public.sqlserver.security)
    • Strange requirement for linked server
      ... We need to create a DTS script to push data from one sql server to another ... PLNZ needing to be in sysservers and please exec sp_addlinkedserver. ...
      (microsoft.public.sqlserver.security)
    • Re: Strange requirement for linked server
      ... > If it is NULL then use sp_addserver 'server name',local ... >> PLNZ needing to be in sysservers and please exec sp_addlinkedserver. ... >> windows authentication and a domain of PLNZ. ... >> Chris Pankhurst ...
      (microsoft.public.sqlserver.dts)