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?
LVL 8
teomcamAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

David ToddSenior DBACommented:
Hi,

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.

Regards
  David
0
teomcamAuthor 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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
teomcamAuthor Commented:
This is the solution.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Forefront ISA Server

From novice to tech pro — start learning today.