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.