Solved

MS SQL Linked Server via VPN Connection

Posted on 2009-05-04
8
1,212 Views
Last Modified: 2012-05-06
I have a good working VPN connection; know the sa password and have another account on the remote SQL Server.  I am trying to set up the Linked Server to connect to the remote db within my local SQL Management Studio envirnoment.  I have a Linked Server...how can I see the remote databases?

Thx
0
Comment
Question by:Glen_D
  • 4
  • 4
8 Comments
 
LVL 13

Expert Comment

by:usachrisk1983
ID: 24298610
If you've linked your database to the remote database, you would query it as below (assumes your link name is "myLink"):

select * from mylink..myTable;

And those are two periods after the dblink name.  You'd still separate tables and columns with one period.
0
 

Author Comment

by:Glen_D
ID: 24298688
Thanks but I didn't link my db to the remote db...just set up the linked server. Is there a way to actually see the remote db and all items, tables, sp, functions, etc?

Thx
0
 
LVL 13

Expert Comment

by:usachrisk1983
ID: 24298726
Hi Glen,

Is your end goal to be able to just see and manipulate the objects in the remote database, or have your local database interact with the objects in the remote database?

Thanks!
Chris.


0
 

Author Comment

by:Glen_D
ID: 24298863
Thx for the tip...I figured out a way to do this by right clicking the local server and then select connect, IP, credentials.
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:Glen_D
ID: 24298883
My end goal was to see and manipulate the objects in the remote db.  Just ran into another issue though...I'm running 2005 E locally & the remote is 2008 S.  I can't connect with 2005 to 2008 so I'm going to install a local version of 2008 as well.

Thoughts?

Thx
0
 
LVL 13

Accepted Solution

by:
usachrisk1983 earned 500 total points
ID: 24298960
You can download the 2008 studio from here (free):
http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

You will be able to connect, over IP, to a remote 2008 server using this studio.

For future reference, a "linked server" is when you virtually link two databases together so that you can connect to one and "call out" to the other.  For example you might create a single view that contains data from your local database and your linked server -- that's where the confusion came from.


0
 

Author Closing Comment

by:Glen_D
ID: 31577722
Thanks...really an Oracle guy but working in MS SQL.   I'm downloading a 2008 version now.
0
 
LVL 13

Expert Comment

by:usachrisk1983
ID: 24299076
No sweat, I'm an oracle guy, too ;)  Linked Tables in MSSQL are just the same as DBLinks in Oracle.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server encoding for storing Indian languages 9 38
SQL Server stored proc 2 14
SQL Query Syntax Join 4 35
sql query questions 2 26
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now