Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
2  
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
add comment

2 Answers 2

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
add comment

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
add comment

Your Answer

 
discard

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