1. Run the MSSQL Enterprise Manager, the new Database Servu, the new SQL login account servu, password XXXX, specified as DBOWNER for the database, specify the default database for servu2, select the database servu in the Enterprise Manager, enter the top menu tool - Query Analyzer, copy all the contents of the following "Table SQL Statement" to the Query Analyzer Run 4, create a system DSN, named servu, point to SQL Server's database Servu5, in Serv-U Administrator, new domain Simple Domain, SIMPLE DOMAIN, Use ODBC storage, select Simple Domain in the tree menu, click the 'ODBC' tab at the top of the right control panel, and fill in the name of the system DSN, the account number, password, and Point application. 6. Stop the Serv-U service, open Servudaemon.ini in the Serv-U installation directory, set "ODBCTABLES" and "odbccolumn" down the two lines of [Domain1] section, "ODBCTABLES" and "odbccolumns" are replaced
ODBCTables = ftp_users | ftp_groups | ftp_userAccess | ftp_groupAccess | ftp_userIPs | ftp_groupIPsODBCColumns = ftpUserName | ftpPassword | sKey | dirHome | loginMsgFile | accessRule | disabled | sessionEncryption | dirHomeLock | hideHidden | alwaysAllowLogin | changePassword | quotaEnable | maxUsersLoginPerIP | speedLimitUp | speedLimitDown | maxUsersConcurrent | timeOutIdle | TimeoutSession | Ratioup | Ratiodown | Ratiocredit | Quotacurrent | Quotamax | Expiration | Privilege | FTPPasswordType | Ratiotype | Groups | Notes | IndexNo
7, start the Serv-U service, OK
Note: All the names above can be changed; the XX in [Domainxx] should be the number corresponding to the new domain.
Construction table SQL statement
If EXISTS (Select * from dbo.sysObjects where id = Object_id ('dbo.ftp_groupaccess ") And ObjectProperty (ID,' isusertable ') = 1) DROP TABLE DBO.FTP_GROUPACCESSGO
If EXISTS (Select * from dbo.sysObjects where id = Object_id ('dbo.ftp_groups') And ObjectProperty (id, 'isusertable') = 1) DROP TABLE DBO.FTP_GROUPSGO
IF exists (select * from dbo.sysObjects where id = Object_id ('dbo.ftp_groups') And ObjectProperty (ID, 'isusertable') = 1) DROP TABLE DBO.FTP_GROUPSGO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id ( 'dbo.ftp_userAccess') AND OBJECTPROPERTY (id, 'IsUserTable') = 1) DROP TABLE dbo.ftp_userAccessGOIF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id ( 'dbo.ftp_userips') And ObjectProperty (ID, 'isusertable') = 1) DROP TABLE DBO.FTP_USERIPSGO
If EXISTS (Select * from dbo.sysObjects where id = Object_id ('dbo.ftp_users') And ObjectProperty (ID, 'isusertable') = 1) DROP TABLE DBO.FTP_USERSGO
Create Table dbo.ftp_groupaccess (IndexNo Smallint Not Null, Ftpusername Varchar (50) Not Null, Accessrule Varchar (200) Not NULL) GO
Create Table dbo.ftp_groupips (Indexno Smallint Not Null, Ftpusername Varchar (50) Not Null, Accessrule Varchar (80) Not Null) Go
Create Table dbo.ftp_groups (id int Intity (1, 1) Not null, ftpusername varchar (50) Not null, Accessrule VARCHAR (200) NULL, NOTES VARCHAR (255) NULL) GO
Create Table DBo.ftp_useraCcess (IndexNo Smallint Not Null, Ftpusername Varchar (50) Not Null, Accessrule Varchar (200) Not NULL) GO
Create Table dbo.ftp_userips (Indexno Smallint Not Null, Ftpusername Varchar (50) Not Null, Accessrule Varchar (80) Not Null) Go
CREATE TABLE dbo.ftp_users (id int IDENTITY (1, 1) NOT NULL, ftpUserName varchar (50) NOT NULL, ftpPassword varchar (50) NOT NULL, ftpPasswordType tinyint NULL, changePassword bit NOT NULL, sKey varchar (50) NOT NULL, accessRule varchar (200) NULL, dirHome varchar (200) NOT NULL, privilege tinyint NULL, loginMsgFile varchar (80) NULL, disabled bit NOT NULL, sessionEncryption bit NOT NULL, dirHomeLock bit NOT NULL, hideHidden bit NOT NULL, alwaysAllowLogin bit NOT NULL , maxUsersConcurrent smallint NOT NULL, speedLimitUp int NULL, speedLimitDown int NULL, maxUsersLoginPerIP smallint NOT NULL, timeOutIdle int NULL, timeOutSession int NULL, quotaEnable bit NOT NULL, quotaCurrent bigint NULL, quotaMax bigint NULL, ratioType tinyint NULL, ratioUp smallint NULL, ratioDown smallint NULL, ratioCredit float NULL, expiration smalldatetime NULL, groups varchar (80) NULL, notes varchar (255) NOT NULL) GOALTER TABLE dbo.ftp_groups WITH NOCHECK ADD CONSTRAINT pk_ftp_groups PRIMARY KEY CLUSTERED (id) Go
Alter table dbo.ftp_users with nocheck add constraint pk_ftp_users primary key clustered (ID) Go
ALTER TABLE DBO.FTP_GROUPACCESS ADD CONSTRAINT DF_FTP_GROUPACCESS_INDEXNO Default (2) for Indexnogo
Create Index IX_FTP_GROUPACCESS__FTPUSERNAME ON DBO.FTP_GROUPACCESS (FTPUSERNAME, INDEXNO) GO
ALTER TABLE DBO.FTP_GROUPIPS Add Constraint DF_FTP_GROUPIPS_INDEXNO DEFAULT (2) for IndexNogo
Create Index IX_FTP_GROUPIPS__FTPUSERNAME ON DBO.FTP_GROUPIPS (FTPUSERNAME, INDEXNO) GO
CREATE UNIQUE INDEX IX_FTP_GROUPS__FTPUSERNAME ON DBO.FTP_GROUPS (FTPUSERNAME) GO
Alter table dbo.ftp_useraccess add constraint df_ftp_useraccess_indexno default (2) for indexnogo
Create Index IX_FTP_USERACCESS__FTPUSERNAME ON DBO.FTP_USERACCESS (FTPUSERNAME, INDEXNO) GO
Alter Table dbo.ftp_userips add constraint df_ftp_userips_indexno default (2) for indexnogocreate index ix_ftp_userips__ftpusername on dbo.ftp_userips (ftpusername, indexno) Go
ALTER TABLE dbo.ftp_users ADD CONSTRAINT df_ftp_users_changePassword DEFAULT (1) FOR changePassword, CONSTRAINT df_ftp_users_sKey DEFAULT ( '') FOR sKey, CONSTRAINT df_ftp_users_disabled DEFAULT (0) FOR disabled, CONSTRAINT df_ftp_users_sessionEncryption DEFAULT (0) FOR sessionEncryption, CONSTRAINT df_ftp_users_dirHome DEFAULT ( '') FOR dirHome, CONSTRAINT df_ftp_users_dirHomeLock DEFAULT (1) FOR dirHomeLock, CONSTRAINT df_ftp_users_hideHidden DEFAULT (1) FOR hideHidden, CONSTRAINT df_ftp_users_alwaysAllowLogin DEFAULT (0) FOR alwaysAllowLogin, CONSTRAINT df_ftp_users_maxUsersConcurrent DEFAULT (10) FOR maxUsersConcurrent, CONSTRAINT df_ftp_users_speedLimitUp DEFAULT ((-1)) FOR speedLimitUp , CONSTRAINT df_ftp_users_speedLimitDown DEFAULT ((-1)) FOR speedLimitDown, CONSTRAINT df_ftp_users_maxUsersLoginPerIP DEFAULT (5) FOR maxUsersLoginPerIP, CONSTRAINT df_ftp_users_timeOutSession DEFAULT ((-1)) FOR timeOutSession, CONSTRAINT df_ftp_users_quotaEnable DEFAULT (1) FOR quotaEnable, CONSTRAI NT DF_FTP_USERS_QUOTACURRENT Default (0) for quotacurrent, constraint DF_FTP_USERS_QUOTAMAX DEFAULT (52428800) for quotamax, constraint df_ftp_users_notes default (') for Notesgo
CREATE UNIQUE INDEX IX_FTP_USERS__FTPUSERNAME ON DBO.FTP_USERS (FTPUSERNAME) GO
