From the potential program or method, I am hoping to find via this topic. I confirmed the query by using excel, so all I need is a program that...

How about this, would this be helpful?

WHILE NOT EXISTS (SELECT  * FROM table1 WHERE Text LIKE '%fire%' ) BEGIN
    WAITFOR DELAY '00:00:10'
END;
THROW 50000,'Some...

• This reply was modified 2 years, 5 months ago by  mybne.

From the potential program or method, I am hoping to find via this topic. I confirmed the query by...

• This reply was modified 2 years, 5 months ago by  mybne.

You will need to set a static port and open that in the firewall instead, along with UDP 1434

This should help with that.

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver16%5B/quote%5D

Thank you, sir, spot on....

• This reply was modified 2 years, 5 months ago by  mybne.

Thanks, gentlemen. Ant-Green was right. Via localhost, I can connect but not from other PCs this time. I receive the below error.  Firewall is off for now.

Details:...

• This reply was modified 2 years, 5 months ago by  mybne.
• This reply was modified 2 years, 5 months ago by  mybne.