We are in the attempt of creating a Always On, 2 node,  setup. We were sucessful in windows 2016 and mssql. We reloaded to Windows 2022 server, and MSSQL Server 2022 Developer Edition.

     We get MSSQL and SSMS loaded on both boxes. We create a database and create and grant the required DB user. On node1, we connect to DB just fine with SSMS using SQL Authentication. 

     On Node 2 we use SSMS to try to connect to node1 (with SQL Authentication) without success, just the generic network error. Our DBA has MSSQL server at his house he tests with, and we cannot find the differences. we can ping node1 from 2, we can \ node1 from node2 (i know different mechanisms), but network is not the issue. we can rdp to each other.

      Is there something new in SQL Server 2022 that we are overlooking? We cannot connect to the DB running on NODE1 from other SQL developer tools either. 

1) The SQL server properties are set to permit remote login, (have not enabled Always On yet, until we can get basic connectivity tested).

2) MS Defender Firewall has been disabled.

3) NODE1 Can connect to itself without issue.

4) NO corp external firwall in the way, had them check that.

5) NO Domain involved, just a workgroup between the 2 server. 

​We are in the attempt of creating a Always On, 2 node,  setup. We were sucessful in windows 2016 and mssql. We reloaded to Windows 2022 server, and MSSQL Server 2022 Developer Edition.     We get MSSQL and SSMS loaded on both boxes. We create a database and create and grant the required DB user. On node1, we connect to DB just fine with SSMS using SQL Authentication.      On Node 2 we use SSMS to try to connect to node1 (with SQL Authentication) without success, just the generic network error. Our DBA has MSSQL server at his house he tests with, and we cannot find the differences. we can ping node1 from 2, we can \ node1 from node2 (i know different mechanisms), but network is not the issue. we can rdp to each other.      Is there something new in SQL Server 2022 that we are overlooking? We cannot connect to the DB running on NODE1 from other SQL developer tools either. 1) The SQL server properties are set to permit remote login, (have not enabled Always On yet, until we can get basic connectivity tested).2) MS Defender Firewall has been disabled.3) NODE1 Can connect to itself without issue.4) NO corp external firwall in the way, had them check that.5) NO Domain involved, just a workgroup between the 2 server.     Read More

​