We just revamp our application from Access to use SQL Express 2005 as
database engine, which is a standalone application running on client PC.
I'm now simulating the scenario when I deploy the DB to client, how can I
protect the database (or some tables) from being read by them?
Since this application will distribute to client PC, which is out of our
control, so we must choose SQL authentication.
What I got is, when I setup a SQL express in a new machine, and attach the
database I want to protect, login as 'sa', I can read everything inside, no
matter what & how I set.
Is it true that I can't protect database/table in SQL authentication mode?
Re: Database Server based on SQL database ... the raw database over WAN. ... So I will write a server program which receives requests from clients via ... Should I base this protocol on SQL or design my own protocol. ... ie the client doesn't have OLE DB, ADO, DAO or whatever installed - ... (microsoft.public.win32.programmer.networks)
Re: DataSet.GetChanges() in RowChanged(DataRowAction.Add) ... have you considered SQL Express and use ... > I realize now that I didn't describe well how the client application is ... > Framework installed on the client machine, but not any SQL Server).... > 20 tables in different relations with eachother in the database,... (microsoft.public.dotnet.framework.adonet)
Re: SBS 2003 and Sql Server ~ Client Install ... but as a client, there are many applications that can act as client as already pointed out. ... Access front end to a SQL database, Excel can be a front end, A word mail merge document could access a SQL database via ODBC. ... We are trying to install the client software. ... (microsoft.public.backoffice.smallbiz2000)
Re: Quick Question on SQL Server 2005 Express ... run queries/change tables/etc using the Management Consule for a SQL Server... server to a client anyway. ... We are moving an Access database over to SQL Server ... (microsoft.public.sqlserver.setup)
Re: Datasets fundamental ...client the way they want. ... loading from the Database into this "cache" and you want to update on a ... another option is using SQL 2005 Express and having it ... You then move from a custom "cache" solution to a normal replication type of ... (microsoft.public.dotnet.framework.adonet)
