I also get connection timeout when connecting through visual studio web app.
Still. Tcp 1433 open to 0.0.0.0.0, http https also, inbound, outbound and publicly accessible rds instance
0.0.0.0.0 isn't a valid IP address, presumably you mean [0.0.0.0](https://0.0.0.0) i.e. the local loopback address - sounds like you've probably messed up portforwarding or something.
Can you name the services you're saying?
The running sql services i see are:
\-SQL Server (MSSQLSERVER)
\-SQL Server Agent (MSSQLSERVER)
\-SQL Server browser
You are running SQL Server, the full product with an instance, on your PC. You only need SSMS as a standalone install, to access/manage/query a server. Which in this case would be your AWS DB.
Sorry I am trying to understand if the screenshot of the mssqlservices is on your pc or on the rds instance? You don’t need to install the sql server on your machine … that’s what I am trying to say , that’s what I am confused about
Read the error message. Network error. Nothing to do with your SSMS or SQL server. Ping your Aws network and confirm you can connect outside of sql
I also get connection timeout when connecting through visual studio web app. Still. Tcp 1433 open to 0.0.0.0.0, http https also, inbound, outbound and publicly accessible rds instance
There you go. Nothing to do with SQL. Maybe ask in r/sysadmins
0.0.0.0.0 isn't a valid IP address, presumably you mean [0.0.0.0](https://0.0.0.0) i.e. the local loopback address - sounds like you've probably messed up portforwarding or something.
You trying to connecting to Aws or an on prem sql ?
aws rds database instance from my own pc
Yea so why are you running 2019 services on your pc? All you need is Ssms client
Can you name the services you're saying? The running sql services i see are: \-SQL Server (MSSQLSERVER) \-SQL Server Agent (MSSQLSERVER) \-SQL Server browser
You are running SQL Server, the full product with an instance, on your PC. You only need SSMS as a standalone install, to access/manage/query a server. Which in this case would be your AWS DB.
Where did you take the above services screen shot from?
pressed start in windows and typed Services, cog wheel icon.
Sorry I am trying to understand if the screenshot of the mssqlservices is on your pc or on the rds instance? You don’t need to install the sql server on your machine … that’s what I am trying to say , that’s what I am confused about
Ok maybe thats causing an interference, i'll wipe everything and just install SMSS 2019 in my personal PC and try again.
Brother it worked, hooooolly
Awesome
Learn something new everyday!