This article describes how to restore WMS database using SQL Studio Express.
First, navigate to Start -> Programs -> Microsoft SQL Server 2005 -> SQL Server Management Studio Express
Upon opening the program, you should be prompted with a Connect to Server box. Fill out the fields with your database information.
The Server Name field is the IP of the Database Server. You also must include ‘,2433′ after the IP to specify port ’2433′.
The Authentication field should be SQL Server Authentication by default.
The Login field is the username you have set up for the database.
The ‘Password’ field is the password you have set up for the user.
Upon connecting, you will see a window similar to the picture below. On the left, select/expand Databases and find your Database name.
Right click on your database and go to Tasks -> Restore -> Database
Select From device and click the small grey box on the right labeled … . A window will pop up, Click Add and browse to the location of your .bak file. Click OK.
Check the checkbox under the column Restore next to the database information in the bottom pane.
Select To database: as required (if you restoring existing DB select that or type the your prefer you create new DB )
Go to the Options (top-left).
Check Overwrite the existing database.
Click OK to begin the database restoration.
Now that your database is restored, we have to make sure the users associated with the database have proper permissions. (Datapel user is must)
Collapse the Databases directory in the left window. Expand the Security folder and go to Logins and find the Username associated with the database. Right click on the Username and go to Properties.
Go to the User Mapping on the top-left. Locate your database in top-right window pane list and make sure the checkbox is checked next to it. Once the database is selected, make sure below checkbox are checked in the bottom window pane as below and click OK.
Disconnect and Conect back to SQL and login to WMS to update the Database.