[jboss-jira] [JBoss JIRA] (WFLY-6408) Failed to add datasource of sql server in Wildfly 9

[Tomaz Cerar (JIRA)]

     [ https://issues.jboss.org/browse/WFLY-6408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tomaz Cerar closed WFLY-6408.
-----------------------------
      Assignee:     (was: Jason Greene)
    Resolution: Rejected


This is type of discussion that belongs to user forums not bug tracker.
Forums can be found at https://developer.jboss.org/en/wildfly

> Failed to add datasource of sql server in Wildfly 9
> ---------------------------------------------------
>
>                 Key: WFLY-6408
>                 URL: https://issues.jboss.org/browse/WFLY-6408
>             Project: WildFly
>          Issue Type: Bug
>            Reporter: vlad ZHANG
>
> Hello, 
> I encounter a problem in deploying datasource of sql server in Wildfly 9. 
> The Wildfly version I have downloaded is Wildfly 9.2.0.Final. I added a user and entered the Administrator Console in a browser. 
> The sql server version I have downloaded is sql server 2008. I want to deploy a datasource of sql server. 
> I started to download a JDBC Driver. The version I have downloaded is "Microsoft JDBC Drivers 6.0 (Preview), 4.2, 4.1, and 4.0 for SQL Server" from "https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774". 
> I succeeded in adding this driver by choosing deployment--->add--->Upload a new deployment in the Administration Console. But when I try to add a datasource, I had a problem. 
> In the "configuration" of Administration Console, I chose Subsystems--->Datasources--->Non-XA--->add. Then I chose the driver I had deployed. But I always cannot create this datasource, the error is always: 
> Failed to create JDBC connection.
> An internal error occurred.
> Unexpected HTTP response: 500
> Request
> {
>     "address" => [
>         ("subsystem" => "datasources"),
>         ("data-source" => "MSSQLDS")
>     ],
>     "operation" => "test-connection-in-pool"
> }
> Response
> Internal Server Error
> {
>     "outcome" => "failed",
>     "failure-description" => "WFLYJCA0040: failed to invoke operation: WFLYJCA0047: Connection is not valid",
>     "rolled-back" => true,
>     "response-headers" => {"process-state" => "reload-required"}
> }
> And I don't know why. Could anyone help me, please? Thank you in advance. 



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)