MS SQL Database access
am 26.02.2007 19:51:43 von LubomirHi,
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 (
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