Solved

Time Matters 11 in Windows 2008 Domain Environment

Posted on 2013-06-26
7
283 Views
Last Modified: 2013-07-22
Dear Experts,

We are performing a migration from a Windows 2003 domain to a brand new Windows 2008 domain.

We performed the migration of 10 or so computers and tested.  Everything is working perfectly except for the application Time Matters.  We had to back out of the migration until we get this problem fixed.

Here is a summary of the problem and the troubleshooting we have done so far:

Problem:  When we launch Time Matters (v11) we connect to the SQL database just fine.  The application opens and it seems that it functions ok as well.  However, at the same time the application opens, an error message also opens.

Screenshot of the error message
Of course, we go down the rabit hole of looking at the Support Article the error message references and ultimately says there is an issue with SQL (in brief).  

When we close the application and close the error message two or three times, it finally leaves us with another error message:

Screenshot of second error message
Here is a summary of the troubleshooting we've done to determine that it is NOT a SQL related issue.

From the machine that has been migrated already to Windows 2008 (PC#1), we connect to the new database AND the old one and get the same message.

All of the other machines that are still on the old domain, connect to both databases - old and new - without an issue or error message

On PC#1, logged in with a brand new user account and let Windows create a brand new profile.  Get the same error message on both databases

Unlinked all GPOs on the default domain policy on the new Windows 2008 domain.  PC#1 has absolutely no GPOs being applied.  Same error on both databases

Unjoined domain on PC#1, no error messages EITHER database

No firewall running and AV disabled for troubleshooting

We do NOT have an active support contract with Lexis Nexis / Time Matters so cannot call them.  I can't even buy a per incident support case.

Thanks for your help.

Mark
0
Comment
Question by:MarkDJordan
  • 4
  • 3
7 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 39280015
What are the workstations running?
0
 

Author Comment

by:MarkDJordan
ID: 39280443
Most are Windows XP SP3 32 bit.
One Windows 7 Pro SP1 64 bit
Same issues on both OSes.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 39283326
I'm shooting totally in the dark on this so bear with me.

Do the same logins/users with matching SIDs exist on both sides?

A way to check is the sp_help_revlogin script.
http://support.microsoft.com/kb/918992

Is there a service running on the old server that is not on the new?

Is there a config file or registry entries that don't match?

Dump the registry to files and then use Beyond Compare (scootersoftware.com) to compare the files.

I'm guessing it is a userid/login issue that is masquerading as something else.

I do
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:MarkDJordan
ID: 39283635
Thanks Jimpen,

Remember, computers on the OLD domain can use the application fine while connecting to the NEW database on the NEW server.

So, although I like your thinking, the configuration of the server, SQL or shared Time Matters application data folder, on not the issue.

The problem only starts to occur once the computer joins the NEW DOMAIN.

By the way, in my early troubleshooting I did use Beyond Compare to see the differences in the shared Time Matters application data folders.  There are a number of INI files in there and everything is tip top.  Good idea on the registry comparison, but again, cant be the problem or all computers would have a problem.

Thanks for your suggestions.  Still working towards a resolution.

Yesterday I tried to update the SQL drivers on the client machines, to no avail.

Thanks,
Mark
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 39285972
That sounds like a SID issue then.

Is there a table in the database that has the computer names and or SIDs?
0
 

Accepted Solution

by:
MarkDJordan earned 0 total points
ID: 39325825
The issue turned out to be an entry in the database that was pointing to the wrong path for EXE file.  It was pointing to the old server.  Once this was manually updated, things started to work normally.

screenshot of SQL query
Thanks all.
0
 

Author Closing Comment

by:MarkDJordan
ID: 39345148
Provided detailed SQL query statement on how to resolve.
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Issue idenitfying Microsoft update patches within a "rollup" package 7 32
extended monitor print screen 8 33
Office 2016 GPOs in Server 2012R2 5 28
Application Crash 2 23
In this article, we will see the basic design consideration while designing a Multi-tenant web application in a simple manner. Though, many frameworks are available in the market to develop a multi - tenant application, but do they provide data, cod…
This article runs through the process of deploying a single EXE application selectively to a group of user.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question