项目提交生产环境iq mobile portal dd-syd specification服务端

HistoryFirstversionforSecondversionforTableof PRE-INSTALLATIONHARDWARE INSTALLATIONQUALIFICATION INSTALLATION REFERENCES,ATTAENTS, IQRECORD IQRecord ThisaimstotheinstallationstepsandverificationforDescribeherethescopeofsystemsthatthistemteisusedfor.Provideastatementontheresponsibleorganizationi.e.whoneedstousethistemte.Dependingontheexperienceoftheinstallers,thefollowingsectionshouldbedeletedifnotneeded.AnotherpossibilityistorefertoaationSOP.CommentstotheAnInstallationQualification,orIQ,isa thatprovidesverificationthatasystemisinstalledaccordingtomanufacturerspecifications.Tosatisfyregulationsthismustbewrittenandpre-approved.Therearestrictguidelinesguidingthecreationofthis ,sopleasereadthefollowingrulescarefullyanddonotdeviatefromtheserules:Writeinink.Ifyoumakeamistake,drawasinglelinethroughthemistake,andanddateDonotleaveanyblankfields.Ifsomethingdoesnotapplytothissystem,writeN/Aintheappropriatespacewithabriefexnationofwhy.Alternatively,ifitisforeseeablethatcertainsectionsmaynotalwaysbeapplicable,aconditionalcheckboxindicating paniedbysuitableinstructions,canbeusedtoskipinapplicableIfyoudonotorcannotcompletesomeactionlistedonthisform,writeNOinthe‘OK’field,andmakeafootnoteinthe‘InstallationRemarks’sectionattheendofthisform.Ifyouuseadifferentversionofautilityorcomponentspecifiedinthisform,footnotetheentry,andprovidetheversionoftheutilityorcomponentinthe‘InstallationRemarks’section.Includethereasonforusingadifferentversion.Ifyouobserveanyerrorsduringtheassembly,testing,orshutdownofthesystem,pleasemakeanoteofyourobservationsinthe‘InstallationRemarks’section.Whenyouarerequiredtoprintevidenceinsupportoftheation,pleasedateandinitialthefirstpageoftheandstapleorotherwisebindthepagesoftheprintouttogether.Ifthereisafieldforyoutosignorinitial,pleasedoso.Everyfieldrequiringasignatureorinitialsmustbesigned.PleasefilloutbyFillindataduringexecution,notafterTheInstalleristheperformingthefollowingstepsandassuch,isthethatsignsoffoneachstepasitiscompleted.IntherarecasethatmorethanoneinstallerisworkingonthesamesystemandisallyperformingthestepsinthisIQ,thesecondandsubsequentadditionalinstaller’snamesshouldbewrittenintothespaceprovided.Recordtheprintedname,thesignatureandtheinitialsoftheswhocarryoutthetesting,plusthedateformattheyusuallyapply.Signatactivitystart.(print/Role(DD-MMM-SystemTargetbj-Server提供移动端数据支ApplicationPortalCAC*Sourcedataprovided**Listhereanyconventionsusedtogivespecifictextcontextualmeaning,e.g.ifdatatobeenteredisdenotedas<bracketedThissectionincludesadescriptionoftheprerequisitesrequiredtosuccessfullyexecutetheprocedure.Thisincludesminimumhardwarerequirements,requiredpre-installedsoftware,andanyothernecessaryconfigurationsettings.Ifaddressorpathinformationmustbeobtainedinadvance,theseshouldberecordedhere.Additionally,anyrequiredaccessprivilegesshouldbenoted.Ifnorecordeddataisgeneratedbyastep,crossouttherecordeddataboxesforthatlineorenterN/A.RecordedPrerequisitemet?(ifNo,citeinstaller*数据库执行文件obu_sqlInstallerInitials:Date:Thissectionaddressesinstructionsforpreparinghardware,e.g.settingupaSANconnection,switchingboards,etc.Thisentiresectionmaybedeletedifitisinapplicable.Ifsuchstepsmightberequiredsome,butnotall,ofthetime,aconditionalinstructionsuchasthatbelowcanbeusedtoallowtheinstallertoskipthesectionasappropriate.IfIftherearenohardwarepre-installationsteps,checkhereandproceedtosection SatisfactoryCompletion?(ifNo,citeinstallerInstallerInitials:Date:InstallationProcedurePartAuthorinstructions:Thissectionincludestheactualinstructionsforinstallation.Instructionsshouldbeclear.Stepsshouldreflectdiscreteactivitiesthatcanbeevaluatedforsuccess.Whenagroupofrelatedstepsarecompletedprovideaspacefortheinstallertoinitialanddatehis/herwork.Theremightbeseveralsuchacknowledgementsinaprocedure.Referencestodatarecordedintheconfigurationlistingortheprerequisitesshouldbeclearlyindicatedintheinstructions.Ifscreenshotsarethebestwaytodescribeastep,apicturemaybepastedintotheinstructions.Iftherearelogicalbreakpointsintheprocess(e.g.asystemreboot)itis mendedtobreaktheinstallationprocedureintomultiplesections.Ifthereisaneedtorecordobservationsorotherinformationaspartoftheinstallationprocess,consideraddinga“recordeddata”columnlikethatinSection4.Ifyouusethisapproachgrayoutspaceswherenodataentryisexpected.Alternatively,ifonlyasmallamountofdataistoberecorded,aspacetorecorditcanbewrittenintotheinstructionscolumn.Ifprintedevidenceofsuccessisrequired,thatshouldbenotedintheInstallerinstructions:Printedevidenceshouldbeinitialedanddatedbytheinstaller,andafootnoteshouldbemarkedbytheinstallerattheappropriatestepandontheprintout.Ifastepwasnotexecutedsatisfactorily,orifitwasdeemednotapplicable,indicatethiswithareferencetotheinstallationremarkssectionexiningthereasoning.SuccessfullyCompleted?(ifNoorN/A,citeinstaller打开IIS，停止SQLServer2012的SQLServerPortalDB备份到指 SQLServeManagermentStudio中按照如obu_sql\obu_sql\InstallerInitials:Date:InstallationProcedurePartThisandsubsequentinstallationsectionsareonlyappropriateiftherearelogicalbreakpointswheretheprocesscanbepausedforasignificanttime,e.g.inconjunctionwithare-boot.(ifNoorN/A,citeinstaller打开IIS，停止在C盘 PortalWebSite文件夹。\InstallerInitials:SuccessfullyCompleted?(ifNoorN/A,citeinstaller运行SQLServer2012的SQLServerManagermentStudio，执行备份操作,将PortalDB备份到指 RemoveSample进入数据库后，点击Databases展开后查看，没有SampleDatabases,把结果贴在下面表格的No.2里面。Revokeguestuser的连接是关闭的。把结果贴在下面表格的No.3HideSQLServerConfigrutionManagerSQLforDBInstanceflaghideinstance为No，把结果贴在下面表格的No.4AdHocDistributedAdHocDistributedQueries：SQLServer数openrowset/opendatasource前首先要启用AdHocDistributedQueries服务，因为这个服务不安全所以SqlServer默认是关闭的。查看：selectconfiguration_id,name,valuefromsys.configurationswherename='AdHocDistributedQueries';查询出AdHocDistributedQueries的value值是0SuccessfullyCompleted?(ifNoorN/A,citeinstallerCLR查看：selectconfiguration_id,name,valuefromsys.configurationswherename='CLRCrossDBOwnershipSQLServer实例配置跨数据库所selectconfiguration_id,name,valuefromsys.configurationswherename='CrossDBOwnershipChaining';DatabaseMailXPs的value值为0把结果贴在下面表格的No.8SuccessfullyCompleted?(ifNoorN/A,citeinstallerOLEAutomation是否可以在Transact-SQL批处理中实例化OLEAutomation对象。sys.configurationswherename='OLEAutomationProcedures';ScanForStartupScanForStartupProcsscanforstartupprocs选项扫描在SQLServer启动时自动执selectconfiguration_id,name,valuefromsys.configurationswherename='ScanForStartupProcs';ScanForStartupProcsvalue0SQLMailSQLMailXPs：使用SQLMailXPs选项可以Select*Fromdbo.sysmail_log日志，SQLMailXPs的value值为0把结果贴在下面表格的No.11TrustworthyDatabase把结果贴在下面表格的No.12SuccessfullyCompleted?(ifNoorN/A,citeinstallerCLRAssemblyPermissionSELECT*FROMExtendedStoresp_configuresys.configurationswhereServerAuthenticationToWindows混合模式（Windows验证和SQL验证），则必须输入强saSecurity-->Logins-->sanewlogin>generalwidows把结果贴在下面表格的No.15PasswordChange混合模式（Windows验证和SQL验证），则必须输入强saSecurity-->Logins-->sanewlogin>generalSQLServerAuthenticationusermustchangepasswordatnext把结果贴在下面表格的No.16SuccessfullyCompleted?(ifNoorN/A,citeinstallerCheck混合模式（Windows验证和SQL验证），则必须输入强saSecurity-->Logins-->sanewlogin>generalSQLServerAuthenticationenpassword把结果贴在下面表格的No.17SetExpirationfor混合模式（Windows验证和SQL验证），则必须输入强saSecurity-->Logins-->sanewlogin>generalSQLServerAuthenticationenpassword把结果贴在下面表格的No.18RemoteAdminselectconfiguration_id,name,valuefromsys.configurationswherename='RemoteAdminConnections';umNumberOfErrorLog 下，在SQLServer日志上右在弹出的“配置SQLServer错误日志”窗口把结果贴在下面表格的No.20SuccessfullyCompleted?(ifNoorN/A,citeinstallerDefaultTraceselectconfiguration_id,name,valuefromsys.configurationswherename='DefaultTraceEnabled';Remoteselectconfiguration_id,name,wherename='RemoteInstallerInitials:Date:InstallerInitials:Date:InstallationProcedurePartThisandsubsequentinstallationsectionsareonlyappropriateiftherearelogicalbreakpointswheretheprocesscanbepausedforasignificanttime,e.g.inconjunctionwithare-boot.(ifNoorN/A,citeinstaller6.InstallationProcedurePart12数据库执行异常的时候，请把在第1步备份SQLServer2012新启动异常的时候，将第2步备份的PortalWebSite发布文件夹覆盖C盘目 PortalWebSite文件夹。InstallerInitials:Authorinstructions:Thissectiondescribesanyteststhatshouldberuntoverifythattheinstallationwassuccessful.Theauthormustfillinthe“Action”and“ExpectedResult”sections,withadequaydetailedinstructionsandexpectedobservationssothatanindependentjudgmentcanbemadebasedontheobserved/ edobservationsastowhetherthetestwassuccessful.Ifobservedresultsarebestedviascreenprintordataoutput(e.g.alogfile)thisshouldbenotedintheinstructions.Theauthormustensurethatenoughspaceisprovidedtorecordobservedresults.Installerinstructions:Theinstallerwillfillinthe“ObservedResult”,apass/failassessment,andinitialanddatethetestbyhandatthetimeoftesting.Printedevidenceshouldbehandledaspertheinstructionsinsection9.IMPORTANT:Thefollowingtestsmustbeperformedtovalidatetheinstallationprocess.FollowtheseinstructionsandreporterrorsduringtestsordifferencesfromexpectedExpected使用 j-s3112/能够正确进入Portal登录页 议配置界面增加会议详情、会议日程可选择、HTML或PDF类型文件上传，分会议配Observed**Ifprintedevidenceisusedtotheobservationattachallthoseprintstothis.Eachprintmustbeuniquelyreferencedtotheins