SQL Login Issues between replicated VM's

  • SQL Espo

    SSCrazy

    Points: 2673

    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.

    issue

     

    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: 25929

    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