Converting Web Mail Personal Contacts from Access to SQL or SQLExpress on a 2003 Server.
Product: IMail
Version: 2006.21
Platform: Windows 2003 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 2003. If you are running Server 2000, please see Converting Web Mail Personal Contacts from Access to SQL or SQLExpress on a 2000 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'.
16. Add the user NT AUTHORITY\NETWORK SERVICE. Leave Windows Authentication checked.
17. Next add the IIS Anonymous User set up for your Web Mail web sites. This is usually IUSR_machinename.
18. Now expand 'Databases\WorkgroupShare\Security'.
19. Highlight 'Users', Right-click and add 'New User'.
20. Add the 'NT AUTHORITY\NETWORK SERVICE' user.
21. In the 'DB Role Membership' section, grant this user the db_datareader, db_datawriter, and db_owner permissions.
22. Repeat steps 20 and 21 for the 'IUSR_machinename' user.
23. Once this has been saved, exit the SQLExpress console and reboot the server.
24. Once the server has rebooted, open the Data Source (ODBC) console from Administrative Tools.
25. Click the 'System DSN' tab.
26. Select the current WorkgroupShare DSN, click the 'Configuration' button and rename it to 'WorkgroupShareOld'
27. Back on the 'System DSN' tab, select 'Add', and select SQL Server.
28. Next click the 'Client Configuration' button, uncheck the 'Dynamically determine Port' check box, and make sure the Port is set to 1433.
29. 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-KF01.htmRevision Date: 09/14/07