MS SQL Database access

[=?Utf-8?B?THVib21pcg==?=]

Hi,

I am learning how to access MS SQL database from ASP.NET and run into 2
problems:

1/
When a user from asp page is connected to database, I can not connect to the
database from windows management console. My database was created as local.
Could be this be a problem?

Is it preferable to create database as the system db?


2/
IIS is set up to anonymous access and basic authentication. In my web config
I set up impersonate to true, so the user IUSER_username should be connected
to the database. Is this solution secure enough or should I allowe another
type of access?


3/
I was playing with the impersonate attribute and wanted to observe what’s
going on.
When I turned it OFF, the user ASPNET wanted to access the db and it was not
allowed. Then I turned it ON again, but still I get error message the access
was denied to the user ASPNET. After turning “impersonateâ € to true, the user
IUSER should be accessing the db. Is there any type of caching during the
development?

4/
What file I/O rights should be set up to the database mdf and ldf file?

5/
As I am using my own database, not ASPNET.mdb I wanted to remove the default
reference to it in config file (<remove …./>)
When I did it in the wwwrooot\MySite folder, I get error message. When I did
it in the APP_DATA folder where database is located, I didn’t get any error.
Why did I get the error in the first case?

Thank you for help,


Lubomir

[Evertjan.]

Re: MS SQL Database access

=?Utf-8?B?THVib21pcg= =?= wrote on 26 feb 2007 in
microsoft.publi c.inetserver.as p.general:

I am learning how to access MS SQL database from ASP.NET and run into 2
problems:
>

This is a classic asp group.
Dotnet questions should be asked in:

<microsoft.publ ic.dotnet.frame work.aspnet>

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)

[=?Utf-8?B?THVib21pcg==?=]

Re: MS SQL Database access

Oh,

Thanks,

Lubomir


"Evertjan." wrote:

=?Utf-8?B?THVib21pcg= =?= wrote on 26 feb 2007 in
microsoft.publi c.inetserver.as p.general:
>

I am learning how to access MS SQL database from ASP.NET and run into 2
problems:

>
This is a classic asp group.
Dotnet questions should be asked in:
>
<microsoft.publ ic.dotnet.frame work.aspnet>
>
--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
>