Using a new copy of SSMS: Where do I specify the access (IP) for a remote database?

Question

On my old computer (Windows 10 laptop) I can use SSMS to access the local SQL database and a remote database identified as "DB". DB uses SQL Server authentication so I enter a userid and password and I can access the remote database with SSMS without problems.

I am setting up a new computer (Windows 11 PC), and I've set up SQL Server and SSMS, everything works correctly with the local database, I had no problem creating copies of the old local databases on the new computer. So far so good.

Where do I tell SSMS or Windows 11 how to find "DB". I know the IP address of the remote SQL server, and of course I have the username and password, but I don't how to tell my new computer that DB = this IP address (and whatever else I might need to tell it). I can't find anywhere to give this information, there must be somewhere in SSMS or in W11, but where?

Thank you, Robert.

Answer 1

but I don't how to tell my new computer that DB = this IP address

Hello Robert,
to be true, I don't understand a single word or what your issue is?
Databases don't have a IP address, server do.

In SSMS server login dialog enter under "Server name" the server name or IP address, your SQL credentials and go.
What happens then / which may error message do you get?

Answer 2

Please see:
https://learn.microsoft.com/en-us/sql/ssms/register-servers/register-servers?view=sql-server-ver15