Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDBName;Data Source=MyServerName
this is the connection string, it can not be changed, it is in a dll from the dark ages. we are having to use it on a server outside of our domain. we can hit the server because we set up a host entry all we need is read access is there something on the sql server that can be configured to allow this connection?
but get the following:
Message: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Source: Microsoft OLE DB Provider for SQL Server