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

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.