I have a windows server 2012 machine that has two sql server databases. One uses sql server express 2008R2 and the other uses Sql Server Express 2012.
I have an Access application that uses odbc dsn connections to link tables to both of the sql server databases.
Until a few days ago both of them were working fine.
Then different things started happening;
The first thing was that I had to turn off the firewall on the server in order to connect to the databases using Access.
Then a few days later, I started losing connection even with the firewall turned off.
Both databases can be contacted using a ssms on the server where the databases are located.
Currently the 2012 database cannot be contacted using ssms from a workstation on the network. That same workstation can contact the 2008 database.
Earlier today, the Access application could only contact the 2012 sql server database.
Now it can only contact the 2008 sql server database database.
This is with windows firewall on the server turned off completely.
I have a feeling the problem is network related, but I'm not sure what it is.
Sql server network configuration settings:
protocols for 2012== shared memory, named pipes, tcp/ip all enabled
protocols for 2008 == shared memory, named pipes, tcp/ip all enabled
protocol: TCP/IP: Enbabled: YES Keep Alive: 30000 listen all : YES
Ip Addresses: All ip addresses have enabled set to NO except the main ip address for the server, which is set to YES. Dynamic Port set to 0
Native Client configuration: TCP/IP default port set to 1433