I am currently setting up a new SQL Server database server with databases. It is supplied by a third party company.
I need to request access for them around ports etc.
I would like to be able connect to the SQL Server instance on the above database from SQL Server Management Studio on my PC. What do I need to get setup on the server so I can get such access?
The other question I have is that I have a number of databases on other servers, I will like to "copy" these databases to the new server. I need to copy both structure and data. What is the best way to do such?