ODBC SETUP - WINDOWS AUTHENTICATION

To avoid computer connectivity problems, please use the System DNS host name when configuring computers.

The host name of the server is: 128.118.75.84

INSTALLATION AND SETUP TO THE FISDATAMART for windows authentication

View PDF version

The first time you access the FISDataMart, you’ll need to follow these steps: 

  1. Open MS Access, select a blank database, give File Name and Click on Create
  2. Go to External Data, select New Data Source, Select From other sources and select ODBC Database 
  3. In Get External Data – ODBC Database screen, Select Link to the data source by creating a linked table.
  4. In Select Data Source screen, select Machine Data Source and select New
  5. In Create New Data Source screen, Make sure User Data Source is selected and click select Next
  6. In Create New Data Source screen, Select SQL Server Native Client 10.0 (Note: Alternative option would be SQL Server if, you do not have SQL Server Native Client 10.0) Click Next
  7. Verify that User Data Source Driver: SQL Server, Select Finish
  8. In Create a New Data Source to SQL Server screen
    1. Name: FISDataMart
    2. Description: Corporate Controller Data Warehouse
    3. Server: 128.118.75.84

             **Note: Select Next.

  1. At the ‘How should SQL server verify the authenticity of the login ID?' – Select : 'With Integrated Windows authentication'. (Note: first option)

        Select Next

  1. At the next dialog box, the default selections are fine.
    1. Change the language of SQL Server system messages to: keep English
    2. Use strong encryption for data - Unchecked
    3. Perform translation for character data - Checked
    4. Use regional setting when outputting currency. numbers. dates and times - Unchecked
    5. Save long running queries to the log files… - Unchecked
    6. Log ODBC driver statistics to the log files … - Unchecked

   Click on Finish. (You can test connectivity to the data source by clicking on the Test Data Source button.)

  1. At the next dialog box, select OK.
  2. Select Data Source window will popup, please select FISDataMart (Note: whatever the name you have given in Create a New Data Source to SQL Server wizard). Click ok.
  3. At the Link Table dialogue box, select the desired tables from the database and click ok.
  4. You might see another dialogue box opening, please select cancel on that popup.
  5. Now you should see tables been populated in all Access Objects in Access.
  6. Contact Saritha Kuchipudi if you have got different results than as you have expected.