Converting Web Mail Personal Contacts from Access to SQL or SQLExpress on a 2000 Server.
Product: IMail
Version: 2006.21
Platform: Windows 2000 Server
NOTE: IMail uses the WorkgroupShare.mdb file to store personal contacts, which uses Access by default. Below are the instructions for converting this database from Access to SQL or SQLExpress.
This article is for IMail running on Server 2000, if you are using Server 2003 please see Converting Web Mail Personal Contacts from Access to SQL or SQLExpress on a 2003 Server.
1. Download and install SQLExpress and the SQL Management Studio. (If you already have SQL, this can be used).
2. Once installed, open the SQL Server Configuration Manager.
3. Expand SQL Server 2005 Network.
4. Highlight Protocols for SQLExpress.
5. Right-click TCP/IP and choose Properties.
6. On the IP Address tab, under the IPALL section, set the TCP Dynamic Ports to 2874, and the TCP Port to 1433.
7. Once set, save and close the SQL Server Configuration Manager console.
8. Open the SQL Management Express Studio and create a new database named WorkgroupShare. (When prompted for login information, make sure to use machine_name\SQLEXPRESS for the 'Server name' section and not an IP address.)
9. Close the console.
10. Download and install SQL Server Migration Assistant for Access.
11. Once installed, follow the registration process (Required) for SSMA for Access.
12. Once registered, open SSMA for Access and add the old WorkgroupShare.mdb file.
13. Next, point to the newly created WorkgroupShare SQL database created in step 8.
14. Once the conversion completes, exit the console. Use defaults on all pop-up screens.
15. Open SQLExpress, Expand 'Security' and highlight 'Logins'. Right-click and create 'New Login'. (If IMail is on a Domain Controller, skip to step 17.)
16. Add the user DOMAIN\ASPNET. Leave Windows Authentication checked.
17. If IMail is on a Domain Controller, Add the DOMAIN\IWAM_machinename user.
18. Next add the IIS Anonymous User set up for your Web Mail web sites. This is usually IUSR_machinename.
19. Now expand 'Databases\WorkgroupShare\Security'.
20. Highlight 'Users', Right-click and add 'New User'.
21. Add the 'NT AUTHORITY\NETWORK SERVICE' user.
22. In the 'DB Role Membership' section, grant this user the db_datareader, db_datawriter, and db_owner permissions.
23. Repeat steps 20 and 21 for the 'IUSR_machinename' user.
24. Once this has been saved, exit the SQLExpress console and reboot the server.
25. Once the server has rebooted, open the Data Source (ODBC) console from Administrative Tools.
26. Click the 'System DSN' tab.
27. Select the current WorkgroupShare DSN, click the 'Configuration' button and rename it to 'WorkgroupShareOld'
28. Back on the 'System DSN' tab, select 'Add', and select SQL Server.
29. Next click the 'Client Configuration' button, uncheck the 'Dynamically determine Port' check box, and make sure the Port is set to 1433.
30. Finish the setup.
30. Edit HKEYLM\Software\Softalk\WorkgroupShare\Setup\DBType (Dword) to 1 (this may have to be created)
31. Reboot the server.
Document #: IM-20070802-KF02.htmRevision Date: 09/14/07