none
MSSQL (2) 15466 RRS feed

  • Общие обсуждения

  • На сервере Microsoft SQL Server x64 2005 регулярно появляется ошибка:

    Source: MSSQL

    Category: (2)

    ID: 15466

    An error occurred during decryption.

    Шифрование на базах данных не используется.

    С чем может быть связана проблема?

    Михаил

     

    1 апреля 2011 г. 9:28

Все ответы

  • сколько инстансов скуля на машине? что в логах самого скуля?


    http://www.t-sql.ru
    1 апреля 2011 г. 9:55
    Отвечающий
  • На сервере один именованный экземпляр.

    Я заметил, что ошибка появляется, когда идет физическая перезагрузка сервера. Лог на этот момент такой:

    Date,Source,Severity,Message
    04/02/2011 13:26:26,spid51,Unknown,Using 'xplog70.dll' version '2005.90.3042' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
    04/02/2011 13:26:26,spid51,Unknown,Using 'xpstar90.dll' version '2005.90.3042' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
    04/02/2011 13:26:25,spid51,Unknown,Using 'xpsqlbot.dll' version '2005.90.3042' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
    04/02/2011 13:26:24,spid5s,Unknown,Recovery is complete. This is an informational message only. No user action is required.
    04/02/2011 13:26:24,spid18s,Unknown,Recovery is writing a checkpoint in database 'SMT3' (10). This is an informational message only. No user action is required.
    04/02/2011 13:26:24,spid18s,Unknown,0 transactions rolled back in database 'SMT3' (10). This is an informational message only. No user action is required.
    04/02/2011 13:26:23,spid18s,Unknown,121 transactions rolled forward in database 'SMT3' (10). This is an informational message only. No user action is required.
    04/02/2011 13:26:23,spid18s,Unknown,Analysis of database 'SMT3' (10) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
    04/02/2011 13:26:22,spid14s,Unknown,Recovery is writing a checkpoint in database 'SMT3_back2' (6). This is an informational message only. No user action is required.
    04/02/2011 13:26:22,spid14s,Unknown,0 transactions rolled back in database 'SMT3_back2' (6). This is an informational message only. No user action is required.
    04/02/2011 13:26:22,spid14s,Unknown,1 transactions rolled forward in database 'SMT3_back2' (6). This is an informational message only. No user action is required.
    04/02/2011 13:26:20,spid25s,Unknown,Recovery is writing a checkpoint in database 'WSS_Content' (17). This is an informational message only. No user action is required.
    04/02/2011 13:26:20,spid25s,Unknown,0 transactions rolled back in database 'WSS_Content' (17). This is an informational message only. No user action is required.
    04/02/2011 13:26:20,spid25s,Unknown,911 transactions rolled forward in database 'WSS_Content' (17). This is an informational message only. No user action is required.
    04/02/2011 13:26:18,spid15s,Unknown,Recovery is writing a checkpoint in database 'greylist' (7). This is an informational message only. No user action is required.
    04/02/2011 13:26:18,spid15s,Unknown,0 transactions rolled back in database 'greylist' (7). This is an informational message only. No user action is required.
    04/02/2011 13:26:18,spid15s,Unknown,5681 transactions rolled forward in database 'greylist' (7). This is an informational message only. No user action is required.
    04/02/2011 13:26:17,spid19s,Unknown,Recovery is writing a checkpoint in database 'Roston' (22). This is an informational message only. No user action is required.
    04/02/2011 13:26:17,spid19s,Unknown,0 transactions rolled back in database 'Roston' (22). This is an informational message only. No user action is required.
    04/02/2011 13:26:17,spid22s,Unknown,Recovery is writing a checkpoint in database 'SharePoint_Config' (14). This is an informational message only. No user action is required.
    04/02/2011 13:26:17,spid22s,Unknown,0 transactions rolled back in database 'SharePoint_Config' (14). This is an informational message only. No user action is required.
    04/02/2011 13:26:17,spid19s,Unknown,1 transactions rolled forward in database 'Roston' (22). This is an informational message only. No user action is required.
    04/02/2011 13:26:17,spid22s,Unknown,9314 transactions rolled forward in database 'SharePoint_Config' (14). This is an informational message only. No user action is required.
    04/02/2011 13:26:16,spid25s,Unknown,Analysis of database 'WSS_Content' (17) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
    04/02/2011 13:26:14,spid12s,Unknown,Recovery is writing a checkpoint in database 'MTS_back' (5). This is an informational message only. No user action is required.
    04/02/2011 13:26:14,spid12s,Unknown,0 transactions rolled back in database 'MTS_back' (5). This is an informational message only. No user action is required.
    04/02/2011 13:26:14,spid26s,Unknown,Recovery is writing a checkpoint in database 'TSM' (19). This is an informational message only. No user action is required.
    04/02/2011 13:26:14,spid26s,Unknown,0 transactions rolled back in database 'TSM' (19). This is an informational message only. No user action is required.
    04/02/2011 13:26:14,spid27s,Unknown,Recovery is writing a checkpoint in database 'MTS' (21). This is an informational message only. No user action is required.
    04/02/2011 13:26:14,spid27s,Unknown,0 transactions rolled back in database 'MTS' (21). This is an informational message only. No user action is required.
    04/02/2011 13:26:14,spid27s,Unknown,1 transactions rolled forward in database 'MTS' (21). This is an informational message only. No user action is required.
    04/02/2011 13:26:14,spid12s,Unknown,1 transactions rolled forward in database 'MTS_back' (5). This is an informational message only. No user action is required.
    04/02/2011 13:26:14,spid26s,Unknown,1 transactions rolled forward in database 'TSM' (19). This is an informational message only. No user action is required.
    04/02/2011 13:26:14,spid24s,Unknown,Recovery is writing a checkpoint in database 'WSS_Search_WSPS' (16). This is an informational message only. No user action is required.
    04/02/2011 13:26:14,spid24s,Unknown,0 transactions rolled back in database 'WSS_Search_WSPS' (16). This is an informational message only. No user action is required.
    04/02/2011 13:26:13,spid21s,Unknown,Recovery is writing a checkpoint in database 'MTS3' (13). This is an informational message only. No user action is required.
    04/02/2011 13:26:13,spid21s,Unknown,0 transactions rolled back in database 'MTS3' (13). This is an informational message only. No user action is required.
    04/02/2011 13:26:13,spid24s,Unknown,6688 transactions rolled forward in database 'WSS_Search_WSPS' (16). This is an informational message only. No user action is required.
    04/02/2011 13:26:13,spid21s,Unknown,16 transactions rolled forward in database 'MTS3' (13). This is an informational message only. No user action is required.
    04/02/2011 13:26:13,spid13s,Unknown,Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
    04/02/2011 13:26:13,spid13s,Unknown,0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
    04/02/2011 13:26:13,spid17s,Unknown,Service Broker manager has started.
    04/02/2011 13:26:12,spid13s,Unknown,187 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
    04/02/2011 13:26:12,spid17s,Unknown,The Database Mirroring protocol transport is disabled or not configured.
    04/02/2011 13:26:12,spid17s,Unknown,The Service Broker protocol transport is disabled or not configured.
    04/02/2011 13:26:11,spid19s,Unknown,Starting up database 'Roston'.
    04/02/2011 13:26:11,spid23s,Unknown,Recovery is writing a checkpoint in database 'SharePoint_AdminContent_5ae95720-23cb-428c-ac1b-bacea2565067' (15). This is an informational message only. No user action is required.
    04/02/2011 13:26:11,spid23s,Unknown,0 transactions rolled back in database 'SharePoint_AdminContent_5ae95720-23cb-428c-ac1b-bacea2565067' (15). This is an informational message only. No user action is required.
    04/02/2011 13:26:10,spid17s,Unknown,Recovery is writing a checkpoint in database 'DRMS_Config_itsmd_test_moscow_sovmortrans_com_443' (9). This is an informational message only. No user action is required.
    04/02/2011 13:26:10,spid17s,Unknown,0 transactions rolled back in database 'DRMS_Config_itsmd_test_moscow_sovmortrans_com_443' (9). This is an informational message only. No user action is required.
    04/02/2011 13:26:10,spid23s,Unknown,2 transactions rolled forward in database 'SharePoint_AdminContent_5ae95720-23cb-428c-ac1b-bacea2565067' (15). This is an informational message only. No user action is required.
    04/02/2011 13:26:10,spid17s,Unknown,7 transactions rolled forward in database 'DRMS_Config_itsmd_test_moscow_sovmortrans_com_443' (9). This is an informational message only. No user action is required.
    04/02/2011 13:26:10,spid19s,Unknown,Recovery is writing a checkpoint in database 'DRMS_DirectoryServices_itsmd_test_moscow_sovmortrans_com_443' (11). This is an informational message only. No user action is required.
    04/02/2011 13:26:10,spid19s,Unknown,0 transactions rolled back in database 'DRMS_DirectoryServices_itsmd_test_moscow_sovmortrans_com_443' (11). This is an informational message only. No user action is required.
    04/02/2011 13:26:10,spid20s,Unknown,Recovery is writing a checkpoint in database 'DRMS_Logging_itsmd_test_moscow_sovmortrans_com_443' (12). This is an informational message only. No user action is required.
    04/02/2011 13:26:10,spid20s,Unknown,0 transactions rolled back in database 'DRMS_Logging_itsmd_test_moscow_sovmortrans_com_443' (12). This is an informational message only. No user action is required.
    04/02/2011 13:26:10,spid9s,Unknown,Starting up database 'tempdb'.
    04/02/2011 13:26:10,spid20s,Unknown,1 transactions rolled forward in database 'DRMS_Logging_itsmd_test_moscow_sovmortrans_com_443' (12). This is an informational message only. No user action is required.
    04/02/2011 13:26:10,spid19s,Unknown,2 transactions rolled forward in database 'DRMS_DirectoryServices_itsmd_test_moscow_sovmortrans_com_443' (11). This is an informational message only. No user action is required.
    04/02/2011 13:26:10,spid27s,Unknown,Starting up database 'MTS'.
    04/02/2011 13:26:10,spid26s,Unknown,Starting up database 'TSM'.
    04/02/2011 13:26:10,spid25s,Unknown,Starting up database 'WSS_Content'.
    04/02/2011 13:26:10,spid24s,Unknown,Starting up database 'WSS_Search_WSPS'.
    04/02/2011 13:26:10,spid23s,Unknown,Starting up database 'SharePoint_AdminContent_5ae95720-23cb-428c-ac1b-bacea2565067'.
    04/02/2011 13:26:10,spid21s,Unknown,Starting up database 'MTS3'.
    04/02/2011 13:26:10,spid22s,Unknown,Starting up database 'SharePoint_Config'.
    04/02/2011 13:26:10,spid19s,Unknown,Starting up database 'DRMS_DirectoryServices_itsmd_test_moscow_sovmortrans_com_443'.
    04/02/2011 13:26:10,spid13s,Unknown,Starting up database 'msdb'.
    04/02/2011 13:26:10,spid20s,Unknown,Starting up database 'DRMS_Logging_itsmd_test_moscow_sovmortrans_com_443'.
    04/02/2011 13:26:10,spid14s,Unknown,Starting up database 'SMT3_back2'.
    04/02/2011 13:26:10,spid17s,Unknown,Starting up database 'DRMS_Config_itsmd_test_moscow_sovmortrans_com_443'.
    04/02/2011 13:26:10,spid18s,Unknown,Starting up database 'SMT3'.
    04/02/2011 13:26:10,spid15s,Unknown,Starting up database 'greylist'.
    04/02/2011 13:26:10,spid12s,Unknown,Starting up database 'MTS_back'.
    04/02/2011 13:26:10,spid16s,Unknown,Starting up database 'Androsov'.
    04/02/2011 13:26:09,Server,Unknown,SQL Server is now ready for client connections. This is an informational message; no user action is required.
    04/02/2011 13:26:09,Server,Unknown,Dedicated admin connection support was established for listening locally on port 49295.
    04/02/2011 13:26:09,Server,Unknown,Server is listening on [ 127.0.0.1 <ipv4> 49295].
    04/02/2011 13:26:09,Server,Unknown,Server is listening on [ ::1 <ipv6> 49295].
    04/02/2011 13:26:09,Server,Unknown,Server named pipe provider is ready to accept connection on [ \\.\pipe\MSSQL$SQL2005\sql\query ].
    04/02/2011 13:26:09,Server,Unknown,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\SQL2005 ].
    04/02/2011 13:26:09,Server,Unknown,Server is listening on [ 'any' <ipv4> 49294].
    04/02/2011 13:26:09,Server,Unknown,Server is listening on [ 'any' <ipv6> 49294].
    04/02/2011 13:26:09,Server,Unknown,A self-generated certificate was successfully loaded for encryption.
    04/02/2011 13:26:09,spid9s,Unknown,Clearing tempdb database.
    04/02/2011 13:26:09,spid9s,Unknown,Recovery is writing a checkpoint in database 'model' (3). This is an informational message only. No user action is required.
    04/02/2011 13:26:09,spid9s,Unknown,0 transactions rolled back in database 'model' (3). This is an informational message only. No user action is required.
    04/02/2011 13:26:09,spid9s,Unknown,1 transactions rolled forward in database 'model' (3). This is an informational message only. No user action is required.
    04/02/2011 13:26:09,spid5s,Unknown,Server name is 'SMT-SQL\SQL2005'. This is an informational message only. No user action is required.
    04/02/2011 13:26:09,spid9s,Unknown,Starting up database 'model'.
    04/02/2011 13:26:09,spid5s,Unknown,An error occurred during decryption.
    04/02/2011 13:26:09,spid5s,Unknown,Error: 15466<c/> Severity: 16<c/> State: 1.
    04/02/2011 13:26:08,spid5s,Unknown,The resource database build version is 9.00.3080. This is an informational message only. No user action is required.
    04/02/2011 13:26:08,spid5s,Unknown,Starting up database 'mssqlsystemresource'.
    04/02/2011 13:26:08,spid5s,Unknown,SQL Trace ID 1 was started by login "sa".
    04/02/2011 13:26:08,spid5s,Unknown,CHECKDB for database 'master' finished without errors on 2009-10-16 14:04:06.160 (local time). This is an informational message only; no user action is required.
    04/02/2011 13:26:08,spid5s,Unknown,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    04/02/2011 13:26:08,spid5s,Unknown,0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
    04/02/2011 13:26:08,spid5s,Unknown,41 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
    04/02/2011 13:26:07,spid5s,Unknown,Starting up database 'master'.
    04/02/2011 13:26:07,Server,Unknown,Database mirroring has been enabled on this instance of SQL Server.
    04/02/2011 13:26:07,Server,Unknown,The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted.  If you would like distributed transaction functionality<c/> please start this service.
    04/02/2011 13:26:07,spid1s,Unknown,A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 35880<c/> committed (KB): 71864<c/> memory utilization: 49%.
    04/02/2011 13:26:07,Server,Unknown,Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
    04/02/2011 13:26:06,Server,Unknown,Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    04/02/2011 13:26:05,Server,Unknown,Detected 4 CPUs. This is an informational message; no user action is required.
    04/02/2011 13:26:05,Server,Unknown,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    04/02/2011 13:26:05,Server,Unknown,-l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
    04/02/2011 13:26:05,Server,Unknown,-e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
    04/02/2011 13:26:05,Server,Unknown,-d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
    04/02/2011 13:26:05,Server,Unknown,Registry startup parameters:
    04/02/2011 13:26:05,Server,Unknown,This instance of SQL Server last reported using a process ID of 4200 at 02.04.2011 13:10:22 (local) 02.04.2011 9:10:22 (UTC). This is an informational message only; no user action is required.
    04/02/2011 13:26:05,Server,Unknown,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
    04/02/2011 13:26:05,Server,Unknown,Authentication mode is MIXED.
    04/02/2011 13:26:05,Server,Unknown,Server process ID is 1804.
    04/02/2011 13:26:05,Server,Unknown,All rights reserved.
    04/02/2011 13:26:05,Server,Unknown,(c) 2005 Microsoft Corporation.
    04/02/2011 13:26:05,Server,Unknown,Microsoft SQL Server 2005 - 9.00.3080.00 (X64) <nl/> Sep  6 2009 09:15:46 <nl/> Copyright (c) 1988-2005 Microsoft Corporation<nl/> Standard Edition (64-bit) on Windows NT 6.0 (Build 6002: Service Pack 2)

    Михаил

     

    6 апреля 2011 г. 9:07
  • MikAndr, раз шифрование в базах у Вас не используется, стоит проверить Service Master Key. Посмотрите вот эту ветку http://social.msdn.microsoft.com/Forums/en-IE/sqlsecurity/thread/0b699c8e-5b37-4d7b-9c56-982934056104 и, если симптомы аналогичны, то проблема Ваша точно в повреждении мастер-ключа. А вот здесь  http://blogs.msdn.com/b/lcris/archive/2007/11/14/sql-server-2005-how-to-recover-when-the-service-master-key-smk-is-not-accessible.aspx неплохо описано решение этой проблемы в самых различных ситуациях
    Мнения, высказанные здесь, являются отражением моих личных взглядов, а не позиции корпорации Microsoft. Вся информация предоставляется "как есть" без каких-либо гарантий.
    11 апреля 2011 г. 16:30
  • Уважаемый MikAndr!

    В Вашей теме отсутствует активность в течение последних 5 дней. При отсутствии каких-либо действий в течение 2 последующих дней тема будет переведена в разряд обсуждений. Вы можете возобновить дискуссию, просто оставив сообщение в данной теме.


    Мнения, высказанные здесь, являются отражением моих личных взглядов, а не позиции корпорации Microsoft. Вся информация предоставляется "как есть" без каких-либо гарантий.
    22 апреля 2011 г. 13:59