November 25, 2013 at 12:11 pm
Hi all,
I am trying to create a linked server from our amazon sql box to our local box and I get a "login timeout expired" error. The firewall is open on port 1433 and I am able to access the database on amazon. I have tried the following code. Any help would be appreciated. Thank you.
EXEC sp_addlinkedserver 'MYSERVER', '', 'SQLOLEDB', 'IP Address,1433'
EXEC sp_addlinkedsrvlogin 'MYSERVER', 'FALSE', NULL, 'local_login', 'password'
EXEC sp_addlinkedserver 'MYSERVER', '', 'SQLNCLI', 'IP Address,1433'
EXEC sp_addlinkedsrvlogin 'MYSERVER', 'FALSE', NULL, 'local_login', 'password'
November 25, 2013 at 12:29 pm
<removed previous content>
November 25, 2013 at 12:32 pm
Below are the errors when I try to run a select statement:
OLE DB provider "SQLNCLI11" for linked server "my_server" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "my_server" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 10060, Level 16, State 1, Line 0
TCP Provider: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
November 25, 2013 at 1:00 pm
Please disregard this post, there is all sorts of wrong with it. The local server is not an outward facing server, so it is impossible for the aws server to find it though IP or DNS name. Case closed.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply