Creating A New SQL User for the Image Gallery Pro Database

AdComplete.com, LLC
4536 Grove Park Dr..
Tallahassee, FL 32311
407-551-0777 Phone

Home

Purchase

Features

Preview

Support

Installation

FAQ's

Creating A New SQL User for the Image Gallery Pro Database

Choose a version of SQL Server:

SQL 2005 Instructions

Always create a separate user for your Image Gallery Pro database. Do not use an existing user such as the SA account for security purposes.

Launch SQL Server Management Studio Express edition from your Start--Programs--Microsoft SQL Server 2005 menu and connect to the server.
Create New Login for the ImageGalleryPro database. Within SQL Server Management Studio Express, expand the tree down to Security then expand logins.
Right-mouse click on Logins and Select New Login.
Enter the Login name as "ImageGalleryPro" or choose another desired username.
Choose SQL Server authentication.
Enter a unique password then confirm the password.
Uncheck the box "Enforce password expiration".
Under Default Database, select the appropriate ImageGalleryPro database.
On the left side, click "User Mapping".
Check off the Map checkbox next to the ImageGalleryPro database. At the bottom, click db_owner in addition to public.
Click OK. If you get an error relating to the password you must enter a longer password.

SQL 2000 Instructions

Create a new SQL user to access the Image Gallery Pro database. From within SQL Server Enterprise Manager, expand the tree down to Security.
Right-mouse click on Logins and Select New Login.
Enter the name as "ImageGalleryPro" or any other name as desired.
Choose SQL Server authentication.
Enter a unique password.
Under Database, select the appropriate database such as "ImageGalleryPro".
Select the Database Access tab.
Click the Permit check box for the ImageGalleryPro database.
Click OK and confirm password.