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)
Please help me in connection Sql Server 2005 with the eclipse. Due to this, I am unable to execute database programs in my eclipse....
"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.
Customer surveys are for companies who didn't pay proper attention to begin with.
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.