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.

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

Hi there @AmeliaGu-msft and @ErlandSommarskog

Yesterday at last we can make it work the Linux server and now is fully accepting connections from my production database server!!

We dont know what we do because the Infraestructure Manager in my company recovers a back up from a days ago (the problem in those days was still persisting)...

I put the rule in the inbound entrances of the firewall in my production server but with or ot without those rules the conections was still stablished either way...

We dont really know what we do or if bringing back that back up was the solution...

The problem was solved and those solutions that you all post here it serves to me so i can get much more knowledge if i get future problems with something like that!..

Thank your for your time and predisposition in those weeks for us was a tornado all of this we are really happy that this comes to an end...

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.