Re: DSN Error Connecting to Sql Server, Trusted Connection Error

From: Ryan Waight (Ryan_Waight_at_nospam.hotmail.com)
Date: 11/07/03 

Date: Fri, 7 Nov 2003 14:57:47 -0000

I think this is due to the following :-

When you TEST CONNECTION it goes with your user credentials.

When your ASP page connects it will be going in the context of the IIS
Server . IUSR_.....

Ensure the IUSR_ account has SQL permission. 

-- 
HTH
Ryan Waight, MCDBA, MCSE
"Earl Teigrob" <earlt777@hotmail.com> wrote in message
news:ualDdw6oDHA.1072@TK2MSFTNGP09.phx.gbl...
> I am try to connect to a SQL Database on a differect Domain. A Dsn entry
> gives me an error but a connection string works fine. The application we
are
> using requires a DSN
>
> 1. I can connect to the database just fine using a connection string that
> includes the username and password
>
> 2. When I set up the DSN and press test, it tests successful
>
> 3. When I use the DSN in my asp code, it gives the following error.
> -------------------------------
> Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
> '(null)'. Reason: Not associated with a trusted SQL Server connection.
>
> /_landingPg/Default.asp, line 26
>
> ------------------------------------------- 
>
>

Relevant Pages

  • Balasan: RE: cant execute "use $database"
    ... I Use Perl on Windows Vista, MS SQL Server 2005, DBI, ADO. ... I create 'myperl' as DSN from ODBC Administration Tools. ... Here is my connection string: ... Generally speaking, when you want to connect to a specific database, it ...
    (perl.dbi.users)
  • Balasan: RE: cant execute "use $database"
    ... I Use Perl on Windows Vista, MS SQL Server 2005, DBI, ADO. ... I create 'myperl' as DSN from ODBC Administration Tools. ... Here is my connection string: ... Generally speaking, when you want to connect to a specific database, it ...
    (perl.dbi.users)
  • Re: ASP form write to DB issue
    ... Do a response.write with the SQL and try running that using whatever tool ... that posts the input to a ASP page (the ASP page must establish a ... ' Creating Connection Object and opening the database ... Set con = CreateObject ...
    (microsoft.public.scripting.vbscript)
  • Connection Pooling in ASP
    ... When connections are pooled in ASP to an SQL backend, ... times for a scheduling program and compare that using a join to the already ...
    (microsoft.public.inetserver.asp.db)
  • Re: IIS State - help appreciated
    ... > previously web classes managed it all. ... ASP page, but writing code around it, is possibly giving problems. ... > correctly and performance wise SQL seems fine - it's certainly not working ... it will not release a connection soon as well:) ...
    (microsoft.public.inetserver.iis)