I am trying to create a SQL Server 2014 data source in weblogic through admin console. When I click on test configuration, I get the following error:
Message icon - Error Connection test failed.
Message icon - Error [FMWGEN][SQLServer JDBC Driver][SQLServer]
Could not find stored procedure 'master..xp_jdbc_open2'.
In WebLogic console, if you are selected XA Driver then it need additional drivers specific library files like sqljdbc.dll etc. Better to choose Oracle non XA driver(second item from the dropdown list) while you are configuring your datasource.
HTH
That stored procedure isn't installed on SQL Server by default.
Seems like JDBC needs to do some kind of initialization on that server first. Compare the target server with a server where the connection does work - I'll bet you find a difference in some JDBC item in Programs and Features, or hopefully this has already rung a bell about something that had to be configured elsewhere that still needs to be done for this server.
See the documentation, this blog post, and this blog post.
