Easiest way to check a connection for a MSSQL database:

Create a file called : myfile.udl

Paste the following content (make sure to use your settings):

[oledb]
; Everything after this line is an OLE DB initstring
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=myUsername;Data Source=100.200.3.4;Password=myPassword