ColdFusion 10/Windowns 7 Pro 64bit 数据源连接验证失败

2022-01-09 00:00:00 sql-server coldfusion coldfusion-10

我在新的 Windows 7 Pro 64 位笔记本电脑上设置数据源时遇到问题.我全新安装了带有最新热修复和 Microsoft SQL Express 2012 64 位的 Coldfusion 10.

I’m having issue setting up a data source on my new windows 7 Pro 64bit laptop. I have a fresh install of Coldfusion 10 with latest hot fix and Microsoft SQL Express 2012 64bit.

我已确保在 SQl 服务器配置管理器中启用 TCP/IP 并将 TCP 端口设置为 1433.我也试过删除 TCP 动态端口.

I have ensured that TCP/IP enable and set TCP port to 1433 in the SQl server configuration manager. I've also tried removing the TCP Dynamic Ports.

我仍然收到此错误:

数据源的连接验证失败:TEST

Connection verification failed for data source: TEST

java.sql.SQLInvalidAuthorizationSpecException:[Macromedia][SQLServer JDBC Driver][SQLServer]用户xxxxx"登录失败.

java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'xxxxx'.

根本原因是:java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]用户xxxxx"登录失败.

The root cause was that: java.sql.SQLInvalidAuthorizationSpecException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'xxxxx'.

我不确定我现在缺少什么.任何建议将不胜感激.

I’m not sure what I’m missing at this point. Any suggestion would be much appreciated.

提前谢谢你！

推荐答案

(来自评论...)

您是否在 SQL Server 中启用了混合模式身份验证?IIRC，它默认为仅 Windows 身份验证.

Did you enable mixed mode authentication in SQL server? IIRC, it defaults to Windows Authentication only.

链接说明:

要...在混合身份验证中配置 SQL Server模式 ... [适用于] SQL Server 2014、SQL Server2012、SQL Server 2008 和 SQL Server 2005

To ... configure SQL Server in Mixed Authentication Mode ... [for] SQL Server 2014, SQL Server 2012, SQL Server 2008, and SQL Server 2005

  1. 打开 SQL Server Management Studio
  2. 右键单击服务器，然后单击属性.
  3. 在安全"页面的服务器身份验证下，单击SQL Server 和 Windows 身份验证模式选项按钮，然后单击确定.
  4. 在 SQL Server Management Studio 对话框中，单击确定"以重新启动 SQL Server.
  1. Open SQL Server Management Studio
  2. Right-click the server, and then click Properties.
  3. On the Security page, under Server authentication, click the SQL Server and Windows Authentication mode option button, and then click OK.
  4. In the SQL Server Management Studio dialog box, click OK to restart SQL Server.

相关文章