Connect to SQL Server via ODBC in Windows OS

From Start > Go to SQL Server configuration manager

Expand: SQL Server network configuration

Choose: Protocols for database

Right Click on TCP/IP and Enable

From Start > Go to SQL Server services

Restart: SQL Server instance(database)

From Start > Go to Control panel > Administrative tools > ODBC data sources 64/32 bit

Choose: System DSN > Add

Choose: SQL Server from the list

Give a name for the ODBC data source

Provide the name of the server: Copy the Server Name from the SSMS (SQL Server Management Studio) and paste it here. (From Start Go To SQL Server Management Studio)

Choose: With Windows NT authentication using the network login id.

Change: the default database to your preferred one.

Finish

Test data source