TMG 2010 reporting not working, must access user activities asap

TMG 2010 reporting is not working. I searched but I couldn;t find fix yet. This morning we have received a request by local authorities for a particlar user activities. Since I couldn't make the reporting get work I need to access and extract with any/someway. Can I access SQL 2008 database which came along with the TMG and export the datas. If yes how can I do that?
Who is Participating?
teomcamConnect With a Mentor Author Commented:
I found the solution on another foreign website. Changed the region local from Australia to US and fixed the problem.

Set the local region setting to Format English (United States) MM/dd/yyyy and set your present location to US.  You need to make sure that you restart the SQL reporting services and some SQL (TMG) related services as well.
David ToddSenior DBACommented:

You need to look for SSMS in start menu.

If that doesn't work, have a scan through the program files directory and look for sqlcmd. Its a command line application.

Let us know which you find.

If you don't find anything, then I suggest downloading an evaluation copy of sql (preferably 2008 in this instance, but 2012 will work) and installing _just_ the tools on your workstation.

teomcamAuthor Commented:
This is the solution.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.