When I was configuring MWS I got two problems:
The configurator couldn’t recognize a named SQL server instance, such as server\dev1; The configurator complained that the server is not running at all or login failure.I created an alias using cliconfg to get around this problem;
When connecting to a SQL 2005 server, it complained that “Data type 0x38 is unknown”. I did some search, it looks like the configurator is using a 2000 JDBC driver to connect to the 2005 server.
I think webMethods is using the Merant driver sl53_cj34.jar as default.
I am wondering if anyone experienced the same issue and fixed it eventually.