IIS and SQL Server Persmission Issue

From: Patrick24601 (patrick24601_at_yahoo.com)
Date: 08/15/04 

Date: Sun, 15 Aug 2004 15:36:21 -0500

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

Code is:
Dim MM_webprodmx_STRING
MM_webprodmx_STRING = "dsn=DSNwebprodmxSQL;uid=IUSR_ATBSLAPTOP;
Set rsCategories = Server.CreateObject("ADODB.Recordset")
9: rsCategories.ActiveConnection = MM_webprodmx_STRING
rsCategories.Source = "SELECT * FROM dbo.categories ORDER BY category ASC"
rsCategories.CursorType = 0

The DSN is defined and working (testing outside of dreamweaver, via setup
directly). The database and table exist and have data present. Like I said
it works everyplace else except when going through IIS. I have read some of
the MS Support articles and made sure I am accessing my machine via (local)
so there is no network access. Everything is running on my single local
machine - even IIS and SQL Server 2000.

Any suggestions would be appreciated.

Relevant Pages

  • Re: Heres a rather broad question...
    ... I'm familiar enough with using ADO with VBScript/Javascript in ASP pages, ... authentication or permission issues with SQL Server 2000. ... IIS user doesn't have the proper permissions to access the database, ...
    (microsoft.public.data.ado)
  • IIS/ASP/SQL Security Error
    ... I am learning ASP/IIS/SQL Server by writing a small ASP app in Dreamweaver. ... it works everyplace else except when going through IIS. ... machine - even IIS and SQL Server 2000. ...
    (microsoft.public.inetserver.iis.activeserverpages)
  • IIS/ASP/SQL Security Error
    ... I am learning ASP/IIS/SQL Server by writing a small ASP app in Dreamweaver. ... it works everyplace else except when going through IIS. ... machine - even IIS and SQL Server 2000. ...
    (microsoft.public.inetserver.iis)
  • Re: New to Merge/Replication
    ... ADO.NET 3.0 includes "Synchronization Services" that does not require IIS. ... Hitchhiker's Guide to Visual Studio and SQL Server ... It was my deepest hope that Merge/Replication between SQL Compact Edition and SQL Server 2005 Enterprise Edition would have it's own sync services NOT dependent on IIS. ... You can use merge replication with SQL Server on your main desktop serving as the publisher with SQL Compact on PPC, TabletPC, or other desktops as subscribers, so that would probably be the easiest solution for you. ...
    (microsoft.public.sqlserver.ce)
  • Re: How can I run asp pages in Local Computer?
    ... database-driven (SQL Server or another db is also an option here) website or ... Kristofer Gafvert - IIS MVP ... >> I programmed some asp pages, ... >> I need run asp pages in local computer because I 'm ...
    (microsoft.public.inetserver.iis)
Loading