question

MichaelLevin-9347 avatar image
0 Votes"
MichaelLevin-9347 asked ErlandSommarskog commented

How to check if my SQL Express is working?

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?

sql-server-generalwindows-server
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

but it's not able to access the database.

So what happens? Do you get an error message? If so, share it.

0 Votes 0 ·

1 Answer

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.