Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

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!

SQL Server 2005 Jdbc connection

843838Jul 26 2007 — edited Jul 27 2007
I just have a small question and I was wondering if you could help me out with it? I'm using a JSP page to connect up to the database on the server. I have the JDBC driver and am trying to connect from my machine to SQL Server 2005 on our server. The thing is I'm having a little trouble with the connection string.
(i am using the Microsoft SQL Server 2005 JDBC Driver)

Can you use Windows Authentication when using the connection string?

Also i tried using a SQL Server connection but it gave me the error : "com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'Matt'. The user is not associated with a trusted SQL Server connection. "

This is the connection string

Connection connection1 = java.sql.DriverManager.getConnection("jdbc:sqlserver://"server":1433;Database=BusinessDatabase;User=Matt;Password=testpass");

(obviously "server" is replaced with the server name)

can you set it up for windows authentication?

thanks for any help anyone can give me with this!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2007
Added on Jul 26 2007
1 comment
88 views