Forum Discussion
User1165
Sep 10, 2024Copper Contributor
Unable to connect to windows mssql 2022 update 14 running on opposite node
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 M...
User1165
Sep 19, 2024Copper Contributor
Fixed the Problem. Apparently MSSQL Server no longer defaults to port 1433, but uses dynamic ports, starting at port 50027.
To find the problem Went onto the running DB machine, opened up SQL Server Configuration Manager, went to SQL Server Network Configuration --> Protocols --> TCP/IP -->Properties and then IP Addresses, and clear at the bottom is running on Port 50027, so on my second node, I used <SERVER>\MSSQL,50027 and used SQL Server Authentication --> DB user:<User> Password:<pwd> remember password, and remember server certificate.. and it connected just like described. so not sure where port 1433 comes into play anymore. Problem solved.
To find the problem Went onto the running DB machine, opened up SQL Server Configuration Manager, went to SQL Server Network Configuration --> Protocols --> TCP/IP -->Properties and then IP Addresses, and clear at the bottom is running on Port 50027, so on my second node, I used <SERVER>\MSSQL,50027 and used SQL Server Authentication --> DB user:<User> Password:<pwd> remember password, and remember server certificate.. and it connected just like described. so not sure where port 1433 comes into play anymore. Problem solved.