August 22, 2019 at 2:17 pm
The issue is that this server (BFS-DEV02) in a virtual clone of another server (BFS-DEV01). Within SQL Server, windows login BFS-DEV02\Administrator is being viewed by SQL Server AS BFS-DEV01\Administrator.
Here are some screen shots shows what I mean about the logins…I believe what we ultimately want is to remove BFS-DEV01\Administrator and make it BFS-DEV02\Administrator.
Also, when trying to create the replication publisher on the server (BFS-DEV02), we get the following error/message
TITLE: New Publication Wizard
------------------------------
SQL Server is unable to connect to server 'BFS-DEV02'.ADDITIONAL INFORMATION:
SQL Server replication requires the actual server name to make a connection to the server. Specify the actual server name, 'BFS-DEV01'. (Replication.Utilities)
We are RDP-ed into the server when we try to do it and get it. Thanks in advance for help pointing me in the direction of resolving this issue! I am a green DBA (my skills are more SQL Development) so I know enough to get into trouble but not get myself out of it 🙂
August 22, 2019 at 2:44 pm
When you cloned the server and renamed the actual Windows server, did you rename the SQL Server also?
This article can help. https://docs.microsoft.com/en-us/sql/database-engine/install-windows/rename-a-computer-that-hosts-a-stand-alone-instance-of-sql-server?view=sql-server-2017
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply