Manage SQL Server Connection
I'm running RapidMiner Studio 9 and am unable to connect to a SQL Server database thru the manage database connections. My SQL Server is on the same pc as RapidMiner, and I have three other applications which connected to SQL Server in minutes (ESRI ArcMap, Tableau and Excel) so I believe my settings are correct (TCP\IP enabled, etc.).
According to the tutorial the "Host" field to be entered in the connection details is the driver path (?). Can someone explain what the Host field requires? Also, I'm using port 1433 and my instance uses windows authentication. I see the instructions for setting up WA but I'm concerned about the consequences of making these types of system changes just for RM. Should I set-up the database instance to use database security instead (vs WA)? Anyways, just looking for some guidance on setting-up my development environment on my local pc to allow RM to easily read and write to SQL Server.
My error message is The TCP/IP connection to the host localhost, port 1433 failed. Error:"connect timed out. Verify.