My Oracle Support Banner

Step-By-Step Guide To Creating A Data Source Which Connects To A Microsoft SQL Server Database (Doc ID 1376537.1)

Last updated on AUGUST 20, 2019

Applies to:

Oracle WebCenter Portal - Version 11.1.1.5.0 to 11.1.1.7.1 [Release 11g]
Information in this document applies to any platform.

Purpose

The purpose of this bulletin is to give an example on how to create a JDBC data source in WebLogic Server which connects to a MS SQL Server database.

This example was done using the following setup, but similar principles may be used with other combinations of version :

This data source may be used to create Mashups in WebCenter Portal to display and format the data.

Scope

This bulletin does not detail the installation or configuration of the WLS, WebCenter Portal or SQL Server instances.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Gather the information required
 Create the Data Source
 Troubleshooting
 Errors seen when Testing Connection
 Problem 1 - Can not make a database connection to the given URL
 Problem 2 - Login failed for user

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.