Re: How to retrieve database password

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

All I have are the old .SQL files no MDF files were created.

"Jens" <Jens@xxxxxxxxxxxxxxxx> wrote in message
news:1136994106.307693.42900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> If you have the MDF files, just attach the database to a new instance
> of MSDE with sp_attachDB.
>
> If you mean a specially created user in the database or server AFAIK
> which the application will use for connection and which is not known to
> you, this password cannot be recovered. (If you have no access to the
> stored password in the source code)
>
> HTH, Jens Suessmeyer.
>


.

Relevant Pages

  • strange setup for a datawarehouse server?
    ... would ever restore a database would be to get an object back, ... how many LDF and MDF files should our databasehave? ... set up with 4 MDF files and 4 LDF files. ... I've read BO's backing up the transaction log and ...
    (microsoft.public.sqlserver.setup)
  • Re: Creating SQL Server Databases With No Security Restrictions
    ... > this question involved both MSDE and security settings. ... We are able to copy the .mdf files to the ... > to create a database link to the file (Connect To Database button on ... > appears in the list of databases under the SQL Server instance and is ...
    (microsoft.public.sqlserver.msde)
  • Re: Creating SQL Server Databases With No Security Restrictions
    ... > this question involved both MSDE and security settings. ... We are able to copy the .mdf files to the ... > to create a database link to the file (Connect To Database button on ... > appears in the list of databases under the SQL Server instance and is ...
    (microsoft.public.sqlserver.security)
  • Re: schema compare problem
    ... mapped the system databases setting database role membership to db_owner. ... we are trying to connect to local .MDF files ... If we attach the .MDF file to SQL Server Express, ... Management Studio Express - No. ...
    (microsoft.public.dotnet.framework.adonet)
  • How do I find out SQL Server instance name and username
    ... those old database (.ldf and .mdf files) I have found an 3rd party, ... something to clean up my MSDE DB because I figured out ISA is accessing ... Server instance name" and "username" that are required to establish ...
    (microsoft.public.isa.configuration)