ODBC for Merak Mail Server Pro with Microsoft
SQL Server
Quick Setup
Upgrade SQL 7.0 installation with the latest service pack. This
example uses Microsoft SQL 7.0 with the SQL Service Pack 3 and Windows 2000
Server, Service Pack 2.
During SQL Service Pack installation select Mixed SQL
authentication (NT and SQL).
Create Database
Open Enterprise Manager
Open SQL Server
Right Click Databases
Select New Database
Enter Name: {e.g. MerakMail}
Prepare Login for Database {MerakMail}
Run Enterprise Manager
Open SQL Server
Select Security
Select Logins
Right Click Logins
Select New Login
Define username: {e.g. merakuser}
Select SQL Server Authentication
Define password: {e.g. merakpass}
Select Database: MerakMail (see step above)
Click on Folder Database Access
Check In Database {MerakMail}
Check Database Roles for MerakMail:
Public
Db_owner
db_accessadmin
db_securityadmin
db_datareader
db_datawriter
Create ODBC source for database {MerakMail}
Open Control Panel
Open Administrative Tools
Open Data Sources (ODBC)
Select Folder System DSN
Click Add and select driver SQL Server (last in pull down list)
Define name for ODBC source {e.g. MerakODBC}
Select (local) SQL server
Click NEXT
Select authenticity:
With SQL Server Authentication
Enter Login id: merakuser
Enter Password: merakpass
CLICK NEXT
Select Default Database
Notice, that default database is already {MerakMail}
CLICK NEXT
Press FINISH
See summary screen.
Click on: Test Data Source…
If everything is OK, result of the test is:
Click OK
Click OK
Click OK (to close ODBC Dialog)
Prepare ODBC Connection String for Merak Mail Server
Run Merak Configuration program
Select folder System
Click on button: DB Settings…
Enter connection string for ODBC:
MerakODBC; merakuser; merakpass
Create Empty tables for Merak
Run Command Prompt
CD Program Files
CD Merak
Dbconv.exe – c
The tables are created in database MerakMail. Run SQL
Enterprise Manager to see, that there are two new tables in MerakMail:
Domains
Users
Leave Enterprise Manager open
Create Test Domain
Run Merak Configuration Program
Select folder: Accounts
Create domain meraktest.com
Create user: test
Vérifiez