Re: Accessing MSDE from a web application
From: Mary Chipman (mchip_at_nomail.please)
Date: 03/06/04
- Next message: John Linville: "Re: Unable to Install MSDE"
- Previous message: Sergio I.: "Re: How to change MSDE 2000 database default location"
- In reply to: bakame: "Accessing MSDE from a web application"
- Next in thread: bakame: "Re: Accessing MSDE from a web application"
- Reply: bakame: "Re: Accessing MSDE from a web application"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 06 Mar 2004 09:17:30 -0500
If you're new to MSDE, you'll find it much easier to administer if you
purchase the SQLS Developer edition ($49 U.S.) and just install the
client tools. Or alternately install the full version and just use
MSDE for deployment. You'll then be able to configure and administer
security using the Enterprise Manager GUI instead of wrestling with
command line utilities. Configuring asp.net security correctly can be
tricky -- you might want to download the "Building Secure ASP.NET
Applications" whitepaper (it's really more like a book) but it covers
all of the angles, including accessing SQLS:
http://www.microsoft.com/downloads/release.asp?ReleaseID=44047
-- Mary
MCW Technologies
http://www.mcwtech.com
On Fri, 5 Mar 2004 16:49:50 -0600, bakame <bakame.12o4fi@mail.mcse.ms>
wrote:
>
>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!!!!!!!!
- Next message: John Linville: "Re: Unable to Install MSDE"
- Previous message: Sergio I.: "Re: How to change MSDE 2000 database default location"
- In reply to: bakame: "Accessing MSDE from a web application"
- Next in thread: bakame: "Re: Accessing MSDE from a web application"
- Reply: bakame: "Re: Accessing MSDE from a web application"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
