My Sellerdeck Account | Free Trial

Sellerdeck Community & Knowledge Base

Old 01-Jun-2011, 04:05 PM
G.W.Green G.W.Green is offline
Join Date: Sep 2005
Full Name: G.W.Green
Posts: 485
Thanks: 0
Thanked 68 Times in 43 Posts
Licensing a new site with an SQL Database

With SellerDeck Enterprise you have the option of licensing a site using a Microsoft Access database or Microsoft SQL database. If you choose the SQL option, there are a few options to complete before the site is created:

  1. In SellerDeck, go to ‘File | Sites | Database Setup’
  2. Enter the correct SQL Server instance name in the ‘SQL Server’ field. You will need to include the PC name also. Ie ‘SELLERDECK-PC\SQLSERVERNAME’
  3. Choose whether you are going to use Database User or Windows User by default.
    If using Database User, you need to enter the SQL Administrator username and password that you used when installing SQL Server
  4. Enter the UNC path to your Sites folder in the Backup Details field. This is the full network path to the sites folder.

Once the database setup is complete, click ‘License New Site’ and choose ‘MS SQL SERVER’ for Database type.

This will open a new window:

  1. The SQL Server field should already be populated with the details entered into Database Setup. If you have more than one SQL Server instance installed, and you wish to use a different instance for this site, make sure this field is completed with the correct SQL Server instance.
  2. Server Administration User Details. These details should again be pre-populated, depending on your Database Setup details.
  3. New User For New Databases. Choose whether you want the site licensed with Database User or Windows User. If you choose Database User, enter a Username and Password. (It is recommended you select "Database User", this makes licensing new sites easier)
  4. New Databases. These are the databases that will be created. You will be able to view them in MS SQL Server Management Studio once complete.
  5. Press OK to start the Database creation.

Once finished, you will see the new site listed in the site list as normal. You activate and switch sites as normal.
Attached Images
File Type: png SQLLIC.PNG (26.8 KB, 581 views)
File Type: png SQLLIC2.PNG (32.1 KB, 535 views)
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT. The time now is 04:19 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.