How can I
RESTORE a database through SQL Server Management Studio by connecting "remotely" to it?
If I know the "IP address" of the target machine what else do I need to know?
If the port number is a requirement, how can I find it?
I only know the IP address of the target machine. I want to know on which port the SQL Server runs. I am given the task to connect to the SQL Server instance and take a backup.