Re: Security is TOO GOOD!

From: Erymuzuan Mustapa (emustapa@mac.com)
Date: 11/24/02 

From: "Erymuzuan Mustapa" <emustapa@mac.com>
Date: Sun, 24 Nov 2002 12:30:45 +0800

go to your enterprise manager( well if you have one), add ASPNet to
"mydatabase" and err.. make 'im dbowner as well, but if don't have em,
sp_addlogin and/or sp_adduser, see BOL for details

regards
erymuzuan mustapa

"Ron" <ronkrevat@mindspring.com> wrote in message
news:12a0601c29320$44e9ba40$8af82ecf@TK2MSFTNGXA03...
> I am using VS.NET, and I am trying to add rows to a
> database that I created in MSDE. I made the connection to
> this database using a SqlDataAdapter, which I dragged onto
> my form. I then created a dataset, and I bound the
> textboxes on the form to fields in the database table,
> through the properties section of these textboxes. I added
> the line, "SqlDataAdapter1.Fill(DsMYDATASET1)" to a button
> click event, in the code. Then, I went into my control
> panel and made ASPNET a member of the Administrators
> group. When I run the program, I get the error:
> Cannot open database requested in login 'MyDataBase'.
> Login fails. Login failed for user '(local)\ASPNET'.
> WHY? What must I do to be able to access this database?