Installing Smart Connect – can't connect to SQL Server
I’ve tried specifying the SQL Server name using a host name and an IP address and the username using DOMAIN\username and just username.
The SQL Server is version 14.0.2027.
What can I try?
We use SQL authentication to install SmartConnect. We recommend using “sa” to login as we know that user has the correct permissions to create the database and SQL Logins. If you have another SQL Authentication user that has “Sysadmin” permissions that will work as well.