如何使用数据源资源管理器连接sql server 2008和eclipse helios

I'm trying to connect Sql Server 2008 database with Eclipse using database source explorer, could you help me ?

我正在尝试使用数据库源资源管理器将Sql Server 2008数据库与Eclipse连接,你能帮帮我吗?

in Eclipse->
Windows ->
open Perspective ->

打开透视 - >

others ->
Database Development ->

数据库开发 - >

I got DataSource Explores Screen, then

然后我得到了DataSource Explores Screen

in database Connection->

在数据库Connection->

rightClick ->
click new ->

点击新 - >

connection` profile will open.

连接`配置文件将打开。

In that i have selected

在那我选择了

sqlserver->
next ->
driver details ->

司机详情 - >

i have selected sqljdbc4.jar file because iam using jdk1.6

我选择了sqljdbc4.jar文件,因为我使用jdk1.6

In next tab we can see properties like connection url and driver class my doute is my system is client system i want to connect with server my server name is SQL1. But in URL there is no ServerName.

在下一个选项卡中,我们可以看到连接url和驱动程序类等属性我的系统是客户端系统我希望与服务器连接我的服务器名称是SQL1。但是在URL中没有ServerName。

it can't establish connection

它无法建立连接

Error: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port

错误:com.microsoft.sqlserver.jdbc.SQLServerException:与主机localhost,端口1433的TCP / IP连接失败。错误:“连接被拒绝:连接。验证连接属性,检查主机上是否正在运行SQL Server实例并接受端口上的TCP / IP连接,并且没有防火墙阻止与端口的TCP连接

thank you

1 个解决方案

#1

Seen this issue before. Copy sqljdbc_auth.dll to the working directory, should sort it.

以前看过这个问题。将sqljdbc_auth.dll复制到工作目录,应对其进行排序。

Other than that SQL server isn't running, or it's a firewall issue. Or something else potentially is using that port.

除了SQL服务器没有运行,或者它是防火墙问题。或者其他可能正在使用该端口的东西。

#1