While trying to open the HITB reset tool, I get a
"There was a problem creating the tables, please contact support"
Google turns up nothing
(No, I haven't contacted support)
Are you logged in as 'sa' when you initialize this tool?
Richard E. Wheeler 2013 and 2014 MVP
Member Microsoft Academic Alliance
www.rbsolutions.com Revered Business Solutions Ballston Lake, NY 518-877-0763 x10
It sounds to me like you have a security issue with the system trying to create the new tables and/or stored procedures.
I would check that the user you are running it under has appropriate rights to the GP database.
Hope this helps,
I ran this as SA
Was there a 'More Info' button to at least give us a clue as to what the problem is? I do not know if the scripts that run can create tables that already exist. We need to find out what the real problem is. Can you try running SQL Profiler while you attempt to initialize the HITB Reset tool?
Nope, that was it. I'll run profiler now and see what I can see
Here's a link to the profiler output
(do a right click, save link as)
What version of SQL are you using?
Unfortunately nothing unusual is in this trace file. It is using the DYNGRP. I would start by checking the mapping of the DYNGRP. It needs db_owner and public on the DYNAMICS and company databases.
You might also check the windows event log to see if it gives you additional error details.
Richard - DYNGRP didn't have DB_Owner, but even after changing that, I have the same error
Adam - Unfortunately there's nothing in the logs
Do you have multiple companies? Can you trying initializing this tool in the Fabrikam company? I am running out of ideas. You may need to open a support call with MS.
Yes, multiple companies. I hadn't tried Fabrikam yet, I'll try that now.
For the Windows event log, did you try on both the server and client?