When trying to connect to the SQL Server I get this error on all client pc's:
Microsoft SQL Server Login
SQL State: 01000
SQL Server Error: 67
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()).
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL-server does not exist or access denied
Turning off firewall on server for Domain and it works!! However I want that turned ON so here's what I've done so far:
In sql server config manager I've manually set the port on the sql instance tcp/ip protocol to 1433 and deleted the 0 next to dynamic (and restarted the instance)
I've made a Inbound rule on firewall 1433 TCP Domain Allow
I checked in netstat (with firewall off) that the client acually uses 1433
Tried to delete the 1433-rule in firewall and reapply
Tried to "add program" sql srv instance path to "sqlservr.exe"
Have also rebooted both client and server several times
It clearly has to be firewall related on the server since the client can connect when I turn the firewall off (domain). But I am out of ideas on how to fix this so any help would be greatly (500points) appreciated... :)