It sounds like you are trying to use a SQL login but that
your server is configured for Windows Authentication only.
Try changing SQL Servers authentication to Windows and SQL
Server and restart SQL service for changes to take affect.
-Sue
On Wed, 19 Nov 2003 11:03:57 -0600, "J Harrigan"
[quoted text, click to view] <jlharrigan@hotmail.com> wrote:
>On my local machine running Win XP Pro, a sql server login fails: ][SQL
>Server]Login failed for user 'userid'. Reason: Not associated with a trusted
>SQL Server connection.
>
>The connection to sql server is specified in a web file called
>dataconnection.asp:
>
>Set objConn = Server.CreateObject("ADODB.Connection")
>objConn.Open "Driver={SQL Server};" & _
>"Server=mycomputername;" & _
>"Database=dbname;" & _
>"Uid=userid;" & _
>"Pwd=password;"
>
>I went to sql server, created a user that matched the user id above,
>assigned the password exactly as shown in dataconnection.asp, and assigned
>rights to the database 'hotels' and assigned roles as 'public' and
>'db_owner'. But I'm still getting the same error.
>
>I've also checked and doublechecked computername, database name, userid, and
>password.
>
>I also tried this on my web server, and the connection to sql server worked
>first time.
>
>Any thoughts as to what's wrong and where? Thanks...Jan
>
On my local machine running Win XP Pro, a sql server login fails: ][SQL
Server]Login failed for user 'userid'. Reason: Not associated with a trusted
SQL Server connection.
The connection to sql server is specified in a web file called
dataconnection.asp:
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Driver={SQL Server};" & _
"Server=mycomputername;" & _
"Database=dbname;" & _
"Uid=userid;" & _
"Pwd=password;"
I went to sql server, created a user that matched the user id above,
assigned the password exactly as shown in dataconnection.asp, and assigned
rights to the database 'hotels' and assigned roles as 'public' and
'db_owner'. But I'm still getting the same error.
I've also checked and doublechecked computername, database name, userid, and
password.
I also tried this on my web server, and the connection to sql server worked
first time.
Any thoughts as to what's wrong and where? Thanks...Jan
Yes I am using windows authentication and that HAS to be it. THANK YOU!!!!
[quoted text, click to view] "Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
news:669nrv4pvvgnt1838cgf87p0l6tmsv1qta@4ax.com...
> It sounds like you are trying to use a SQL login but that
> your server is configured for Windows Authentication only.
> Try changing SQL Servers authentication to Windows and SQL
> Server and restart SQL service for changes to take affect.
>
> -Sue
>
> On Wed, 19 Nov 2003 11:03:57 -0600, "J Harrigan"
> <jlharrigan@hotmail.com> wrote:
>
> >On my local machine running Win XP Pro, a sql server login fails: ][SQL
> >Server]Login failed for user 'userid'. Reason: Not associated with a
trusted
> >SQL Server connection.
> >
> >The connection to sql server is specified in a web file called
> >dataconnection.asp:
> >
> >Set objConn = Server.CreateObject("ADODB.Connection")
> >objConn.Open "Driver={SQL Server};" & _
> >"Server=mycomputername;" & _
> >"Database=dbname;" & _
> >"Uid=userid;" & _
> >"Pwd=password;"
> >
> >I went to sql server, created a user that matched the user id above,
> >assigned the password exactly as shown in dataconnection.asp, and
assigned
> >rights to the database 'hotels' and assigned roles as 'public' and
> >'db_owner'. But I'm still getting the same error.
> >
> >I've also checked and doublechecked computername, database name, userid,
and
> >password.
> >
> >I also tried this on my web server, and the connection to sql server
worked
> >first time.
> >
> >Any thoughts as to what's wrong and where? Thanks...Jan
> >
>
