Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to establish a trusted connection with JDBC for SQL SERVER 2000

843859Jul 20 2007 — edited Jul 23 2007
Hi!I am using jdk 1.4 and eclipse 3.3.

I create a servlet in eclipse with in-build tomcat.
When I run it ,it was working perfectlly has it was suppose to work.

In this servlet I connect to a sql 2000 database using jdbc-odbc bridge driver.

But when I tried to deploy the servlet on tomcat 5.5 manully on the same machine ,it gave me error saying

[Microsoft][SQLServer JDBC Driver][SQLServer]Login failed
for user 'sa'

I searched around some post and found that ok ,I need trusted connection

But I have 2 Questions
1). Why was in eclipse I was able to connect to the SQL server and why not in the servlet which I deployed manully on tomcat.

2). How do I create a trusted connection with JDBC for SQL server 2000


Thnaks for your help in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2007
Added on Jul 20 2007
11 comments
677 views