Solved

MS SQL Linked Server via VPN Connection

Posted on 2009-05-04
8
1,286 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

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
 

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

726 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