Test Remote Connection MSSQL (ODBC) Database on Windows (Clinet)
This post describes about how to test the MSSQL - ODBC database remote connection on windows system. We have already discussed to allow MSSQL database remote connection on Windows Server 2012.
I have tried on Windows Server 2012, the database user name is "sa" and password is "Administrator user password"
Open your Control Panel --> Administrative Tools --> ODBC Data Sourcess
Step 1 : Click on "Add" button,
Step 2: Choose "SQL Server Native Clinet 11.0" click on "Finish"
Step 3 : Enter your data source name, description and MSSQL Server IP Address
Step 4 : Enter your database user name and password. Click on "Next" button,
Step5: Click on "Next" button
Step 6: Click on "Finish" button,
Step 7: Now the remote connection is configured, if you want to test it click in "Test Data Source.." button
Now, you view the details "TESTS COMPLETED SUCCESSFULLY!"