getting ASPNET to work with MSDE

[Paul C.]

Hi folks,

I cannot seem to get my .NET app to successfully login to my Sql Server MSDE
instance. It always tells me that the login for ASPNET failed. My biggest
problem is that I cannot find any tools to let me administer the MSDE
database. How do you guys all do it? Why didn't the MSDE installation take
care of this?

I should tell you that I am running my MSDE instance under the Local
Account, which is Paul, a member of the Administrators group. I tried
giving ASPNET Administrators rights, but that didn't help.

Any tips would be greatly appreciated. Thank you.
I am running XP Pro, VS.NET 2002.

Paul C.

 

[Matt Berther]

Hello Paul,

Since MSDE does not include the enterprise manager (expected), administration tasks to be performed are done so using OSQL. There's an introduction available here: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003

Because managing using OSQL can be a daunting task, there are several tools available that will simplify this process for you. A quick google yielded this one (in ASP.NET), which looks pretty nice.

http://www.aspenterprisemanager.com/

 

[Joerg Jooss]

Hello Paul,

Since MSDE does not include the enterprise manager (expected),
administration tasks to be performed are done so using OSQL. There's
an introduction available here:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003

Because managing using OSQL can be a daunting task, there are several
tools available that will simplify this process for you. A quick
google yielded this one (in ASP.NET), which looks pretty nice.

http://www.aspenterprisemanager.com/

Don't forget SqlWebAdmin:

http://www.microsoft.com/downloads/...72-5e6c-459e-a6d8-6745a729c3c9&displaylang=en

Cheers,