How to test connection to SQL Server database

Navigation
2

I have an application that connects to SQL Server, but in a client terminal it is returning a random error.

I would like to know if I can test the connection of this terminal with the SQLServer server, in isolation from my application. And if possible make an appointment.

When the database is oracle I can do this with TNSPing and SQLPlus, but I do not know how to test it with SQLServer.

You're pinging the bank server, the only test I've been able to do.

S.O .: Windows 10

    
asked by anonymous 14.06.2018 / 15:44

1 answer

3

Create a new blank txt file on the computer you would like to test:

Andthenchangeyourextensionto.udl:

Runthisfileandyoucantesttheconnectiontothedatabase:

    
14.06.2018 / 15:52
How to check if all the data in my list exists in the database? Find and Replace in bash