Set up a server for Best Bid with step-by-step instructions

General Overview

1. Download and install SQL Express 2022
2. Install SSMS 21
3. Open SSMS 21 Tools, activate the sa user, and set a password. Make sure the login status is enabled and the server authentication is set to SQL Server and Windows Authentication mode (as shown in the video).
4. Before configuring the SQL connection, you must set a fixed IP address.
5. The IP fixing process is shown in the video.
6. After that, try connecting with the sa user from CMD, then install Microsoft ODBC Driver 17 for SQL Server (as shown in the video).
7. Once ODBC is installed, open SQL Server Configuration Manager, enable TCP/IP, and in IPALL, set TCP Port = 1433.
8. Restart the SQL Server.
9. Test the connection using the following command (as shown in the video):
   sqlcmd -S 192.168.0.110,1433 -U sa -P sql@s3rv3r#

   sqlcmd -S <ipaddress>,<port> -U <username> -P <password>

   got this from sqlcmd utility
   I just created this sqlcmd with specific ip and port

10. Configure the SQL connection in the software, then click Process to create the SQL Database.
11. Verify the database (as shown in the video).
12. On another PC, create a Shared Folder (follow the video).
13. Set Shared Folder permissions for Everyone (or assign specific users as needed).
14. Follow the video carefully for all remaining steps.