SQL Server 2005 Jdbc connection
843838Jul 26 2007 — edited Jul 27 2007I 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!