import java.sql.DriverManager;
import java.sql.DatabaseMetaData;
import java.sql.*;
// Test connection to certain MS SQL database database
public class JustConnect {  public static void main(String[] args) {
	String databaseServer = "127.0.0.1:1433;"; // IP and port
	String databaseName = "Company;";
	String loginUser = "sa;";
	String loginPwd = "masterkey";
	String connectionString = "jdbc:sqlserver://" + databaseServer + "databaseName=" + databaseName + "user=" + loginUser + "password=" + loginPwd;
	// "jdbc:sqlserver://127.0.0.1:1433;databaseName=Company;user=sa;password=secret"

	System.out.println("Try connecting");
	System.out.println("ConnectionString: " + connectionString);

	Connection databaseConnection = null;
	DatabaseMetaData databaseInfo = null;

	try {
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		databaseConnection = DriverManager.getConnection(connectionString);
		databaseInfo = databaseConnection.getMetaData(); // get meta data
		System.out.println("Connected successfully:");
		System.out.println("Connected to " + databaseInfo.getURL());
		System.out.println("Driver " + databaseInfo.getDriverName());
		System.out.println("Database product name " + databaseInfo.getDatabaseProductName());
		databaseConnection.close();
	}
	catch (ClassNotFoundException eNotFound) {
		System.out.println("Driver exception: " + eNotFound);
	}
	catch (SQLException e) {
		System.out.println("Query exception - select: " + e);
	}
}
}