Upgrade License Offline

Licenses, subscriptions, prices, payments
1

Hi,
I have the license for SQLBackupAndFTP but the SQL Server where I want to install this tool have no internet access. So it there any way to upgrade the license offline.

I have tried to provide the internet on the server by proxy but still it not working. It might be because it uses any other protocol than HTTPS to verify the license key. And that protocol is blocked on the server.

So can you tell me which protocol you use to verify the license key So that I can enable that particular protocol on the server or Is there any way to upgrade offline?

2

Hello,

If you can connect to Internet via proxy you can configure SQLBackupAndFTP application to use your proxy server for Internet connection. To enable connection via a proxy server, you need to create ConnectionSettings file without extension in C:\ProgramData\Pranas.NET\SQLBackupAndFTP\Client folder.
Please remember restart “SQLBackupAndFTP (SQL Server backup)” windows service after updating the configuration to load new settings.

For example:

<?xml version="1.0" encoding="utf-8"?>

< ConnectionSettings xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=“http://www.w3.org/2001/XMLSchema” xmlns:pranas=“http://www.pranas.net/2012/XMLSchema”>
< WebConnection WebConnectionType=“Proxy”>
< WebProxySettings Address=“127.0.0.1:3128” UseDefaultCredentials=“False” BypassProxyOnLocal=“False”>
< Credentials UserName=“UUU” Password=“PPP” />
< /WebProxySettings>
< /WebConnection>
< /ConnectionSettings>
Where 27.0.0.1:3128 is a proxy address, UUUis a proxy user name and PPP is a password.

To use proxy connection only for all web requests and FTP requests using OPEN command, you should write content like in the example below:

<?xml version="1.0" encoding="utf-16"?>

< ConnectionSettings xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=“http://www.w3.org/2001/XMLSchema” xmlns:pranas=“http://www.pranas.net/2012/XMLSchema”>
< WebConnection WebConnectionType=“Proxy”>
< WebProxySettings Address=“27.0.0.1:3128” UseDefaultCredentials=“False” BypassProxyOnLocal=“False”>
< Credentials UserName=“UUU” Password=“PPP” />
< /WebProxySettings>
< /WebConnection>
< FtpConnection FtpConnectionType=“Proxy”>
< FtpProxySettings AuthenticationMethod=“Basic” BypassProxyOnLocal=“False” Host=“27.0.0.1” Port=“2121” ProxyType=“FtpOpen”>
< Credentials UserName=“UUU” Password=“PPP” />
< /FtpProxySettings>
< /FtpConnection>
< /ConnectionSettings>

Please find the files with a simple configuration and full configuration specifications by the following link https://www.dropbox.com/sh/7kkoi1b1kyoi85a/AAD6Z6wzIBKw2YDBHZXUJ8_ua?dl=0

3

Thanks, Alexander,

It worked.

4

Good news! Please feel free to contact us on any issues or concerns.

5

I can not connect to the internet at all due to new security policy.
I have autorenew subscription but I can not refresh by lisence.
I’d appreciate a speedy reply as by backups are halted.

6

Hi,

Sorry, but for the correct work of SQLBackupAndFTP you have to have a stable internet connection. If you use Proxy Server to connect to the internet please add appropriate settings by clicking “Tools” > “Proxy Settings…”. Without the internet connection, you can use only Free edition.

Sorry for the inconvenience.

7

Hi.

  1. After the new installation the proxy settings were configured within the application
  2. The ConnectionSettings file exists in the appropriate folder and all proxy settings were found as correct
  3. After upgrading up to 12.5.5 the service does not start

Please advise and thank you in advance

8

Hi Ilan_Amir,

Could you please add SQLBackupAndFTP to your antivirus and/or profiler exception list and check if it works.

If you still have this issue, please check your Windows Event Log (Application and System) are there any error messages related to SQLBackupAndFTP?

Sorry for the inconvenience.