This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
NOTE: “localhost” will be correct only in case you are running MS SQL locally. Otherwise you need to enter hostname/IP address of your MS SQL server.
Here is the full properties file:
Start the windows service “Alteryx Connect” and wait for the initialization of the database (this can take up to 10 minutes).
After the database is initialized, you should be able to connect to UI (such as http://localhost/).
If you are not able to connect to UI, follow these steps:
Mssql basic install (180 days evaluation version) (SQL2019-SSEI-Eval).
Basic installation is sufficient.
After mssql server is installed, set port to fixed and enable TCP/IP:
Open the SQL Server Configuration Manager.
In SQL Server Network Configuration select Protocols for [yourServerInstance].
In the right-hand pane, make sure that TCP/IP is Enabled.
Open the 1433 port in your firewall.
In the SQL Server Configuration Manager, right-click TCP/IP and select Properties.
Select the IP Addresses tab and make sure the TCP Port for IP1 is 1433.
Make sure that’s not configured to DYNAMIC (on old SQL server versions).
Download and install SQL Server Management Studio (SSMS):
Login with windows authentication
or when using advanced settings configure password for sa user.
Configure and change the authentication mode to use also sql server creds:
Once we login to SSMS using Windows Authentication, we need to check the security settings to confirm whether MS SQL is set up to allow both Windows and SQL Authentication.
Recommended step: Unlock user sa in Security/Logins/select sa/properties/tab Status/login enabled and and set up password in the General tab.