I installed SQL Server Express 2012 on one computer and imported a database from Access. This all went fine.
I set the server to accept both Windows and SQL Server authentication and enabled TCP/IP connections. I am able to connect to the server and do all other routine functions in SQL Server Management Express 2012 on the machine where the SQL Server instance
is running using either my Windows login or the 'sa' / password login.
I then installed SQL Server Management Express 2012 on a second computer attached to the same local network. Computers on this network are in the same workgroup but there is no domain or AD validation.
When I try to connect to the SQL Server Express instance on the first computer from Management Studio on the second computer using the 'sa' / password login, I get the following error message:
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL ...
Go to the complete details ...