Strange requirement for linked server

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

Date: Fri, 23 Sep 2005 11:51:40 +1200

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

Relevant Pages

  • Re: Strange requirement for linked server
    ... To generate the DTS script I am just right clicking the database, ... >> tables and views and SQL server gives an error message about a server ... >> domain name, as the computer was once connected to a domain called PLNZ, ...
    (microsoft.public.sqlserver.security)
  • 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
    ... > 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)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)