SQL Server Connection

  

Can someone help on the following issue:

I'm using the 10.0.200.2 version, and i can't connect to the sql server database using. 

I have allowed the remote connection to my server;

I have enabled the tcp/ip protocols;

I have confirmed that the services are running;

I have the firewall disabled (so i didn't change the configurations).


 When i try to connect without the instance on the connection string, the system gives me the "error: 40 - Could not open a connection to SQL Server"  but, when i put the instance on the connection string, the system gives me the "error: 26 - Error Locating Server/Instance Specified".

Is there something missing or wrong on my configuration?


As you can see the images below.

1. Why are you using advanced configuration? Basic seems to be enough.

2. Instead of  "server\instance" try the format "server, port". Usually we have that error in internal servers.



Hi Nuno, thanks for your reply. 

The first time i tried to apply your recommendations i succeed. But now i can't connect any more (using the same data). What can be? 

Sansao Chambala wrote:

Hi Nuno, thanks for your reply. 

The first time i tried to apply your recommendations i succeed. But now i can't connect any more (using the same data). What can be? 

Can you check sql logs?


Dear Sansao Chambala

Where are you hosting the SQL Server? Azure or AWS?

Best Regards,

Mário Pereira