Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1464
  • Last Modified:

MS SQL Linked Server via VPN Connection

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
Glen_D
Asked:
Glen_D
  • 4
  • 4
1 Solution
 
usachrisk1983Commented:
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
 
Glen_DAuthor Commented:
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
 
usachrisk1983Commented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Glen_DAuthor Commented:
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
 
Glen_DAuthor Commented:
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
 
usachrisk1983Commented:
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
 
Glen_DAuthor Commented:
Thanks...really an Oracle guy but working in MS SQL.   I'm downloading a 2008 version now.
0
 
usachrisk1983Commented:
No sweat, I'm an oracle guy, too ;)  Linked Tables in MSSQL are just the same as DBLinks in Oracle.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now