SQL Server connection could not be established
-
MY PDC server (WIndows 2003)is also SQL server(2000)
Till yesterday i was able to connect to the sql server thru enterprize mgr.
today when i click on the sql server in the enterprize mgr in my machine i get the follwoing error...
connection could not be established.
Reason:cannot generate SSPI context
Please verify SQL server is running and check your SQL server registration property and try again.
SQL server is showing started (green arrow). checked in the services both server and agent services are running. No change in registration property.
Application Event log of the SQL server is showing follwoing error...
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(2)
Event ID:17055
Date:07/07/2009
Time:10:30:04 PM
User:NT AUTHORITY\SYSTEM
Computer:ANDH002
Description:
18210 :
BackupVirtualDeviceSet::Initialize: Open failure on backup device '{3706E7A8-4791-4A87-8F76-E3029C2E0D3F}1'. Operating system error 0x80070005(error not found).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 22 47 00 00 10 00 00 00 "G......
0008: 08 00 00 00 41 00 4e 00 ....A.N.
0010: 44 00 48 00 30 00 30 00 D.H.0.0.
0018: 32 00 00 00 07 00 00 00 2.......
0020: 6d 00 61 00 73 00 74 00 m.a.s.t.
0028: 65 00 72 00 00 00 e.r...
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(6)
Event ID:17055
Date:07/07/2009
Time:10:30:04 PM
User:NT AUTHORITY\SYSTEM
Computer:ANDH002
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [master] TO VIRTUAL_DEVICE='{3706E7A8-4791-4A87-8F76-E3029C2E0D3F}1' WITH SNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: e1 0b 00 00 10 00 00 00 á.......
0008: 08 00 00 00 41 00 4e 00 ....A.N.
0010: 44 00 48 00 30 00 30 00 D.H.0.0.
0018: 32 00 00 00 07 00 00 00 2.......
0020: 6d 00 61 00 73 00 74 00 m.a.s.t.
0028: 65 00 72 00 00 00 e.r...
The above 2 errors are comming for all databases... and further follwoing error...
Event Type:Error
Event Source:VSS
Event Category:None
Event ID:6013
Date:07/07/2009
Time:10:30:04 PM
User:N/A
Computer:ANDH002
Description:
Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft OLE DB Provider for SQL Server
Error message: BACKUP DATABASE is terminating abnormally.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 2d 20 43 6f 64 65 3a 20 - Code:
0008: 53 51 4c 43 4f 4e 4e 43 SQLCONNC
0010: 30 30 30 30 30 36 33 39 00000639
0018: 2d 20 43 61 6c 6c 3a 20 - Call:
0020: 53 51 4c 43 4f 4e 4e 43 SQLCONNC
0028: 30 30 30 30 30 36 31 34 00000614
0030: 2d 20 50 49 44 3a 20 20 - PID:
0038: 30 30 30 30 32 33 33 32 00002332
0040: 2d 20 54 49 44 3a 20 20 - TID:
0048: 30 30 30 30 33 34 36 30 00003460
0050: 2d 20 43 4d 44 3a 20 20 - CMD:
0058: 43 3a 5c 57 49 4e 44 4f C:\WINDO
0060: 57 53 5c 53 79 73 74 65 WS\Syste
0068: 6d 33 32 5c 76 73 73 76 m32\vssv
0070: 63 2e 65 78 65 20 20 20 c.exe
0078: 2d 20 55 73 65 72 3a 20 - User:
0080: 4e 54 20 41 55 54 48 4f NT AUTHO
0088: 52 49 54 59 5c 53 59 53 RITY\SYS
0090: 54 45 4d 20 20 20 20 20 TEM
0098: 2d 20 53 69 64 3a 20 20 - Sid:
00a0: 53 2d 31 2d 35 2d 31 38 S-1-5-18
can anybody explain the errors?
What could be the reason?
-
This article can probably help you: http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply