Install Guide [Database for WHORU Syslog, Webserver]

You just fellow next step.

1. Must take and install mssql express 2014 ( http://msdn.microsoft.com/ko-kr/evalcenter/dn434042.aspx express edition limit size, so i recommend more high version)

2. When install finish you create mssql account. here we offer to sql script. red text you must change(alert: you need to check a sql server logon by server authentication)!

USE [master]
GO

CREATE LOGIN [esm] WITH PASSWORD = ‘P@ssword, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

ALTER SERVER ROLE [sysadmin] ADD MEMBER [esm]
GO

You need to check sqluser logon and SQL Server Configuration Manager check TCP/IP service enable.

3. Next is run to database create script(alert: must create folder before run script)

(default path is c:data, if you want to change, edit to script.)

Facebook Comments

Leave A Reply

이메일은 공개되지 않습니다. 필수 입력창은 * 로 표시되어 있습니다.