Re: Strange requirement for linked server
- From: "Christopher Pankhurst" <christopher_pankhurst@xxxxxxxxxxx>
- Date: Wed, 28 Sep 2005 10:49:43 +1200
SELECT @@SERVERNAME returns FCN1, which seems to be correct. It is the same
as the windows name of the computer.
Chris Pankhurst
"Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx> wrote in message
news:e6OtHQ9vFHA.1148@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>
.
- References:
- Re: Strange requirement for linked server
- From: Allan Mitchell
- Re: Strange requirement for linked server
- Prev by Date: DTS Package won't execute when Scheduled as a Job
- Next by Date: Re: Save as Meta Data Services impossible
- Previous by thread: Re: Strange requirement for linked server
- Next by thread: A problem with DTSTransferObjectsTask
- Index(es):
Relevant Pages
|
