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) |
|