0

Can anyone help me in configuring SQL Server named instance in IBM Websphere Application server?

With Regards Gopinathan K. Munappy

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Gopinathan K M
  • 335
  • 2
  • 6
  • 15

2 Answers2

2

Try:

Server Name: "IPAddressServer\instanceName"

in the Common and required data source properties of Data Source Configuration, it works for me on WAS 8.0.0.3.

BenjamínS
  • 31
  • 3
  • Can confirm this works on WAS 7.0 also. If you're using custome properties it's called "serverName" – Tommy Apr 07 '15 at 13:48
1

Please see page 24 of Accessing Databases chapter of WAS 7 Administration and Configuration Guide for Example: Connecting to an SQL Server database, which gives you step by step instructions.

You will have different options according to which JDBC driver you will use and kind of datasource you'll define (XA / nonXA). These options and respective configuration parameters are outlined in Data source minimum required settings for Microsoft SQL Server document at infocenter.

Kurtcebe Eroglu
  • 1,934
  • 11
  • 15