Accessing MSDE from a web application

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: bakame (bakame.12o4fi_at_mail.mcse.ms)
Date: 03/05/04 

Date: Fri, 5 Mar 2004 16:49:50 -0600

Hello!
I was doing some research on how to read data off an MSDE 2000 database
and display it on a web-form using .NET and I came across a discussion
in the security forum that talks about adding ASP.NET as a user thru
the "osql utility" and
"sp_addlogin, sp_adduser" stored procedures...
I can connect to my MSDE by typing "osql -E" in the command prompt...
What is the syntax for sp_addlogin and sp_adduser when adding the
ASPNET account?? In other words, can anyone give me a step by step
answer on how to do that.... As you can see I am a newbie with MSDE and
NET!
In the post they also talk about adding ASPNET login as a user in
master database and and then run this command in Query Analyzer (in
master database).
GRANT EXEC ON sp_sdidebug TO ASPNET
GO

HELP!!!!!!!! 

--
bakame
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message453086.html

Relevant Pages