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 Server
Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated
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 Server
>Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated
>with a trusted SQL Server connection.
>Can someone guide me to any articles or guides on how to get this
>accomplished in vbs?
>Thanks!
Showing posts with label domainfrom. Show all posts
Showing posts with label domainfrom. Show all posts
Sunday, February 12, 2012
connecting to sql server in another domain in vbs
connecting to sql server in another domain in vbs
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!
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:
Posts (Atom)