eclipse with sql server 2005

[in.anurag Singh]

Hi,
I am trying to connect the Eclipse with Sql Server 2005. What I have done so far is as below:

1) I have installed sql server 2005.
2) I have downloaded drivers for sql server 2005.
3) opened Eclipse->Window->open perspective->Database Development
4) Right click on database connections in Data Source Explorer and selected New->SQL Server.
5) The window that is opened is "new connection profile".
6) Then, user name and password are blank, port number is 1433, database name is "pubs". I have checked the "use integrated authentication, and then the connection url is " jdbc:sqlserver://localhost:1433;databaseName=pubs;integratedSecurity=true; " i.e. by default
7) From the new driver definition, I selected Microsoft SQL Server 2005 JDBC Driver.
8) Add the Driver file to the Jar List, The driver file name is sqljdbc.jar.
9) In the properties the password and userId is empty, and connection url is "jdbc:sqlserver://localhost:1433;databaseName=pubs" . this all is by default.
10) After Clicking o.k., when I click the "test connection" on "New Connection Profile", I get an error "ping failed" and the details are:

com.microsoft.sqlserver.jdbc.SQLServerException: Invalid integratedSecurity property value:true
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:206)
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:104)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:72)
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:355)
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:55).

Please help me in connection Sql Server 2005 with the eclipse. Due to this, I am unable to execute database programs in my eclipse....

[David Newton]

First I'd try removing the parameter it says is invalid, and seeing what happens.

[Tim Holloway]

"Integrated security" means that your authentication comes from the Windows login. For JDBC, you don't want that, you want to be able to pass in explicit userid/password external credentials.

You also need to set up the SQL Server connection options if you intend to connect from an external system. I don't think you're having that problem at the moment, but then if you're not connecting from another system, you wouldn't.

[P Arunkumar]

Hi

Same like this iam trying to connect Eclipse with Sql server2008. but iam facing some error messages.

in Eclipse-> Windows -> open Perspective -> others -> Database Development -> ok

I got DataSource Explores Screen, then in database 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

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.

My URL wants to be in this format

URL = "jdbc:sqlserver://localhost:1433;server=SQL1;database=MyDatabase;"  

But iam getting

URL = "jdbc:sqlserver://localhost:1433;database=MyDatabase;"  

If i change the URL and i add server details in next step insted of database name server=SQL1 is showing.
Then Click Ok.

In next step it is asking for database name ,username , password.


If i gave all the details and click test connection its showing Ping Failed !.

The error message is

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'. ClientConnectionId:7bf72ad4-552e-4111-9bfe-bb118be2264b   
    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:2908)   
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)   
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)   
    at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)   
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)   
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)   
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)   
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)   
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)   
    at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)   
    at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:214)   
    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:73)   
    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:54)  

I have copy and pasted sqljdbc_auth.dll file in c:\windows\system32


Still same problem from my knowledge Eclipse is not connecting with server, i wants to access the server but i don't know the way please guide me.

I tried in google i got failed connection only please help me.

My system is client and server is another system i want to connect my client system with server system with dataSource it will be possible or not.my server name is SQL1.

I want to connect my datasource with my server system (SQL Server Management Studio).


Please guide me to solve my issue.


Thanks in advance.

[Tim Holloway]

As Manish has pointed out, we prefer that you do not ask the same question more than once. It causes too much confusion. Also, we call bringing up an old dead message thread such as this one "resurrecting a zombie" and we discourage that as well, since if you're answering the original question, chances are that the original participants don't care anymore, and if you start a new discussion, it's confusing, so we'd prefer you start your own thread instead.