Protect MDF Only 1 user can access



I'm new on protection !
i use sql server 2005 express sp2

I need to create a database that can be read on other computers simply by copying MDF and LDB files by using Attached file connection.
What i desire is to create a username like FLAVIO and password like xxxx and in any computer with sql server installed only with this credential i can access.

thanks in advance
Flavio



.



Relevant Pages

  • Re: Issue with ASP/IIS and remaining Access 2K lockfile .ldb
    ... Bob Barrows wrote: ... I should add that it is not a good idea to delete the ldb files if a user is ... currently connected to the database. ... server-based database such as SQL Server (the MSDE version of SQL Server ...
    (microsoft.public.inetserver.asp.db)
  • Re: Issue with ASP/IIS and remaining Access 2K lockfile .ldb
    ... Bob Barrows wrote: ... I should add that it is not a good idea to delete the ldb files if a user is ... currently connected to the database. ... server-based database such as SQL Server (the MSDE version of SQL Server ...
    (microsoft.public.inetserver.asp.general)
  • Re: Issue with ASP/IIS and remaining Access 2K lockfile .ldb
    ... Bob Barrows wrote: ... I should add that it is not a good idea to delete the ldb files if a user is ... currently connected to the database. ... server-based database such as SQL Server (the MSDE version of SQL Server ...
    (microsoft.public.inetserver.iis)
  • Re: MS OLE DB Provider for SQL Server Error: Invalid authorization
    ... Meaning it works from other computers, ... >> The middle tier uses SQL OLE DB to talk to the database. ... > So how does the part of the connect where the connection string is set ... > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...
    (microsoft.public.data.oledb)
  • how to snyc 2 databases
    ... i seem to be missing some records from my sql server 2005 ... database after copying over the mdb and ldb files from a sql server 2000 ... i now need to import records missing in my 2005 db. ...
    (microsoft.public.sqlserver)