Command Line does not carry edition over UNC Path

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Command Line does not carry edition over UNC Path

Postby swelsh » Fri May 02, 2014 5:12 pm

I have a PowerShell script that I wrote to dynamically propagate a call to SQLDataCompare.exe on a UNC path. The current host with the professional edition on it is Windows Server 2003, SQL Data Compare 10.2

We are shutting down this server, and the replacement host is Windows Server 2012 R2, Data Compare 10.7

When I updated my PowerShell script to use the UNC path to the new server, it is no longer reconizing the install on the new server as Professional edition. If I log in to the server and launch the GUI, it is showing professional edition, and I can also run sqldatacompare.exe directly on the host and it recognizes that it is professional edition. It is only when I access it over the UNC path from another host that it is showing a different, standard edition key.

Any help would be greatly appreciated.
swelsh
 
Posts: 9
Joined: Fri Jan 13, 2012 1:10 am
Location: Palm Harbor, FL

Postby eddie davis » Mon May 05, 2014 9:49 am

Thank you for your forum post.

I suspect that this is either a security permissions problem or a network / DNS problem.

The edition of SQL Data Compare does not change if you use it on the local machine or connect to it remotely.

I quote from your post:
It is only when I access it over the UNC path from another host that it is showing a different, standard edition key.


When you use the unc path connection, are the details of the standard edition license key identical to the local machine and view the professional license via the GUI ->Help ->about? If the license information is not identical, I suspect that DNS has not resolved to the correct machine.

If you ping the new Windows Server 2012 R2, Data Compare 10.7 host, does it resolve the correct machine name to IP address?

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

Postby swelsh » Mon May 05, 2014 8:09 pm

Eddie,

I tried the ping from the server running the PowerShell to the new host server, and it resolved correctly. I also verified the IP/name resolution using NSLookup compared the ipconfig on the new host server.
swelsh
 
Posts: 9
Joined: Fri Jan 13, 2012 1:10 am
Location: Palm Harbor, FL

Postby eddie davis » Thu May 08, 2014 9:34 am

Thank you for your reply.

This does not make any sense, a single installation of SQL Data Compare cannot be activated using two different license serial numbers.

A support ticket has been created for you which can be reviewed HERE.

I will send an email requesting some screen shot information, details of the licensing files on the machine and registry key information.

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 943
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests