I would like to know if it's possible to embed a SQL Server 2000/2005 DB
within a desktop application so that the end users cannot view the DB.
Also, this will prevent them from copying the database on to their other
SQL Servers.

Also, what are the options to load SQL Server 2005 on Win 98


*** Sent via Developersdex http://www.developersdex.com ***

mal hit (malehit@yahoo.com) writes:
> I would like to know if it's possible to embed a SQL Server 2000/2005 DB
> within a desktop application so that the end users cannot view the DB.
> Also, this will prevent them from copying the database on to their other
> SQL Servers.

You can never hide anything from the system administrator. If users does
not have admin rights on their boxes, you could hide the databases. But
that would only work within an organisation.

> Also, what are the options to load SQL Server 2005 on Win 98

SQL 2005 does not run on Windows 98.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Erland Sommarskog wrote:
> mal hit (malehit@yahoo.com) writes:
> > I would like to know if it's possible to embed a SQL Server 2000/2005 DB
> > within a desktop application so that the end users cannot view the DB.
> > Also, this will prevent them from copying the database on to their other
> > SQL Servers.
>
> You can never hide anything from the system administrator. If users does
> not have admin rights on their boxes, you could hide the databases. But
> that would only work within an organisation.
Correct. To expand further. You need to design a database security
strategy based on SQL roles and capabilities. Not just on *hide from
users* vague concepts. I suggest you get some better understanding of
SQL security features before you design an efficient security strategy
plan...


> > Also, what are the options to load SQL Server 2005 on Win 98
>
> SQL 2005 does not run on Windows 98.

> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pro...ads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinf...ons/books.mspx