Hallo,
hatte gestern AVG Virensoftware installiert.
Danach eine Menge Probleme und wieder runter geworfen.
Seitdem geht der SQL Server von JtL nicht mehr.
Hier mal die LOG Datei:
2010-10-15 14:21:59.49 Server Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)
May 26 2009 14:24:20
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
2010-10-15 14:21:59.49 Server (c) 2005 Microsoft Corporation.
2010-10-15 14:21:59.49 Server All rights reserved.
2010-10-15 14:21:59.49 Server Server process ID is 2128.
2010-10-15 14:21:59.49 Server Authentication mode is MIXED.
2010-10-15 14:21:59.49 Server Logging SQL Server messages in file 'C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-10-15 14:21:59.49 Server This instance of SQL Server last reported using a process ID of 1796 at 15.10.2010 14:07:35 (local) 15.10.2010 12:07:35 (UTC). This is an informational message only; no user action is required.
2010-10-15 14:21:59.49 Server Registry startup parameters:
2010-10-15 14:21:59.49 Server -d C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-10-15 14:21:59.49 Server -e C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-10-15 14:21:59.49 Server -l C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-10-15 14:21:59.50 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-10-15 14:21:59.51 Server Detected 2 CPUs. This is an informational message; no user action is required.
2010-10-15 14:22:00.19 Server 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.
2010-10-15 14:22:00.21 Server Database mirroring has been enabled on this instance of SQL Server.
2010-10-15 14:22:00.21 spid5s Starting up database 'master'.
2010-10-15 14:22:00.21 spid5s Fehler: 17207, Schweregrad: 16, Status: 1.
2010-10-15 14:22:00.21 spid5s FCB::Open: Operating system error 5(Zugriff verweigert) occurred while creating or opening file 'C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf'. Diagnose and correct the operating system error, and retry the operation.
2010-10-15 14:22:00.21 spid5s Fehler: 17204, Schweregrad: 16, Status: 1.
2010-10-15 14:22:00.21 spid5s FCB::Open failed: Could not open file C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf for file number 1. OS error: 5(Zugriff verweigert).
2010-10-15 14:22:00.22 spid5s Fehler: 5120, Schweregrad: 16, Status: 101.
2010-10-15 14:22:00.22 spid5s Die physikalische Datei "C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" kann nicht geöffnet werden. Betriebssystemfehler 5: "5(Zugriff verweigert)".
2010-10-15 14:22:00.22 spid5s Fehler: 17207, Schweregrad: 16, Status: 1.
2010-10-15 14:22:00.22 spid5s FCB::Open: Operating system error 5(Zugriff verweigert) occurred while creating or opening file 'C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf'. Diagnose and correct the operating system error, and retry the operation.
2010-10-15 14:22:00.22 spid5s Fehler: 17204, Schweregrad: 16, Status: 1.
2010-10-15 14:22:00.22 spid5s FCB::Open failed: Could not open file C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf for file number 2. OS error: 5(Zugriff verweigert).
2010-10-15 14:22:00.22 spid5s Fehler: 5120, Schweregrad: 16, Status: 101.
2010-10-15 14:22:00.22 spid5s Die physikalische Datei "C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" kann nicht geöffnet werden. Betriebssystemfehler 5: "5(Zugriff verweigert)".
ot register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2010-10-14 16:38:00.04 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-10-14 16:38:00.37 spid4s 1 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2010-10-14 16:38:00.46 spid4s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2010-10-14 16:38:00.46 spid4s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2010-10-14 16:38:00.51 spid8s Clearing tempdb database.
2010-10-14 16:38:03.21 spid8s Starting up database 'tempdb'.
2010-10-14 16:38:03.99 spid4s Recovery is complete. This is an informational message only. No user action is required.
2010-10-14 16:38:04.05 spid11s The Service Broker protocol transport is disabled or not configured.
2010-10-14 16:38:04.05 spid11s The Database Mirroring protocol transport is disabled or not configured.
2010-10-14 16:38:04.75 spid11s Service Broker manager has started.
2010-10-14 18:08:13.62 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2010-10-14 18:08:30.07 spid11s Service Broker manager has shut down.
2010-10-14 18:08:30.20 spid11s Error: 17054, Severity: 16, State: 1.
2010-10-14 18:08:30.20 spid11s The current event was not reported to the Windows Events log. Operating system error = 1717(Die Schnittstelle ist unbekannt.). You may need to clear the Windows Events log if it is full.
2010-10-14 18:08:31.64 spid4s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Hoffe Ihr könnt mir helfen.
Die letzte BAK ist schon eine Weile her...sch...
mfG
hatte gestern AVG Virensoftware installiert.
Danach eine Menge Probleme und wieder runter geworfen.
Seitdem geht der SQL Server von JtL nicht mehr.
Hier mal die LOG Datei:
2010-10-15 14:21:59.49 Server Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86)
May 26 2009 14:24:20
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
2010-10-15 14:21:59.49 Server (c) 2005 Microsoft Corporation.
2010-10-15 14:21:59.49 Server All rights reserved.
2010-10-15 14:21:59.49 Server Server process ID is 2128.
2010-10-15 14:21:59.49 Server Authentication mode is MIXED.
2010-10-15 14:21:59.49 Server Logging SQL Server messages in file 'C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-10-15 14:21:59.49 Server This instance of SQL Server last reported using a process ID of 1796 at 15.10.2010 14:07:35 (local) 15.10.2010 12:07:35 (UTC). This is an informational message only; no user action is required.
2010-10-15 14:21:59.49 Server Registry startup parameters:
2010-10-15 14:21:59.49 Server -d C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-10-15 14:21:59.49 Server -e C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-10-15 14:21:59.49 Server -l C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-10-15 14:21:59.50 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-10-15 14:21:59.51 Server Detected 2 CPUs. This is an informational message; no user action is required.
2010-10-15 14:22:00.19 Server 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.
2010-10-15 14:22:00.21 Server Database mirroring has been enabled on this instance of SQL Server.
2010-10-15 14:22:00.21 spid5s Starting up database 'master'.
2010-10-15 14:22:00.21 spid5s Fehler: 17207, Schweregrad: 16, Status: 1.
2010-10-15 14:22:00.21 spid5s FCB::Open: Operating system error 5(Zugriff verweigert) occurred while creating or opening file 'C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf'. Diagnose and correct the operating system error, and retry the operation.
2010-10-15 14:22:00.21 spid5s Fehler: 17204, Schweregrad: 16, Status: 1.
2010-10-15 14:22:00.21 spid5s FCB::Open failed: Could not open file C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf for file number 1. OS error: 5(Zugriff verweigert).
2010-10-15 14:22:00.22 spid5s Fehler: 5120, Schweregrad: 16, Status: 101.
2010-10-15 14:22:00.22 spid5s Die physikalische Datei "C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf" kann nicht geöffnet werden. Betriebssystemfehler 5: "5(Zugriff verweigert)".
2010-10-15 14:22:00.22 spid5s Fehler: 17207, Schweregrad: 16, Status: 1.
2010-10-15 14:22:00.22 spid5s FCB::Open: Operating system error 5(Zugriff verweigert) occurred while creating or opening file 'C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf'. Diagnose and correct the operating system error, and retry the operation.
2010-10-15 14:22:00.22 spid5s Fehler: 17204, Schweregrad: 16, Status: 1.
2010-10-15 14:22:00.22 spid5s FCB::Open failed: Could not open file C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf for file number 2. OS error: 5(Zugriff verweigert).
2010-10-15 14:22:00.22 spid5s Fehler: 5120, Schweregrad: 16, Status: 101.
2010-10-15 14:22:00.22 spid5s Die physikalische Datei "C:\Programme\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf" kann nicht geöffnet werden. Betriebssystemfehler 5: "5(Zugriff verweigert)".
ot register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2010-10-14 16:38:00.04 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2010-10-14 16:38:00.37 spid4s 1 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2010-10-14 16:38:00.46 spid4s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2010-10-14 16:38:00.46 spid4s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2010-10-14 16:38:00.51 spid8s Clearing tempdb database.
2010-10-14 16:38:03.21 spid8s Starting up database 'tempdb'.
2010-10-14 16:38:03.99 spid4s Recovery is complete. This is an informational message only. No user action is required.
2010-10-14 16:38:04.05 spid11s The Service Broker protocol transport is disabled or not configured.
2010-10-14 16:38:04.05 spid11s The Database Mirroring protocol transport is disabled or not configured.
2010-10-14 16:38:04.75 spid11s Service Broker manager has started.
2010-10-14 18:08:13.62 Server SQL Server is terminating because of a system shutdown. This is an informational message only. No user action is required.
2010-10-14 18:08:30.07 spid11s Service Broker manager has shut down.
2010-10-14 18:08:30.20 spid11s Error: 17054, Severity: 16, State: 1.
2010-10-14 18:08:30.20 spid11s The current event was not reported to the Windows Events log. Operating system error = 1717(Die Schnittstelle ist unbekannt.). You may need to clear the Windows Events log if it is full.
2010-10-14 18:08:31.64 spid4s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
Hoffe Ihr könnt mir helfen.
Die letzte BAK ist schon eine Weile her...sch...
mfG