cannot connect with JDBC to express 2005

Hi all,

I try to connect with a java application to a freshly download SQL server express 2005, but I cannot anything I do.

If I try with the following string "10.0.0.82:1433;databaseName=flavio;user=f.palumbo;" I get this message :

java.sql.SQLException: Impossibile eseguire l'accesso per l'utente 'f.palumbo'. L'utente non è associato a una connessione SQL Server trusted.

If I try with this string "localhost:1433/flavio" I get this message :

com.microsoft.sqlserver.jdbc.SQLServerException: Il numero di porta 1433/flavio non è valido.

So I'm getting crazy to find out a solution ... can somebody help me?

Thanks a lot

Flavio

The first error says that f.palumbo user is not associated with a trusted user. Are you sure you have added the user using the sql express surface administrator to the server. The second syntax you are using is invalid. You cant do localhost:1433/flavio to get to the database flavio.

|||

Also, to troubleshoot express issues you may look at here:

http://blogs.msdn.com/sql_protocols/archive/2006/03/23/558651.aspx

|||

Hi thanks for your reply,

but about your "Are you sure you have added the user using the sql express surface administrator to the server" the answer is "no I'm not sure at all".

Sorry, I'm sure a newbie, but I cannot find a user administration tool in the place you say ; can you please give a more detailed path to do this work ?

Thanks a lot

Flavio