nTouch2014R2配置報警歷史查詢功能

1、InTouch2014R2配置報警歷史查詢功能一、首先配置SQLSERVER首先要啟用 sqlserver 和 windows 混合驗證方式1、開始菜單中打開 SQLServer2012ManagermentStudioMicrosoftMicrosoft,SQLServer20i2ManagementStudioPouredbyVisualStudio2、Servername 默認為計算機名，點擊 ConnectSQLServer2012S*r*wt泮:StrrtrStrrtrVxn-dfAuthentietiiion.F-i=FCF-i=FCFEI-PCC3rl3、選擇默認登錄名稱 Sa,

2、右鍵屬性QtjjffidLipiimrQtjjffidLipiimr*?MIV御九,二CwebKf6 63 30 0 -L旬*if*T&所NF加野W型牛l2I&MTSfRfi.MSSQLSEftVil占NT的網(wǎng)1儀乳場由&W?野ftVMXvMifgmrt良 g, ,SvwNlfiSvwNlfi1 1# #-上d*yE0，4b3 出醇J口通rtPcw-ryt4fttpertttIWwnaNHeIWwnaNHeFrFr n4r4i*in4r4i*i4、打開“屬性”窗口后，定位到“常規(guī)”選項卡，輸入密碼和確認密碼 1 1 * * .T-.T-值WLT1111IULIItajfwKajutajfwKa

3、juEVarJp*.iryarJp*.iry口,n4XvtdvrfifvRIMb,n4XvtdvrfifvRIMbfti-kfti-k口*4 *&*wfwfIFIFICTICTiJ.MiiJ.MigllrmgllrmFirapiniFirapini，infvnllinfvnll3CrU*Mfid3CrU*MfidLr*4i4Lti!Lr*4i4Lti!.1.1.L*ci*L*ci*fiifiiftJtw-triBftJtw-triB4.*4.*卜f fp p i i”narnar F F #44jfJr*11B-Kfe-tavil#44jfJr*11B-Kfe-tavilij.ij.5、然后切

4、換到“狀態(tài)”選項卡，選擇“連接到數(shù)據(jù)庫”為“授予”6、選擇數(shù)據(jù)庫，在出現(xiàn)的右鍵菜單中選擇“屬性”選項，之后將出現(xiàn)下圖界面：切換到“安全性”選項卡，在“服務器驗證方式”下選擇“sqlserver 和windows 身份驗證模式”，點擊“確定”保存退出%：Mienos由SQtSqrvqrMprwgemQntSfcdkl-F混Edit/e蚓DebugTo&sWinder*Hdp:J+j&dnNe*Ouerv*出33Qhjed:Conhfrct“登錄”為“啟用” ,之后點擊右下方的“確定”按鈕保存退出I If ffrn4vfrn4v* *Svrvir&Svrvir& 1 1 . .WlnrWlnr*

5、*SiRiruSiRiru3*HTrnhohFlepkhoh MangnMangniacannKtiacannKtRegkterAdi祖MonimfStartStopPauasPauasR*F5UEGR*F5UEGReRjrtReRjrtPdidwfateisStjrtPwrrShdlftfinhftfinhPreWlPreWlr-xmartLiwr-xmartLiwF F L LE EfCljiitgffCljiitgf L LCgnmcUnCgnmcUnSiTTirSiTTir：FIC-TCFIC-TC才j jI ILFLF滋 arjrEQhtuarjrEQhtuE E5*f*r5*f*r

6、卜式i*i*C C1 1ILnJ.ILnJ. r3AilhantLdtJtjnr3AilhantLdtJtj.EkLtaHtKtiZ4.EkLtaHtKti田一Ltcin皿itNO OVlhlVlhl螺fMITI4PPI5L L SsrcflaauLSsrcflaauLlifijixlifijix&nly&nly“9k9k理EEBZBZI IH HS StrdtrdGECGEC. .VEVEE EO O! !l-a3ai,l-a3ai,5*r*5*r*什河aryary匚EtuiLEtuiL Kwi*rpTKwi*rpT cyu-ziGntcyu-ziGntTrTr颯y y曲皿?wir-fid?

7、wir-fid：m.m.O OE EM MI*I*CSCSw w：httr*?ii4httr*?ii4|Emai4ttLaa*mgrihij-rkwiauaEEmai4ttLaa*mgrihij-rkwiauaE7、右鍵數(shù)據(jù)庫名稱，在出現(xiàn)的右鍵菜單中選擇“停止”選項，停止服務器進程，在出現(xiàn)的提示窗體中選擇“是”知 MicrosoftSQLServerManagementStudioMicrosoftSQLServerManagementStudioFileEditViewDebugToolsWindowHelpStartStepStepPauseResumeResumeRestartResta

8、rtPoliciesFacetsFacetsStartPowerShellStartPowerShellReportsReportsRefreshRefreshPropertiesMicrosoftoftSQLServerManagementStudioManagementStudioAreyouAreyouaireyxjuyxjuwanttostoptheMSSQtSERRserviceontostoptheMSSQtSERRserviceonFET-PC?ObjectExplorerObjectExplorerConnectConnect/為晶二FEI-PC(SQLServer11,CFE

9、I-PC(SQLServer11,C+而:讓 3535_SecuritytServerObjecti+iReplication(+1口 ManagementManagementConnect.DisconnectDisconnectRegister,Register,NewQueryActivityMonitorQX8、當 sqlserver 服務器圖標變?yōu)辄S色的時候，依然右擊它，點擊“啟動”， 在出現(xiàn)的提示窗體中選擇“是”O(jiān)bjectExplorerObjectExplorerConnectConnect. .善烈。/ /W1W1J J日30 0 口 DatabasesDatabases+

10、+_|_|SecuritySecuritytServerObjects+_jReplicationf+1f+1ManagementManagementStartStartStopStopPau5ePau5eResumeResumeReatartReatartPoliciesPoliciesFacetsFacetsStartPowerShellReportsReportsRefreshRefreshPropertiesPropertiesMicrosoftSQLServerManagementStudioAreyousveyouwantt。starttheMSSQLSB1VERservicieo

11、nFEI-PC?YesMoNewQueryNewQueryActivityMonitorActivityMonitorFEI-PC(SQLServer11,03000-FEI-PC(SQLServer11,03000-4X4XDisconnectDisconnectRegister.9、關(guān)閉 microsoftsqlserver,重新以 sa 用戶登錄，便可以成功利用 sqlserver登錄驗證方式登錄 sqlserver。10、然后需要在 sqlserver 中建立數(shù)據(jù)庫，例如：WWAlmD 選擇存放路徑，盡量不要放置在 C 盤。11、打開 AlarmDBLoggerManager,選擇設置*W線定施本點擊開始O OAlarmDBLogg