I am trying to connect to a sql server database that is in another domain
from a vb script (not within ASP, just .vbs file). I am getting error:
Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Ser
ver
Driver][SQL Server]Login failed for user '(null)'. Reason: Not associate
d
with a trusted SQL Server connection.
Can someone guide me to any articles or guides on how to get this
accomplished in vbs?
Thanks!There are a lot of articles - hard to narrow down which may
apply in your case. Are you trying to connect with windows
authentication? Are you by chance using a DSN? What
authentication mode is the server set to?
If you are trying to use a SQL login, did you make sure to
specify the user and password?
These articles may give you an idea of what to look at:
http://support.microsoft.com/?id=827422
http://support.microsoft.com/?id=889615
http://support.microsoft.com/?id=307002
-Sue
On Fri, 16 Sep 2005 09:59:06 -0700, "slimbim"
<slimbim@.discussions.microsoft.com> wrote:
>I am trying to connect to a sql server database that is in another domain
>from a vb script (not within ASP, just .vbs file). I am getting error:
>Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Se
rver
>Driver][SQL Server]Login failed for user '(null)'. Reason: Not associat
ed
>with a trusted SQL Server connection.
>Can someone guide me to any articles or guides on how to get this
>accomplished in vbs?
>Thanks!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment