Steps to Migrate MS Access 2007 Database to SQL Server 2008 using Upsizing Wizzard

-          Install SQL server 2008 on the database server with the default settings.

-          Check if installed correctly by using SQL Server Management Tools.

-          Open SQL Server Configuration Manager, and go to SQL Server Network Configuration, click on Protocol for MSSQLSERVER and enable TCP/IP protocol. Check IP address with port 1433 (default port for SQL server).

-          Open SQL Server Management tools and connect to the server.

-          Right click server name and click properties.

-          Go to Security tap and enable SQL Server and Windows Authentication Mode found on the right pane. Click ok

-          Still on the SQL Server Management tools open Security-Logins at the left pane.

-          Right click Logins and click add new Login.

-          Type Login Name: wie_admin.

-          Chose SQL Server Authentication and type password for it.

-          Uncheck enforce password policy and click ok.

-          Open Logins and right click the user you have just created (wie_admin) and chose properties.

-          Go to Roles and check the following roles for this user: Dbcreator, public, serveradmin, and sysadmin.

-          Be sure that you enable telenet client service on the server.

-          Test the telenet on the server locally by write command:

telnet 10.242.25.231 1433.

-          If telnet connection is successful then you are now able to connect to the SQL server from any device.

-          On the Web server create new txt file on the desktop and rename it to SQL_TestConnection.Udl.

-          Right click the udl file and click properties.

-          On the connection tab, enter the server IP, chose enter specific username and password, select master database and click test connection.

-          If the connection is successful then you are now able to connect to the SQL server from remote server.

-          Now it’s time to migrate the Access Database to the SQL server.

-          Open the mdb access file using MS Access 2007.

-          Go to Database tools pane and click SQL server.

-          Chose create new Database, and click next.

-          Enter the IP of the server and remove check from Trusted Connection so that you can enter the SQL authentication username and password (wie_admin), click next.

-          Chose the tables you want to migrate, click next.

-          Keep the default selection on how you want to transfer your tables and data, but change the timestamp settings to NEVER, click next.

-          Chose No programs needed and click next then finish.

Process will start and you can progress how tables are transferred.