I am simply trying to test my connection with SQL Server 2008 as follows:
Java Code:
public class ForJDBC {
public static void main(String[] args) {
try{
Connection conn = DriverManager.getConnection("jdbc:http://sqlserver10.11.0.225:1433;databaseName=Alerts;user=sa;password=mypassword");
if(conn != null){
System.out.println("Connection is Successfull");
}
}
catch(SQLException ex){
ex.printStackTrace();
}
}
}
But I keep on getting the following exception:
Java Code:
[COLOR="#FF0000"]com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'. ClientConnectionId:96f7d048-9734-4fd8-8216-21231d89b2e6
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:254)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:84)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:2908)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2234)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:41)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2220)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1326)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:991)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:827)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1012)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at forjdbc.ForJDBC.main(ForJDBC.java:35)[/COLOR]
When I connect to MySQL 5.5, it works fine.
Troubleshooting Steps I have followed:
1) Tried Logging with the "sa" user name and password within the SQL Server Management Console
using SQL Server Management studio
2) I have sqljdbc4.jar in my Source Package folder of Netbeans 7.4
3) Updated to Java 8
No comments:
Post a Comment