Re: Strange requirement for linked server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Is it possible the server has lost its name

What is the outcome of SELECT @@SEVRVERNAME?

If it is NULL then use sp_addserver 'server name',local

If not and also not the name of your box then use sp_dropserver first.


Allan


"Christopher Pankhurst" <christopher_pankhurst@xxxxxxxxxxx> wrote in message news:#oD$QB9vFHA.256@xxxxxxxxxxxxxxxxxxxx:

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 ... > PLNZ needing to be in sysservers and please exec sp_addlinkedserver. ...
    (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)
  • Re: security error in IIS logs (401.2 error)
    ... I initially thought it was being blocked by a proxy on our network. ... "Integrated Windows authentication is disabled by default if you ... Server 2003 w/ SP-1. ... I have attached my IIS log below. ...
    (microsoft.public.inetserver.iis.security)