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.

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

Yes, please run the command prompt mofcomp sqlmgmproviderxpsp2up.mof first, and then run the process monitor.

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

Hi Amelia here is what the Process Monitor brings to me when i run the mofcomp....

97612-image.png



image.png (97.9 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.
97760-01.jpg
Please go to and right-click the above registry key ->Permissions to make sure you have read permission.
97841-02.jpg

And you also can try to add Network service on the above key as the article mentioned.
Please remember to backup the registry before editing it, and check if there are any other processed that deny access.

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 (39.0 KiB)
02.jpg (51.9 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 ErlandSommarskog commented

Well @AmeliaGu-MSFT good news! we could fix the .mof file in the SQL Server and we can rebuild the x64 architecture of the Database...

Now we have an issue that the other pc who is running in Linux cant conect to the database...

And when i check the IPV Values in the Protocols of my Instance i saw this things...

97836-02.jpg

97942-image.png

The correct ip of this server is not 0.248 its other so i dont know if we need to change that value to the correct one so that server could reach the database or where i need to redirect so we can have an established connection...

Right now the other server throws out a "Connection Timeout" when i try to connect with the ip and the current port i dont restart the services of the database so i dont know if this could be the cause too...



02.jpg (22.6 KiB)
image.png (11.0 KiB)
· 1
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.

Well, SQL Server does not set those IP addresses... A machine can have more than one network, and thus more than one IP-address. When I look in SSCM on my machine, I find 14 entries under the IP Address tab Some are standard addresses like 127.0.0.1, but I also have VMWare on this machine, so there are a couple of networks created by VMware, so you may see something similar.

This is not the only IP address you see, is it?

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

Hi @MarianoDabove-4155,
In addition, you also can find the IP address for server in cmd using ipconfig /all:
98213-01.jpg
And please try to use the ip address and port to connect to SQL Server. If there are any error message, please feel free to share us.

Best Regards,
Amelia



01.jpg (128.6 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

This is what ipconfig /all trows...

98310-03.jpg

This is the correct ip of my server and i change that value in the server configuration network and protocols for my instance to that ip...

When we try to conecto to that ip with the port that trrows the IPAA it give us the "Connection TImeout"...

How can i run a cmd to conect to my instance from a different pc to this server using the port and ip adress (or public ip with the port) so i try to check that the connection is stablished and is not an error of the configuration of the server that now runs the other server???.


03.jpg (171.6 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.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

How can i run a cmd to conect to my instance from a different pc to this server using the port and ip adress (or public ip with the port) so i try to check that the connection is stablished and is not an error of the configuration of the server that now runs the other server???.

That's really a different question and it would be better to start a new thread. Except that this is one we answer about daily. Check the usual suspects: firewalls, is SQL Server running, does it accept remote connections, is the servername/IP address correct? The port number? Keep in mind configuration changes in this area do not take effect until SQL Server has been restarted.

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,
Sorry for the delay.
In addition, we can use sqlcmd in cmd to connect remote SQL Server.
Please refer to Access Microsoft SQL Server remotely with command prompt  and this doc which might help.
If you have more question about connection, suggest you open a new thread in the forum. If you find any post in the thread is helpful, you could kindly accept it as answer.

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

Hi there sorry to for not to reply @AmeliaGu-msft

I wil ltry to use that command you suggest if i can reach by windows cmd to the Database...

If not the programmer that notice this issue told me this...

From Linux he used a comand called nmap to check what ports are open and wich not and he show me those things...

In the server that has the issues he show me those ports...

99848-01.jpg

then in our different server that we use as a back up to mount the webservice who runs this server he shown us this thing...

99826-03.jpg


I found that the common port of Sql Server runs displays a common server that is the one highlighted in the image.-

So the next the thing that the programer shown to us is trying to reach with the default port to the database of the first server and get a "rejected from server" status..

99855-05.jpg

But if he tries with those "unknown ports" that are displayed in the first image he establish a connection with the server i think of with something...

99862-02.jpg

My question is now... 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??

And how can i assign the "service" that is displayed in the second image in my main server because this rings me a lot how it didnt is displayed in those ports that he see in the Server...

@ErlandSommarskog about your questions my server has the correct ip / servername, this server accepts remote sesions because right now im conected by remote desktop to this server and my issue for me radicates in the firewalls / ports because if you follow this thread this issue occurs when i try to get this server inside a domain and because we have a negative response from the software we use in production we decide to exit this one to the domain and this is when the conflict between those two servers occurs... One of the servers is running in Linux the other one (the database) in Windows.


01.jpg (54.2 KiB)
03.jpg (43.8 KiB)
05.jpg (12.0 KiB)
02.jpg (37.8 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.

ErlandSommarskog avatar image
0 Votes"
ErlandSommarskog answered

First you need to find out on which port SQL Server is listening on. You can see that in SQL Server Configuration Manager. You can also find it the SQL Server errorlog (which are in /var/opt/mssql/log/errorlog on the Linux system I look at). It should come fairly early, on the first 100 liines or so.

Then you can open these ports in the firewall.

As for the display in the SERVICE column, I believe that only reflects standard ports. So it will say 1433 for ms-sql-s no matter what is running there. And if you have SQL Server listening on port 47123, it will always unknown.

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.