Hi,
I just upgraded from Version 10.2.14 to 11.7.1 (Windows Server 2012) and have problems getting the Service to run properly. DotNet-Version ist 4.03.30319.
First, it didn´t start at all (time out)
After checking some of the Topic here I changed the serviceaccount to one with more rights. Then it started, but the application can´t validate the licence key.
Now I went back to Version 10.2.14…
Since we have limited access to the configuration of our servers because of security reasons from our datacenter (for example I can´t make any changes in dcom config) I think I need a solution to get the app running without Internet Connection or a service at all (like the Version 10.2).
Greetings
Markus
Hi Markus,
Could you please clarify do you use Free edition of SQLBackupAndFTP?
For the correct work, SQLBackupAndFTP version 11.7.1 requires .NET Framework version 4.6.0 or above to be installed on your computer, also you have to have a stable internet connection.
If you use SQLBackupAndFTP version 11.7.1 Free edition then it can be used without the internet connection.
If there is no way to install .NET Framework version 4.6.0 or above you can use SQLBackupAndFTP version 11 for older .NET Framework version 4.0.0 which can be downloaded at https://sqlbackupandftp.com/download
Hi Alexander,
we want to run the Professional Version because of aes encryption.
Now I tried Version 11.3.12 but I still have the Problem with the missing internect Connection.
I like SQLBackupAndFTP, but if there is no chance of getting it work without Internet Connection, I have to switch to another Software.
Greetings
Markus
Hi Markus,
Sorry, but currently there is no way to use SQLBackupAndFTP (except Free edition) without a stable internet connection. We’ll consider your request, thank you.
Could you please clarify, you do not have an internet connection at all or you use a Proxy Server?
Hi Alexander,
we use a Proxy Server and the User-ID I start the Service with doesn´t has the rights to access the Internet.
Greetings
Markus
Thank you, Markus, for the clarification. If you use Proxy Server, you can try to set your Proxy Settings for SQLBackupAndFTP. You can find these settings by clicking “Tools” > “Proxy Settings…”.
I can´t edit the Proxy Settings, because when i open the app it wants me to restart the service.
Hi Markus,
If there is no way to restart the service, please use the following workaround:
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
