I then click 'Test Connection' to which an error stating "Ping failed!" is presented with the following details: In the resulting "New Connection Profile" window, I input the database name ("sec"), URL (" jdbc:sqlserver://localhost"), and user name and password created in MS SSMS.
I again click 'New Connection Profile', and this time select "Generic JDBC", input a Connection Profile Name, and click 'Next'. I then click 'Cancel' to close the "New Driver Definition" window and 'Cancel' again to close the "New Connection Profile" window, thus starting anew. From there, I click 'New Driver Definition' and find that "Microsoft SQL Server 2017 JDBC Driver is not listed. In this view, I click 'New Connection Profile', select "SQL Server", input a Connection Profile Name, and click 'Next'.
From the default Java perspective, I click 'Window | Show View | Other.' and then 'Data Management | Data Source Explorer'.
2 on a local Windows 10 Home machine but having a difficult time at it. I have searched the DTP forum to no avail and am hoping to discover a solution through conversation.