title: Unable to use vbscript to connect to sql server on different domain
body: <p>I'm using vbscript to try to connect to a sql server on another domain. The server is part of a cluster and is SQL Server Data Center Edition (64bit). I can ping the server from my machine. I'm using the IP address to connect which works fine on SSMS.
  The vbscript code I'm using is:</p>
  
  <pre><code>Set cn = CreateObject("ADODB.Connection")
  cn.Open "DRIVER={SQL Server};Server=123.456.345.567\instance;Database=MyDB;User
  ID=domain\myuserid;Password=mypass;"
  strCommandText = "Select * from mytable"
  cn.Execute strCommandText
  </code></pre>
  
  <p>When I run this, I get the following error: 
  Microsoft OLE DB Provider for
  ODBC Drivers: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'domain\myuserid'.</p>
  
  <p>I can't join my test machine to the domain and I can't use sql authentication as it's disabled on the sql server.</p>
  
  <p>What do I need to do to get this to work?</p>