Windows 10: Unable to connect to MSSQL database when Dns servers are added to second NIC.

Hi all,In our setup we have a machine that has 2 network interfaces. the 2 networks it is part of are both statically configured and completely separated. The two networks are:172.16.2.0/24 completely isolated network, unmanaged switches connect all the machines.192.168.150.0/24 connection to an external network. We have the following routing table:===========================================================================Interface List 13...c4 34 6b 60 42 9a ......IntelR Ethernet Connection I217-LM 11...68 05 ca 20 ac b4 ......IntelR Gigabit CT2 Desktop Adapter 1.........................

:)

 

Switching from mySQL to MSSQL

Hello all,
I a have a dilemma on my hands. MY application uses mySQL, and everything woks great. I planned to list mysql server as a requirement for my application, so that I didn't have to worry about licensing issues with distribution (my app is commercial, not GPL). My app uses libmysql.dll to connect to the mysql database instance, which, come to find out, must be licensed to distribute as well says Oracle.

So:
I planned to switch everything over to MSSQL express, which is totally free to distribute and use in commercial applications. I am used to mySQL server, not MSSQL. Upon installing MSSQL server, I discovered it uses local authentication (Windows username and pass)... Is there a way to set up MSSQL server to function like mySQL server? ex: requiring my connection string to use username, pass, DB name, and table name? The DB is accessed by both my app and an IIS site runnign on the same server.

Does anyone know of any good tutorials or sample walkthroughs of building a vb.net app that connects to and uses MSSQL server?

Thanks so much guys

 

DNS SERVER NOT RESONDING

Hi Rita French,

This issue often occurs when the DNS settings are incorrect. I suggest you to perform the following methods to troubleshoot the issue.

Method 1:

I would recommend you to change the Preferred DNS server and check if it helps.

• Press Windows + R keys to open Run window, type
  ncpa.cpl and press Enter.
• Right-click on the connection that you use for the local connection, and then click
  Properties.
• Click to select Internet Protocol Version 4 (TCP/IPv4), and then click
  Properties.
• In the Internet Protocol window, let's change the Preferred DNS server to
  208.67.222.222
• Click OK twice to complete the modification.

Note: If the issue persists, please repeat the steps and change the "Preferred DNS server" to 208.67.220.220.

Method 2:

If that does not help, try to flush the DNS. Follow these steps below.

• From Start screen, type Command Prompt.
• Right-click on Command Prompt and choose Run as Administrator.
• Type: ipconfig /flushdns and press Enter.

Note: The ipconfig /flushdns command provides you with a means to flush and reset the contents of the DNS client resolver cache. During DNS troubleshooting, if necessary, you can use this procedure to discard negative cache entries from the cache, as well
as, any other dynamically added entries.

Hope any of these methods help!

Kind regards,

Leon

 

PC not blocking ads despite correct DNS configuration

winver: 22H2 19045.2965 I am seeking assistance regarding a peculiar issue I've been facing with my PC's ad-blocking setup. I have set up a Pi-hole server and have correctly configured my PC's DNS settings to point to the assigned DNS of the Pi-hole server. However, despite these settings, my PC still fails to block ads. Here are the troubleshooting steps I have already tried:

• Verified DNS Configuration: I have double-checked and confirmed that my PC's DNS settings are correctly pointing to the Pi-hole server's DNS IP address.
• Tested on Other Devices: To ensure it's not an issue with the Pi-hole server itself, I have tested ad-blocking functionality on other devices connected to the same network, such as another PC, both wired and wireless, and various cell phones. Ad-blocking works perfectly fine on these devices, confirming that the Pi-hole server is functioning as intended.
• Previous Configuration with Docker: It's worth noting that I initially had Pi-hole installed on my PC using Docker, and it worked flawlessly in that setup. However, I later switched to using a separate device (Orange 3 LTS) dedicated to running the Pi-hole server. This is when the issue with my PC not blocking ads started occurring.

Considering the steps I've taken and the fact that ad-blocking functions properly on other devices, it appears to be an isolated problem with my PC. I'm puzzled as to why the DNS configuration is not taking effect on my PC specifically.