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
Author

Problem with Connectivity

Jerry ikon
Greenhorn

Joined: Jul 19, 2006
Posts: 1
Hi,

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

JerryIkon

import java.io.*;
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;
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = java.sql.DriverManager.getConnection(ub.getConnectionUrl(),ub.userName,ub.password);
if(con!=null) System.out.println("Connection Successful!");
}
catch(Exception e)
{
e.printStackTrace();
System.out.println("Error Trace in getConnection() : " + e.getMessage());
}
}
}

I AM GETTING THE FOLLOWING ERRORS:-

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
tion.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown
Source)
Masoud Kalali
Author
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
Hi...jdbc..no 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