I am trying to connect to a remote server using the string:

objconn.Open "driver=sql
server;server=MYSERVER;database=MYDB;uid=MYUSER;pwd=MYPASSWD;"

the connection works fine when it is on a machine that is currently
logged in as a domain authenticated user. It seems though, if I try to
connect with a machine logged in with a non-domain account it fails
with the error:

-2147467259 (80004005)
Client unable to establish connection

If I connect to a share on the data server prior to making the
connection - all works well.

any ideas how I can establish this connection with attaching to the
server first? or any other work-arounds?

thanks in advance -