question

MarianoDabove-4155 avatar image
0 Votes"
MarianoDabove-4155 asked MarianoDabove-4155 answered

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

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...

95488-image.png
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...


95586-image.png
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...


sql-server-general
image.png (16.1 KiB)
image.png (15.4 KiB)
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.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @MarianoDabove-4155,
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.

100177-image.png

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.



image.png (13.5 KiB)
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.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered AmeliaGu-msft edited

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.



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.

MarianoDabove-4155 avatar image
0 Votes"
MarianoDabove-4155 answered

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...

96141-image.png

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

96142-image.png

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!!!


image.png (41.7 KiB)
image.png (9.7 KiB)
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.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

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`

96296-01.jpg

Best Regards,
Amelia







01.jpg (91.3 KiB)
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.

MarianoDabove-4155 avatar image
0 Votes"
MarianoDabove-4155 answered

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...

96355-image.png

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


image.png (127.1 KiB)
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.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi MarianoDabove-4155,
Glad to know that another SQL Server instance is working.
For the network configuration 32- bit registry key, it should be under the HKLM_LOCAL_MACHINE\Software\WOW6432Node\Microsoft\MSSQLServer\MSSQL11.BRIO. But from the screenshot, it seems the registry key doesn’t exist.
Could you please check if the instance BRIO is 32-bit? If it is 64-bit instance, then you can find the network configuration registry key in HKLM_LOCAL_MACHINE\Software\ Microsoft\Microsoft SQL Server\ MSSQL11.BRIO\MSSQLServer\SuperSocketNetLib. And 32-bit registry key should not exist.
96605-01.jpg
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.



01.jpg (97.3 KiB)
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.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi MarianoDabove-4155,
In addition, for "acceso denegado" error, please try the solution in this article which might help.

Best Regards,
Amelia


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.

MarianoDabove-4155 avatar image
0 Votes"
MarianoDabove-4155 answered MarianoDabove-4155 edited

Hi Amelia Glad to hear news from you... I found that my post was reach 404 yesterday and i was very afraid that was erased...

Here i follow your steps then i found that yes its a 64 bit architecture but in the server configuration manager it doesnt be displayed....

96734-image.png

Here is the image that corrobors it but in my sql server configuration i dont have anything of this...

96762-image.png

Edit: I checked the article you provide to me and yes i fix a regitry so i can "see" the configuration manager but i dont know how to use that tool to check what are the "access denied" registry keys because the filter section for me its no so clear to follow or what process should i need to search.... Because some pages says the sqlsrv.exe should i look here svchost.exe but if you can guide me to how to follow this could be awesome because there is the root of the problem i think....


image.png (124.3 KiB)
image.png (35.4 KiB)
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.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered

Hi @MarianoDabove-4155,
Thanks for your reply.

i found that yes its a 64 bit architecture but in the server configuration manager it doesnt be displayed....

For 64-bit SQL Server 2012, sqlmgmprovider.dll is located at Program Files\Microsoft SQL Server\110\Shared. Please try to copy it from another machine which is working correctly.

use that tool to check what are the "access denied" registry keys because the filter section for me its no so clear to follow or what process should i need to search...

You can add the filter like Result is Access denied and Process Name is svchost.exe in filter.
97111-01.jpg

97103-02.jpg
Then click Ok to filter.

97112-03.jpg

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.



01.jpg (97.3 KiB)
02.jpg (54.9 KiB)
03.jpg (60.4 KiB)
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.

MarianoDabove-4155 avatar image
0 Votes"
MarianoDabove-4155 answered

Hi Amelia good Monday sorry if i dont reply to you during weekends but i was away from my work and i cant access by remote control...

Let me tell you that yes i replace that archive with a new one from another sql that works correctly but when i try to run that mofcomp it didnt came out at the end of that...

About the Process Monitor let me put you what does the results brings to me in the moment i run the search...

A question... did i need to run the mofcomp then when i run i check the process so i can know where is giving the error???

97118-01.jpg

Where could it be the issue???

If i put the svchost.exe it didnt bring any results with that kind of "Access Denied"...


01.jpg (266.2 KiB)
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.