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!
(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!