我正在尝试使用Netbeans 8.2建立连接数据库SQL Server 2012
使用连接向导我选择Sql Server 2012并输入凭据和字段。
但是我收到无法建立连接的消息。
您可以看到输入字段的屏幕截图: 完整分辨率
I'm trying to make a connection database SQL Server 2012 with Netbeans 8.2
Using the connection wizard I select Sql Server 2012 and enter the credentials and fields.
However I get the message that a connection cannot be established.
You can see screenshots of the entered fields: Full Resolution
最满意答案
您将需要在数据库URL中输入“集成安全性”。 我的连接字符串有效,如下所示:
jdbc:sqlserver://localhost\ComputerName:1433;databaseName=DatabaseName;integratedSecurity=true;在您的情况下,如果您使用混合模式身份验证,则将“integratedSecurity”的条目更改为false,并且它应该正常工作。
You will need an entry for 'Integrated Security' in your database URL. My connection string, which works, is as follows:
jdbc:sqlserver://localhost\ComputerName:1433;databaseName=DatabaseName;integratedSecurity=true;Change your entry for 'integratedSecurity' to false in your case, if you are using mixed mode authentication, and it should work OK.
更多推荐
发布评论