Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to export data from an MSSQL server that ACT uses. It is ACT 2005. I have tried tons of different things, from trying to starting the MSSQL server in single user mode (still can't login), I have tried copying the mdf files from it and putting it on another server (it complains about having the same name as another database for master.mdf and almost every other file), I have tried putting Administrator in the group that the MSSQL instance runs under, and nothing seems to work! Can anybody with experience with this help me out? Thanks!

share|improve this question
Single-user mode should do what you need. – Evan Anderson Feb 24 '10 at 4:05
What version of SQL Server 2005 are you working with? The master.mdf is not the application database, that is a system database for SQL Server. – Shawn Melton Nov 9 '12 at 13:32

ACT secure the DB to prevent access by anything other than it's own tools. They have a procedure on their site whereby you can request access to a tool that will provide you with the account credentials - I think they try to specify some usage constraints that you can only use the account to enable your own backups outside of ACTs tools.

... but in an previous job we used it to allow us to query customer data for use within another application and it worked pretty well.

share|improve this answer

Use the File|Export|Text File function.

share|improve this answer
I don't think this is going to help much if he can't login to the DB. – Chris S Jul 18 '10 at 14:57

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.