The server that I am trying to connect to is SQL server 2008 R2, with a custom port. If the same connection string is used in Microsoft SSMS tool, the connection works. I've tried deleting the connections in dbForge, rebooting the computer many different times, before and after deleting the connections, deleting all the connections and recreating the connections with different names. The connection fails each and every time with this message:
However, if I connect to a local DB instance, the connection works.A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.)
Please advise on what I am doing wrong. Currently I am using SSMS to complete my work, but I really miss the automated tools within dbForge.
Thank you.