How to check if my SQL Express is working?

Question

I'm totally new to SQL and Windows. I need to install a piece of software on my brand new Windows Server system (iMonnit Enterprise) and it required SQL to be running. I installed SQL Express, which didn't complain. Now the iMonnit application wants a Server Name, username, and password in order to connect to the SQL. How do I indicate "localhost" (same machine) to it, and what's the default credentials after install? I tried MONNIT\SQLEXPRESS , sa, and RPSsql12345, but it's not able to access the database. What am I doing wrong - how do I check that the SQL server process is actually working and log on successfully?

Answer 1

Hello,

install SSMS = "SQL Server Management Studio" and try to connect with that tool; for a local named instance of Express the default name is ".\SQLEXPRESS"

Download:
https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15