Share via

When i try to connect MSSQLSERVER server it doesn't appear and only the SQLEXPRESS server appears.

ABDELHALEEM MOHAMMED 20 Reputation points
2024-07-05T01:05:50.22+00:00

I've installed SQL2022-SSEI-Dev then installed the SQL2022-SSEI-Expr then the SSMS-Setup-ENU when i open the SSMS to connect a server i cant find DEV server and only the Express server appears. What's wrong and how to fix?
Uploaded image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,856 questions
Accepted answer
  1. Olaf Helper 44,741 Reputation points
    2024-07-05T05:22:51.7933333+00:00

    I've installed SQL2022-SSEI-Dev then installed the SQL2022-SSEI-Exp

    By default the Express Edition get's install as "named instance" = "SQLEXPRESS"

    "MSSQLSERVER" is a pseudo instance name, which do not really exists by name, it's the "default instance". In your list it's just the machine name "HALEEMO"; select that one to connect to.

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. MikeyQiaoMSFT-0444 3,105 Reputation points
    2024-07-05T06:23:58.0133333+00:00

    Hi,ABDELHALEEM MOHAMMED

    Use SSMS to view the existing instances on the machine：User's image

    look for connectable instances in the Browse for Servers in SSMS.User's image

    1 person found this answer helpful.
    0 comments
  2. Erland Sommarskog 111.7K Reputation points MVP
    2024-07-05T09:15:48.32+00:00

    Just connect to HALEEMO. That should be your default instance running Developer Edition.

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.