(Windows 2016 Server running SQL Server 2019 Cluster installation)
I have run into an issue and I am at a complete loss as to what to do about it.
The only other option is to delete the VM and create a new one and re-do the process and see if it will work then.
On a Virtual Machine.
I have SQL Server 2019 installed as a cluster.
Currently, there is only ONE server running in this test run.
Connecting to the server through SSMS 18.4
From my laptop to the server, it fails every time. Error 26
I have done the following.
(On the VM Server)
Made sure all SQL items in the Services, are in fact running and they are from the get-go.
Open Firewall for programs: SQLBrowser and SQLServer. (Also for good measure, I created two more rules for 1433 and 1434)
For SQL Server Config Manager - Enabled all items, TCP/IP, set on port 1433 for both the IP Addresses shown.
(Actually, there are IP Addresses in the TCP/IP config, that I have NO idea what the heck they are, or how they got in there???)
I checked the DC for entries in DNS, and all IP addresses are entered.
Both for the two NICs and the Cluster assigned IP.
Installed SSMS 18.4 on the VM Server, and it connected to it, without an issue.
I also checked once I launched SSMS to make sure it was set up to allow connections, and it was by default.
It just will not connect through the network.
Now, this is NOT my first time working with a VM Machine with SQL Server and connecting with SSMS.
I have a successfully running setup at the moment, but this one, I just don't know what is going on.
Any other ideas?
This is racking my brain.
Usually doing all the above-mentioned items, with the Firewall, services, and Config, it goes to work. But not in this case.