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

[vlad ZHANG (JIRA)]

vlad ZHANG created WFLY-6408:
--------------------------------

             Summary: 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
            Assignee: Jason Greene


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)