"Tim Allen" <Tim.allen@torex.com> wrote in message
news:09d201c3b4df$b61df870$a401280a@phx.gbl...
> Hi there. I have a problem within DTS design.
> Out IT dept changed our server name without us knowing..
> Great! I have run Sp_dropserver and sp_addserver to rename
> the server fine.
> However when I go into DTS i establish the server
> connection ok, but have problems when I try and build an
> execute SQL task.
> If I click on the bulid option the message generated is as
> follows:
> Source MS OLE DB provider for SQL server
> Description Server 'Servername' is not configured for data
> access.
> Never come across this before? Any ideas. All other
> functionality is present.
> many thanks
> Tim

<anonymous@discussions.microsoft.com> wrote in message
news:08be01c3b4e8$4f6e8000$a501280a@phx.gbl...
> The server name was the old server
> After run the two SP's add and drop, it then showed the
> new server name as I had called it in sp_ addserver
>
> However on hindsight thought it should be called local
> so I ran sp_dropserver 'The sever name just renamed'
>
> Then sp_add server 'local'
> Is that right?
>
> >-----Original Message-----
> >when you do
> >
> >SELECT @@servername
> >
> >what is the result ?
> >
> >You can also use sp_serveroption
> >
> >Which version of SQL Server ?
> >
> >What were the exact statements you ran to rename the
> server as far as SQL
> >Server was concerned?
> >
> >--
> >--
> >
> >Allan Mitchell (Microsoft SQL Server MVP)
> >MCSE,MCDBA
> >www.SQLDTS.com
> >I support PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >"Tim Allen" <Tim.allen@torex.com> wrote in message
> >news:09d201c3b4df$b61df870$a401280a@phx.gbl...
> >> Hi there. I have a problem within DTS design.
> >> Out IT dept changed our server name without us knowing..
> >> Great! I have run Sp_dropserver and sp_addserver to
> rename
> >> the server fine.
> >> However when I go into DTS i establish the server
> >> connection ok, but have problems when I try and build an
> >> execute SQL task.
> >> If I click on the bulid option the message generated is
> as
> >> follows:
> >> Source MS OLE DB provider for SQL server
> >> Description Server 'Servername' is not configured for
> data
> >> access.
> >> Never come across this before? Any ideas. All other
> >> functionality is present.
> >> many thanks
> >> Tim
> >
> >
> >.
> >