在转换前，请务必将dbmail在线升级到最新版本。
1) 在SQL Server里建立一个数据库，取名为dbmailserver。注意数据库的存储位置，要选一个空余空间较大的盘。
2) 关闭DBMailServer，然后将下面的内容拷贝到config.ini的最下面。保存。
[Database]
Count = 16
SQL1 = CREATE TABLE LDAP (account nvarchar (255) PRIMARY KEY NOT NULL default '', accountsize int NULL default '20', password nvarchar (255) NULL default '', ismax bit NOT NULL default 0, username nvarchar (255) NULL default '', comment ntext NULL default '', contactemail nvarchar (255) NULL default '', disabled bit NOT NULL default 0, isgroup bit NOT NULL default 0, permission nvarchar (255) NULL default 'account', lastvisited nvarchar (255) NULL default '', personalsign ntext NULL default '', addsign bit NOT NULL default 0, messageperpage int NULL default 20, replyaddress nvarchar (255) NULL default '', savesent bit null default 0)
SQL2 = CREATE TABLE attachinfo (attachid int identity(1,1) NOT NULL ,mailid int NULL default 0,attachname nvarchar (255) NULL default '', attachsize int NULL default 0, attachfile image NULL)
SQL3 = CREATE TABLE autoreply (autoreplyid int identity(1,1) NOT NULL, account nvarchar (255) NOT NULL ,enable bit NULL default 0,subject ntext NULL default '',body ntext NULL default '')
SQL4 = CREATE TABLE contact (contactid int identity(1,1) NOT NULL ,username nvarchar (255) NULL default 0,emailaddress nvarchar (255) NULL default '',sex int NULL default 1,phone nvarchar (255) NULL default '',im nvarchar (255) NULL default '',comment nvarchar (255) NULL default '',account nvarchar (255) NOT NULL )
SQL5 = CREATE TABLE domain (name nvarchar (255) PRIMARY KEY NOT NULL ,maxaccount int NULL default -1,maxspace int NULL default -1,defaultsize int NULL default 20, signupneedauth bit null default 0, helo nvarchar (255) NULL default '', displaypublicaddress bit null default 0)
SQL6 = CREATE TABLE emailfilter (emailfilterid int identity(1,1) NOT NULL, account nvarchar (255) NOT NULL ,enable bit NULL default 1,fromcompare int NULL default 0,subjectcompare int NULL default 0,operation int NULL default 0,folderdeliverto int NULL default 4,mailfrom ntext NULL default '',subject ntext NULL default '')
SQL7 = CREATE TABLE emailforward (emailforwardid int identity(1,1) NOT NULL, account nvarchar (255) NOT NULL ,leavecopy bit NULL default 0,enable bit NULL default 0,emailaddress nvarchar (255) NOT NULL )
SQL8 = CREATE TABLE emailgroup (emailgroupid int identity(1,1) NOT NULL, account nvarchar (255) NOT NULL ,member nvarchar (255) NOT NULL )
SQL9 = CREATE TABLE emailpop3remote (emailpop3remoteid int identity(1,1) NOT NULL, account nvarchar (255) NOT NULL ,pop3server nvarchar (255) NULL default '',pop3account nvarchar (255) NULL default '',pop3password nvarchar (255) NULL default '',enable bit NULL default 1,leavecopy bit NULL default 0)
SQL10 = CREATE TABLE mailfolderinfo (folderid int identity(1,1) NOT NULL ,account nvarchar (255) NOT NULL ,foldername nvarchar (255) NULL default '',property int NULL default 0,foldertype int NOT NULL ,parentfolder int NULL default 0)
SQL11 = CREATE TABLE mailinfo (mailid int identity(1,1) NOT NULL, mailsize int NULL default 0, isread bit NULL default 0,folderid int NOT NULL ,mailcontent image NULL ,mailfrom ntext NULL default '',mailto ntext NULL default '',mailcc ntext NULL default '',maildate nvarchar (255) NULL default '',mailsubject ntext NULL default '',mailbody ntext NULL default '',mailhtml ntext NULL default '', isreply bit NULL default 0, isforward bit NULL default 0, status int NULL default 1)
SQL12 = CREATE TABLE pop3uidl (pop3uidlid int identity(1,1) NOT NULL, account nvarchar (255) NOT NULL ,uid nvarchar (255) NOT NULL )
SQL13 = CREATE TABLE sendattachinfo (attachid int identity(1,1) PRIMARY KEY NOT NULL ,mailid int NULL ,attachname nvarchar (255) NULL default '',attachsize int NULL default 0, attachfile image NULL)
SQL14 = CREATE TABLE sendmailinfo (mailid int identity(1,1) PRIMARY KEY NOT NULL ,mailsize int NULL default 0,mailcontent image NULL ,mailfrom ntext NULL default '',mailto ntext NULL default '',mailcc ntext NULL default '',mailbcc ntext NULL default '',maildate nvarchar (255) NULL default '',mailsubject ntext NULL default '',mailbody ntext NULL default '',mailhtml ntext NULL default '',account nvarchar (255) NULL default '',status int NULL default 0,ip nvarchar (50) NULL default '',savetosent bit NULL default 0,savetodraft bit NULL default 0)
SQL15 = CREATE TABLE systemparam (domainlist bit null default 1, trashcanempty bit null default 0, trashcanemptydays int null default 3)
SQL16 = insert into systemparam (domainlist, trashcanempty, trashcanemptydays) values(1, 0, 3)
Dependence=MSSQLSERVER
3) 在config.ini的[system]下面一行加入
DBConnectionStr=Provider=sqloledb;Data Source=(local);Initial Catalog=dbmailserver;Integrated Security=SSPI
4) 启动DBMailServer，这时DBMailServer自动完成数据库初始化。
5) 修改webmail目录下的conn.asp，将strConn = "DSN=DBMailServer"修改成
strConn = "Provider=sqloledb;Data Source=(local);Initial Catalog=dbmailserver;Integrated Security=SSPI"
6) 打开IIS管理器，编辑虚拟目录mail的属性 -> 目录安全性 -> 编辑匿名访问 -> 在用户名和密码处输入操作系统的登陆帐号和密码。

至此SQL Server版安装完毕。可以参照相关FAQ，做一些索引配置，以优化数据库访问。

如果原来使用了Access作为dbmailserver数据库，这时可以直接通过SQL Server导入Access文件到dbmailserver数据库。