- 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