Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

MS SQL Linked Server via VPN Connection

Posted on 2009-05-04
8
Medium Priority
?
1,390 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
Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

 

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 2000 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

705 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