Sql Server Network Configuration (32 Bit) is empty after leave my server from a domain

Question

Hi There guy i have an issue that occurs about 2 weeks ago...

We have a Windows Server 2012 r2 running our Sql Server Production Database that has Windows Authentication credentials to login in the Micrososft Server Managment Studio and out main Software that we use to work in here...

The thing was when we join that server to our New Active Directory (we use Super Admin account to do it) we have some issues to connect the odbc of the computers so we decide to exit from the Domain that Server and go back with the common settings we have later on...

When we do that we found that we cant enter to the Sql Server Configuration Manager it gives you an error from the WMI service... That was this one...

"Cannont Connect to WMI Provider you do not have permissions or the server is unrecheable. Nota that you can manage SQL server 2005 (??? we have 2012) and later Servers with SQL Server Configuration Manager. Invalid Class [0x80070005]"

Digging some information i nthe internet i found some member that says that i need to add NETWORK SERVICE (or something like that) to an Registry Entry.. With this we could open the SQL Server Configuration Manager but when i check the SQL Server Network Configuration (32 bits) its empty and dont show my Protocols of connection from my instance... (And to be clear we have a 32 bits SQL Server Conf its not a 64 bits).

Some of the other things that i saw digging about this issue is some say that i need to recompile the sqlmgmproviderxpsp2up.mof using that command prompt "mofcomp sqlmgmproviderxpsp2up.mof"

and when i run this one the command gives me this thing...

Another thing all of my working computers are working correctly and have connection to the database all this comes because we have a linux server (that is in the same network as i) and when they try to connect to that server it trows out a connection refused error when they try to acces to the port that is open...

How can i solved that without uninstalling all my production enviroment because this is the core of my company and doing that i dont know what could come around if i doing that...

Answer 1

Hi @Mariano Dabove ,
Thanks for your reply.

where i need to put those ports... in my firewall configuration of the Server who runs the Sql Server or in the Sql Server Configuration Managment??? or in both??

As Erland mentioned, please check the port SQL Server is listening on in the SQL Server Configuration Manager->SQL Server Network Configuration-> Protocols for instance->TCP\IP properties.
By default, the default instance that SQL Server listens on is port 1433. For a named SQL Server instance, the ports that are used to talk to the SQL Server are by default dynamic.
In the TCP\IP properties dialog box of SQL Server Configuration Manager, if the TCP Dynamic Ports dialog box contains 0, indicating the Database Engine is listening on dynamic ports.

We can configure the instance to listen on a specific port, so that the appropriate port can be opened in the firewall. To assign a TCP/IP port to the SQL Server instance, please delete the 0 in the TCP Dynamic Ports dialog box and set the TCP Dynamic Ports to blank, and in the IPn Properties area box, in the TCP Port box, type the port number you want this IP address to listen on, and then click OK. Multiple ports may be specified by separating them with a comma. Please refer to this article which might help.
Then we need to add a firewall exception for the port. Please refer to this doc which might help.
Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi MarianoDabove-4155,

when i check the SQL Server Network Configuration (32 bits) its empty and dont show my Protocols of connection from my instance...

Could you please check if sqlmgmprovider.dll which is responsible for the Network and Native Client configurations is corrupted or missing? For 32-bit SQL Server 2012, sqlmgmprovider.dll is located at Program Files (x86)\Microsoft SQL Server\110\Shared\ . If so, we can just copy it from another machine which is working correctly.

In addition, SQL Server network configuration (32bit) is specified in the following registry key:

HKLM_LOCAL_MACHINE\Software\WOW6432Node\Microsoft\MSSQLServer\MSSQL12.instancename\MSSQLServer\SuperSocketLib\  

We can use it to configure SQL Server network configuration before resolving the issue.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 3

Hi there Amelia..

How do i know if that file is corrupted?? Because the file is there in the folder that you mention it...

About the Path of the Registry it doest say anything about that let me put a picture of what is shown...

It Says Client and not the name of the Instance that is...

We have those folders in a different disk partition in the production this could be the issue that it didnt be shown in the registry???...

Tomorrow i will update how it was the replacement of that file because now they are ussing the server the company...

Thanks you for your Reply!!!

Answer 4

Hi MarianoDabove-4155,
Thanks for reply.

It Says Client and not the name of the Instance that is...

Could you please show the registry key? It seems you are located at sql server client configuration registry key: HKLM\Software\Microsoft\MSSQLServer\Client
Please check if there are registry key under HKLM_LOCAL_MACHINE\Software\WOW6432Node\Microsoft\MSSQLServer\

Best Regards,
Amelia

Answer 5

Hi Amelia Good Morning for me hahaha...

YEsterday i replace the .dll with one that works in another sql instance that i have and still the information that will have in sql network protocols doesn't shown up... Either i try to run the mofcomp to recompile that file and the problem still persist...

And yes i was looking in the wrong direction i follow the steps you mention now and i reach this...

Those are the only things that are displayed in that location...