Hi,
I've just installed SQL Server 2005 into Win SBS 2003 R2, everything went
fine and other instances (SHAREPOINT & SBSMONITORING) are working as well.
The only thing and the most important that should be working but not, is
application that uses SQL Server as it's main database. Before this, the
application used SQL Server 2000 and working fine.
Everytime users launch the application, there's this error message: "Error
in DataAccessLayer.DataAccess.CheckUserLogin. Login failed for user 'sa'."
Although I've allowed Windows Authentication & SQL Server authentication in
SQL Server 2005 logins settings, that error message will still appears and
restrict any users to log-in to the application.
That application uses a "DataAccessLayer.config" file that has this
parameters:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="UseWebService" value="false"/>
<add key="DAL.DataService.DataService" value="http://companyweb"/>
<add key="DBCnnString" value="Persist Security Info=False;User
ID=sa;Password=;Initial Catalog=INVENTORY;Data Source=192.168.16.2"/>
<add key="server" value="ServerName"/>
<add key="database" value="INVENTORY"/>
<add key="uid" value="sa"/>
<add key="password" value=""/>
</appSettings>
</configuration>
What happened? Have anyone encountered the same symtomps/problem and know
how to work around it?
Please be noted, I attach this "INVENTORY" database into
ServerName\Database; I do not use instances for it.
Thank you, all help is appreciated.
ON the Security tab, change to [SQL Server and Windows Authentication].
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Dhow" <Dhow@.discussions.microsoft.com> wrote in message
news:9114C9D0-F787-41A2-B2A1-9B84FA635F1B@.microsoft.com...
> Hi,
> I've just installed SQL Server 2005 into Win SBS 2003 R2, everything went
> fine and other instances (SHAREPOINT & SBSMONITORING) are working as well.
> The only thing and the most important that should be working but not, is
> application that uses SQL Server as it's main database. Before this, the
> application used SQL Server 2000 and working fine.
> Everytime users launch the application, there's this error message: "Error
> in DataAccessLayer.DataAccess.CheckUserLogin. Login failed for user
> 'sa'."
> Although I've allowed Windows Authentication & SQL Server authentication
> in
> SQL Server 2005 logins settings, that error message will still appears and
> restrict any users to log-in to the application.
> That application uses a "DataAccessLayer.config" file that has this
> parameters:
> <?xml version="1.0" encoding="utf-8"?>
> <configuration>
> <appSettings>
> <add key="UseWebService" value="false"/>
> <add key="DAL.DataService.DataService" value="http://companyweb"/>
> <add key="DBCnnString" value="Persist Security Info=False;User
> ID=sa;Password=;Initial Catalog=INVENTORY;Data Source=192.168.16.2"/>
> <add key="server" value="ServerName"/>
> <add key="database" value="INVENTORY"/>
> <add key="uid" value="sa"/>
> <add key="password" value=""/>
> </appSettings>
> </configuration>
> What happened? Have anyone encountered the same symtomps/problem and know
> how to work around it?
> Please be noted, I attach this "INVENTORY" database into
> ServerName\Database; I do not use instances for it.
> Thank you, all help is appreciated.
|||And did you really install SQL 2005 without a password for the [sa] account?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Dhow" <Dhow@.discussions.microsoft.com> wrote in message
news:9114C9D0-F787-41A2-B2A1-9B84FA635F1B@.microsoft.com...
> Hi,
> I've just installed SQL Server 2005 into Win SBS 2003 R2, everything went
> fine and other instances (SHAREPOINT & SBSMONITORING) are working as well.
> The only thing and the most important that should be working but not, is
> application that uses SQL Server as it's main database. Before this, the
> application used SQL Server 2000 and working fine.
> Everytime users launch the application, there's this error message: "Error
> in DataAccessLayer.DataAccess.CheckUserLogin. Login failed for user
> 'sa'."
> Although I've allowed Windows Authentication & SQL Server authentication
> in
> SQL Server 2005 logins settings, that error message will still appears and
> restrict any users to log-in to the application.
> That application uses a "DataAccessLayer.config" file that has this
> parameters:
> <?xml version="1.0" encoding="utf-8"?>
> <configuration>
> <appSettings>
> <add key="UseWebService" value="false"/>
> <add key="DAL.DataService.DataService" value="http://companyweb"/>
> <add key="DBCnnString" value="Persist Security Info=False;User
> ID=sa;Password=;Initial Catalog=INVENTORY;Data Source=192.168.16.2"/>
> <add key="server" value="ServerName"/>
> <add key="database" value="INVENTORY"/>
> <add key="uid" value="sa"/>
> <add key="password" value=""/>
> </appSettings>
> </configuration>
> What happened? Have anyone encountered the same symtomps/problem and know
> how to work around it?
> Please be noted, I attach this "INVENTORY" database into
> ServerName\Database; I do not use instances for it.
> Thank you, all help is appreciated.
|||Dhow wrote:
> Hi,
> I've just installed SQL Server 2005 into Win SBS 2003 R2, everything went
> fine and other instances (SHAREPOINT & SBSMONITORING) are working as well.
> The only thing and the most important that should be working but not, is
> application that uses SQL Server as it's main database. Before this, the
> application used SQL Server 2000 and working fine.
> Everytime users launch the application, there's this error message: "Error
> in DataAccessLayer.DataAccess.CheckUserLogin. Login failed for user 'sa'."
> Although I've allowed Windows Authentication & SQL Server authentication in
> SQL Server 2005 logins settings, that error message will still appears and
> restrict any users to log-in to the application.
> That application uses a "DataAccessLayer.config" file that has this
> parameters:
> <?xml version="1.0" encoding="utf-8"?>
> <configuration>
> <appSettings>
> <add key="UseWebService" value="false"/>
> <add key="DAL.DataService.DataService" value="http://companyweb"/>
> <add key="DBCnnString" value="Persist Security Info=False;User
> ID=sa;Password=;Initial Catalog=INVENTORY;Data Source=192.168.16.2"/>
> <add key="server" value="ServerName"/>
> <add key="database" value="INVENTORY"/>
> <add key="uid" value="sa"/>
> <add key="password" value=""/>
> </appSettings>
> </configuration>
> What happened? Have anyone encountered the same symtomps/problem and know
> how to work around it?
> Please be noted, I attach this "INVENTORY" database into
> ServerName\Database; I do not use instances for it.
> Thank you, all help is appreciated.
You are trying to connect to the server using the "sa" login, with no
password!!! You have two problems here:
1. Never, ever, purposely allow an application to connect as "sa", you
need to tightly control the use of this login.
2. If you purposely installed SQL Server with a blank password for
"sa", change it, now. Your server is wide open to anybody who chooses
to login as "sa".
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||Arnie,
When I installed the SQL Server 2005 for Default Database, I use Windows
Authentication and Local System.
Is there a way to know whether the [sa] has blank password or not?
Further notice: I tried to input [sa] password, and I use the same password
in "DataAccessLayer.config" under "Password=" value; but it still won't work.
The error message is still the same as before.
Any other suggestions perhaps?
Thanks!
"Arnie Rowland" wrote:
> And did you really install SQL 2005 without a password for the [sa] account?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "Dhow" <Dhow@.discussions.microsoft.com> wrote in message
> news:9114C9D0-F787-41A2-B2A1-9B84FA635F1B@.microsoft.com...
>
>
|||Arnie,
When I installed the SQL Server 2005 for Default Database, I use Windows
Authentication and Local System.
Is there a way to know whether the [sa] has blank password or not?
Further notice: I tried to input [sa] password, and I use the same password
in "DataAccessLayer.config" under "Password=" value; but it still won't work.
The error message is still the same as before.
Any other suggestions perhaps?
Thanks!
"Arnie Rowland" wrote:
> And did you really install SQL 2005 without a password for the [sa] account?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "Dhow" <Dhow@.discussions.microsoft.com> wrote in message
> news:9114C9D0-F787-41A2-B2A1-9B84FA635F1B@.microsoft.com...
>
>
|||Arnie,
When I installed the SQL Server 2005 for Default Database, I use Windows
Authentication and Local System.
Is there a way to know whether the [sa] has blank password or not?
Further notice: I tried to input [sa] password, and I use the same password
in "DataAccessLayer.config" under "Password=" value; but it still won't work.
The error message is still the same as before.
Any other suggestions perhaps?
Thanks!
"Arnie Rowland" wrote:
> And did you really install SQL 2005 without a password for the [sa] account?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "Dhow" <Dhow@.discussions.microsoft.com> wrote in message
> news:9114C9D0-F787-41A2-B2A1-9B84FA635F1B@.microsoft.com...
>
>
|||Arnie,
When I installed the SQL Server 2005 for Default Database, I use Windows
Authentication and Local System.
Is there a way to know whether the [sa] has blank password or not?
Further notice: I tried to input [sa] password, and I use the same password
in "DataAccessLayer.config" under "Password=" value; but it still won't work.
The error message is still the same as before.
Any other suggestions perhaps?
Thanks!
"Arnie Rowland" wrote:
> And did you really install SQL 2005 without a password for the [sa] account?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "Dhow" <Dhow@.discussions.microsoft.com> wrote in message
> news:9114C9D0-F787-41A2-B2A1-9B84FA635F1B@.microsoft.com...
>
>
|||Arnie,
When I installed the SQL Server 2005 for Default Database, I use Windows
Authentication and Local System.
Is there a way to know whether the [sa] has blank password or not?
Further notice: I tried to input [sa] password, and I use the same password
in "DataAccessLayer.config" under "Password=" value; but it still won't work.
The error message is still the same as before.
Any other suggestions perhaps?
Thanks!
"Arnie Rowland" wrote:
> And did you really install SQL 2005 without a password for the [sa] account?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "Dhow" <Dhow@.discussions.microsoft.com> wrote in message
> news:9114C9D0-F787-41A2-B2A1-9B84FA635F1B@.microsoft.com...
>
>
|||Tracy,
I know I input blank password for [sa] user, but that was only for a tryout.
Later on after everything works fine, I'll input new password into it.
When I installed the SQL Server 2005 for Default Database, I use Windows
Authentication and Local System.
Is there a way to know whether the [sa] has blank password or not?
Further notice: I tried to input [sa] password, and I use the same password
in "DataAccessLayer.config" under "Password=" value; but it still won't work.
The error message is still the same as before.
Any other usefull sugesstions?
Thanks!
"Tracy McKibben" wrote:
> Dhow wrote:
> You are trying to connect to the server using the "sa" login, with no
> password!!! You have two problems here:
> 1. Never, ever, purposely allow an application to connect as "sa", you
> need to tightly control the use of this login.
> 2. If you purposely installed SQL Server with a blank password for
> "sa", change it, now. Your server is wide open to anybody who chooses
> to login as "sa".
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>
Showing posts with label ive. Show all posts
Showing posts with label ive. Show all posts
Wednesday, March 21, 2012
Failed to configure server install error
I've been looking into this all day and haven't gotten anywhere. I'm using
InstallShield to install a .Net application, the application uses MSDE as
its database. I've added InstallShield's MSDE object to the install, works
fine sometimes but most of the time I get the following error message when
the MSDE is almost installed.
"Setup failed to configure the server. Refer to the server error logs and
setup errors for more information."
I've scoured the internet looking into this error and nothing seems to
correct this issue. I've remove all files, registry keys and anything
related to MSDE and I still get the same error. I've generated an install
log (attached in an email to follow as "MSDELog.log").
Thanks in advance,
Dave
ERRORLOG
2004-11-16 14:01:09.51 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2004-11-16 14:01:09.51 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-11-16 14:01:09.51 server All rights reserved.
2004-11-16 14:01:09.51 server Server Process ID is 4060.
2004-11-16 14:01:09.51 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$INSPPRO\LOG\ERRORLOG'.
2004-11-16 14:01:09.57 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-11-16 14:01:09.62 server SQL Server configured for thread mode
processing.
2004-11-16 14:01:09.62 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2004-11-16 14:01:09.63 spid3 Warning ******************
2004-11-16 14:01:09.63 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2004-11-16 14:01:09.68 spid3 Starting up database 'master'.
2004-11-16 14:01:10.13 server Using 'SSNETLIB.DLL' version '8.0.760'.
2004-11-16 14:01:10.13 spid5 Starting up database 'model'.
2004-11-16 14:01:10.20 server SQL server listening on 192.168.0.119:
1395.
2004-11-16 14:01:10.20 server SQL server listening on 127.0.0.1: 1395.
2004-11-16 14:01:10.20 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-11-16 14:01:10.20 server SQL Server is ready for client connections
2004-11-16 14:01:10.24 spid3 Server name is 'CHRISTABLET\INSPPRO'.
2004-11-16 14:01:10.24 spid3 Skipping startup of clean database id 5
2004-11-16 14:01:10.24 spid3 Skipping startup of clean database id 6
2004-11-16 14:01:10.24 spid3 Starting up database 'msdb'.
2004-11-16 14:01:10.84 spid5 Clearing tempdb database.
2004-11-16 14:01:11.78 spid5 Starting up database 'tempdb'.
2004-11-16 14:01:12.18 spid3 Recovery complete.
2004-11-16 14:01:12.18 spid3 SQL global counter collection task is
created.
2004-11-16 14:01:12.25 spid3 Warning: override, autoexec procedures
skipped.
2004-11-16 14:03:15.07 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
cnfgsvr.out
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
An error occurred while attempting to start the service (1460)
SQL Server configuration failed.
################################################## #############################
Hi ,
net helpmsg 1460: This operation returned because the timeout period
expired.
This may occur due the following reasons:
1) You are using terminal services /RDP to install msde which opens a
different session and is NOT the same as being on the console.
Try to logon on locally to the machine and then run the installation with
the following command line
setup /L*v c:\msde.log disablerollback=1 disablenetworkprotocols=0
sapwd="some password"
Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.
|||This is absolutely the solution.
I just solved the SAME problem described in the first message in this
way.
To Microsoft: please WRITE somewhere that you CAN NOT install SQL or
MSDE on Windows XP from Remote Desktop!!
Marco
> 1) You are using terminal services /RDP to install msde which opens a
> different session and is NOT the same as being on the console.
> Try to logon on locally to the machine and then run the installation with
> the following command line
> setup /L*v c:\msde.log disablerollback=1 disablenetworkprotocols=0
> sapwd="some password"
> Girish Sundaram
> This posting is provided "AS IS" with no warranties, and confers no rights.
InstallShield to install a .Net application, the application uses MSDE as
its database. I've added InstallShield's MSDE object to the install, works
fine sometimes but most of the time I get the following error message when
the MSDE is almost installed.
"Setup failed to configure the server. Refer to the server error logs and
setup errors for more information."
I've scoured the internet looking into this error and nothing seems to
correct this issue. I've remove all files, registry keys and anything
related to MSDE and I still get the same error. I've generated an install
log (attached in an email to follow as "MSDELog.log").
Thanks in advance,
Dave
ERRORLOG
2004-11-16 14:01:09.51 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)
2004-11-16 14:01:09.51 server Copyright (C) 1988-2002 Microsoft
Corporation.
2004-11-16 14:01:09.51 server All rights reserved.
2004-11-16 14:01:09.51 server Server Process ID is 4060.
2004-11-16 14:01:09.51 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$INSPPRO\LOG\ERRORLOG'.
2004-11-16 14:01:09.57 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2004-11-16 14:01:09.62 server SQL Server configured for thread mode
processing.
2004-11-16 14:01:09.62 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2004-11-16 14:01:09.63 spid3 Warning ******************
2004-11-16 14:01:09.63 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2004-11-16 14:01:09.68 spid3 Starting up database 'master'.
2004-11-16 14:01:10.13 server Using 'SSNETLIB.DLL' version '8.0.760'.
2004-11-16 14:01:10.13 spid5 Starting up database 'model'.
2004-11-16 14:01:10.20 server SQL server listening on 192.168.0.119:
1395.
2004-11-16 14:01:10.20 server SQL server listening on 127.0.0.1: 1395.
2004-11-16 14:01:10.20 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2004-11-16 14:01:10.20 server SQL Server is ready for client connections
2004-11-16 14:01:10.24 spid3 Server name is 'CHRISTABLET\INSPPRO'.
2004-11-16 14:01:10.24 spid3 Skipping startup of clean database id 5
2004-11-16 14:01:10.24 spid3 Skipping startup of clean database id 6
2004-11-16 14:01:10.24 spid3 Starting up database 'msdb'.
2004-11-16 14:01:10.84 spid5 Clearing tempdb database.
2004-11-16 14:01:11.78 spid5 Starting up database 'tempdb'.
2004-11-16 14:01:12.18 spid3 Recovery complete.
2004-11-16 14:01:12.18 spid3 SQL global counter collection task is
created.
2004-11-16 14:01:12.25 spid3 Warning: override, autoexec procedures
skipped.
2004-11-16 14:03:15.07 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
cnfgsvr.out
################################################## #############################
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
An error occurred while attempting to start the service (1460)
SQL Server configuration failed.
################################################## #############################
Hi ,
net helpmsg 1460: This operation returned because the timeout period
expired.
This may occur due the following reasons:
1) You are using terminal services /RDP to install msde which opens a
different session and is NOT the same as being on the console.
Try to logon on locally to the machine and then run the installation with
the following command line
setup /L*v c:\msde.log disablerollback=1 disablenetworkprotocols=0
sapwd="some password"
Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.
|||This is absolutely the solution.
I just solved the SAME problem described in the first message in this
way.
To Microsoft: please WRITE somewhere that you CAN NOT install SQL or
MSDE on Windows XP from Remote Desktop!!
Marco
> 1) You are using terminal services /RDP to install msde which opens a
> different session and is NOT the same as being on the console.
> Try to logon on locally to the machine and then run the installation with
> the following command line
> setup /L*v c:\msde.log disablerollback=1 disablenetworkprotocols=0
> sapwd="some password"
> Girish Sundaram
> This posting is provided "AS IS" with no warranties, and confers no rights.
Monday, March 19, 2012
Failed Login SQL Express
Everything works fine with the website I've created except i get a Login failed message every now and then
Failed Login is: NT AUTHORITY\NETWORK SERVICE
Is this to do with the maximum number of connections to the database?
how can i stop this from happening?
AusClans:
Is this to do with the maximum number of connections to the database?
Maybe, but probably not. That would be a different error message. What is the full exception message you get?
Don
Monday, March 12, 2012
Failed Assertion?
When going through my logs this morning I found this curious error. Anybody
know what I've got going here? Currently running SQL 2000 sp3a.
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0063.txt
*
************************************************** **************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:37 spid 55
*
*
*
* Input Buffer 48 bytes -
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00000037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A84A840: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A84A824: 0A84B044 0087C41F BCA77230 0A84B1A8 0A84B417 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A84A7F8: BCA77558 00000000 BCA77230 0A84A840 BCA77000 0A84A7F8
* SegSs: 00000023:
*
************************************************** **************************
***
* ----
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 00404829 Module(sqlservr+00004829)
(XdesRMReadOnly::~XdesRMReadOnly+00000075)
* 0040479D Module(sqlservr+0000479D) (ReadOnlyXactImp::Rollback+0000009B)
* 00404490 Module(sqlservr+00004490) (AutoReadOnlyXact::Rollback+0000000E)
* 00404551 Module(sqlservr+00004551) (CSysScan::VRelease+00000069)
* 0045D0B0 Module(sqlservr+0005D0B0) (CObject::FResolveName+0000052D)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
2004-12-06 06:50:43.50 spid55 Stack Signature for the dump is 0xC84ECD88
2004-12-06 06:50:43.61 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
2004-12-06 06:50:43.61 spid55 Error: 3624, Severity: 20, State: 1.
2004-12-06 06:50:43.66 spid55 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0064.txt
*
************************************************** **************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:43 spid 55
*
*
*
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00060037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A848F8C: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A848F70: 0A849790 0087C41F BCA77230 0A8498F4 0A849B63 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A848F44: BCA77558 00000000 BCA77230 0A848F8C BCA77000 0A848F44
* SegSs: 00000023:
*
************************************************** **************************
***
* ----
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 004437D8 Module(sqlservr+000437D8) (dec_dbopen+0000000D)
* 0044377F Module(sqlservr+0004377F) (closedb+00000069)
* 004438BD Module(sqlservr+000438BD) (CAutoDb::SafeClose+00000027)
* 7800925D Module(MSVCRT+0000925D) (_doserrno+0000009E)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
2004-12-06 06:50:45.08 spid55 Stack Signature for the dump is 0xC2291C8B
2004-12-06 06:50:45.10 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
"Mike Johnson" <mj@.microsoft.com> wrote in message
news:upbtGP62EHA.1400@.TK2MSFTNGP11.phx.gbl...
> When going through my logs this morning I found this curious error.
Anybody
> know what I've got going here? Currently running SQL 2000 sp3a.
Sounds liek you've hit a bug. An assertion shouldn't show up in production
code.
Contact MS Server support.
know what I've got going here? Currently running SQL 2000 sp3a.
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0063.txt
*
************************************************** **************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:37 spid 55
*
*
*
* Input Buffer 48 bytes -
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00000037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A84A840: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A84A824: 0A84B044 0087C41F BCA77230 0A84B1A8 0A84B417 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A84A7F8: BCA77558 00000000 BCA77230 0A84A840 BCA77000 0A84A7F8
* SegSs: 00000023:
*
************************************************** **************************
***
* ----
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 00404829 Module(sqlservr+00004829)
(XdesRMReadOnly::~XdesRMReadOnly+00000075)
* 0040479D Module(sqlservr+0000479D) (ReadOnlyXactImp::Rollback+0000009B)
* 00404490 Module(sqlservr+00004490) (AutoReadOnlyXact::Rollback+0000000E)
* 00404551 Module(sqlservr+00004551) (CSysScan::VRelease+00000069)
* 0045D0B0 Module(sqlservr+0005D0B0) (CObject::FResolveName+0000052D)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
2004-12-06 06:50:43.50 spid55 Stack Signature for the dump is 0xC84ECD88
2004-12-06 06:50:43.61 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
2004-12-06 06:50:43.61 spid55 Error: 3624, Severity: 20, State: 1.
2004-12-06 06:50:43.66 spid55 Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 55, PSS = 0xbca77230, EC = 0xbca77558
*Stack Dump being sent to H:\Program Files\Microsoft SQL
Server\MSSQL\log\SQLDump0064.txt
*
************************************************** **************************
***
*
* BEGIN STACK DUMP:
* 12/06/04 06:50:43 spid 55
*
*
*
* exec Spot_GeneralDBStats
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C622FFF 000b3000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* CLUSAPI 73930000 7393FFFF 00010000
* RESUTILS 689D0000 689DCFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* NETAPI32 06890000 068DEFFF 0004f000
* Secur32 068E0000 068EEFFF 0000f000
* NTDSAPI 068F0000 06900FFF 00011000
* DNSAPI 06910000 06933FFF 00024000
* WSOCK32 06940000 06947FFF 00008000
* WS2_32 06950000 06963FFF 00014000
* WS2HELP 06970000 06977FFF 00008000
* WLDAP32 06980000 069A9FFF 0002a000
* NETRAP 069B0000 069B5FFF 00006000
* SAMLIB 069C0000 069CEFFF 0000f000
* ole32 07030000 0711EFFF 000ef000
* XOLEHLP 07120000 07127FFF 00008000
* MSDTCPRX 07130000 071E6FFF 000b7000
* MTXCLU 071F0000 071FFFFF 00010000
* VERSION 07200000 07206FFF 00007000
* LZ32 07210000 07215FFF 00006000
* mswsock 07220000 07231FFF 00012000
* msafd 07280000 0729DFFF 0001e000
* wshtcpip 072E0000 072E6FFF 00007000
* rnr20 072F0000 072FBFFF 0000c000
* iphlpapi 07340000 07352FFF 00013000
* ICMP 07360000 07364FFF 00005000
* MPRAPI 07370000 07386FFF 00017000
* OLEAUT32 07390000 0742AFFF 0009b000
* ACTIVEDS 07430000 0745EFFF 0002f000
* ADSLDPC 07460000 07482FFF 00023000
* RTUTILS 07490000 0749DFFF 0000e000
* SETUPAPI 074A0000 0752DFFF 0008e000
* RASAPI32 07530000 07562FFF 00033000
* RASMAN 07570000 07580FFF 00011000
* TAPI32 07590000 075B1FFF 00022000
* COMCTL32 075C0000 07643FFF 00084000
* SHLWAPI 07650000 076B8FFF 00069000
* DHCPCSVC 076C0000 076D8FFF 00019000
* winrnr 07B80000 07B87FFF 00008000
* msv1_0 07C10000 07C30FFF 00021000
* CRYPT32 07C40000 07CC6FFF 00087000
* MSASN1 07CD0000 07CDFFFF 00010000
* rasadhlp 07CE0000 07CE4FFF 00005000
* SSNETLIB 00BF0000 00C04FFF 00015000
* SSNMPN70 00C10000 00C15FFF 00006000
* security 08790000 08793FFF 00004000
* SSmsLPCn 08920000 08926FFF 00007000
* kerberos 08FB0000 08FE5FFF 00036000
* CRYPTDLL 08930000 0893DFFF 0000e000
* SQLFTQRY 00C70000 00CA1FFF 00032000
* CLBCATQ 087A0000 0882FFFF 00090000
* sqloledb 08710000 08782FFF 00073000
* MSDART 00CB0000 00CCEFFF 0001f000
* comdlg32 08840000 0887DFFF 0003e000
* SHELL32 08AD0000 08D14FFF 00245000
* MSDATL3 00CD0000 00CE4FFF 00015000
* oledb32 09E00000 09E65FFF 00066000
* OLEDB32R 08900000 0890FFFF 00010000
* xpsqlbot 08A40000 08A45FFF 00006000
* rsabase 09F80000 09FA2FFF 00023000
* xpstar 0A030000 0A076FFF 00047000
* SQLRESLD 08910000 08916FFF 00007000
* SQLSVC 08EF0000 08F06FFF 00017000
* ODBC32 0A080000 0A0B1FFF 00032000
* odbcbcp 08FA0000 08FA5FFF 00006000
* W95SCM 0A0C0000 0A0CBFFF 0000c000
* SQLUNIRL 0A0D0000 0A0FCFFF 0002d000
* WINSPOOL 0A100000 0A11DFFF 0001e000
* MPR 0A120000 0A12FFFF 00010000
* SHFOLDER 0A130000 0A137FFF 00008000
* odbcint 0A400000 0A415FFF 00016000
* NDDEAPI 0A420000 0A426FFF 00007000
* SQLSVC 0A430000 0A435FFF 00006000
* xpstar 0A440000 0A448FFF 00009000
* xplog70 07B90000 07BA1FFF 00012000
* xplog70 07BB0000 07BB3FFF 00004000
* srchadm 07BD0000 07C05FFF 00036000
* mssws 09D80000 09D87FFF 00008000
* msi 0B5F0000 0B7F3FFF 00204000
* athprxy 09D90000 09D97FFF 00008000
* adsldp 09D00000 09D21FFF 00022000
* adsmsext 09D30000 09D41FFF 00012000
* dbghelp 0BC00000 0BCB4FFF 000b5000
*
* Edi: BCA77558: BCA77230 BCA7755C BCA7755C BCA3D328 5AF67AE0 BC2D8030
* Esi: 00000000:
* Eax: 00000000:
* Ebx: BCA77230: 00060037 00000000 0111C7EF 000095B0 00000000 00000000
* Ecx: 0A848F8C: 00000000 0001003F 00000000 00000000 00000000 00000000
* Edx: FFFFFFFF:
* Eip: 0087A90E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B
* Ebp: 0A848F70: 0A849790 0087C41F BCA77230 0A8498F4 0A849B63 780238AE
* SegCs: 0000001B:
* EFlags: 00010246: 004F0052 00450043 00530053 0052004F 003D0053 00000038
* Esp: 0A848F44: BCA77558 00000000 BCA77230 0A848F8C BCA77000 0A848F44
* SegSs: 00000023:
*
************************************************** **************************
***
* ----
* Short Stack Dump
* 0087A90E Module(sqlservr+0047A90E)
(CStackDump::GetContextAndDump+0000002E)
* 0087C41F Module(sqlservr+0047C41F) (stackTrace+00000223)
* 00931097 Module(sqlservr+00531097) (utassert_fail+000002E3)
* 00830207 Module(sqlservr+00430207) (DBLockCache::ReleaseDBLock+00000072)
* 004021F5 Module(sqlservr+000021F5) (unlockdb+00000024)
* 004437D8 Module(sqlservr+000437D8) (dec_dbopen+0000000D)
* 0044377F Module(sqlservr+0004377F) (closedb+00000069)
* 004438BD Module(sqlservr+000438BD) (CAutoDb::SafeClose+00000027)
* 7800925D Module(MSVCRT+0000925D) (_doserrno+0000009E)
* 0045EB9F Module(sqlservr+0005EB9F) (CObject::FResolveName+0000003E)
* 0045EA3E Module(sqlservr+0005EA3E) (CAlgTable::FBind+000002BC)
* 0044F048 Module(sqlservr+0004F048) (FOpenAllRanges+000000DD)
* 0044EAD7 Module(sqlservr+0004EAD7) (find_all+000008DA)
* 0044E684 Module(sqlservr+0004E684) (colnames+00000078)
* 0044E5B4 Module(sqlservr+0004E5B4) (CProchdr::NormQuery+00000045)
* 0044ACF2 Module(sqlservr+0004ACF2) (CProchdr::FCompile+00000305)
* 0041BF21 Module(sqlservr+0001BF21) (CSQLSource::FTransform+0000034C)
* 0044CE55 Module(sqlservr+0004CE55) (CSQLStrings::FTransform+000001A1)
* 0041B8EF Module(sqlservr+0001B8EF) (CSQLSource::Execute+0000015B)
* 006040BD Module(sqlservr+002040BD) (CStmtExecStr::XretExecute+0000032E)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 00498A8A Module(sqlservr+00098A8A) (CStmtExec::XretLocalExec+0000014D)
* 00498926 Module(sqlservr+00098926) (CStmtExec::XretExecute+0000031A)
* 0041B442 Module(sqlservr+0001B442)
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041AA88 Module(sqlservr+0001AA88) (CMsqlExecContext::Execute+000001B6)
* 0041B9B6 Module(sqlservr+0001B9B6) (CSQLSource::Execute+00000357)
* 0048A63B Module(sqlservr+0008A63B) (language_exec+000003E1)
* 0042708C Module(sqlservr+0002708C) (process_commands+0000010E)
* 41075002 Module(UMS+00005002) (ProcessWorkRequests+00000272)
* 41074698 Module(UMS+00004698) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57B388 Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
* ----
2004-12-06 06:50:45.08 spid55 Stack Signature for the dump is 0xC2291C8B
2004-12-06 06:50:45.10 spid55 SQL Server Assertion: File: <dbtable.cpp>,
line=2612
Failed Assertion = 'm_refCount [slot] > 0'.
"Mike Johnson" <mj@.microsoft.com> wrote in message
news:upbtGP62EHA.1400@.TK2MSFTNGP11.phx.gbl...
> When going through my logs this morning I found this curious error.
Anybody
> know what I've got going here? Currently running SQL 2000 sp3a.
Sounds liek you've hit a bug. An assertion shouldn't show up in production
code.
Contact MS Server support.
Subscribe to:
Posts (Atom)