title: jdbc.SQLServerException: Login failed for user for any user
body: <p>I trying to test the connection with my local sql DB. I have this code:</p>
  
  <pre><code>try{
      Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
      DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=SocialFamilyTree;user=SOSCOMP");
  
  }catch(Exception e){
      System.out.println("Couldn't get database connection.");
      e.printStackTrace();
  }
  </code></pre>
  
  <p>I tried many users. my windows user is SOSCOMP and doesn't have a password. I also know that SQL 2008 create users as "sys" "dbo", I tried these too. I'm always getting:</p>
  
  <pre><code>Couldn't get database connection.
  com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SOSCOMP'.
  
      at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
      at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:246)
      at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:83)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2532)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:1929)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:1917)
      at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1061)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:833)
      at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:716)
      at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:841)
      at java.sql.DriverManager.getConnection(DriverManager.java:579)
      at java.sql.DriverManager.getConnection(DriverManager.java:243)
      at FT_Receiver.FT_Receiver.main(FT_Receiver.java:12)
  </code></pre>
  
  <p>Any ideas?</p>
  
  <p>Thanks</p>