"mm" <postto@news.com> wrote in message
news:eIM2gdb$EHA.2196@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> When going through the replication wizard to setup transactional
> replication
> the following error is returned when it starts to setup replication.
>
> SQL Server Enterprise Manager could not configure '<four part servername>'
> as the distributor for '<four part servername>'
> Error 18456: Login failed for user 'Distributor_admin'
>
>
>
> Can someone please help. Is it because of the four part server name?
>
> Thanks
>
>
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:eiLeJZi$EHA.3472@TK2MSFTNGP14.phx.gbl...
> It could be. What happens when you create an alias using the client
network
> utility. After doing this de-register your server in EM, and then
reregister
> it with the new one part alias.
>
> Is the distributor local?
>
>
> "mm" <postto@news.com> wrote in message
> news:eIM2gdb$EHA.2196@TK2MSFTNGP14.phx.gbl...
> > Hi,
> >
> > When going through the replication wizard to setup transactional
> > replication
> > the following error is returned when it starts to setup replication.
> >
> > SQL Server Enterprise Manager could not configure '<four part
servername>'
> > as the distributor for '<four part servername>'
> > Error 18456: Login failed for user 'Distributor_admin'
> >
> >
> >
> > Can someone please help. Is it because of the four part server name?
> >
> > Thanks
> >
> >
> >
> >
>
>