我在新的Windows 7 Pro 64bit笔记本电脑上设置数据源时遇到问题.我有一个全新安装的Coldfusion 10,带有最新的Hot Fix和Microsoft sql Express 2012 64bit.
我确保在sql服务器配置管理器中启用TCP / IP并将TCP端口设置为1433.我也尝试删除TCP动态端口.
我仍然收到此错误：
Connection verification Failed for data source: TEST
java.sql.sqlInvalidAuthorizationSpecException: [Macromedia][sqlServer JDBC Driver][sqlServer]Login Failed for user ‘xxxxx’.
The root cause was that: java.sql.sqlInvalidAuthorizationSpecException: [Macromedia][sqlServer JDBC Driver][sqlServer]Login Failed for user ‘xxxxx’.
我不确定我现在缺少什么.任何建议将不胜感激.
先谢谢你！
解决方法
(来自评论……)
你在sql服务器上启用了mixed mode authentication吗？ IIRC,它默认只对Windows身份验证.
链接说明：
To … configure sql Server in Mixed Authentication
Mode … [for] sql Server 2014,sql Server
2012,sql Server 2008,and sql Server 2005
- Open sql Server Management Stu@R_404_410@
- Right-click the server,and then click Properties.
- On the Security page,under Server authentication,click the sql Server and Windows Authentication mode option button,and then
click OK.- In the sql Server Management Stu@R_404_410@ dialog Box,click OK to restart sql Server.
