I have 2 server instances, one called "SQLMACHINE" and the other "SQLMACHINE\MYINSTANCE". When I attempt to connect with the OLEDB driver (connection string), it WILL connect to SQLMACHINE\MYINSTANCE, but it WILL NOT connect to SQLMACHINE. It is unable to find the server.
The workaround so far has been to STOP the SQL Service on the SQLMACHINE\MYINSTANCE, which apparently forces OLEDB to the other server by some kind of default. How can I CHOOSE which server I want to connect to? Ofcourse, I have tried all the basic stuff, i.e., "local", "SQLMACHINE", "localhost", "127.0.0.1", you name it. Can't find that server.