Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Receiving SQLException "Login failed for user" connecting to SQL Server 2008

I am trying to connect to SQL Server 2008 via Java.

  1. I've added sqljdbc4.jar to my project's library.
  2. No username and password is set for database accessing the database (Windows Authentication).
  3. The 1433 port is Listening, but I still receive this exception:

SQL Exception: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. ClientConnectionId:085d5df3-ad69-49e1-ba32-b2b990c16a69

Relevant code:

public class DataBases 
{

    private  Connection link;
    private  java.sql.Statement  stmt;
    public    ResultSet rs;

    public DataBases() 
    {  
        try 
        {    
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            String connectionUrl = "jdbc:sqlserver://localhost:1433;databaseName=DB;";
            Connection con = DriverManager.getConnection(connectionUrl);
        } 
        catch (SQLException e) 
        {
            System.out.println("SQL Exception: "+ e.toString());
        }
        catch (ClassNotFoundException cE)
        {
            System.out.println("Class Not Found Exception: "+ cE.toString());
        }
     }
}
like image 250
Sal-laS Avatar asked Feb 18 '13 20:02

Sal-laS


1 Answers

If you want windows authentication you need to add the option integratedSecurity=true to your JDBC URL:

jdbc:sqlserver://localhost:1433;databaseName=DB;integratedSecurity=true

You also need sqljdbc_auth.dll (beware of 32/64 bit) in your Windows system path or in a directory defined through java.library.path

For details see the driver's manual: http://msdn.microsoft.com/en-us/library/ms378428.aspx#Connectingintegrated

like image 88
a_horse_with_no_name Avatar answered Nov 14 '22 20:11

a_horse_with_no_name