running windows 2003 server, Sql 2000 sp3 and WSS 2.0. I have been getting
the following error. Any ideas on hot to fix it? Also sometimes I cant
connect to the DB using sql mamanger but if I restart the db I can connect.
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 6/9/2004
Time: 3:10:58 PM
User: NA\SqlServerAccount
Computer: CINSQLWSS1
Description:
Error: 17803, Severity: 20, State: 12
Insufficient memory available.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 8b 45 00 00 14 00 00 00 ?E.....
0008: 0b 00 00 00 43 00 49 00 ...C.I.
0010: 4e 00 53 00 51 00 4c 00 N.S.Q.L.
0018: 57 00 53 00 53 00 31 00 W.S.S.1.
0020: 00 00 1a 00 00 00 53 00 .....S.
0028: 54 00 53 00 5f 00 63 00 T.S._.c.
0030: 69 00 6e 00 73 00 71 00 i.n.s.q.
0038: 6c 00 77 00 73 00 73 00 l.w.s.s.
0040: 31 00 5f 00 31 00 35 00 1._.1.5.
0048: 30 00 37 00 32 00 35 00 0.7.2.5.
0050: 31 00 38 00 39 00 33 00 1.8.9.3.
0058: 00 00 ..17803 indicates that you are having memory pressure. Depending on what the
SQL error logs say, the pressure could be in the main area (Buffer pool) or
the MemToLeave area.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Showing posts with label cant. Show all posts
Showing posts with label cant. Show all posts
Sunday, February 26, 2012
Friday, February 24, 2012
Error in connection
when sinchronize this error is show:
"el proceso no pudo conectar con subscriber 'PCP'"
The process can't connect to suscriber.
Please, any IDEA, is accept.
Thanxs
Gabriel
Argentina
Gabriel Argentina,
To remove the problem, enter the distributor properties, subscribers tab and
click on the elipsis by the side of the relevant subscriber. Choose to
"impersonate the sql server agent account on 'servername' (trusted
connection)". Provided the distribution agent account exists as a login on
the subscriber and has sysadmin or db_owner rights on the subscription
database, the error is removed.
Paul England :-)
"el proceso no pudo conectar con subscriber 'PCP'"
The process can't connect to suscriber.
Please, any IDEA, is accept.
Thanxs
Gabriel
Argentina
Gabriel Argentina,
To remove the problem, enter the distributor properties, subscribers tab and
click on the elipsis by the side of the relevant subscriber. Choose to
"impersonate the sql server agent account on 'servername' (trusted
connection)". Provided the distribution agent account exists as a login on
the subscriber and has sysadmin or db_owner rights on the subscription
database, the error is removed.
Paul England :-)
Subscribe to:
Posts (Atom)