SQL Server with Windows Authentication not working. RRS feed

  • Question

  • Dear Experts,

    i have two virtual Machines with SQL Server 2016 installed.

    on VM 1 i connect the SQL Server of VM2 with Windows Authentication and it works.  

    But when i connect the SQL Server of VM1 from VM2 with Windows authentication, it does not connect. 

    Both the VMs connect each other with SA account. 

    Your urgent help needed.



    Thursday, December 24, 2020 1:38 PM

All replies

  • Hi,
    in case of  really Urgent a Error Message should be posted.

    check for allowed remote access on vm1.
    See: https://knowledgebase.apexsql.com/configure-remote-access-connect-remote-sql-server-instance-apexsql-tools/

    Regards Alexander

    Thursday, December 24, 2020 2:58 PM
  • Hi Alexander,

    Many thanks and let me check it. I shall return back on it. 



    Thursday, December 24, 2020 4:21 PM
  • Hi

    Enable only the services and connection types used by your applications

    Disabling unused services and connections.

    Surface Area Configuration Setting Connections.

    Best Regards.

    Please remember to mark the replies as answers if they help.

    Thursday, December 24, 2020 8:25 PM