Now a dialog will launch. It will show you the credentials to login to
MS SQL Server. Make sure you have entered the correct information. Also
make sure you are using SQL credentials to login.
Click the Test
connection button to make sure the connection is
Now click the Save button to save the settings.
Testing if the machine is able to connect to SQL Server...
Click on 'Start > Control Panel > Administrative Tools > ODBC Data Sources (64-bit)’. The’ ODBC Data Source Administrator (64-bit)’ window will pop up. Note: If you are using a 32 bit operating system, please use 'ODBC Data Sources (32-bit)'.
On the ‘User DSN’ tab, click on the Add button. The ‘Create New Data Source’ window will pop up.
Select the option ‘SQL Server’ from the List displayed and then
click on the Finish button. The ‘Create a New Data Source to SQL Server’
window will pop up.
Enter the name, description and SQL Server for the data source. Click on the Next button. (You will need to enter the Server name in the format MachineName\InstanceName ).
Choose the option ‘SQL Server Authentication using a login ID and
password entered by the user’.
If you are using a custom port instead of the default 1433, you will need to click on the Client Configuration button.
Uncheck the checkbox 'Dynamically determine port'. Specify the custom port being used. Click OK.
Enter the Login ID and password and click
on the Next button.
If you proceed to the next page, it means
that you have connected to MS SQL Server. Other wise it should give an
error saying ‘Connection Failed’.