Error Connecting to SQL Database
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
waelfarah
5 - Atom
‎02-19-2021
04:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Although the SQL Server whitelisted my IP addresses and I am being able to log in through the Remote Desktop Connection but when I put the credentials & server name on Alteryx --> SQL Database --> Quick Connect I am getting Error 08001. Screenshot attached.
Is this error something related to SQL server access or it is something from specific to local configuration of Alteryx?
Labels:
- Labels:
- Connectors
- Database Connection
1 REPLY 1
19 - Altair
‎02-21-2021
05:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @waelfarah
Try to connect to the SQL server from your machine using SSMS or create an ODBC connection to the server from your local machine using ODBC Data Source Administrator. If you can't connect through either of those methods, may be there is firewall blocking the port, either the default 1433 or a custom port number, if used.
Dan
