problems connecting to an external mssql server

[PaalO]

When I try to connect my database server to the plesk panel I get the following error:
Test connection to the database server has failed because of network problems:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

My guess is that it fails because im using a different port than 1433, but there is no option to change ports
other than on mysql. Does anyone have any solutions to this?

Sincerly Paal.

 

[IgorG]

Did you tried to define needed port via comma after IP of server?

 

[Milind Koyande]

Hello,

My guess is that it fails because im using a different port than 1433, but there is no option to change ports
other than on mysql. Does anyone have any solutions to this?

You can change the MSSQL Port from MSSQL Management Studio from the RDP of the Remote Server. Also make sure that remote connections are allow in MSSQL.