Failed Assertion = 'm_activeSdesList.Head () == NULL' (in Combination With Error: 1203)
Jun 6, 2000
On our datawarehouse server we are regularly having a 1203 error, causing the sql-server to hang. We get this message in the errorlog: Failed Assertion = 'm_activeSdesList.Head () == NULL'. In the knowledgebase I found a bug description that is very lookalike to our problem.
Article: Q240853 FIX: Lock Escalation With Parallel Query May Cause 1203 Error And Server Shutdown
*** part of the article ***
SYMPTOMS
If a lock escalation occurs while running a parallel query, it is possible to encounter error message 1203 as follows:
spid7 Process 7 unlocking unowned resource: KEY: 13:117575457:2 (35010560ebcd)
spid7 Process 7 unlocking unowned resource: KEY: 13:117575457:2 (35010560ebcd)
spid7 Error: 1203, Severity: 20, State: 1
spid7 Process ID 7 attempting to unlock unowned resource KEY: 13:117575457:2 (35010560ebcd).
spid7 Error: 1203, Severity: 20, State: 1
spid7 Process ID 7 attempting to unlock unowned resource KEY: 13:117575457:2 (35010560ebcd).
The error message included in the error log probably mentions the same lock resource in several of the error messages.
Once the error is printed, an assertion message similar to the following is also printed:
1999-08-09 13:15:26.79 kernel SQL Server Assertion: File: <proc.c>, line=1866 Failed Assertion = 'm_activeSdesList.Head () == NULL'.
After a dump of the stack for all threads, the server initiates a shutdown of the SQL Server process.
...
*** end ***
You can find the complete article on: http://support.microsoft.com/support/kb/articles/q240/8/53.asp?LN=EN-US&SD=gn&FR=0
We can't use the workaround, because that would shut out parallelism, which is necessary for the project.
There is a fix, but in the article Microsoft says: "A supported fix that corrects this problem is now available from Microsoft, but it has not been fully regression tested and should be applied only to systems experiencing this specific problem.".
You understan,d this is not one of my favorite type of fixes...
Does anyone have already installed the fix mentioned? Had any problems with it, or did it cause some other troubles?
Thx,
Kurt De Cauwsemaecker
Database Administrator
Telepolis Antwerpen
View 1 Replies
ADVERTISEMENT
Dec 26, 2006
Now I moved Sql Server 2005 sp1 into production, but I've got so many the following "SQL Server Assertion Failed" exception.
Who can help me? Thanks in advance!
=========== Exception INFO from SQL LOG =====================
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 9.00.2047.00
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is DELL - 1
Phoenix ROM BIOS PLUS Version 1.10 1.1.0
Current time is 17:27:14 12/25/06.
4 Intel x86 level 6, 1995 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 1.
Memory
MemoryLoad = 52%
Total Physical = 4094 MB
Available Physical = 1963 MB
Total Page File = 5973 MB
Available Page File = 3757 MB
Total Virtual = 2047 MB
Available Virtual = 251 MB
**Dump thread - spid = 63, PSS = 0x713695C0, EC = 0x713695C8
***Stack Dump being sent to F:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump1698.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 12/25/06 17:27:14 spid 63
*
* Location: lckmgr.cpp:10846
* Expression: GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()
* SPID: 63
* Process ID: 5464
*
* Input Buffer 404 bytes -
* 3 ? [SQL SCRIPT OVER HERE]
*
*
* MODULE BASE END SIZE
* sqlservr 01000000 02BCEFFF 01bcf000
* ntdll 7C800000 7C8BFFFF 000c0000
* kernel32 77E40000 77F41FFF 00102000
* MSVCR80 78130000 781CAFFF 0009b000
* msvcrt 77BA0000 77BF9FFF 0005a000
* MSVCP80 7C420000 7C4A6FFF 00087000
* ADVAPI32 77F50000 77FEBFFF 0009c000
* RPCRT4 77C50000 77CEEFFF 0009f000
* USER32 77380000 77411FFF 00092000
* GDI32 77C00000 77C47FFF 00048000
* CRYPT32 761B0000 76242FFF 00093000
* MSASN1 76190000 761A1FFF 00012000
* Secur32 76F50000 76F62FFF 00013000
* MSWSOCK 71B20000 71B60FFF 00041000
* WS2_32 71C00000 71C16FFF 00017000
* WS2HELP 71BF0000 71BF7FFF 00008000
* USERENV 76920000 769E3FFF 000c4000
* opends60 333E0000 333E6FFF 00007000
* NETAPI32 71C40000 71C97FFF 00058000
* SHELL32 7C8D0000 7D0D3FFF 00804000
* SHLWAPI 77DA0000 77DF1FFF 00052000
* IMM32 76290000 762ACFFF 0001d000
* LPK 62D80000 62D88FFF 00009000
* USP10 75490000 754F0FFF 00061000
* comctl32 77420000 77522FFF 00103000
* psapi 76B70000 76B7AFFF 0000b000
* instapi 48060000 48069FFF 0000a000
* sqlevn70 4F610000 4F7A3FFF 00194000
* sqlevn70 00890000 00A23FFF 00194000
* SQLOS 344D0000 344D4FFF 00005000
* rsaenh 33B40000 33B6EFFF 0002f000
* AUTHZ 76C40000 76C53FFF 00014000
* MSCOREE 341E0000 34224FFF 00045000
* ole32 77670000 777A3FFF 00134000
* msv1_0 76C90000 76CB6FFF 00027000
* iphlpapi 76CF0000 76D09FFF 0001a000
* kerberos 34450000 344A7FFF 00058000
* cryptdll 766E0000 766EBFFF 0000c000
* schannel 76750000 76776FFF 00027000
* COMRES 77010000 770D5FFF 000c6000
* XOLEHLP 57B10000 57B15FFF 00006000
* MSDTCPRX 61150000 611C7FFF 00078000
* msvcp60 780C0000 78120FFF 00061000
* MTXCLU 51620000 51638FFF 00019000
* VERSION 77B90000 77B97FFF 00008000
* WSOCK32 71BB0000 71BB8FFF 00009000
* OLEAUT32 77D00000 77D8BFFF 0008c000
* CLUSAPI 51640000 51651FFF 00012000
* RESUTILS 51660000 51672FFF 00013000
* DNSAPI 76ED0000 76EFEFFF 0002f000
* winrnr 76F70000 76F76FFF 00007000
* WLDAP32 76F10000 76F3DFFF 0002e000
* rasadhlp 76F80000 76F87FFF 00008000
* security 51AB0000 51AB3FFF 00004000
* msfte 52320000 52578FFF 00259000
* dbghelp 52580000 52692FFF 00113000
* WINTRUST 76BB0000 76BDAFFF 0002b000
* imagehlp 76C10000 76C38FFF 00029000
* dssenh 52980000 529A3FFF 00024000
* hnetcfg 5F270000 5F2C8FFF 00059000
* wshtcpip 52A10000 52A17FFF 00008000
* NTMARTA 77E00000 77E21FFF 00022000
* SAMLIB 5CCF0000 5CCFEFFF 0000f000
* ntdsapi 766F0000 76704FFF 00015000
* xpsp2res 52B20000 52DE4FFF 002c5000
* CLBCatQ 777B0000 77832FFF 00083000
* sqlncli 52E00000 53021FFF 00222000
* COMCTL32 77530000 775C6FFF 00097000
* comdlg32 762B0000 762F9FFF 0004a000
* SQLNCLIR 53050000 53082FFF 00033000
* msftepxy 53190000 531A4FFF 00015000
* xpsqlbot 55B80000 55B85FFF 00006000
* xpstar90 55A20000 55A67FFF 00048000
* SQLSCM90 55A70000 55A78FFF 00009000
* ODBC32 55A90000 55ACCFFF 0003d000
* BatchParser90 55AD0000 55AEEFFF 0001f000
* ATL80 7C630000 7C64AFFF 0001b000
* odbcint 55F00000 55F16FFF 00017000
* xpstar90 562F0000 56315FFF 00026000
* xplog70 56350000 5635BFFF 0000c000
* xplog70 56370000 56372FFF 00003000
* dbghelp 56500000 56612FFF 00113000
*
* Edi: 532AC278: 0016DFC0 0414E040 521F4040 532ADACD 027D6FA0 0414E3D0
* Esi: 00000000:
* Eax: 532AC15C: 000042AC 00000000 00000000 77E55E02 00000000 7C821B34
* Ebx: 0000003F:
* Ecx: 532AC7CC: 00000000 00010007 00000000 0090008E 0016DFC4 532AC18C
* Edx: 0000003D:
* Eip: 77E55E02: 10C2C95E 90909000 A1649090 00000018 C334408B 891C428B
* Ebp: 532AC1AC: 532AC1F0 02187744 000042AC 00000000 00000000 00000000
* SegCs: 0031001B: 09022800 28000800 08000A02 08022000 20000000 00000902
* EFlags: 00000246:
* Esp: 532AC158: 713695C0 000042AC 00000000 00000000 77E55E02 00000000
* SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
77E55E02 Module(kernel32+00015E02)
02187744 Module(sqlservr+01187744)
0218B600 Module(sqlservr+0118B600)
0202CCDA Module(sqlservr+0102CCDA)
01590ED5 Module(sqlservr+00590ED5)
021C7486 Module(sqlservr+011C7486)
0165C09E Module(sqlservr+0065C09E)
01468A13 Module(sqlservr+00468A13)
014688D5 Module(sqlservr+004688D5)
01023E34 Module(sqlservr+00023E34)
01C2935A Module(sqlservr+00C2935A)
0121B069 Module(sqlservr+0021B069)
010251BC Module(sqlservr+000251BC)
01025741 Module(sqlservr+00025741)
01023E34 Module(sqlservr+00023E34)
01041DD5 Module(sqlservr+00041DD5)
0103DFD4 Module(sqlservr+0003DFD4)
01006A96 Module(sqlservr+00006A96)
01006BBC Module(sqlservr+00006BBC)
01006DAB Module(sqlservr+00006DAB)
01447562 Module(sqlservr+00447562)
0144859B Module(sqlservr+0044859B)
0144789A Module(sqlservr+0044789A)
01447720 Module(sqlservr+00447720)
781329AA Module(MSVCR80+000029AA)
78132A36 Module(MSVCR80+00002A36)
PSS @0x713695C0
---------------
CSession @0x71368278
--------------------
m_spid = 63 m_cRef = 12 m_rgcRefType[0] = 1
m_rgcRefType[1] = 1 m_rgcRefType[2] = 9 m_rgcRefType[3] = 1
m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x71368040
m_pstackBhfPool = 0x00000000 m_dwLoginFlags = 0x03e0 m_fBackground = 0
m_fClientRequestConnReset = 0 m_fUserProc = -1 m_fConnReset = 0
m_fIsConnReset = 0 m_fInLogin = 0 m_fReplRelease = 0
m_fKill = 0 m_ulLoginStamp = 34123 m_eclClient = 5
m_protType = 5 m_hHttpToken = FFFFFFFF
m_pV7LoginRec
---------------------
00000000: 22010000 02000972 401f0000 00000006 c00e0000 € "......r@...........
00000014: 00000000 e0030000 00000000 00000000 5e000300 € ................^...
00000028: 64000900 76000000 94001c00 cc000b00 e2000000 € d...v...............
0000003C: e2001c00 1a010000 1a010400 57a89cec 1de02201 € ............W.....".
00000050: 00002201 00002201 00000000 0000€ € € € € € € € € € € € € € € .."...".......
CPhysicalConnection @0x71368188
-------------------------------
m_pPhyConn->m_pmo = 0x71368040 m_pPhyConn->m_pNetConn = 0x71368788 m_pPhyConn->m_pConnList = 0x71368260
m_pPhyConn->m_pSess = 0x71368278 m_pPhyConn->m_fTracked = -1 m_pPhyConn->m_cbPacketsize = 8000
m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0
CBatch @0x71368A90
------------------
m_pSess = 0x71368278 m_pConn = 0x713689F0 m_cRef = 3
m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1
m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x00D947A8
EXCEPT (null) @0x532ABA6C
-------------------------
exc_number = 0 exc_severity = 0 exc_func = 0x023F4C60
Task @0x00D947A8
----------------
CPU Ticks used (ms) = 4 Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x00000000 WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x00000000 SchedulerId = 0x3
ThreadId = 0x146c m_state = 0 m_eAbortSev = 0
EC @0x713695C8
--------------
spid = 63 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x40 ec_atomic = 0x4 __fSubProc = 1
ec_dbccContext = 0x00000000 __pSETLS = 0x71368A30 __pSEParams = 0x71368CD0
__pDbLocks = 0x713698B0
SEInternalTLS @0x71368A30
-------------------------
m_flags = 0 m_TLSstatus = 3 m_owningTask = 0x00D947A8
m_activeHeapDatasetList = 0x71368A30 m_activeIndexDatasetList = 0x71368A38
SEParams @0x71368CD0
--------------------
m_lockTimeout = -1 m_isoLevel = 4096 m_logDontReplicate = 0
m_neverReplicate = 0 m_XactWorkspace = 0x062ACC58 m_pSessionLocks = 0x71369AC0
m_pDbLocks = 0x713698B0 m_execStats = 0x0414C8B8 m_pAllocFileLimit = 0x00000000
View 7 Replies
View Related
May 1, 2007
I got an Assertion failed error while resizing a vector in a plug-in algorithm.
In order to isolate the problem I created a simple model class in Navigator.h file as shown below:
//========================= begin code =======================
class CStateStats
{
public:
DOUBLE m_dblSum;
DOUBLE m_dblSqrSum;
public:
CStateStats()
{
m_dblSum = 0.0;
m_dblSqrSum = 0.0;
}
};
class CAttStats : public DMHALLOC
{
public:
dmh_vector<CStateStats> vstatestats;
public:
CAttStats() : vstatestats (*this)
{
}
};
//========================= end code =======================
The access to DMHALLOC is provided in that class and in Navigator class as shown below:
//========================= begin code =======================
class ATL_NO_VTABLE NAVIGATOR :
public DMHALLOC,
public CComObjectRootEx<CComMultiThreadModel>,
public CComCoClass<NAVIGATOR, &CLSID_NAVIGATOR>,
public ISupportErrorInfo,
public IDMAlgorithmNavigation
{
public:
NAVIGATOR() : _viAttributeOutput(*this), _vCAttStats(*this)
//========================= end code =======================
I succeded making room for _vCAttStats vector, but when I tried providing room for the vectors of the vector I got an Assertion failed error (file dmhallocator.h Line:56 Expression assert(_dmhalloc._spidmmemoryallocator != NULL)). Please, see the code below, included in NAVIGATOR::GetNodeArrayProperty function:
//========================= begin code =======================
_vCAttStats.resize (2); // <<<<< succeeded here!
// make space for the states
_vCAttStats[0].vstatestats.resize(ulStates); // <<<<<<< assertion failed here!
//========================= end code =======================
I tried using a vector-of-vector approach and I also succeeded.
But I have to use that kind of structure: a vector of class with a vector inside.
I think I must provide a similar approach of vector-of-vector existing in DmhVector.h but I don't know how to do it.
I would apreciate any help.
View 3 Replies
View Related
Apr 25, 2008
Hi All,
I am trying to restore sql 2000 database backup on sql 2005. I get below error.
SQL Server Assertion: File: <mdupgrad.cpp>, line = 3342 Failed Assertion = 'f' No object for Index!. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or
Error: 928, Severity: 20, State: 1.
During upgrade, database raised exception 3624, severity 20, state 1, address 000000000247E5A1. Use the exception number to determine the cause
Error: 3624, Severity: 20, State: 1.
I feel this could be due to upgrade from sql 2000 to sql 2005.
I could restore other 2000 databases successfully to 2005. However only this particular database is throwing this error.
Can anyone advise on this please.
Thanks in Advance
Kiran
View 13 Replies
View Related
Jul 20, 2005
Hey all -We are running SQL 2000 with ALL available service packs, etc.applied. We just built a brand new database server, which has dual2Ghz XEONs, 2GB memory, and the following disk configuration:RAID 1 array (2 disks) Operating System Windows Server 2003RAID 1 array (2 disks) Database LogsRAID 10 array (4 disks) Database DataDisks are SATA, with a 3Ware hardware RAID controller. The machineSCREAMS.We run 5 databases on this machine. 2 of these are fairly large (byour standards, anyway). The second largest database (and the busiestand most important) is consistently generating consistency errors thatbring many important queries down. These are almost ALWAYS in theform of index corruption on one single table. The corruption does notnormally occur on other tables, although it DOES happen once in awhile - rarely - on one of the other tables), nor does it EVER occuron any other databases on the server.The corruption seems to happen right in the neighborhood of midnightALMOST every day, give or take a few minutes, but does not seemdirectly associated with any of our MANY scheduled database cleanuptasks (believe me, we've tried desperately to find an associationusing SQL profiler). At midnight, our database traffic is fairly low,so it does not seem associated with a high traffic level.We are using the FULL recovery model, with log backups every 15minutes, and full backups daily at 12:15am. However, the corruptionhappens consistently BEFORE 12:15, like between 11:50pm and 12:10am.The most frustrating thing is, the database can go WEEKS without anycorruption at all, and then it'll go 4 or 5 days in a row with thisstrange corruption stuff.************************************************** ***********************Typical query errors when the corruption exists include:************************************************** ***********************SQL Server Assertion: File:<p:sqltdbmsstorengdrsinclude
ecord.inl>, line=1447Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.SQL Server Assertion: File: <recbase.cpp>, line=1378Failed Assertion = 'm_offBeginVar < m_SizeRec'.Server: Msg 3624, Level 20, State 1, Line 7Location: recbase.cpp:1374Expression: m_nVars > 0Connection Broken************************************************** ***********************Most of the responses to this type of issue (failed assertions) on thenewgroups appear to point to hardware failures. However, this isbrand new hardware, AND, it seems to us that if this was a hardwareissue, other databases, tables, and indexes would be affectedrandomly. Isn't that a valid assumption (that if it was hardware,particularly the RAID controller, the corruption would not be in sucha predictable place)? What if we moved the physical database files toanother location on the disk? Would/could that help?If anyone could offer some suggestions as to what may be causing thiscorruption, we would be eternally grateful. It is getting to be areal pain in the A*** to run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSSevery day or two (it always seems to solve the problem without dataloss, but still...).Again, thanks in advance for your response.Sincerely,Morgan LeppinkJoin Bytes!
View 4 Replies
View Related
Oct 12, 2007
Hi all
I am facing this prob with SSRS.
please sugges any solution.
Problem:
I have a few reports deployed on the report server.
When I click them I get the following error
An internal error occurred on the report server. See the error log for more details. (rsInternalError)
Checking the log file has the following entries
w3wp!processing!1!10/12/2007-17:02:12:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderReportAction.Render(String format, String deviceInfo)
Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
Microsoft.ReportingServices.WebServer.ReportExecutionService.InternalRender(String Format, String DeviceInfo, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format, String deviceInfo, String& extension, String& mimeType, String& encoding, String[]& streams, Warning[]& warnings)
Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& extension)
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension)
Microsoft.Reporting.WebForms.ReportControlSource.RenderReportHTML4(String deviceInfo)
Microsoft.Reporting.WebForms.ReportControl.RenderReport(ReportControlSource controlSource, String instanceIdentifier, String navigationID, ZoomMode zoomMode, Int32 zoomPercent, Int32 pageNumber, String prefix, String searchText, String linkTarget, String replacementRoot, String alertMessage, Int32 searchStartPage, Boolean sizeToContent)
Microsoft.Reporting.WebForms.ReportAreaPage.OnPreRender(EventArgs e)
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
System.Web.UI.Page.ProcessRequest()
System.Web.UI.Page.ProcessRequest(HttpContext context)
System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage)
System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm)
System.Web.HttpServerUtility.Transfer(IHttpHandler handler, Boolean preserveForm)
Microsoft.Reporting.WebForms.ReportAreaPageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!1!10/12/2007-17:02:12:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
w3wp!library!1!10/12/2007-17:02:15:: i INFO: Exception dumped to: C:apps_srvSQL 2005 Analysis ServicesMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
The reportserver also generates SQLDumper log file and a crash dump file
The report executes fine sometime and sometime gives the error mentioned above.
The reportserver at some point in time stopped doing anything.
I tried to delete those reports created I couldn€™t delete one report.
When I try to delete it takes a long time and says request timeout error.
Then I opened the web.config file of reportserver and report manager and just saved it so that the application reloads. And then it worked fine for few moments. I was also able to delete that report which was not getting deleted before. But after some time I again get the assertion failed error.
I have the same reports deployed in another server where they are working fine.
The database is SQL Server 2005 with SP2
How do it solve this problem
View 18 Replies
View Related
May 16, 2007
Hello,
To quote my honorable colleague who posted some time ago in this forum "If i'd had any hair left, I'd pull it all out".
I am trying to run package from an external .NET app. The package is stored in the SQL server MSDB with protection level to 'Rely on sql server'
The package uses an environment variable for the configuration dtsconfig file.
I use manageddts to load the package from the sql server
LoadFromSqlServer
When I launch my app from the visual studio environment (in debug mode) I get this error message window:
Assertion Failed
at STrace.ReadTraceValues()
at STrace..cctor()
at ...
at ManagedHelper.GetNextManagedInfo(DTs_M...
This message window comes several times, one after the other. I have to click ignore to continue.
When i run this program from the command line , it runs without this message.
I've already put my package load in a separate function with debuggerstepthroug, but to no avail.
<System.Diagnostics.DebuggerStepThrough()> _
Private Function LoadPkg(ByRef app As Application, ByVal PackageName As String) As Package
Return app.LoadFromSqlServer(PackageName, m_SSISServername _
, "myname", "mypassw", Nothing)
End Function
Is there anything that can be done to avoid these warnings?
View 3 Replies
View Related
Sep 21, 2007
I have SSIS packages created to import .xls files into sql tables. I now have vb.net code within which I am trying to execute individual packages whenever my code notices the .xls files being deposited within a network folder. When I try to run my code I get the error message:
Assertion Failed:Abort=Quit, Retry=Debug, Ignore=Continue
at STrace.ReadTraceValues()
at STrace..cctor()
at STrace.Trace(String strComponentName, String strLine)
at ManagedHelper.GetNextManagedInfo(DTS_Managed_INFO&nextManagedInfo)
here is my code:
Sub RunPackage(ByVal pkgCMD As String)
'
Dim app As New Application
Dim pkg As New Package
Dim pkgResults As DTSExecResult
'Dim pkgevents As IDTSEvents
'
pkg = app.LoadPackage(pkgCMD, Nothing)
pkgResults = pkg.Execute()
The error occurs during the pkg=app.LoadPackage(pkgCMD, Nothing) statement. Any idea of how I determine why the SSIS package will not load thru my vb app? It runs fine if I load the SSIS package in SSBIDS.
Thanks for any help or guidance.
View 6 Replies
View Related
Apr 25, 2000
Hi there,
One of my databases is getting the Following error
Error 1203
Caller of lock manager is incorrectly trying to unlock an unlocked object. spid=%d locktype=%d dbid=%d lockid=%Id.
I ran DBCC statements after I got the server up and running and it didn't come up with any errors. Everything ran ok until the following week when the same problem happened again. Originally we had problems with this server and we disabled write-caching,
Does anyone have any idea what could be causing the problem and how to fix it,
Thanks in advance,
Fin
View 1 Replies
View Related
Aug 8, 2006
I am running a script on a schedule and I get this error quite often:
Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (Error 0) Process ID ## attempted to unlock a resource it does not own: OBJECT: ## . Retry the transaction, because this error may be caused by a timing condition. If the problem persists, contact the database administrator. [SQLSTATE HY000] (Error 1203)
If I keep rerunning the transaction, it will eventually succeed. I am running SQL Server 2005 with SP1 installed. Does anyone know what this means and what would cause it to fail sometimes and succeed other times?
Thanks
View 6 Replies
View Related
Jul 23, 2005
I have a case where a table has two candidate primary keys,but either (but not both) may be NULL. I don't want to storea copy of the concatenated ISNULL'ed fields as an additionalcolumn, though that would work if necessary. Instead, I triedthe following (this is a related simplified example, not myreal one):CREATE FUNCTION ApplyActionPK(@IP int = NULL,@DNS varchar(64) = NULL)RETURNS varchar(74) -- NOT NULLASBEGINdeclare @val varchar(74)set @val = str(ISNULL(@IP, 0), 10)set @val = @val + ISNULL(@DNS, '')return @val-- Also tried "return str(ISNULL(@IP, 0), 10)+ISNULL(@DNS, '')"-- Also tried "return ISNULL(STR(@IP, 10), ISNULL(@DNS, ''))"-- ... and other things...ENDGOcreate table ApplyAction(-- An action applies to a computerAct varchar(16) NOT NULL,-- The action to applyIP int NULL,-- The computer IP address, orDNS varchar(64) NULL,-- The DNS name of the computerTarget as dbo.ApplyActionPK(ComputerID, DNS), -- PK value-- Also tried "Target as ISNULL(STR(@IP, 10), ISNULL(@DNS, ''))"CONSTRAINT PK_ApplyAction PRIMARY KEY(Act, Target))SQL Server always complains that the primary key constraint cannot becreated over a nullable field - even though in no case will the 'Target'field be NULL.Please don't explain that I should store an IP address as a string.Though that would suffice for this example, it doesn't solve myactual problem (where there are four nullable fields, two of whichare FKs into other tables).What's the reason for SQL Server deciding that the value is NULLable?What's the usual way of handling such alternate PKs?Clifford Heath.
View 7 Replies
View Related
Jul 13, 2006
Our SQL Server 200 box is getting perflib errors when we get a decentamount of people using an application that I wrote, call queue system,web based. To accomplish a queue type system on a button push I wrotea query like this...BEGIN TRANSACTION;Select top 1...fields here...FROM table with (xlock,readpast)(2 joins)WHERE numerous where clausesORDER BY 2 order bys.Now our sql server starts timing out..then in the app log this showsup....Error: 1203, Severity: 20, State: 1Process ID 62 attempting to unlock unowned resource PAG: 6:1:126407.For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.The reason I am doing xlock is to make a record not viewable to 2people if they click the button on the web form that runs the abovequery within the same minute, they would get different records....So to avoid this error which I assume is due to my xlock should Irethink my query?
View 3 Replies
View Related
Apr 12, 2004
hi,
i'm trying to update a table wich have a trigger on it,when i run the update, this fire the trigger that saves in other table the values of the modified fields and the type of operation that the user did.
this other table is for auditing the changes of the date.
when i try to run the update sql gives me this error :
Process 67 unlocking unowned resource: TAB: 10:334884510
i dont know what it means..can anybody help me to find how to correct this?
thanks
View 3 Replies
View Related
Aug 21, 2002
We have a customized package which uses 2 middle layers before it hits the database.
yesterday the sqlserver rebooted all of sudden and I got this error
Process ID 96 attempting to unlock unowned resource KEY: 7:167671645:4 (8d021bb2cdf2)..
Error: 1203, Severity: 20, State: 1
Error 1203
Severity Level 20
Message Text
Process ID %d attempting to unlock unowned resource %.*ls.
Explanation
This error occurs when Microsoft® SQL Server™ is engaged in some activity other than normal post-processing
cleanup and it finds that a particular page it is attempting to unlock is already unlocked. The
underlying cause for this error may be related to structural problems within the affected database. SQL Server manages
the acquisition and release of pages to maintain concurrency control in the multi-user environment. This mechanism is maintained
through the use of various internal lock structures that identify the page and the type of lock present. Locks are acquired
for processing of affected pages and released when the processing is completed.
Action
Execute DBCC CHECKDB against the database in which the object belongs. If DBCC CHECKDB reports no errors, attempt to reestablish the connection and execute the command.
Important If executing DBCC CHECKDB with one of the repair clauses does not correct the index problem, or if you are unsure what effect DBCC CHECKDB with a repair clause has on your data, contact your primary support provider
Can anyone help with this.DBCC checkdb returned without errors.
View 1 Replies
View Related
Jan 16, 2005
Hello everyone. I'm very new to asp.net. I've been coding in vb.net for a while now (getting my associates degree in desktop application programming) and my boss wants all of my new applications to be web based now. Well, i decided to take some initiative on this and begin a new project for my department. This is a very small project. So far, everything is coming along alright (i found an eBook that's helped me quite a bit). Everything was cool until yesterday when i tried to connect to our sql server database. I get an error message stating:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Because i'm testing this on my system as well as the remote system which hosts the application, i can see the error message on the remote system. Here is the error it's giving me:
Server Error in '/' Application.
--------------------------------------------------------------------------------
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Source Error:
Line 57: sConnString = "Server=F11602A2120564OPS;Initial Catalog=OpsMonitor;User ID='public';Password=;Integrated Security=SSPI;"'Connection String
Line 58: sConn = New SqlConnection(sConnString)'Initialize New Connection
Line 59: sConn.Open'Open the connection
Line 60: End Sub
Line 61: </script>
Source File: c:inetpubwwwrootatm_reporting.aspx Line: 59
Stack Trace:
[SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +383
ASP.atm_reporting_aspx.OpenConn() in c:inetpubwwwrootatm_reporting.aspx:59
ASP.atm_reporting_aspx.Page_Load(Object Src, EventArgs E) in c:inetpubwwwrootatm_reporting.aspx:23
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
You can see my SQL Connection string in there as well. Can someone please help me with this? I can post the code to the entire page as well if that would help. I'm developing this with Dreamweaver MX 2004 (i like dreamweaver MUCH better than visual studio, especially for web design/development). Thanks,
Eric
View 1 Replies
View Related
Feb 6, 2006
I'm working on an ASP.NET project, and we're attempting to switch from SQL Server authentication to Windows authentication to connect to the database.
It works fine locally when I debug in Visual Studio, but when it hits the web server, I get the error: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
IIS has anonymous access disabled, and Integrated Windows Authentication is checked. The web.config file has:
<authentication mode="Windows"/><identity impersonate="true"/>
The database I'm attempting to access is on a different machine than IIS, and the connection string doesn't contain a username or password, and has "Trusted_Connection=Yes", and "Integrated Security=SSPI".
From what I've been able to find online, I'm guessing the problem is due to IIS and SQL Server residing on different machines, but I'm not sure how to fix it.
Any ideas?
View 3 Replies
View Related
Feb 5, 2007
We have a browser based application that is doing some updates on the database. This app was earlier built to run on SQL server 2000 and we are in the process of migrating to SQL server 2005. Until now the application was seamlessly working on the new SQL server 2005 database. I got the following error message on the web when an item was clicked on the web that triggered a set of database updated through our app server. This is first time i am seeing anything like this.
---------------------------
Windows Internet Explorer
---------------------------
Unable to delete the selected items. Warning: Fatal error 3624 occurred at Feb 5 2007 2:34PM. Note the error and time, and contact your system administrator.
A severe error occurred on the current command. The results, if any, should be discarded.
Location: IndexRowScanner.cpp:370
Expression: m_sizeOfBuffer > currentOffset + colLen
SPID: 54
Process ID: 2712
---------------------------
OK
---------------------------
In the beginnning we thought it may be some thing in the app server or the CLR. But when I checked the process ID in the task manager it turned out to be SQL server 2005 process. the SPID was the application servers connection to the database.
This is what I got when i ran the profiler.
SQL Server Assertion: File: <IndexRowScanner.cpp>, line=370 Failed Assertion = 'm_sizeOfBuffer > currentOffset + colLen'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check
the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
Warning: Fatal error 3624 occurred at Feb 5 2007 3:00PM. Note the error and time, and contact your system administrator.
2007-02-05 15:00:23.04 spid54 Error: 3624, Severity: 20, State: 1.
2007-02-05 15:00:23.04 spid54 A system assertion check has failed. Check the SQL Server error log for details
Any clues on what this is all about????
Thanks..
View 7 Replies
View Related
Nov 23, 2005
Hi,
I keep getting this error
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 112, PSS = 0x49b051f0, EC = 0x49b05520
*Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0576.txt
Stack Signature for the dump is 0x16F06946
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
Error: 3624, Severity: 20, State: 1.
DBCC gives me consistency errors with index id 0.
Restarting the sql server services and the error disappears but then reappears after 2-3 days.
All help is appreciated....
View 5 Replies
View Related
Nov 23, 2005
ask192 writes "Hi,
I keep getting this error
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 112, PSS = 0x49b051f0, EC = 0x49b05520
*Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0576.txt
Stack Signature for the dump is 0x16F06946
SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.
Error: 3624, Severity: 20, State: 1.
DBCC gives me consistency errors with index id 0.
Restarting the sql server services and the error disappears but then reappears after 2-3 days.
All help is appreciated...."
View 2 Replies
View Related
Mar 21, 2007
Hello,
Since we started using another sales program (1C Enterprise), SQL Server started "crashing" (connection between our program and SQL Server breaks)
with this assertion error:
Event ID: 17066
SQL Server Assertion: File: <"xrange.cpp">, line=399 Failed Assertion = '0 == pxteRangeHrow->m_pxteFetch'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.
After this error DBCC CHECKDB doesn't find any priblems.
I can't find what exactly causes it, sometimes we get it only once a week, but today I got it four times in a row.
We had the same error on all versions of SQL Server 2005, SQL Server SP1, SQL Server SP1+Hot fixes, etc.
select @@version
Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)
View 11 Replies
View Related
Aug 11, 2005
can any one help
View 3 Replies
View Related
Jun 15, 2007
I'm getting this, after upgrading from 2000 to 2005.Replication-Replication Distribution Subsystem: agent (null) failed.The subscription to publication '(null)' has expired or does notexist.The only suggestions I've seen are to dump all subscriptions. Sincewe have several dozen publications to several servers, is there adecent way to script it all out, if that's the only suggestion?Thanks in advance.
View 3 Replies
View Related
May 14, 2008
Hi all
This Job ran yester day fine,to day It got failed with this error
any suggestion to troubleshoot problem is appreciated.
DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147203052 (80044814)
Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Error source: Microsoft SQL-DMO (ODBC SQLState: 28000)
Help file: SQLDMO80.hlp
Help context: 1131
Error Detail Records:
Error: 0 (0); Provider Error: 0 (0)
Error string: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Error source: Microsoft SQL-DMO (ODBC SQLState: 28000)
Help file: SQLDMO80.hlp
Help context: 1131
DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1
DTSRun: Package execution complete.
View 3 Replies
View Related
Aug 1, 2007
I have an issue dealing with connectivity between the client and Sql Server Services or Sql Authentication. I keep receiving this type of error message:Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I am sure my connection string is correct within my web config file, I have something like this:Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
The reason why I think the connection string is correct is because I have a server where my asp.net application is stored and used, this server is called server1. Server1 is connected to MS-SQL server that is installed and used on server2. When I run my application from server1 everything is perfect, nothing goes wrong, but when I run the application from my client or local machine I get the error message saying not associated with a trusted site.
Now I have the web config set to <identity impersonate="true"> that will allow windows Authentication, and I set the permissions within the database to use NT AUTHORITY NETWORK SERVICE as a user, plus my own network credentials are set within user on the database, just so I could troubleshoot the problem. But I still get the error message not associated with a trusted site.
Just to recap my problem, I can see the data when I run the application in Server1, but I can't see the data when I run the application from my local machine. http://server1/MyApplication.aspx <-- this is an example of the url that I enter on my local machine to acces the application. Plus I have full acces to server1, and other application are running just fine from this server.
I am using visual studio 2005, but using sql 2000, with the latest service pack for windows XP pro.
thanks,
xyz789
View 4 Replies
View Related
Jan 5, 2004
I am creating a Data Web Form using the Data Form Wizard.
After configuring a valid connection to a SQL Server on my network, I receive the following error when trying to run the page: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
Any ideas?
Thanks,
Mark
View 9 Replies
View Related
Mar 31, 2006
Any users out there resolve this one. Thanks in advance!Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection. Description:
An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and
where it originated in the code. Exception Details:
System.Data.OleDb.OleDbException: Login failed for user '(null)'. Reason:
Not associated with a trusted SQL Server connection.Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[OleDbException (0x80004005): Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.] System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +1054593 System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +53 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.OleDb.OleDbConnection.Open() +37 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +41 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360
View 1 Replies
View Related
May 17, 1999
SQL7 server is configured to use both SQL and NT authentication. Periodically, NT authenticated users get the error "Login failed for user '(null'. Reason: Not associated with a trusted SQL Server connection."
Repeating the login will eventually end in success.
Microsoft article Q216848 indicates this has something to do with the version of MDAC.
We have not changed the version of MDAC on the server, but checked it and the versions are as the article states (MDAC 2.1 & SQL Driver 3.70.623).
We had a newer version on the client, but went back to the version above that came on the SQL7 CD with no luck.
Any ideas, suggestions, or similar problem experienced?
Thanks in advance.
View 1 Replies
View Related
Sep 8, 2003
When I try to open up a table in EM I get the msg of ...Login failed for user (null)...which is me
it looks like my sid has become null...Im the system admin...do I use the procedure 'sp_change_users_login'
I tried reading up on this procedure, but BOL was not very clear.
How would I go about getting my sid back ?
thanks
View 3 Replies
View Related
Apr 20, 2006
Need help for this error ---- [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
while accessing vb6 datareport through citrix client which is accessing sql2000 I got the above error msg.
vb6 datareport use the oledb provider for odbc driver with dsn for connection.It is working fine if run it locally and problem occured only through citrix client.
Thanks in advance for help.
View 6 Replies
View Related
Dec 21, 2006
I'm new to Crystal Reports and ASP and I'm sure i'm missing something simple here.
I've got a SQL server database, A Crystal Report, a VB application and an ASP Application
In the VB app i call the crystal report and log on to the database with the intergrated security
However in the ASP app i try the same and it has me log on as a null user.
what have i forgotten to do that will let the intergrated security work between SQL Server and ASP
View 2 Replies
View Related
Mar 6, 2007
I recieved this error in my logs:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
It appeared nearly 20 times, then about 30 minutes after the first occurence, I noticed in my Event Viewer this error:
The registration of DNS name XXX.XXX.XXX.XX.in-addr.arpa. for network name resource 'SQL Network Name(SQLServer)' failed for the following reason:
DNS operation refused.
After that I began recieving hundreds of errors like this one:
Login failed for user 'SQL user'. Only administrators may connect at this time.
I was unable to connect to the server to see what was going on so I had to failover the server. That's why my troubleshooting is limited to error logs. After the failover, everything came up fine with no more errors. Has anyone ever encountered this before?
BTW, This is a SQL 2000 Cluster on Windows 2000.
View 1 Replies
View Related
Aug 26, 2005
Hello,I have problem with linked servers (MS SQL Server 2k)- when I try to executequery(update, insert..) with linked servers, I have message Login failed foruser 'null'. This is very strange problem, some computers in AD (2k3 std)don't have this error, when the other have this problem for few hours andsome have this error all the time. Network Protocols is TCP/IP.Any idea ?
View 1 Replies
View Related
Jan 17, 2007
Hi,
I am using a Third Party software which depends on my SQL Server 2000 for storing data. When I use Windows Security in my Third Party software, I get the following message in the event viewer of my SQL Server 2000.
Description:
18452:
Login failed for user '(null)'. Reason: Not associated with trusted SQL Server connection.
When I user SA, I do not get the above error.
Any clarifications on the possibilites for getting the error is appreciated.
Also let me know if we can overcome the error without using SA.
I tried the article in http://support.microsoft.com/kb/840219. But it didn't make a difference.
View 5 Replies
View Related
