This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Problem with Connectivity Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem with Connectivity" Watch "Problem with Connectivity" New topic

Problem with Connectivity

Jerry ikon

Joined: Jul 19, 2006
Posts: 1

I have installed Microsoft SQL server on my computer.

using windows authentication it has been installed .

My windows xp username is administrator and has no password

Now I can open my server,execute queries in QueryAnalyzer but unable to connect through java program.

My database tree=>

under SQL server group-->(LOCAL)(windows NT)-->newraj

what is my server name?is it LOCAL or localhost

I have checked the connection with the following program too

Please help me in this regard as soon as possible


import java.sql.*;

public class UBDAO {
private java.sql.Connection con = null;
private final String url = "jdbc:microsoft:sqlserver://";
private final String serverName= "localhost";
private final String portNumber = "1433";
private final String databaseName= "pubs";
private final String userName = "sa";
private final String password = "";

private String getConnectionUrl()
return url+serverName+":"+portNumber+";databaseName="+databaseName+";";

public static void main(String args[])
UBDAO ub = new UBDAO();
Connection con = null;
con = java.sql.DriverManager.getConnection(ub.getConnectionUrl(),ub.userName,ub.password);
if(con!=null) System.out.println("Connection Successful!");
catch(Exception e)
System.out.println("Error Trace in getConnection() : " + e.getMessage());


java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Log
in failed for user 'sa'. Reason: Not associated with a trusted SQL Server connec
at Source
at Source)
Masoud Kalali
Ranch Hand

Joined: Jul 08, 2004
Posts: 531

localhost is correct , but you hsould notice that you need to set SQL server authentication to mixed mode , by default it will use windows based authentication which AFAIR is not supported by MS JDBC driver

Masoud Kalali
Software Engineer - My Weblog - GlassFish Security
I agree. Here's the link:
subject: Problem with Connectivity
It's not a secret anymore!