Microsoft SQL server data source creation in Weblogic

Microsoft Sql Server

Please follow below steps to create the microsoft sql server data source in weblogic.

Create new Datasource
Login as administrator to weblogic Admin Console
MyDomain -> Services -> JDBC ->DataSources -> New
Name: SQLDataSource
JNDI Name: jdbc/SQLDataSource
Database Type:  MS SQL Server
Database Driver: BEA MS SQL Server Driver (Type 4) Vesions 7.0, 2000,2005
Next
Leave the Supports Global Transactions (Checked)
Next
Database Name: MSSQLEnterpriseServices
Host Name: tire904\webtechpaste
Port:  1433
Database User Name: ES_javaUser
Password:  Pass
Confirm Password: Pass
Next
Driver Class Name: weblogic.jdbc.sqlserver.SQLServerDriver
URL: jdbc:bea:sqlserver://hostname\db:1433
Database User Name: ES_javaUser
Password: should be filled in
Confirm: should be filled in

Properties:
user=ES_javaUser
portNumber=1433
databaseName= MSSQLEnterpriseServices
serverName= tire904\webtechpaste
Test Table Name:
SQL SELECT 1
Select Targets:
Target to Servers in Cluster as required.
Finish and Activate Changes
Test Connection to validate

In case of any ©Copyright or missing credits issue please check CopyRights page for faster resolutions.

Leave a Reply