Solved

MS SQL Linked Server via VPN Connection

Posted on 2009-05-04
8
1,255 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
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
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.
Viewers will learn how the fundamental information of how to create a table.

828 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