I am trying to connect to SQLExpress hosted on an AWS instance from Tableau Desktop installed on my local machine.
I am not sure what should be the 'Server'.
Should do it be the IP address of the AWS instance by which I connect to the AWS instance through my RDP? Or should it be the server name which I enter while connecting to the SQLExpress through management studio?
I am getting following error irrespective of whatever I try. Is there any specific port which I should specifically check (like 1433)?
[Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server .
[Microsoft][SQL Server Native Client 10.0]Login timeout expired
[Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Unable to connect to the server "abc-srv-aws45.xxx.COM". Check that the server is running and that you have access privileges to the requested database.
I'd try using the server name that you use with SSMS, can you get SSMS on your machine to connect to SQLExpress ?
When you can get that working, the same credentials should work in Tableau.
Things that would mean that it doesn't work ? Any firewall settings in AWS so that the "real world" can't see SQLExpress; a port change from the default, etc....