Would you know if i have to have the connection open for the linked server to work? Once the linked server is established then SQL Server should be able to access it correct? That didnt work as well. It started opening command line ssh connection for every 1 minute. I feared it would happen and it did. The content you requested has been removed. Ask a question. Quick access. Search related threads. Remove From My Forums.
Asked by:. Archived Forums. Sign in to vote. Created a putty session with port forwarding 2. Added the private key to it 3. Used the putty session to create an odbc connection on my server. Created a linked server using that odbc connection in my SQL Server Issue: When i have to query the linked server i have to have the putty session open. I can then actually test the connection by telnetting to localhost , and I get a connection: the screen clears and I can type characters to some listening process.
I am sure that the server accepts remote connections, because I have connected to it remotely while logged in via RDP to a different machine within the remote network. I have Googled around to know that this is possible; does anyone have some idea why this isn't working, or what I might do to diagnose and hopefully fix the problem? On the remote network which we don't control , for security purposes, it appears that the database servers are set up to ignore database requests coming from the gateway machine.
So I guess there's just no good solution short of convincing them to give us full VPN access. Thanks everyone for your help.
Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 10 years, 5 months ago. Active 2 years, 5 months ago.
Viewed 40k times. In my development shop, we deploy code on virtual servers that sit on a remote network. But when I try to connect SSMS to localhost, it times out and then claims that there is no SQL Server listening on that port: Cannot connect to localhost Additional information: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
Improve this question. Jim Burnell. Jim Burnell Jim Burnell 3 3 gold badges 8 8 silver badges 19 19 bronze badges. I assume wherever you typed you meant ? I tried to edit it, but there are only 2 characters worth of typos and to submit an edit, you have to make at least 8 characters of changes.
Pretty sure the OP can make small edits, though. Updated all s to s. Approximate size Age rating For all ages. This app can Access all your files, peripheral devices, apps, programs and registry Microsoft.
Permissions info. Installation Get this app while signed in to your Microsoft account and install on up to ten Windows 10 devices. This product needs to be installed on your internal hard drive. Language supported English United States. Seizure warnings Photosensitive seizure warning.
Report this product Report this app to Microsoft Thanks for reporting your concern. Our team will review it and, if necessary, take action. Sign in to report this app to Microsoft. Report this app to Microsoft. Report this app to Microsoft Potential violation Offensive content Child exploitation Malware or virus Privacy concerns Misleading app Poor performance.
0コメント