Re: Strange requirement for linked server
From: Steen Persson (DK) (spe_at_REMOVEdatea.dk)
Date: 09/23/05
- Next message: Stephen Russell: "Is there a log of activity as compared to the Tran log?"
- Previous message: Christopher Pankhurst: "Strange requirement for linked server"
- In reply to: Christopher Pankhurst: "Strange requirement for linked server"
- Next in thread: Christopher Pankhurst: "Re: Strange requirement for linked server"
- Reply: Christopher Pankhurst: "Re: Strange requirement for linked server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 23 Sep 2005 14:57:39 +0200
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: Stephen Russell: "Is there a log of activity as compared to the Tran log?"
- Previous message: Christopher Pankhurst: "Strange requirement for linked server"
- In reply to: Christopher Pankhurst: "Strange requirement for linked server"
- Next in thread: Christopher Pankhurst: "Re: Strange requirement for linked server"
- Reply: Christopher Pankhurst: "Re: Strange requirement for linked server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
