This is what I entered in the Connect to Server dialog in MSSMS:
Server Type: Database Engine Server Name: [ the correct IP address and port that GoDaddy/plesk provides ] Authentication: SQL Server Authentication My login and password
NOTE: This question is also posted here, on StackOverflow, with images.
...but got this err msg:
"Cannot connect o [ip address/port ]"
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: SQL Network Interfaces, error: 25 - Connection string is not valid) (Microsoft SQL Server, Error: 87) The parameter is incorrect"
I also tried first uploading my database backup file via the Files tab in plesk, but got an err msg that the file was too large, and to ftp it - but it doesn't provide me with the information I would need in order to do that using FileZilla, namely the Host, Username, Password, and Port.