Re: Strange requirement for linked server

From: Steen Persson (DK) (spe_at_REMOVEdatea.dk)
Date: 09/26/05 

Date: Mon, 26 Sep 2005 12:54:34 +0200

Christopher Pankhurst wrote:
> 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
>
>
I'm not an expert in using DTS for data export, but are you sure you
specify the right server for both the Source and Destination? Maybe you
could try to do the export from/to a test database just to make sure
that you enter the right info in the Wizard. You could maybe start with
2 database on the same server and make sure that works.
 From where do you start the wizard - from your desktop or from one of
the servers? If you are doing it from your dekstop, then you could maybe
try to connect to the server with Remote Desktop and then run the Wizard
from there. It might not make any difference, but I know that in some
cases you can't use a linked server unless you are connected directly to
the server.

Regards
Steen

Relevant Pages

  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... Personally I feel using the copy DB wizard is more effort than just a backup ... Passwords Between SQL Servers ... Issues When a Database Is Moved Between SQL Servers ... for SQL Server ...
    (microsoft.public.sqlserver.setup)
  • RE: File Import Wizard
    ... Microsoft Online Support ... we provide a wizard like UI to collect ... | and file will be posted to the server for processing. ... | it and build SQL data execution command to insert data into database. ...
    (microsoft.public.dotnet.general)
  • Re: ASP and Access Database queries
    ... than give me some ideas why the FP Wizard is not fing my database? ... http://www.bellfield-barna.com/ is running on an Apache server running ... My Access database is situated in my office. ... I have an Access database where I would like to ...
    (microsoft.public.frontpage.programming)
  • "Database Results Wizard Error".. HELP!
    ... This past Monday - the employee designated to update our databases - which are located on an RackSpace W2003 based IIS server brought in the first message that had the subject of this message instead of the expected database results. ... I have spent all week trying to figure out why this happened - all the Wizard generated browses are hosed. ...
    (microsoft.public.frontpage.extensions.windowsnt)
  • RE: Reconfiguring a Small Business Server using the Wizards.
    ... <Subject: RE: Reconfiguring a Small Business Server using the Wizards. ... <For the computers, we can move the computer accounts to SBSComputers OU. ... <For the backup, you can run the SBS Backup wizard to configure the it. ...
    (microsoft.public.windows.server.sbs)