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!
Asked
Active
Viewed 785 times
0
-
2Single-user mode should do what you need. – Evan Anderson Feb 24 '10 at 04: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. – Nov 09 '12 at 13:32
2 Answers
1
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.
Chris W
- 2,670
- 1
- 23
- 32
