We have migrated our SQL server 2008 db on SBS 2011 to a new Windows 2012 server.The migration was successfull but now we are having issues with our workgroup pc's connecting via Microsoft Access Frontend to SQL srv 2008.
We previously had issues a year ago when we got our SBS 2011 srv,connecting Workgroup pc's(XP Home, Vista Home) to network.We eventually resolved the Workgroup issue and Access connected to SQL server.I just can't remember how and what we did.
Most pc's on domain connect via Windows auth. on ODBC to SQL srv 2008.
We created a user on SQL srv with SQL mixed mode auth and it worked BUT every time i close Access and re-open it have to re-enter the password into the SQL server login box.
I understand that that's the way Access will work when setting up a SQL mixed mode user.
I ideally would want to return to the previous state when Access worked before migrating db server.
Is there not User settings on Workgroup pc 's i can set to work around this problem?
We have 6 of these machines on domain,so we can't just replace them simultaneously.