User Instance-like SQL Server Express 2005 setup
- From: "Gary" <gniemcew@xxxxxxxxx>
- Date: 8 Feb 2006 16:42:06 -0800
Hi,
I am trying to figure out a way to re-distribute SQL Server Express
2005 with a custom application in the way that User Instances work (I
cannot use native User Instance functionality, since I use C++/OLE DB,
and not ADO.NET).
I would like both SQL Server Express 2005 and the application installed
once on a particular Windows system by an administrator (available to
all users on a system), and then allow a custom application to create a
new database and take ownership of it.
The problem is (as far as I understand it...) that for things to work,
each new user would have to have sa-level access to an instance FIRST
to add its own user, create its own database, grant appropriate
permissions, etc. before switching back to its own user name to access
the data. Moreover, in case of integrated security, each user would
have to update his or her SQL Server Express 2005 password, after
changing the Windows logon password.
Ideally, I would like to setup an SQL Server Express 2005 instance in
such a way, that every new Windows user can connect to that instance
(using Windows logon information or chosen SQL username and password),
create and use a database, but without instance-wide sa access.
Is that possible?
Gary
.
- Prev by Date: Who is using MSMQ?
- Next by Date: Re: 'Domain\LocalServer$' is not a valid user
- Previous by thread: Who is using MSMQ?
- Next by thread: Re: User Instance-like SQL Server Express 2005 setup
- Index(es):
Relevant Pages
|
