Ok guys after a week I need to share this because every answer said you have to switch to both SQL and Windows Auth to make this error go away. Not True!
If you’re using an Access front end and SQL Back end you probably will see this error when trying to connect via one of your work stations. My normal way to connect to the server was \\192.168.1.123, and when ask for a password the user would logon and have the workstation remember the password so you don't have to logon again; however in my case SQL is looking for \\SERVER not \\192.168.1.123 so go to your browser type the name of your server (\\Server) logon and remember the password and wala it will work. I Hope this work around helps it took me a week to figure it out and I have yet to get and answer anywhere on the web.
If you’re using an Access front end and SQL Back end you probably will see this error when trying to connect via one of your work stations. My normal way to connect to the server was \\192.168.1.123, and when ask for a password the user would logon and have the workstation remember the password so you don't have to logon again; however in my case SQL is looking for \\SERVER not \\192.168.1.123 so go to your browser type the name of your server (\\Server) logon and remember the password and wala it will work. I Hope this work around helps it took me a week to figure it out and I have yet to get and answer anywhere on the web.
