LIMS服务器配置要求
系统:Windows Server 2019
内存:32G
vCPUs:8核 Intel Cascade Lake 2.6GHz
硬盘:固态硬盘(1T) * 2
数据库:Microsoft SQL Server 2014 X64
需要放开的端口号:1433、8733、8700、21、33、80、8180端口
1、拷贝数据库文件
- Sqserver 导出:
- 数据库版本与目标数据库版本完全一致:可以导出.bak 文件到目标数据库进行还原数据库
- 数据库版本与目标数据库版本不一致:高版本导入低版本(目标数据库)
可以按照如下操作:
导出:
导入:
需要提前创建用户并授权(以下为多数据库设置脚本)
Use master
GO
IF EXISTS ( SELECT name FROM sys.syslogins WHERE name = 'worker2022' )
BEGIN
alter login worker2022 with password='password'
END
ELSE
BEGIN
create login worker2022 with password='password'
END
DECLARE @dbname VARCHAR(50) = ''
DECLARE @granstatement NVARCHAR(max) = ''
DECLARE db_cursor CURSOR
LOCAL FAST_FORWARD
FOR
SELECT name
FROM MASTER.dbo.sysdatabases
WHERE name like 'db_huanjing%'
OPEN db_cursor
FETCH NEXT FROM db_cursor INTO @dbname
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @granstatement = ' use '+@dbname +'; IF NOT EXISTS (select name from sys.sysusers where issqluser=1 and name = ''worker2022'') BEGIN create user worker2022 for login worker2022 with default_schema=dbo END ALTER ROLE db_datareader ADD MEMBER worker2022; ALTER ROLE db_datawriter ADD MEMBER worker2022; '
SELECT @granstatement += ' exec sp_change_users_login ''UPDATE_ONE'',''worker2022'', ''worker2022'' '
SELECT @granstatement += ' GRANT EXECUTE ON f_GetPY TO worker2022; GRANT EXECUTE ON fun_getPY TO worker2022; '
exec sp_executesql @granstatement
FETCH NEXT FROM db_cursor INTO @dbname
END
CLOSE db_cursor
DEALLOCATE db_cursor
GO
- Sqserver 导入:
将创建表之前的修改数据库的语句删除掉,选择目标数据库,点击执行
- Sqserver 维护计划:
- 配置IIS:
参考如下:
- 配置IIS及FTP:
安装FTP
添加MIMO 类型
.fr3 application/octet-stream
.apk application/octet-stream
.zip application/octet-stream
.doc application/octet-stream
.docx application/octet-stream
.zip application/octet-stream
.xls application/octet-stream
.xlsx application/octet-stream
.pdf application/octet-stream
配置FTP用户组和用户
右键“我的电脑”,点击管理, 展开本地用户和组 -> 右键“用户”,选择“新用户” -> 填写“用户名”、“密码”及其他信息 -> 点击“创建”
古老版本在控制面板中找