Microsoft SQL server data source creation in Weblogic
![Microsoft Sql Server](https://i0.wp.com/www.techpaste.com/wp-content/uploads/2014/07/MS-SQL-Server.jpg?fit=233%2C276&ssl=1)
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.