msde security...........................

I have a business directory software done in vb.net and sqlserver .We are
using msde for distribution purpose .The problem we are facing is about the
security of the data . The cd goes to common man and we are concerned about
the security of the data.Is there any option where we can ensure that the
database cannot be opened by the user . please help
..Urgent.........................
If by "common man" you mean that the database is installed on each
person's computer in their own MSDE instance, then the answer is no,
you can't prevent them from getting at the data because they are a
system administrator on that instance. If the database is located on a
server, then it is possible to implement a more robust security scheme
since users can be prevented from accessing the physical files and
from connecting as system administrators.
--Mary
On Thu, 8 Sep 2005 13:33:01 -0700, "techiebose"
<techiebose@.discussions.microsoft.com> wrote:

>I have a business directory software done in vb.net and sqlserver .We are
>using msde for distribution purpose .The problem we are facing is about the
>security of the data . The cd goes to common man and we are concerned about
>the security of the data.Is there any option where we can ensure that the
>database cannot be opened by the user . please help
>.Urgent.........................
sql

MSDE from SBS200 on Windows 2k3

Hello,
I am attempting to install MSDE on a client's Windows 2003 server machine
from their Small Business Server 2000 CD containing MS SQL.
The Windows 2003 server unfortunately was partitioned in such a way that I
would like the installation program files, etc. to reside on the D: drive and
not the C: drive.
For some reason I have some vague memory that the destination location for
MSDE cannot be changed from here?
I hope I am wrong and someone can tell me how to fix it. The programs keep
going to the C: drive.
thanks,
Rob
hi Rob,
wallyworld wrote:
> Hello,
> I am attempting to install MSDE on a client's Windows 2003 server
> machine from their Small Business Server 2000 CD containing MS SQL.
> The Windows 2003 server unfortunately was partitioned in such a way
> that I would like the installation program files, etc. to reside on
> the D: drive and not the C: drive.
> For some reason I have some vague memory that the destination
> location for MSDE cannot be changed from here?
> I hope I am wrong and someone can tell me how to fix it. The
> programs keep going to the C: drive.
you can both specify alternate location for data files and executable files
providing the optional
DATADIR="d:\somefolder\" TARGETDIR="d:\somefolder\"
parameters to the setup.exe boostrap installer...
just a note... there's a part of executable that are shared among all
instances of SQL Server 2000/MSDE 2000 that will always be installed in
c:\program files\Microsoft SQL Server\ , and you can not bypass this as,
again, this shared componentes have to be there..
please have a look at
http://msdn.microsoft.com/library/de...stsql_84xl.asp
for additional parameters synopsis..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply