Topic
  • 4 replies
  • Latest Post - ‏2013-01-31T03:59:37Z by visuvasam
SystemAdmin
SystemAdmin
37422 Posts

Pinned topic Cluster SQL Server DB datasource config in Websphere 6.1

‏2013-01-31T02:18:16Z |
We want to config the datasource in WAS 6.1 with a cluster SQL Server DB.

Open admin console -> Resources -> Data soures

This is the info we have to set up.
1. Server name/ip
2. Instance name
3. DB name
4. username
5. password

1, 3, 4, 5 has no problems. The problem is how we can config the instance name. We tried to config in custom properties with name "instanceName" but it dones not work.

Anyone has experience in this? Thanks in advance.
Updated on 2013-01-31T03:59:37Z at 2013-01-31T03:59:37Z by visuvasam
  • visuvasam
    visuvasam
    13 Posts

    Re: Cluster SQL Server DB datasource config in Websphere 6.1

    ‏2013-01-31T02:52:03Z  
    Hi ...
    go through the website..
    what ever it is ....
    other issues so post this forum i will help to you..

    http://www.daizhoulin.com/blog/2007/07/19/connecting-to-sql-server-2005-in-websphere-application-server-v61-using-embedded-connect-jdbc-driver/

    by

    visu
  • visuvasam
    visuvasam
    13 Posts

    Re: Cluster SQL Server DB datasource config in Websphere 6.1

    ‏2013-01-31T03:12:17Z  
    Hi...

    http://www.redbooks.ibm.com/redpapers/pdfs/redp4577.pdf
    Go through the red book and explained with screen shot also..

    Regards,
    R.Visuvasam.
  • SystemAdmin
    SystemAdmin
    37422 Posts

    Re: Cluster SQL Server DB datasource config in Websphere 6.1

    ‏2013-01-31T03:13:25Z  
    • visuvasam
    • ‏2013-01-31T02:52:03Z
    Hi ...
    go through the website..
    what ever it is ....
    other issues so post this forum i will help to you..

    http://www.daizhoulin.com/blog/2007/07/19/connecting-to-sql-server-2005-in-websphere-application-server-v61-using-embedded-connect-jdbc-driver/

    by

    visu
    Thanks.

    But the example in the web site is just a single SQL Server, not SQL Server cluster, so there is no instance name
  • visuvasam
    visuvasam
    13 Posts

    Re: Cluster SQL Server DB datasource config in Websphere 6.1

    ‏2013-01-31T03:59:37Z  
    "Instance name" what ever you did like give it... after working fine,

    by
    visu