I am a novice when it comes to Windows networking authentication, as well as just getting my feet wet with SQL Express, so please bear with me, hopefully this is a simple fix but so far the obvious fixes I have found in forums have not solved it.
I am trying to set up a geodatabase to be accessible by remote PC's running ESRI's ArcMap with standard license.
I have installed MS SQL Express 2012 as well as necessary components from the 2008 release to be able to access geodatabases.
I can successfully connect to the database from within ArcMap on the machine that is serving it, so I know the server is working.
However if I try and set up a connection on a remote machine I get authentication errors. I can confirm the server machine is seeing the connection attempt and the firewall is letting in the TCP/IP, as I can see in SQL Management Studio Express's log on the server machine logging the failed attempts.
I get two errors depending on how i try and connect, if I use windows authentication I get a message that the domain is untrusted so i can't use windows authentication. If I use database authentication I get a message that login failed and to check login/pwd/server. As mentioned before I know the server part seems to be correct.
In SQL Management configuration I have added a user to the DB and given it a password, I have also switched authentication over to both windows authentication and db authentication. However if I select db authentication at the connect dialog and put in the user/pwd I still get an error.
I have tried to add my remote machine's IP to the trusted domains on the server PC, but not sure I did that right. Still get errors that say the domain is untrusted if i try windows authentication.
So not sure where to turn next, or what info you folks might require to sort this out. Any leads are appreciated, thanks.