Back to Search

Creating a DB Mail List in SP-C or SQL Server

Document ID: 10192

Synopsis

The information below shows how to create a Database Mailing list for MailSite using SQL Server to hold the data for the Mailing list. The example shows how to create a Database mail list

More Information

Creating a DB Mail List in SP-C or SQL Server The information below shows how to create a Database Mailing list for MailSite using SQL Server to hold the data for the Mailing list. The example shows how to create a Database mail list for the default domain and virtual domains.
  1. Create a New Database within the SQL Server Enterprise Manager. (example MailList)
  2. Create a new table.
  3. Add EmailAddress as a Primary Key and with a 'length' value of around 40, do not allow nulls.
  4. Add 'FullName' as the next 'Column Name' with 'length' value set to 50.
  5. Close and save the table with the same name as the mail list that you will have in MailSite (Example testing01)
  6. Open the Table and return all rows. Add the entry Testing@test.com as a test account, Close the the table.
  7. Open ODBC Data Source manager.
  8. Select System DSN.  Click Add Select SQL Server and press 'Finish'.
  9. The Name is 'Default', Description is whatever you want, Select the SQL Server the Database resides. Click 'Next'
  10. Select you authentication that you have set for the SQL server. If you have only set SQL Server Authentication make sure you put the user name and password in. Click on 'Client Configuration' Make sure it is set to 'TCP', Click 'Ok' then 'Next.
  11. Select the database that you have used i.e. MailList. Click 'Next'. Then 'Finished'.
  12. Click 'Test Data Source' then Click 'Ok', Click 'Ok' again. Then Click 'Ok' to close the ODBC Data Source Manager.
  13. Open MailSite.
  14. Go to the Default domain and select Mail Lists.
  15. Add a new Database List Calling it the 'testin01'. Open the Mail List.
  16. Set the 'General' Settings first. Then Select Database.
  17. Enter 'Default' for the 'Data Source Name'. Enter the User name and password, Click 'Apply'. Then Select the 'Members' Tab and you will see the entry Testing@test.com as the first user.

To Create a Database Mailing List for a virtual Domain

  1. Change the above step 5 to the Database Mailing list that you are going to be using.
  2. Change Step 9's name to the virtual domains name (example test.com)
  3. Change Step 14 the the DSN entry for that virtual Domain.