Test SQL Server database connectivity from local machine

Simplest way is create an empty file by right click and new . Name it to something .UDL

Now double click on it and it should open something like below now enter the details and test connection