Accessing Remote Data  «Prev  Next»
Lesson 1

Introduction to Accessing remote data Sources

Up until now, you have been accessing data that resides on only one server, and possibly in only one database. Did you know that you can access data from tables that are not on the same server?
This is possible. In fact, you can also execute stored procedures located in another database on another server. This module shows you how to do all that.

Learning objectives

After completing this module, you will be able to:
  1. Set up servers for remote data
  2. Execute remote stored procedures
  3. Construct and execute queries from remote data sources

In the next lesson, you will learn how remote data access is achieved in SQL Server 2012.

Using Remote Data Sources

If the report retrieves data from a remote database server, verify the following:
  1. The credentials provided to the database server are valid. If you are using Windows user credentials, make sure that the user has permission to the server and database.
  2. Ports used by the database server are open. If you are accessing SQL Server relational databases on external computers, or if the report server database is on an external SQL Server instance, you must open port 1433 and 1434 on the external computer. Be sure to restart the server after you open ports. For more information, see Configure a Windows Firewall for Database Engine Access.
  3. Remote connections must be enabled. If you are accessing SQL Server relational databases on external computers, you can use SQL Server Configuration Manager tool to verify that remote connections over TCP are enabled.