Command Line does not carry edition over UNC Path
swelsh
Posts: 13
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.
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.
Comments
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:
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com
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.
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com