I need help with Server-MSSQL-Application error.

[Chance]

Maybe you guys can help give me a clue what could be causing our application/data base errors at a private school I help administer.


We're running AOP's Switched on School house school software. It connects to a server remotely which uses MSSQL to maintain the records. We're done countless troubleshooting sessions with AOP's tech support to resolve some of the errors we receive from the program but we're still uncertin about 1 perticular issue.

Originally we had a local Win2000 server but we've since then moved to a remote server.


Here is the sequence of errors recorded within Event Viewer on the server when the teacher attempts to view the At A Glance Screen:

==================================================
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Description:
17066 :
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = &#39;m_offBeginVar < m_SizeRec&#39;.

Data:
0000: aa 42 00 00 10 00 00 00 ?B......
0008: 0f 00 00 00 4c 00 45 00 ....L.E.
0010: 41 00 52 00 4e 00 49 00 A.R.N.I.
0018: 4e 00 47 00 50 00 4c 00 N.G.P.L.
0020: 41 00 4e 00 45 00 54 00 A.N.E.T.
0028: 00 00 07 00 00 00 4e 00 ......N.
0030: 43 00 41 00 32 00 32 00 C.A.2.2.
0038: 62 00 00 00 b...
===========================================
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Description:
18052 :
Error: 3624, Severity: 20, State: 1.

Data:
0000: 84 46 00 00 10 00 00 00 ?F......
0008: 0f 00 00 00 4c 00 45 00 ....L.E.
0010: 41 00 52 00 4e 00 49 00 A.R.N.I.
0018: 4e 00 47 00 50 00 4c 00 N.G.P.L.
0020: 41 00 4e 00 45 00 54 00 A.N.E.T.
0028: 00 00 07 00 00 00 4e 00 ......N.
0030: 43 00 41 00 32 00 32 00 C.A.2.2.
0038: 62 00 00 00 b...
=============================================
Event Type: Error
Event Source: MSSQLSERVER
Event Category: None
Event ID: 2905
Description:
The description for Event ID ( 2905 ) in Source ( MSSQLSERVER ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: 21332B6E.
Data:
0000: 32 31 33 33 32 42 36 45 21332B6E

Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 322
Description:
The data portion of event 2905 from MSSQLSERVER is invalid.
================================================




AOP&#39;s Tech support has ran cleanup utilites on the database and we&#39;ve even reconsrtucted/installed the database & network practically(Network, Server database and software) from scratch. But we seem to be the only school that has this issue.


Any information you can provide or related links on this issue would be GREATLY appriciated.

Thank you MSForums.org community & adminisrators.
Chance

[genesis]

I looked at a couple of sources but I&#39;ll need more information.

What is the client side operating system, file system and profile types?

I might ask many questions as we go though.

[Chance]

Originally posted by genesis@Jan 16 2005, 06:15 PM
I looked at a couple of sources but I&#39;ll need more information.

What is the client side operating system, file system and profile types?

I might ask many questions as we go though.

[snapback]2537[/snapback]

XP Pro workstations.
NTFS
The profiles on our domain are currently all adminisrator accounts due to us trying to narrow down the issue. The workstations are loging into the domain on our local server but the remote server hosts our school programs server application & database.

We&#39;ve acctually been troubleshooting the errors in the School program for over a year now but we&#39;re narrowing it down 1 step at a time. And I don&#39;t have direct access to the application/database "Remote" server. I&#39;m working with the technician who hosts the remote server who is a pro when it comes to this application but he&#39;s stomped too. So we&#39;ve been troubleshooting from both ends. And we&#39;re running out of ideas.

[genesis]

geez, it does sound like you&#39;ve done almost everything. Of course you&#39;re missing something.

Could it possibly be a profile issue? Have you tried a local profile instead of roaming?

[Chance]

Originally posted by genesis@Jan 16 2005, 10:20 PM
geez, it does sound like you&#39;ve done almost everything. Of course you&#39;re missing something.

Could it possibly be a profile issue? Have you tried a local profile instead of roaming?

[snapback]2540[/snapback]

Actually yes I have. I went as far as to Reinstall our servers OS when we were using it to host our Schools server application. When I did that I set up roaming user profiles and a couple of group policies but I have sence disabled the Group policies & quit using the roaming user profiles.

It doesn&#39;t seem to be group policies or permissions. The workstations have Enterprise administrator accounts. The only clue we have is this error I have posted. Can anyone make since of it?

[genesis]

No it doesn&#39;t make any sense but I have emailed this code to an IT person who is actively managing SQL server with 3000 clients on win 2k. Hope I&#39;ll get an answer back soon.

[Chance]

Thank you for your trouble. B)

[genesis]

No problem, I&#39;ll learn something new in this aswell. I don&#39;t have any updates today, will get some words tomorrow though.

[genesis]

Sorry Chance, not getting much help from anywhere on this.

[Chance]

Originally posted by genesis@Jan 22 2005, 01:43 PM
Sorry Chance, not getting much help from anywhere on this.

[snapback]2753[/snapback]

Me either. Thanks anyways.