sql server tcp connection timed out

i have installed SQL server 2016 on a VPS that is running Win server 2016, i have enabled TCP/IC conectivity and made inbound rules for ports 1433,1434 and SQLSERV.exe. also i have made a sample database and login that has access to that.

now i try to add this server and database into Visual studio using "add data connection" in server explorer . i have chosen "MS SQL server" as data type, and then have used " tcp:XX.XX.XX.XX,1433" as server name and created username and password i get a error message :"...wait operator timed out."

i have also tried to increase connection timeout to 120s but no success.

0
edit delete
are you sure?
asked Reza Deabae

2 answers

Within the Database server field add the non-default SQL port number to the end of the server name. For example:

SQLSERVER.DOMAIN.COM:XXXX

Note: Replace XXXX above with the non-default port number required and SQLSERVER.DOMAIN.COM with the FQDN of the SQL Server with the BES10 or BES12 databases.


Best Car Speakers

0
edit delete
are you sure?
answered Jackson Martinez

Though the only thing which might work for you is a legitimate & active Netflix account login and passwords. Moreover, this would even keep you away from harmful and malicious programs which you might encounter on your hunt, that usually ends up messing up things for you eventually.

0
edit delete
are you sure?
answered Netflix Login

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions