sql server database access problem

From: Ian (no_at_spam)
Date: 09/26/03 

Date: Fri, 26 Sep 2003 21:52:39 +0100

hi

i have a problem with database access (SQL Server/MSDE) on my production
server.

the asp.net web app works fine in test.

on the production server, it won't connect to the database!

i'm pretty sure i have set up the ASPNET login correctly, with permissions
identical to my test system

it only fails when trying to use a Trusted connection for ASPNET - using an
SQL connection.for use 'sa' works just fine.

the only clue i have is a SQL security log entry of "login failed for 'NT
AUTHORITY\NETWORK SERVICE'"

Thanks
Ian

Relevant Pages

  • problems with msde access from asp.net app
    ... i have a problem with database access on my production ... on the production server, it won't connect to the database! ... SQL connection.for use 'sa' works just fine. ...
    (microsoft.public.sqlserver.security)
  • problems with msde access from asp.net app
    ... i have a problem with database access on my production ... on the production server, it won't connect to the database! ... SQL connection.for use 'sa' works just fine. ...
    (microsoft.public.sqlserver.security)
  • sql server database access problem
    ... i have a problem with database access on my production ... on the production server, it won't connect to the database! ... SQL connection.for use 'sa' works just fine. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • CDO.Message Problems in live environment...
    ... I want to send an e-mail message with attachments from a job in SQL Server. ... production server does not have an SMTP server but can contact one. ...
    (microsoft.public.sqlserver.programming)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)