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

Robert Barnes 71 Reputation points
2022-01-20T04:24:36.14+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,851 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 41,006 Reputation points
    2022-01-20T09:12:50.437+00:00

    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?


1 additional answer

Sort by: Most helpful