MySql Backup

Welcome Guest Search | Active Topics | Log In | Register
No such host is known Options · View
Guest
#1 Posted : Thursday, June 14, 2012 12:48:16 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
I go to connect to my remote db, and I can successfully establish a test connection, but when I click "save and close" I get the error "No such host is known".

Any ideas?
AlexP
#2 Posted : Thursday, June 14, 2012 1:31:31 PM
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 822
Hi,

Can you provide us test access to your SQL server to check the issue?
Please use contact us form if it's possible.
Guest
#3 Posted : Thursday, June 14, 2012 4:10:50 PM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
Sorry I can't as it's a live server.

It is a shared hosting environment, I log on with SQL authentication.

The details I am typing in are as follows:

Server Name: kirk.techservers.net,2433

User Name: can'ttellyouthisoriwillbefired

Password: can'ttellyouthisoriwillbefired


I can use those details fine with SQL Server Management Studio to connect.
AlexP
#4 Posted : Monday, June 18, 2012 12:26:04 PM
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 822
Hi,

Thank you for the reporting.
The issue is fixed and we are going to publish the release soon. Will update you here.
AlexP
#5 Posted : Tuesday, June 19, 2012 12:18:34 PM
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 822
Hi,

Could you please check the issue on the latest release 7.2.0?
Guest
#6 Posted : Wednesday, July 4, 2012 11:30:42 PM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
The update to 7.2.4 fixed the log on issue.

THANKS!!!
Guest
#7 Posted : Thursday, July 5, 2012 10:54:14 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
I am still getting this error when connecting to a remote host in the free version 7.2.4.15036. "Test SQL Connection" works fine but "Save and close" gives me "No such host is known"
AlexP
#8 Posted : Thursday, July 5, 2012 11:08:08 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 12/1/2011
Posts: 822
Hi,

At least please tell us how the connection string looks like. We'll try to reproduce the issue then.
AlexC
#9 Posted : Tuesday, July 10, 2012 8:08:22 PM
Rank: Member

Groups: Registered

Joined: 7/10/2012
Posts: 10
Hello, I am new to this program and just ran across this bug. Here is some info that may help:

* Windows 2008 R2 - AWS-EC2 (small instance)
* SQL Server 2008 R2 Express
* SQL Backup and FTP - 7.2.2 Free & 7.2.4 Free
* Both Server-A and Server-B on same subnet using Amazon VPC
* SQL Server Management Studio Express is able to connect from Server-A to Server-B, and the other way around
* On the 'Connect to SQL Server' window, in the Server Name text field all I have is the IP, 10.111.222.333
* Tried both with Windows Auth and SA password
* 'Test SQL' works
* 'Save & Close' fails

Sorry, proprietary data so can't give you direct access. We can work out a time for a desktop sharing session to help diagnose.

Thanks.
AlexC
#10 Posted : Wednesday, July 11, 2012 10:55:42 AM
Rank: Member

Groups: Registered

Joined: 7/10/2012
Posts: 10
WORKAROUND FOUND

This thing really bothered me: why should 'test' work but 'save' fail? To my mind I see the logic as follows:

* TEST button -> Call TestLogic -> END
* SAVE button -> Call TestLogic -> Save to disk -> Close window -> END

And why the message 'no such host is known'?


Since my servers are standalone machines in a VPC there is no DNS to resolve them and this is why I used an IP address in the connection box.

And why the message 'no such host is known'?

Did a quick change to file c:\windows\sysetm32\drivers\etc\hosts and mapped the IP to a name. Updated the connection box in SQLBackupAndFTP. Now both TEST and SAVE work.

SAVE now provides this additional information: You are connecting to a remote SQL Server Instance. The backup will be done using Scripting (Beta) - use at your own risk! . . .


Hope this helps others that may be having the thread subject error.

Regards,

Alex C. (user)
Alexander Omelchenko
#11 Posted : Monday, August 15, 2016 4:44:02 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 457
Thanks for the workaround!
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com