PDA

Click to See Complete Forum and Search --> : SQL Server 2005 Jdbc connection


mgt83
Jul 26th, 2007, 09:34 PM
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!

ComputerJy
Jul 27th, 2007, 05:48 AM
I don't think you can use windows authentication when using the JDBC.

to make your connection url work, the user "Matt" must be enabled on the Server with access to the Master DB. If that's not what you want take a look at this article (http://msdn2.microsoft.com/en-us/library/ms378428.aspx) on how to make your JDBC connection url for SQL Server 2005