|
Home > Archive > Microsoft SQL Server Desktop Engine > November 2006 > SQL Express User Instances
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Express User Instances
|
|
| Olivier Matrot 2006-11-24, 5:26 am |
| Hello,
I'm working with SQL Express User Instances. This is an interresting
functionnality.
Our product is divided into 2 main components :
- A windows Service that insert data into a database.
- An ASP.NET 2.0 Web Site that needs mainly read but also write access to
the same database.
Packaging our product with SQL Express would be a first choice, because with
User instance, we are able to hide our database from the other users, thus
we could eliminate potential damage of our database.
The main problem here is that for a give user, the first connection to the
instance has read/write access. Other connections are limited to read only
access. While we are in CTP for SP2, could we imagine that all connections
have read/write access to the database ?
TIA.
| |
| Olivier Matrot 2006-11-24, 7:14 pm |
| In fact this is only the case where the database files are not installed to
the default data directory. In that case, the files are not copied to the
user environment. ACL are not correct, which is the cause of the read only
access.
"Olivier Matrot" <olivier.matrot.rte@online.nospam> wrote in message
news:eNPaop5DHHA.4952@TK2MSFTNGP06.phx.gbl...
> Hello,
>
> I'm working with SQL Express User Instances. This is an interresting
> functionnality.
> Our product is divided into 2 main components :
> - A windows Service that insert data into a database.
> - An ASP.NET 2.0 Web Site that needs mainly read but also write access to
> the same database.
> Packaging our product with SQL Express would be a first choice, because
> with User instance, we are able to hide our database from the other users,
> thus we could eliminate potential damage of our database.
>
> The main problem here is that for a give user, the first connection to the
> instance has read/write access. Other connections are limited to read only
> access. While we are in CTP for SP2, could we imagine that all connections
> have read/write access to the database ?
>
> TIA.
>
|
|
|
|
|