|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 938
|
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?
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 419
|
Hi, Can you provide us test access to your SQL server to check the issue? Please use contact us form if it's possible.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 938
|
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.
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 419
|
Hi,
Thank you for the reporting.
The issue is fixed and we are going to publish the release soon. Will update you here.
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 419
|
Hi,
Could you please check the issue on the latest release 7.2.0?
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 938
|
The update to 7.2.4 fixed the log on issue.
THANKS!!!
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 938
|
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"
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 419
|
Hi,
At least please tell us how the connection string looks like. We'll try to reproduce the issue then.
|
|
|
|
Rank: Member
Groups: Registered
Joined: 7/10/2012
Posts: 11
|
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.
|
|
|
|
Rank: Member
Groups: Registered
Joined: 7/10/2012
Posts: 11
|
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)
|
|
|
|
|
