Pozdrav svima!
Imam problem sa SQL Server-om Enterprise edition (ceo rezultat select @@VERSION query-ja je
OS je Windows 7 Ultimate 64-bit, CPU AMD Phenom II X4 955 3.2GHz, RAM 4GB...
Od kako sam instalirao SQL Server ne mogu da pokrenem SQL Server Agent. U SQL Server Management Studio mi stoji "SQL Server Agent (Agent XPs disabled). Kada pokusam odatle da ga pokrenem izbaci "Object reference not set to an instance of an object.". U SQL Server configuration manager "SQL Server Agent (MSSQLSERVER) je u statusu "Stopped". Kada pokusam odatle da ga pokrenem izbaci "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details". Trenutno se taj service loguje kao Local System, mada je bio i kao Network System i kao user sa full admin pravima i uvek isto. SQLAGENT.OUT log file ima sledeci sadrzaj:
Ima li iko ideju kako da resim problem? Guglao sam, ali nigde nisam naisao na konkretno ovaj slucaj i ovu gresku "SQLServer Error: 22022, CryptUnprotectData() returned error 13, 'The data is invalid.' [SQLSTATE 42000]". Hvala unapred!
Imam problem sa SQL Server-om Enterprise edition (ceo rezultat select @@VERSION query-ja je
Code:
Microsoft SQL Server 2008 (CTP) - 10.0.1442.32 (X64) May 29 2008 23:52:04 Copyright (c) 1988-2007 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
)Microsoft SQL Server 2008 (CTP) - 10.0.1442.32 (X64) May 29 2008 23:52:04 Copyright (c) 1988-2007 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
OS je Windows 7 Ultimate 64-bit, CPU AMD Phenom II X4 955 3.2GHz, RAM 4GB...
Od kako sam instalirao SQL Server ne mogu da pokrenem SQL Server Agent. U SQL Server Management Studio mi stoji "SQL Server Agent (Agent XPs disabled). Kada pokusam odatle da ga pokrenem izbaci "Object reference not set to an instance of an object.". U SQL Server configuration manager "SQL Server Agent (MSSQLSERVER) je u statusu "Stopped". Kada pokusam odatle da ga pokrenem izbaci "The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details". Trenutno se taj service loguje kao Local System, mada je bio i kao Network System i kao user sa full admin pravima i uvek isto. SQLAGENT.OUT log file ima sledeci sadrzaj:
Code:
2012-02-13 11:32:45 - ? [393] Waiting for SQL Server to recover databases...
2012-02-13 11:32:53 - ? [100] Microsoft SQLServerAgent version 10.0.1442.32 ((Unknown) unicode retail build) : Process ID 1972
2012-02-13 11:32:53 - ? [101] SQL Server ZOMBI-PC version 10.00.1442 (0 connection limit)
2012-02-13 11:32:53 - ? [102] SQL Server ODBC driver version 10.00.1442
2012-02-13 11:32:53 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
2012-02-13 11:32:53 - ? [310] 4 processor(s) and 4094 MB RAM detected
2012-02-13 11:32:53 - ? [339] Local computer is ZOMBI-PC running Windows NT 6.1 (7601) Service Pack 1
2012-02-13 11:32:55 - ? [432] There are 12 subsystems in the subsystems cache
2012-02-13 11:32:56 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2012-02-13 11:32:56 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2012-02-13 11:32:56 - ! [298] SQLServer Error: 22022, CryptUnprotectData() returned error 13, 'The data is invalid.' [SQLSTATE 42000]
2012-02-13 11:32:56 - ! [442] ConnConnectAndSetCryptoForXpstar failed (0).
2012-02-13 11:32:57 - ? [098] SQLServerAgent terminated (normally)
2012-02-13 11:32:45 - ? [393] Waiting for SQL Server to recover databases...
2012-02-13 11:32:53 - ? [100] Microsoft SQLServerAgent version 10.0.1442.32 ((Unknown) unicode retail build) : Process ID 1972
2012-02-13 11:32:53 - ? [101] SQL Server ZOMBI-PC version 10.00.1442 (0 connection limit)
2012-02-13 11:32:53 - ? [102] SQL Server ODBC driver version 10.00.1442
2012-02-13 11:32:53 - ? [103] NetLib being used by driver is DBNETLIB.DLL; Local host server is
2012-02-13 11:32:53 - ? [310] 4 processor(s) and 4094 MB RAM detected
2012-02-13 11:32:53 - ? [339] Local computer is ZOMBI-PC running Windows NT 6.1 (7601) Service Pack 1
2012-02-13 11:32:55 - ? [432] There are 12 subsystems in the subsystems cache
2012-02-13 11:32:56 - ! [364] The Messenger service has not been started - NetSend notifications will not be sent
2012-02-13 11:32:56 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2012-02-13 11:32:56 - ! [298] SQLServer Error: 22022, CryptUnprotectData() returned error 13, 'The data is invalid.' [SQLSTATE 42000]
2012-02-13 11:32:56 - ! [442] ConnConnectAndSetCryptoForXpstar failed (0).
2012-02-13 11:32:57 - ? [098] SQLServerAgent terminated (normally)
Ima li iko ideju kako da resim problem? Guglao sam, ali nigde nisam naisao na konkretno ovaj slucaj i ovu gresku "SQLServer Error: 22022, CryptUnprotectData() returned error 13, 'The data is invalid.' [SQLSTATE 42000]". Hvala unapred!