MS2SQL

Considerations Prior to Setup:

  • Make sure to read the pre-requisites from Microsoft
  • All downloads need to be run with Local Admin or Domain Admins rights

I. Installing Microsoft SQL

  1. Install SQL from this link: https://www.microsoft.com/en-US/download/details.aspx?id=42299
  • Make sure to download the studio along with the database itself.
  • Make sure you are downloading the proper version (32-bit or 64-bit).

2. Run SQL studio manager as Administrator & log in using Windows authentication.

3. In SQL, navigate to the ‘Object Explorer’, then left click on “Database” then right click to view a dropdown menu. Choose “Create New Database”.

4. A separate window will appear titled “New Database.” Here, allocate a name to your database.

Note: The name you allocate does not matter but keep the database name relevant.

Click ‘OK’ to create the database.

5. Next, we will create the SQL user that will be used to have full rights to your database. Navigate to the “Security” folder and left click to select “Logins” and then right click to “Create login”.

6. A separate window will appear titled “Login – New”. Here, create a login name.

  • Choose SQL authentication and assign a password to the account.
  • Uncheck “Enforce Password Policy”
  • In Server roles, select sysadmin.
  • Clicking on “User Mapping”, click on the check box next the newly created database. At the bottom titled “Database role membership for: ‘xxxx’”, select db_owner.
  • Finally, click on “OK” to confirm changes to your newly created SQL user account.

7. Next,  left click on the “Name”.

For example, the name can be: DESKTOP-6KSSSJG\IS2000

Right click on the SQL server and select the properties at the bottom of the drop-down menu. Right click on the “security” page to allow the user to activate “SQL Server and Windows Authentication mode.”

8. Change the Authentication from Windows to SQL and enter the new log in. Test the newly created Log in by disconnecting from the database within the Object Explorer and reconnect to the database.

II. Running the Conversion Process

  1. Open SQL Server Configuration Manager. Click on “SQL Server Network Configuration” and enable the following:
  • Shared Memory
  • Named Pipes
  • TCP/IP
  1. Navigate to the IS2000 folder on the server and locate an application called: “Access2SQL”
  2. Run the application as an admin

IMPORTANT NOTE: If SQL server is on another box, the ‘SQL Browser’ service must be enabled and running to communicate.

4. Fill out the required fields with the appropriate information:

  • Enter the SQL Machine Name and Database Name (e.g. DESKTOP-6KSSSJG\IS2000)
  • SQL user name & password
  • Database Name

5. Click on the arrow at the bottom to commence the conversion process. Once the conversion is complete, please run IS2000 from the server to confirm the conversion is functioning correctly.