Access to SQL Server which is #1 in Hands-On Training Machine where you completed the SQL Express installation.
Log onto the Server via Administrator. (Password is what you configured)
Go to Start menu, and you will see “Microsoft SQL Server 2022” menu folder. Expand it, and click “SQL Server 2022 Configuration Manager.”
To use the SQL Server and database from the other machines over TCP/IP network, you are better to enable the TCP port access against this SQL Server. Go to “SQL Server Network Configuration -> Protocols for SQLExpress (SQLExpress is what you configured in SQL Server installation, it may be different in your choice.)
See the TCP/IP is being Disabled.
Right click “TCP/IP” and “Enable”.
Right click “TCP/IP” and “Properties”.
Move to “IP Addresses”. And check the IP address of this node.
At the “TCP Port” of above IP address section, set “2500” as it is SQL Server defect TCP port number. And then, Apply. Close the properites.
Go to “SQL Server Services”. in SQL Server Configuration manager.
At the right pane, right click “SQL Server (SQLEXPRESS). (SQLEXPRESS is the name you configured in the SQL Server installation stage.) And then, Restart.
The service will be stopped and started.
Confirm the SQL Server is running.
You completed minimum SQL Server Configuration. Close the SQL Server Configuration Manager.
