Using Microsoft SQL Management Studio Express
you can easily
backup, resote and execute queries against any EzParts V5
database.
Installing
If you have not installed Microsoft SQL Management Studio Express it is available in the soft folder on your original EzParts5 Distribution DVD or ISO.
Log on
After you have installed Microsoft SQL
Management Studio
Express you will need to start the application.
On startup you will be presented with a SQL Connect/Login
window.
You
need to select the Servername to connect
to. This is the
computername and MSSQL
instance name where the MSSQL Database Engine was installed. If you installed EzParts5
using the EzParts5
Application installer the server name will be computername/ezparts5
You will need to replace the computername with the name of the computer where you installed the EzParts5 database.
If you are not sure of what login and password to use select windows authentication and make sure you are logged on your local computer system as an Administrator.. Keep in mind that if you installed EzParts5 database other than the computer you are currently running Microsoft SQL Management Studio Express on and you have not configured your firewall on the installation computer you may not be able to connect properly. Configuring Windows firewalls is not covered by this document.
Create Database
To create a database in Microsoft SQL Management Studio Express right click on the database node shown to the right and select "New Database" from the menu.
Type a database name similar to the sample shown below and click the "OK" button. Using standardized database naming conventions is suggested.
Restoring a database
Right click on the database you wish to restore
Select Tasks | Restore | Database from the menu. This will open the Database Restore dialog window.
If you are restoring from a .BAK or backup file then under source select "From Device" and click on the ellipsis button (shown below highlighted in yellow) to select the backup file to restore from.
The Specify Backup window will be displayed. Click add to add your backup file. A directory navigation window/file selection window will be displayed. Select your .BAK or backup file and click "OK"
to return to the Restore
Database window. In the
Select The
Backup Sets To Restore area you will see a new backup file listed. Place a checkmark next to
this backup file to
select it.
Under Options on the
left of your Restore database Window you need to select Overwrite
Existing
Database and Leave the database ready to use as shown to the right
and below. Make sure all
other options are unchecked or
not selected.
Once you have configured these restore options you are ready to restore your database by clicking on the "OK" Button.
Assigning Login Permissions
You can assign user
permissions to the database by expanding the Security Node and
Login Node and
double click on the EzParts50Login user entry in the tree as shown on the left
This will display the Login Properties Dialog Window. On the left of the window select User Mapping.
This will allow you to assign the user access to databases on your server.
In the users mapped to this login section click
the
checkboxes next to any databases that this
user should be able to access.
and click on the elipses button to set the default schema to "dbo" as shown in the screenshot below.
For Each database
selection in the grid check the appropriate Role in the Database
Role
Membership on the bottom portion of the Login Properties Dialog
Window. For each EzParts5
Database that this user
will access you should set the role to db_owner and public as
shown in the
screenshot to the left.
When completed click on the OK button. The user EzParts50Login should now be able to access the new database.