I have two sql server installed in same server. SQL server 2012 express and SQL server 2008 r2. After we moved to new office, we are not able to connect 2008 server but still able to connect 2012.
I have checked and confirmed that TCP/IP is enabled and the port is 1433 for both server.
SQL browser is also enabled
That is no firewall for blocking inbound and outbound from server, however I can't disable end user firewall as the option is being grey out by company IT.
ABC\SQLexpress2012 - working ABC\SQL2008 - doesn't not working
We managed to login Sql management studio in the machine itself. But both NT authentication and SQL authentication are not working in end user PC.
Any ideas from the experts here ?