ASPNET access to MSDE

[DA]

I was wondering if anyone out there could shed some light on this MSDE .NET
interaction problem

I am running MSDE 2K latest service pack running Mixed mode, .NET Framework
1.1 on XP Pro (also latest SP and updates)

I have written a simple ASP app in C# which attempts to access MSDE via a
WebService also written in C#. When I try and do an open the following
exception is thrown:

Cannot open database requested in login 'Act'. Login fails.Login failed for
user 'YORK\ASPNET'

I have gone into MSDE with osql and done the following

EXEC sp_grantlogin 'YORK\ASPNET'
EXEC sp_grantdbaccess 'YORK\ASPNET', 'Act'
EXEC sp_defaultdb 'YORK\ASPNET', 'Act'

And at a last resort I granted it the following permissions:

EXEC sp_addrolemember db_owner, 'YORK\ASPNET'
and made ASPNET part of the administrators group in XP

But I still get the above error.

Any ideas?

[Scot Rose [MSFT]]

Is the database on the same machine as IIS? SQL or Integrated security?

321698 PRB: Cannot Connect to MSDE 2000 by Using ADO.NET with SQL Authentication
[url]http://support.microsoft.com/?id=321698[/url]

176377 INFO: Accessing SQL Server with Integrated Security from ASP
[url]http://support.microsoft.com/?id=176377[/url]

Scot Rose, MCSD
Microsoft Visual Basic Developer Support
Email : [email]scotr@online.microsoft.com[/email] <Remove word online. from address>

This posting is provided “AS IS”, with no warranties, and confers no rights.

Get Secure!
[url]http://www.microsoft.com/security[/url]
[url]http://www.microsoft.com/protect[/url]


--------------------

>From: "DA" <RA@companyabc.tw>
>Subject: ASPNET access to MSDE
>Date: Thu, 11 Sep 2003 15:27:48 +0100
>Lines: 29
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
>Message-ID: <eybRiDHeDHA.2212@TK2MSFTNGP12.phx.gbl>
>Newsgroups: microsoft.public.dotnet.framework.aspnet.security
>NNTP-Posting-Host: host213-122-215-17.in-addr.btopenworld.com 213.122.215.17
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP12.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.aspnet.security: 6640
>X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet.security
>
>I was wondering if anyone out there could shed some light on this MSDE .NET
>interaction problem
>
>I am running MSDE 2K latest service pack running Mixed mode, .NET Framework
>1.1 on XP Pro (also latest SP and updates)
>
>I have written a simple ASP app in C# which attempts to access MSDE via a
>WebService also written in C#. When I try and do an open the following
>exception is thrown:
>
>Cannot open database requested in login 'Act'. Login fails.Login failed for
>user 'YORK\ASPNET'
>
>I have gone into MSDE with osql and done the following
>
>EXEC sp_grantlogin 'YORK\ASPNET'
>EXEC sp_grantdbaccess 'YORK\ASPNET', 'Act'
>EXEC sp_defaultdb 'YORK\ASPNET', 'Act'
>
>And at a last resort I granted it the following permissions:
>
>EXEC sp_addrolemember db_owner, 'YORK\ASPNET'
>and made ASPNET part of the administrators group in XP
>
>But I still get the above error.
>
>Any ideas?
>
>
>

[DA]

Scot,

Thanks for your reply, not sure where my last reply got to I thought I
posted one, but incase it got lost somewhere along the way, here is my
response again.

SQL and IIS are on the same machine, and SQL is configured for mixed
authentication but I am wanting to use integrated security.

Richard

[Scot Rose [MSFT]]

Take a look at the following articles (The first one is most likely what
you need)

316989 PRB: "Login Failed" Error Message When You Create a Trusted Data
[url]http://support.microsoft.com/?id=316989[/url]

306158 INFO: Implementing Impersonation in an ASP.NET Application
[url]http://support.microsoft.com/?id=306158[/url]