Set up ODBC connection with Microsoft SQL Server

A linked server needs to be setup using the MS Management Studio. Below are the steps:
(MSDASQL has to be downloaded and installed piror to following the steps below if not yet preinstalled with Microsoft SQL Server Management Studio.)

1. Open MS SQL Management Studio and go to Server Objects > Linked Servers > Providers menu tree. Right click the MSDASQL and set these options:
    - Dynamic parameter
    - Nested Queries
    - Allow inprocess
    - Supports 'Like' operator
 
2. Right click on Linked Servers, select New Linked Server and on the General tab, set the following:
    - Linked Server: NETSUITE 
    - Provider: Microsoft OLE DB Provider for ODBC Drivers
    - Product Name: NetSuite.com
    - Data Source: NetSuite.com //Copy the DSN name from ODBC Data Source
    - Provider String: DSN=NetSuite.com
 
On the Security tab, select *be made using this security context, and enter Login email and password
 
3. Try to execute SQL to test the connection
 
Select * from [Linked Server].[Company Name].Administrator.Accounts
 
Note:
1. This procedure is also applicable to MS SQL Server 2008. 
2. [Company Name] is the one found at Setup > Company > Company Information > Company Name