Re: IIS and SQL Server Persmission Issue
From: Patrick24601 (patrick24601_at_yahoo.com)
Date: 08/15/04
- Next message: David Portas: "Re: simple Select (i hope)"
- Previous message: Sam: "Linked Server Dynamic Syntax"
- In reply to: David Browne: "Re: IIS and SQL Server Persmission Issue"
- Next in thread: Patrick24601: "Re: IIS and SQL Server Persmission Issue"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 15 Aug 2004 16:01:41 -0500
Thanks David.
I've gone in and check and that user has SELECT/INSERT/DELETE permissions on
all of the needed tables.
"David Browne" <davidbaxterbrowne no potted meat@hotmail.com> wrote in
message news:%23mp8$gwgEHA.384@TK2MSFTNGP10.phx.gbl...
> "Patrick24601" <patrick24601@yahoo.com> wrote in message
> news:ePPTc.4368$wu.1124@okepread04...
>> IIS and SQL Server Persmission Issue
>>
>> I am getting an error trying to run a SQL Server SELECT statement from an
>> ASP Application.
>>
>> I am learning ASP/IIS/SQL Server by writing a small ASP app in
> Dreamweaver.
>> I've created and tested the ODBC connection just fine. And when I create
> the
>> connection in Dreamweaver and run the query it works just fine. However
> when
>> I try to access the web page I get:
>>
>> Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
>> [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
>> 'ATBSLAPTOP\IUSR_ATBSLAPTOP'.
>> /webprodmx/categories.asp, line 9
>
> Your DSN is set up to use integrated authentication. Change that or give
> 'ATBSLAPTOP\IUSR_ATBSLAPTOP' rights to connect you your database. It
> works
> outside of IIS because then it's you, not 'ATBSLAPTOP\IUSR_ATBSLAPTOP'
> connecting to the database.
>
> David
>
>
- Next message: David Portas: "Re: simple Select (i hope)"
- Previous message: Sam: "Linked Server Dynamic Syntax"
- In reply to: David Browne: "Re: IIS and SQL Server Persmission Issue"
- Next in thread: Patrick24601: "Re: IIS and SQL Server Persmission Issue"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
