>When I try to configure distribution for replication, I get an error stating that it cant connect to local host and that I need to connect using the computer name. The thing is, I am ALREADY connecting using the computer name!
>
>SQL was installed, and then the computer name was changed. It now wants me to connect using the old name, but that is not valid any more. I have tried to go into all the SQL setup areas that I can find, but they all reference the new, correct, server name. Not sure why SQL is hung up on the old name or where to fix this. Any / all help is appreciated!
I was able to find an answer in msdn:
[tried to put the link, but UT doesnt like it]
i.e. - Server name needed to be updated:
sp_dropserver 'old name';
GO
sp_addserver 'new_name', local;
GO
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.