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 ?
32 Answers
Change your SQL Server 2008 port
try this one
0I discovered my server had been changed to IPV6, and client was not set up for IPV6. Disabling IPV6 to force IPV4 aliviated the problem.
