Our Products:   CompleteFTP  edtFTPnet/Free  edtFTPnet/PRO  edtFTPj/Free  edtFTPj/PRO
+1 vote
1.4k views
in FAQ: CompleteFTP by (161k points)

1 Answer

–1 vote
by (161k points)
selected by
 
Best answer

You can directly query the configuration database using this tool

Make a copy of C:\ProgramData\Enterprise Distributed Technologies\Complete FTP\config.sdf, install the viewer and then open the copy using the viewer.

Then run this query (or similar) in the query editor:

SELECT UserName,FullName,Description from [User]

You can copy and paste the result.

by (110 points)
Thanks but it appears the link originally provided does not have a tool, it is just literature about how to use SQL Server Compact, I cannot find where to download this tool in the Microsoft site, can you please confirm the tool or suggest another to use to accomplish this task?   Thanks.
by (110 points)
edited by
At least in my case I had to install Microsoft's SQL Server Management Studio Express, found at:

http://go.microsoft.com/fwlink/?LinkId=144346

Which provided the opportunity to select Server Type "SQL Server Compact" , not just "Database Engine".  When SQL Server Compact is chosen, the ability to select a file like config.sdf  is provided, and it works!! :)

To be clear, the option to open "SQL Server Compact" is NOT AVAILABLE on SQL Server Management Studio 2016, which is why you need to install the older Management Studio to get that option.  Hope this helps.
...