Re: sql express 2005 security

Thanks, this solution could be useful to me to some extend........!

"bass_player [SBS-MVP]" <bass_player@xxxxxxxx> ¼¶¼g©ó¶l¥ó·s»D:OS7s8$9LIHA.4308@xxxxxxxxxxxxxxxxxxxxxxx
Or...you can encrypt your connection string inside your app.config file
like how you do it in ASP.NET web.config. Here's a sample in C#
http://davidhayden.com/blog/dave/archive/2006/03/14/2883.aspx


"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns99F45900956Yazorman@xxxxxxxxxxxx
Ming (stm@xxxxxxxxxxxxxxxxx) writes:
I can't get your meaning...?!
Since my application will run on a standalone machine, I can't force
user to login using specific username.
If they can login, they can view the data, right?

Also, how could I distribute the application to client with a predefine
Windows a/c?
Cna you tell me more about them?

With Windows authentication, you don't include UserID and Password in
the connection strint, instead you have:

Integrated Security=SSPI;

All that is needed to make sure that the user has access to the server
and database.

And, yes, this means that the user will be able to connect to the
database
by other means to view the data. But that is nothing you can prevent
anyway.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx




.

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)