I'm posting this for a fellow worker.
Upgrading Server Hardware and changing from Default Instance of SQL Server 2005 Standard 32bit on Windows 2003 32 bit to New Server Hardware with Named Instance of SQL Server 2005 Standard 64bit on Windows 2008 R2 .
I built the new server, created the named instance, restored the system DBs, and restored the user DBs.
My problem: Now I can't drop, rebuild, configure, or do anything with my transactional replication.
I receive the following error message:
An error occurred connecting to Publisher 'NewServer\Instance'
Additional Information: SQL Server requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternative name are not supported. Specify the actual server name, 'OldServerName'. (Replication.Utilities)
Where is this former server name stored? How do I wipe out everything in replication related to old server so I can start from scratch and use my modified replication scripts from the old server to rebuild replication? I would think there is a simple script that would clean up all this old information so you can rebuild replication on your new server.
Additional info: I've already followed the steps outlined in the following article which did not solve my problem.http://msdn.microsoft.com/en-us/library/ms147921(v=SQL.90).aspx
How to: Disable Publishing and Distribution (Replication Transact-SQL Programming)
sp_dropsubscriber 'servername', @Ignore_distributor =1
exec sp_dropdistributor @no_checks = 1, @Ignore_distributor =1
All commands ran successfully but I still receive same error when I try to configure publishing
Thanks in advance to anyone that can help!