See attachment pull from forum below:
http://forums.ipswitch.com/Topic34821-34-1.aspx
Dina Wise
QA Analyst, Messaging Team
Ipswitch, Inc.
-----Original Message-----
From: "Matt" [EMAIL PROTECTED]
Sent 7/31/2007 4:14:13 PM
To: [email protected]
Subject: [IMail Forum] Moving contacts from Access to MS SQL database
Can someone point me to the documentation for how to set up MS SQL to
handle the contacts database instead of the default Access database?
Thanks,
Matt
To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html
List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/
Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
1)Install SQLExpress (or use SQL server if available)
a)configure SQLExpress to accept traffic on TCP port 1433
(Configuration tools\SQL sever configuration manager)
b)create a new blank db name workgroupshare (in SQL management
studio)
2) Convert the database to SQL (SSMA for Access_1.2.852.msi)
http://www.microsoft.com/downloads/details.aspx?familyid=d842f8b4-c914-4ac7-b2f3-d25fff4e24fb&displaylang=en
Install SSMA and register it. Then run it. Use the
WorkgroupSahre.mdb as the access file and the new db
you created as the SQL db.
3)create a new SQL user which maps to NT AUTHORITY\NETWORK SERVICE, then add
that user to the security of your db
and grant full permissions to the user.
4)Rename the WorkgroupShare DSN to WorkgroupShareold
5)Create a new WorkgroupShare DSN which points to the SQL db
6)Edit HKEYLM\Software\Softalk\WorkgroupShare\Setup\DBType (Dword) to 1 (may
have to create this)
Let know if there is anything unclear.
