was8.5配置完数据源之后测试连接mssqlserver 2008失败
我是在windows 2012安装was8.5,配置完数据源之后测试连接mssqlserver 2008,
was报错信息为:The test connection operation failed for data source fingerprint on server server1 at node WIN-PQ5HJKQ20USNode01 with the following exception: java.sql.SQLException: Cannot open database "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=fingerprint" requested by the login. The login failed. DSRA0010E: SQL State = S0001, Error Code = 4,060
查看mssqlserver 2008的日志发现报错信息如下:
Login succeeded for user 'sa'. Connection made using SQL Server authentication. [CLIENT: 127.0.0.1]
20:54:38.78 Logon Error: 18456, Severity: 14, State: 38.
20:54:38.78 Logon Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1]
为什么会连接失败,同时为什么数据库的日志显示login成功但logon失败呢?
希望大家指点下,万分感谢!