I am working on setting up a VMware Mirage test environment, and need to allow a second server to connect to the SQL Server 2012 Express instance on the first server. I am trying to set up an ODBC connection on the second server for the SQL Server on the first. I have already opened inbound TCP port 1433 on the first server. I need to log into the SQL Server using Windows authentication. I am logged into both servers using the same domain administrator account (they are on the same domain). Everytime I hit Next on the "How should SQL Server verify the authenticity of the login ID?" part of the System DSN wizard, I get the following error:
SQL Server Error: 67
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connectio
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Can someone please help with this?