SQL Login Issues between replicated VM's

• SQL Espo

  SSCrazy

  Points: 2678

  More actions

  August 22, 2019 at 2:17 pm

  #3673579

  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

• Michael L John

  One Orange Chip

  Points: 27079

  More actions

  August 22, 2019 at 2:44 pm

  #3673613

  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/