Error on SQL server

Hello all i've just had this error on our SQL server:

Event:

Type: Error

Date: 24/05/2007

Category: Logon

User: N/A

Source: MSSQLSERVER

Computer: server name

Time: 12:24:53

In Work Hours: Yes

Security Category: Critical

Internal Event ID:

Scanned Computer: server name

Rule Name: SQL Server errors

Description ID: Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: my i.p address]

Any ideas what it means?

Thanks in advance

Matt Smith

See this related http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=481967&SiteID=1 post here.

error mssqlserver

Hi all:
The errors always during the maintenance plan, and the last error we have is:
17066; SQL Server Assertion File:<page.cpp>, line=2831
Failed Assertion='spceContig>=Align (spaceNedded)'
What means?
Thank you.
Jose
Did you search KB and Google? Using below search words, I got a number of hits on Google:
SQL 17066
Often Assertion problems are bugs in LSQ server, but then can also be corruption problems in your
database. Run DBCC CHECKDB and also search KB etc and make sure you are current on service pack. If
that doesn't help, consider opening a case with MS Support.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jose Rojas" <JoseRojas@.discussions.microsoft.com> wrote in message
news:54AF2F6A-BA57-4309-BE62-C92BD56C4ABD@.microsoft.com...
> Hi all:
> The errors always during the maintenance plan, and the last error we have is:
> 17066; SQL Server Assertion File:<page.cpp>, line=2831
> Failed Assertion='spceContig>=Align (spaceNedded)'
> What means?
> Thank you.
> Jose

error mssqlserver

Hi all:
The errors always during the maintenance plan, and the last error we have is
:
17066; SQL Server Assertion File:<page.cpp>, line=2831
Failed Assertion='spceContig>=Align (spaceNedded)'
What means'
Thank you.
JoseDid you search KB and Google? Using below search words, I got a number of hi
ts on Google:
SQL 17066
Often Assertion problems are bugs in LSQ server, but then can also be corrup
tion problems in your
database. Run DBCC CHECKDB and also search KB etc and make sure you are curr
ent on service pack. If
that doesn't help, consider opening a case with MS Support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jose Rojas" <JoseRojas@.discussions.microsoft.com> wrote in message
news:54AF2F6A-BA57-4309-BE62-C92BD56C4ABD@.microsoft.com...
> Hi all:
> The errors always during the maintenance plan, and the last error we have
is:
> 17066; SQL Server Assertion File:<page.cpp>, line=2831
> Failed Assertion='spceContig>=Align (spaceNedded)'
> What means'
> Thank you.
> Jose

error mssqlserver

Hi all:
The errors always during the maintenance plan, and the last error we have is:
17066; SQL Server Assertion File:<page.cpp>, line=2831
Failed Assertion='spceContig>=Align (spaceNedded)'
What means'
Thank you.
JoseDid you search KB and Google? Using below search words, I got a number of hits on Google:
SQL 17066
Often Assertion problems are bugs in LSQ server, but then can also be corruption problems in your
database. Run DBCC CHECKDB and also search KB etc and make sure you are current on service pack. If
that doesn't help, consider opening a case with MS Support.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jose Rojas" <JoseRojas@.discussions.microsoft.com> wrote in message
news:54AF2F6A-BA57-4309-BE62-C92BD56C4ABD@.microsoft.com...
> Hi all:
> The errors always during the maintenance plan, and the last error we have is:
> 17066; SQL Server Assertion File:<page.cpp>, line=2831
> Failed Assertion='spceContig>=Align (spaceNedded)'
> What means'
> Thank you.
> Jose

Error Message When Connecting to SQl Server Data

I am using MSDE on XP pro Service Pack 2 and have stored my data on the
default instance of MSSQLSERVER on my computer ID OFFICEPC. This is
networked to LAPTOP and SHOPPC.
My Access front end works fine with the SQL back end on the OFFICEPC. But
when I try to link the same front end from one of the other computers using
ODBC, i get the following error:
Connection Failed:
SQL state 2800
SQL Server Error 18456
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
'OFFICEPC\Guest'
I have run svrnetcn.exe and enabled port 1433 to pass through the firewall.
Ports 135 and 445 are also enabled.
What have I done wrong? Thanks in advance for any help
hi Gerald,
"Gerald G" <GeraldG@.discussions.microsoft.com> ha scritto nel messaggio
news:54F59F97-F083-4C93-B08A-4FCEA3429731@.microsoft.com
> I am using MSDE on XP pro Service Pack 2 and have stored my data on
> the default instance of MSSQLSERVER on my computer ID OFFICEPC. This
> is networked to LAPTOP and SHOPPC.
> My Access front end works fine with the SQL back end on the OFFICEPC.
> But when I try to link the same front end from one of the other
> computers using ODBC, i get the following error:
> Connection Failed:
> SQL state 2800
> SQL Server Error 18456
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> 'OFFICEPC\Guest'
> I have run svrnetcn.exe and enabled port 1433 to pass through the
> firewall. Ports 135 and 445 are also enabled.
> What have I done wrong? Thanks in advance for any help
it seems you do not have firewall troubles, but standard security problems,
as OFFICEPC\.. users are not granted login to MSDE instance... please verify
your Logins
can you telnet on port 1433 the MSDE instance?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea - thanks for answering
I think you are right about it being a standard security problem. How do I
telnet on port 1433, and How do I grant login to my MSDE instance?
"Andrea Montanari" wrote:

> hi Gerald,
> "Gerald G" <GeraldG@.discussions.microsoft.com> ha scritto nel messaggio
> news:54F59F97-F083-4C93-B08A-4FCEA3429731@.microsoft.com
> it seems you do not have firewall troubles, but standard security problems,
> as OFFICEPC\.. users are not granted login to MSDE instance... please verify
> your Logins
> can you telnet on port 1433 the MSDE instance?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Gerald
"Gerald G" <GeraldG@.discussions.microsoft.com> ha scritto nel messaggio
news:7CD6EC0F-53A4-4252-9228-A40089BE66FF@.microsoft.com
> Hi Andrea - thanks for answering
> I think you are right about it being a standard security problem.
> How do I telnet on port 1433, and How do I grant login to my MSDE
> instance?
>
in order to grant your 'OFFICEPC\xxxx' users, you have to add them to the
SQL Server Windows logins...
please have a look at
http://support.microsoft.com/default...N-US;q325003#8 for
further info about granting login to Windows logins/groups
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Error Message 7001

Help: I am getting an event error #7001 and the following
message.
The SQLSERVERAGENT service depends on the MSSQLSERVER
service which failed to start because of the following
error:
%%0| Help: I am getting an event error #7001 and the following
| message.
|
| The SQLSERVERAGENT service depends on the MSSQLSERVER
| service which failed to start because of the following
| error:
| %%0
--
Hi Michael,
Check your SQL Server errorlogs, there could be more information about the
problem why SQL Server won't start.
Hope this helps,
--
Eric Cárdenas
SQL Server support

Error message

Hi,

I keep getting this error message while creating and deploying my report. I already restart the SQL server services(MSSQLServer) a lot of times, it is still the same.

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'AdventureWorks'. (rsErrorOpeningConnection)

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

I also got another error message while deploying my report.

The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)

Anybody knows how to solve this?

For the first error, try enabling named pipe for SQL server. Make sure you restart RS service after restarting SQL service.|||

I already tried that. Sometimes it works, but after a few minutes, it give me back the same error message or this:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable)

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)|||

Oh ... You need to fix "Initialization" first. I am surprised it worked for you at all. However, the error message doesn't make sense to me. Can you try resetting database connection from the config tool? Make sure every tab is green.

Perhaps the easiest solution is to reinstall RS.

Error Message

Can anyone shed any light on the following error message
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 01/07/2003
Time: 17:30:59
User: N/A
Computer: XXXXXX1
Description:
17148 :
SQL Server is terminating due to 'stop' request from
Service Control Manager.
Thanks
PeterHello, Peter!
This, AFAIK, is SQL Server telling you it has been told to shut down. The
Event Type is Information. I do not think there is anything to worry about
from a SLQ Server point of view. You may however want to know who and why
your server is shutting down.<grin>
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
: Event Type: Information
: Event Source: MSSQLSERVER
: Event Category: (2)
: Event ID: 17055
: Date: 01/07/2003
: Time: 17:30:59
: User: N/A
: Computer: XXXXXX1
: Description:
: 17148 :
: SQL Server is terminating due to 'stop' request from
: Service Control Manager.
-- Microsoft CDO for Windows 2000|||Thanks Allan, as you said I will just have to figure out
why.
Peter
>--Original Message--
>Hello, Peter!
>This, AFAIK, is SQL Server telling you it has been told
to shut down. The
>Event Type is Information. I do not think there is
anything to worry about
>from a SLQ Server point of view. You may however want to
know who and why
>your server is shutting down.<grin>
>--
>Allan Mitchell (Microsoft SQL Server MVP)
>MCSE,MCDBA
>www.SQLDTS.com
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>: Event Type: Information
>: Event Source: MSSQLSERVER
>: Event Category: (2)
>: Event ID: 17055
>: Date: 01/07/2003
>: Time: 17:30:59
>: User: N/A
>: Computer: XXXXXX1
>: Description:
>: 17148 :
>: SQL Server is terminating due to 'stop' request from
>: Service Control Manager.
> -- Microsoft CDO for Windows 2000
>
>.
>

Error message

Does anyone know the meaning of this error message?
Event Type: Warning
Event Source: MSSQLServer
Event Category: (8)
Event ID: 19011
Date: 4/27/2007
Time: 10:21:33 PM
User: N/A
Computer:
Description:
SuperSocket info: (SpnRegister) : Error -2146893006.
Thank you.Hi
"GoFishing" wrote:
> Does anyone know the meaning of this error message?
> Event Type: Warning
> Event Source: MSSQLServer
> Event Category: (8)
> Event ID: 19011
> Date: 4/27/2007
> Time: 10:21:33 PM
> User: N/A
> Computer:
> Description:
> SuperSocket info: (SpnRegister) : Error -2146893006.
>
> Thank you.
>
Have you seen http://tinyurl.com/25uyv7
John