Configuring MS SQL Server DSN

Select SQL Server ODBC Driver, and then click Finish. The Microsoft SQL Server DSN Configuration dialog box appears, as shown here:

• Select the IP address of the server or name of computer which is hosting your database from the Which SQL Server do you want to connect to? drop-down list.

Note:  If you are running the database on your computer, you will not need to configure these settings; SQL will automatically configure it for you.

• Click Next. The second page of the Microsoft SQL Server DSN Configuration dialog box appears.

• Enter USERNAME into Logon ID box
• Enter PASSWORD into Password box
• Click Next. The third page of the Microsoft SQL Server DSN Configuration dialog box appears.

• Select Change the default database To: option and select the database on the server you want to connect from the drop-down list
• Click Next. The fourth page of the Microsoft SQL Server DSN Configuration dialog box appears.

• Click Finish. The ODBC Microsoft SQL Server Setup dialog box appears.

• Click OK to apply the confifuration.

You can test whether your settings are suitable for connecting to the server using the button Test Data Source....