0

I have a Microsoft Access front-end application that can log in (cross-domain) with SQL authentication just fine to a SQL Server 2008 instance, but is not able to log in to a SQL Server 2012 instance.

Is there a difference in the network protocols? I haven't been able to find anything.

Regarding the 2012 instance, does TCP/IP need to be first in the configuration manager? Shared Memory is first, and enabled...named pipes are also enabled.

J.D. Walker
  • 56
  • 6
  • Do you get any error message? – FLICKER Mar 15 '16 at 20:37
  • Yes, I do, but the problem turned out to be that MS Access retained the old connection even when you told it to use the new connection. I had to go into the Linked Table manager and use the advanced settings, then it worked. – J.D. Walker Mar 17 '16 at 19:40

0 Answers0