DataMigrator/Reporting Server > Preparing the Microsoft SQL Server ODBC Environment

Preparing the Microsoft SQL Server ODBC Environment

Topics:

The Microsoft SQL Server environment is set up during the installation of the Microsoft SQL Server 2012 or 2014 and the ODBC Driver 11 or higher for SQL Server.

No additional setup steps are required.

Accessing Microsoft SQL Server Remotely

You can access Microsoft SQL Server on a remote node. To access Microsoft SQL Server remotely, you must:

  • Locally install the latest version of Microsoft SQL Server Native Client and ODBC Driver 11 or higher for SQL Server.
  • Know the name of the remote Microsoft SQL Server instance.

All Microsoft SQL Servers installed are defined by using a unique NetBEUI name. The server can access any Microsoft SQL Server on the network, provided you define a valid user ID and password, as well as the name of the Microsoft SQL Server instance. You can define these parameters in either the server global profile or a user profile.

WebFOCUS

Feedback