connecting to a database

[mxb7642]

this is probably a really stupid question, but this i my first time working with databases so here it goes. I'm trying to connect to a database using the following code:

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;database=tempdb;";
String user = "sa";
String pw = "";
Connection con = DriverManager.getConnection( url, user, pw );

I keep getting this error however - Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection..
I've checked the database and this is deffinitely a valid username. I've also tried several other databases with various usernames and i keep getting the same error.

Is there something horribly wrong with my code? Please help

[ksbrother]

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:dsname" ,"username","password");

[herfnai]

hello you must make odbc and:
Connection cn=null;
Statement stm=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
cn=DriverManager.getConnection("jdbcdbc:database name");
stm=cn.createStatement(ResultSet.TYPE_SCROLL_SENSI TIVE,
ResultSet.CONCUR_UPDATABLE);
JOptionPane.showMessageDialog(null,"connected");

}catch(Exception e)
{JOptionPane.showMessageDialog(null,"eroor" +"\n"+e.getMessage());


}

[vishvadeepaktripathi]

when jsp with sqlserver2005 on netbeans on glassfish server then send a error message my page is not connected so tell me how can do this and also say how i configure tomcat6.0 with netbeans it also send error that not find catalina.bat and myclasspath.bat file

[vishvadeepaktripathi]

databsase is not doing well on my page and servlet page occured error
like org.apache.jaspre......something

[r035198x]

Post the exact exact error message that got.
Also realize that error messages are trying to give you clues as to what the problem may be.