I had downloaded and installed the "SQL Server Management Studio Express" on my home PC.
I connect with:
server name: ESA-SAV01 \ sqlexpress
Authentication: Windows Authentication
So without a password.
I can connect, create tables etc.....
I coded a small java program to connect to the SQL database using JDBC with Java.
In "Administrative Tools" / "Data Sources (ODBC)" then in "User Data Source" I click on the add button, then on the "Create New Data Source", I see at the end "SQL server",and there I click on SQL Server.
Then a new window opens. There I met a name like "MyDataSource" for the name. In Server and I see "ESA-SAV01" or Local if I click on one or the other,another window opens and then I check with windows NT authentication for the network login ID after some try, I get the message that tells me that SQL Server does not exist.
even if I click on another option.