将eclipse中的SQL server与java链接时Ping失败。

Question

我正在尝试将SQL server与eclipse中的java SE 8.0链接起来。但每次我收到Ping错误消息时。

我研究了关于如何连接它们的文档以及错误，但它们都没有帮助。

选择SQL2008，URL地址为'jdbc:sqlserver://localhost:1433;databaseName=pubs'，测试连接结果为：

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'Nastaran'. ClientConnectionId:aceb876b-7c92-454c-bab0-9c176045bb76
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2964)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2244)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:43)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2230)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1717)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1328)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:993)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:829)
    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:328)
    at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)
    at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
    at org.eclipse.datatools.enablement.msft.internal.sqlserver.connection.JDBCSQLServerConnectionFactory.createConnection(JDBCSQLServerConnectionFactory.java:27)
    at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
    at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
    at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
    at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:56)
Can anyone help me?

Answer 1

• 1.打开您的SQL Server Management
• 连接到Window Authentication
• right在object_explorer==>Properties==>Security
• Select SQL server和window Authentication
• IF中单击sqlexpress如果您没有用户并使用window身份验证，请创建一个新用户

创建新用户的

在对象资源管理器和LOGIN

• Enter登录名"Student001"中单击 ==> ，选择 SQL server和window ，单击“常规”下的“==> Role”，然后选中需要选中的复选框，然后单击“确定”。

• 重新启动SQL server。<代码>H240<代码>F241

桌面url格式: jdbc:sqlserver://DESKTOP-CQEEAQ3\SQLEXPRESS;databaseName=Customer；-CQEEAQ3\SQLEXPRESS:从SSMS服务器名称复制。