This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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
It is sorta covered in the JavaRanch Style Guide.
subject: Problem with Connectivity
Similar Threads active Connections issue...
SQL Server 2000 JDBC Driver Error
Syntax of getConnection() method
Why cant connect to another computer in lan?
no active Connection...jdbc newbie