Connect ssms to sql server

You start SSMS. When you get the connection dialog, enter a single dot if you installed a default instance (*). Make sure that you check Trust Server Certificate. Off you go.

(*) If you installed Developer Edition and went by the default, then you have a default instance. If you installed Express Edition, you should enter .\SQLEXPRESS, as Express Edition defaults to installing a named instance.

Follow these steps to connect SQL Server Management Studio (SSMS) to a new SQL Server 2025 installation:

1. Start SSMS
   • On Windows, open Start and search for SQL Server Management Studio.
   • Launch the SQL Server Management Studio app.
2. Open the Connect dialog
   • If the Connect to Server window does not appear automatically, select Object Explorer > Connect > Database Engine.
3. Enter server connection details In the Connect to Server dialog:
   • Server type: Leave as Database Engine.
   • Server name (on the same machine as SQL Server 2025):
     • For a default instance: use the computer name or localhost or .
     • For a named instance (for example if installed as SQLEXPRESS or another name): use COMPUTERNAME\INSTANCENAME.
   • Authentication:
     • Use Windows Authentication if the Windows account is configured as a SQL Server admin during setup.
     • Or choose SQL Server Authentication and enter the Login (for example, sa if enabled) and Password configured during SQL Server setup.
4. Connect
   • Select Connect.
   • On success, Object Explorer shows the SQL Server 2025 instance and its databases.
5. If connection fails
   • Verify SQL Server is installed and running.
   • Confirm the instance name (default vs named) and correct spelling.
   • If connecting remotely, ensure firewalls and network configuration allow access and that SQL Server is configured for remote connections.
   • For more detailed connectivity troubleshooting, use the guidance in Troubleshoot connectivity issues in the SSMS quickstart.

Once connected, use New Query in SSMS to run T‑SQL, create databases, tables, and manage the SQL Server 2025 instance.

References:

• Quickstart: Connect and query a SQL Server instance using SQL Server Management Studio (SSMS)
• Use SQL Server Management Studio on Windows to manage SQL Server on Linux
• Lesson 1: Connecting to the Database Engine
• What is SQL Server Management Studio (SSMS)?
• System requirements for SQL Server Management Studio