1

I installed an instance but there is no option for Protocols for <instance_name>. In the image it only shows two options from another software (TIA PORTAL, maybe) and show none of the installed instances. How do I fix this since I really need to enable TCP/IP for my instance to be connected remotely. I already configured mixed mode authentication, allowed remote connection to instance and opened port 1433 in firewall. no options for Protocols of installed instances

Improve this question
5
  • Do you have another menu item under 'Azure Extension For SQL Server' named 'SQL Server Network Configuration'? I just installed SQL Server Express 2022 edition. I see 'Protocols for SQLEXPRESS' under 'SQL Server Network Configuration.'
    – SqlWorldWide
    Commented Jun 13 at 14:17
  • Unfortunately there's nothing under Azure Extension For SQL Server
    – stanps7
    Commented Jun 13 at 14:43
  • Can you try to open mmc.exe and open this file C:\Windows\SysWOW64\SQLServerManager16.msc? I want to make sure you are opening the right file in case you have a different version installed on the same host.
    – SqlWorldWide
    Commented Jun 13 at 14:52
  • I tried opening that file from mmc.exe and it shows the error: MMC could not create the snap-in. The snap-in might have not been installed correctly
    – stanps7
    Commented Jun 13 at 15:18
  • I suggest you resolve that issue first and then try again. There are a few options here.
    – SqlWorldWide
    Commented Jun 13 at 15:25

2 Answers 2

Reset to default
2

You do not see the complete list of items on the left side because the SQL Server Configuration Manager Snap-in is not installed correctly or is corrupted.

If installed correctly, you will see the SQL 2022 SQLEXPRESS edition Protocols under 'SQL Server Network Configuration'.

In the example below, this SQL 2022 Express Edition is installed as a named instance (SQLEXPRESS):

enter image description here

Improve this answer
0
1

It is incredibly simple for me to solve the "could not create snap in" by following these steps:

  1. Go to path "C:\SQL2022\Express_ENU" (can differs a little bit on different version)
  2. Run SETUP.EXE as administrator then navigate to Maintenance. Choose Repair, specify one instance,follow the instruction and wait until the process is done

This should fix the "could not create snap in" error in mmc.exe when opening SQLServerManager16.msc

I still cannot fix error missing Protocols for <instance_name> but will update as soon as possible.

Improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.