Eclipse Community Forums: Newcomers » Java mewbe/student - ms sql connectionstring login failed for user

Home » Newcomers » Newcomers » Java mewbe/student - ms sql connectionstring login failed for user(Trouble connecting to ms sql database remotly )

Show: Today's Messages :: Show Polls :: Message Navigator

Java mewbe/student - ms sql connectionstring login failed for user [message #1717945]

Fri, 18 December 2015 04:22

Ricky Stambach

Messages: 1
Registered: December 2015

Junior Member

I'm trying to make a program to connect to a remote ms sql database to test and learn how to using the following code.

// Create a variable for the connection string.
String connectionUrl = "jdbc:sqlserver://my.server.com;Initial" +
"Catalog=test2;Persist Security Info=True;User ID=rsmobile;Password=xxxx";

// Declare the JDBC objects.
Connection con = null;
Statement stmt = null;
ResultSet rs = null;

try {
// Establish the connection.
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
con = DriverManager.getConnection(connectionUrl);

I may have something wrong in my syntax. I can connect to the table from ms ssms. The database name is test2 and the table name is TestTable2. I get the following error.
com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. ClientConnectionId:

Thanks

Report message to a moderator