-
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.