Connecting to remote MS sqlserver in java using windows authentication

Question

I am using sqlserver with Windows authentication, with a Windows server.

I am trying to connect to a remote MS SQLSERVER on my local network using java eclipse but keep getting this error:

Error : com.microsoft.sqlserver.jdbc.SQLServerException: The port number 64038 databaseName = Data is not valid.

Here is the code:

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

System.out.println("# - driver loaded");

String server = "moddbs169d.network.local\\Moddbs169d\\SQL2008";

int port = 64038;

String database = "Data";

String jdbcUrl = "jdbc:sqlserver://"+server+":"+port+" databaseName = "+database+";integratedSecurity=true";

Connection con = DriverManager.getConnection(jdbcUrl);

System.out.println("# - Connection obtained");

If all is successful it should tell me connection obtained. The local connection and name of the database are both correct, so that is not the issue. The jdbc driver is also installed and working properly.

dan.m was user2321368 · Accepted Answer · 2014-07-07 23:21:21Z

1

You are missing a semicolon before the "databaseName=xxx" property.

Without the semicolon, you are setting the port number to "64038 databaseName = Data". Admittedly, the error message could have used brackets to make it a bit clearer.

See (http://msdn.microsoft.com/en-us/library/ms378428(v=sql.110).aspx) for the form of the connection URL.

answered Jul 7, 2014 at 23:21

dan.m was user2321368

1,71410 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3799636 Over a year ago

Semicolons will be my downfall. Thanks,It works now!

Collectives™ on Stack Overflow

Connecting to remote MS sqlserver in java using windows authentication

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related