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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy