|
rikleo2001
Posting Yak Master
185 Posts |
 Posted - 2009-10-15 : 08:04:15
|
| HiI have SQL Server 2005 SP2 on Windows 2003 with 4 GB memory and working as Witness server for 50 Databases from differant servers.suddenly it stopped working. I can't logon to SSQL, I checked the services are running but I can't connect to instance, Login Handshake error come up, so I re-started the service and all backup and online.Here is error detail.009-10-14 06:30:01.62 spid55 Error: 701, Severity: 17, State: 123.2009-10-14 06:30:01.62 spid55 There is insufficient system memory to run this query.2009-10-14 06:30:01.86 Backup Log was backed up. Database: model, creation date(time): 2003/04/08(09:13:36), first LSN: 57:112:1, last LSN: 57:112:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'f:\SQLdumps\MSSQLSERVER\Scheduled\model\model_tlog_200910140630.TRN'}). This is an informational message only. No user action is required.2009-10-14 07:24:49.83 spid54 Error: 701, Severity: 17, State: 123.2009-10-14 07:24:49.83 spid54 There is insufficient system memory to run this query.2009-10-14 07:24:49.83 spid54 Error: 701, Severity: 17, State: 123.2009-10-14 07:24:49.83 spid54 There is insufficient system memory to run this query.2009-10-14 07:24:51.73 spid54 Error: 701, Severity: 17, State: 123.2009-10-14 07:24:51.73 spid54 There is insufficient system memory to run this query.2009-10-14 07:24:51.73 spid54 Error: 701, Severity: 17, State: 123.2009-10-14 07:24:51.73 spid54 There is insufficient system memory to run this query.2009-10-14 07:24:52.25 spid54 Error: 701, Severity: 17, State: 123.2009-10-14 07:24:52.25 spid54 There is insufficient system memory to run this query.2009-10-14 07:24:52.25 spid54 Error: 701, Severity: 17, State: 123.2009-10-14 07:24:52.25 spid54 There is insufficient system memory to run this query.2009-10-14 08:30:01.56 spid55 Error: 701, Severity: 17, State: 123.2009-10-14 08:30:01.56 spid55 There is insufficient system memory to run this query.2009-10-14 08:30:01.73 Backup Log was backed up. Database: model, creation date(time): 2003/04/08(09:13:36), first LSN: 57:112:1, last LSN: 57:112:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'f:\SQLdumps\MSSQLSERVER\Scheduled\model\model_tlog_200910140830.TRN'}). This is an informational message only. No user action is required.2009-10-14 10:30:01.18 spid55 Error: 701, Severity: 17, State: 123.2009-10-14 10:30:01.18 spid55 There is insufficient system memory to run this query.2009-10-14 10:30:01.72 Backup Log was backed up. Database: model, creation date(time): 2003/04/08(09:13:36), first LSN: 57:112:1, last LSN: 57:112:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'f:\SQLdumps\MSSQLSERVER\Scheduled\model\model_tlog_200910141030.TRN'}). This is an informational message only. No user action is required.2009-10-14 12:30:01.80 spid55 Error: 701, Severity: 17, State: 123.2009-10-14 12:30:01.80 spid55 There is insufficient system memory to run this query.2009-10-14 12:30:02.33 Backup Log was backed up. Database: model, creation date(time): 2003/04/08(09:13:36), first LSN: 57:112:1, last LSN: 57:112:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'f:\SQLdumps\MSSQLSERVER\Scheduled\model\model_tlog_200910141230.TRN'}). This is an informational message only. No user action is required.2009-10-14 14:30:02.24 spid55 Error: 701, Severity: 17, State: 123.2009-10-14 14:30:02.24 spid55 There is insufficient system memory to run this query.2009-10-14 14:30:02.60 Backup Log was backed up. Database: model, creation date(time): 2003/04/08(09:13:36), first LSN: 57:112:1, last LSN: 57:112:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'f:\SQLdumps\MSSQLSERVER\Scheduled\model\model_tlog_200910141430.TRN'}). This is an informational message only. No user action is required.2009-10-14 16:30:02.62 spid55 Error: 701, Severity: 17, State: 123.2009-10-14 16:30:02.62 spid55 There is insufficient system memory to run this query.2009-10-14 16:30:02.86 Backup Log was backed up. Database: model, creation date(time): 2003/04/08(09:13:36), first LSN: 57:112:1, last LSN: 57:112:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'f:\SQLdumps\MSSQLSERVER\Scheduled\model\model_tlog_200910141630.TRN'}). This is an informational message only. No user action is required.2009-10-14 18:30:03.53 spid55 Error: 701, Severity: 17, State: 123.2009-10-14 18:30:03.53 spid55 There is insufficient system memory to run this query.2009-10-14 18:30:03.67 Backup Log was backed up. Database: model, creation date(time): 2003/04/08(09:13:36), first LSN: 57:112:1, last LSN: 57:112:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'f:\SQLdumps\MSSQLSERVER\Scheduled\model\model_tlog_200910141830.TRN'}). This is an informational message only. No user action is required.2009-10-14 19:30:56.92 spid17s Error: 9650, Severity: 16, State: 36.2009-10-14 19:30:56.92 spid17s A system cryptographic call failed during a Service Broker or Database Mirroring operation: system error '8(error not found)'.2009-10-14 19:30:56.93 spid17s Error: 1474, Severity: 16, State: 1.2009-10-14 19:30:56.93 spid17s Database mirroring connection error 4 'An error occurred while sending data: '(null)'.' for 'TCP://xxxx.xx.z.com:5022'.2009-10-14 19:30:56.93 spid17s Error: 17054, Severity: 16, State: 1.2009-10-14 19:30:56.93 spid17s The current event was not reported to the Windows Events log. Operating system error = 8(error not found). You may need to clear the Windows Events log if it is full.2009-10-14 19:31:53.97 spid27s Error: 9650, Severity: 16, State: 36.2009-10-14 19:31:53.97 spid27s A system cryptographic call failed during a Service Broker or Database Mirroring operation: system error '8(error not found)'.2009-10-14 19:31:53.97 spid27s Error: 1474, Severity: 16, State: 1.2009-10-14 19:31:53.97 spid27s Database mirroring connection error 4 'An error occurred while sending data: '(null)'.' for 'TCP://xxxx.xx.z.com:5022'.2009-10-14 19:31:54.06 Logon Database Mirroring login attempt by user 'xxxx\$aaaaaa' failed with error: 'Connection handshake failed. The login 'xxxx\$aaaaaa' does not have CONNECT permission on the endpoint. State 91.'. [CLIENT: xx.xx.x.x.x]2009-10-14 19:31:54.06 spid16s Error: 1474, Severity: 16, State: 1.Any ideas how to get rid of this problem in future?Many Thanks in advance.SKR |
|
Witness Server Stopped working