Problems with remote accessing a new instance in SQL Server 2019



  • I'm trying to setup a new dev environment. I have installed a Windows Server 2022 with SQL Server 2019 on it.

    My idea is to setup a new instance for every project I make.

    But I'm having trouble installing new instances and connecting to them remotely.

    What I do:

    Start setup -> create new instance -> put in instance name let the wizard finish.

    To access remotely, I went to configuration manager and enabled tcp/ip and named pipes.

    I restarted all services.

    In the firewall port 1433 tcp and port 1434 udp are enabled.

    My default instance sqlexpress is accessible for remote connection, So I can definitely say it is not a firewall issue.

    I currently tried 3 times where the first time I was able to connect locally but not remotely, other 2 time failed to even connect locally even after restarting my virtual machine. Locally and remotely I'm getting error 26. googling around doesn't find the right answer.

    services

    configuration manager

    firewall

    Can anyone explain what I'm doing wrong and or give me the steps to install a new instance and allow it to connect remotely?



  • In my case, My problem was both instances were listening to the same port. When replacing the ports by changing to a seperate port for each instance, everything works.


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2