Thursday, March 29, 2012
Error accepting connection request via Net-Library 'SSNETLIB'
I installed SP3 over SQL2K on NT Server SP6. The Server
hangs on startup. This is after I did an upgrade
installation of SQL 7 to SQL Server 2000 and applied SP3
over it. Everything runs fine for afew hours and then we
get the message below and some of our servers lose the
ability to connect to the sql server.
2003-12-18 10:20:08.84 spid65 Using 'xp_AltaMX.dll' version
'0002.00.00' to execute extended stored
procedure 'xp_AltaMX'.
2003-12-18 11:01:49.43 spid62 Using 'xpipass.dll'
version 'UNKNOWN'to execute extended stored
procedure 'xp_ipass_actualiza'.
2003-12-18 12:24:01.62 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:24:01.62 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:24:01.62 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:24:01.62 server Operating system error 1:
Incorrect function...
2003-12-18 12:31:58.09 server SQL Server could not spawn
process_loginread thread.
2003-12-18 12:31:59.09 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:31:59.09 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:31:59.09 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:31:59.09 server Operating system error 1:
Incorrect function...
2003-12-18 12:41:30.01 server Error: 17882, Severity: 18,
State: 1
2003-12-18 12:41:30.01 server Error accepting connection
request via Net-Library 'SSNETLIB'. Execution continuing..
2003-12-18 12:41:30.01 server Error: 17059, Severity: 18,
State: 0
2003-12-18 12:41:30.01 server Operating system error 1:
Incorrect function...
2003-12-18 12:51:21.10 server SQL Server is disallowing new
connections due to 'pause' request from Service Control
Manager.
2003-12-18 12:53:09.60 spid3 SQL Server is terminating due
to 'stop' request from Service Control Manager.
I would be greatful if anyone has any ideas on how to deal
with this ?
I already reviewed this article but me it has not been
helpful.
http://support.microsoft.com/default.aspx?scid=kb;en-
us;811887&Product=sql2k
I am of course afraid that someday we will not be able to
access the
sql server.
Regards,
LeoWho supplied you with
xp_AltaMX
xpipass.dll
xp_ipass_actualiza
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Hi Kevin,
The development area supplied them. Let me tell you=20
something, when this server was working under SQL 7, this=20
error never appeared. After upgrade the error appeared.
Do you think that the problem may be are the xp=B4s?
thanks,
Leo|||Drop /remove the xp's and see if the problem persists. Do this in your
Test environment.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.sql
Sunday, March 11, 2012
Error 5172
Hi,
I have a SQL Server 2000 running in a Windows 2003 Server. I restarted the server but SQL didn't startup, showing in the event viewer Error: 5172, Severity: 16, State: 15
Can anybody help me?
Thanks in advance,
Octavio Vargas
octavio.vargas@.macimex.com
The error text for error 5172 is along the lines of:
"The Header For File '.....ldf'' is not a valid database file header."
So it sounds like one of the system databases is corrupt - possibly the master database, particularly as SQL Server can't start. The lack of an error message in the text you quoted suggests that SQL Server can't access the master.dbo.sysmessages table.
If you have a recent backup of your master database then try restoring it - otherwise you may have to rebuild it.
Have a look at these links for more info:
http://msdn2.microsoft.com/en-us/library/aa173515(SQL.80).aspx
http://msdn2.microsoft.com/en-us/library/aa213831(SQL.80).aspx
Once it has been rebuilt you should re-apply any service packs and hotfixes then re-install any custom objects that you have that reside in the master database.
Chris
|||Error 5172 is "The header for file '%ls' is not a valid database file header. The %ls property is incorrect.".
This indicates that you probably could well have a corrupt database. The full message should tell you which database and what property it is objecting to.
Also
What were the messages around this message in the log?|||Thanks Chris,
I don't have a backup of my master database, only for my user databases.
If i rebuild the master database, can i lose all my DTS and jobs?
|||In the log appears the next message:
Stack overflow - Dump not possible
I have SP1 in Windows 2003 server and SP4 in SQL Server 2000
|||I still think that the first error you provided is the biggest clue to the source of the error.
Chris
|||The jobs and DTS packages are stored in the msdb database, however they will be lost when you rebuild the master database as msdb is also rebuilt.
On this basis I would take copies of the msdb mdf and ldf files before you attempt to rebuild the master database. Once the rebuild has been completed and SP4 has been applied, stop the SQL Server service, rename the newly created msdb data and log files, copy the old (previously copied) files to the same folder then restart SQL Server. This *might* work, however if it doesn't then you'll need to re-instate the newly created data and log files.
Note that DTS packages are stored in msdb.dbo.sysdtspackages so you could actually attach the old msdb files (under a different database name) then use the Import/Export wizard to copy the data into the new msdb database.
Once you've been through the rebuild process I would recommend that, going forward, you take backups of the master and msdb databases on a regular basis.
Chris
|||I was more interested in the lines before which will tell us what database it was trying to start up when it threw the error. Error messages are much easier to interpret in context.
Microsoft are not charging you by the line here so it is useful to put up at least a few messages either side of the one and if there is a fatal error/stop message it is useful to run to that (as you know that you have all the messages up to the failure. You can clear the IP addresses and server names from the messages if that is sensitive, but the existance and meat of the messages is useful in helping with your problem.
|||In the event viewer it only shows the number error, but in the message log it looks like it was trying to open the master database.|||In that case, then, it seems like your master database is corrupt.
Chris
Friday, March 9, 2012
Error 5: Access denied
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives?
Check the 'logon as' in Control Panel\Services. Did the password for that
account get changed during the upgrade? Or should it be a new login all
together? In any case, check that.
hth
"Terry Johnson" <tjohnson@.contech.com> wrote in message
news:%23etTiUw1EHA.2316@.TK2MSFTNGP15.phx.gbl...
> Upgraded an NT 4 server to WIN2K Server with SQL Server 2000 already
> installed. Now getting MSSQLSERVER service startup errors with access
> denied despite having domain admin as logon. What gives?
>
Error 5 Access Denied
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives'Check the drive in which the Binn files are installed. Make sure they arent
ReadOnly, also try giving explicit rights ot your account to those folders
and try agian.
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Error 5 Access Denied
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives?
Check the drive in which the Binn files are installed. Make sure they arent
ReadOnly, also try giving explicit rights ot your account to those folders
and try agian.
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Error 5 Access Denied
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives'Check the drive in which the Binn files are installed. Make sure they arent
ReadOnly, also try giving explicit rights ot your account to those folders
and try agian.
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Sunday, February 26, 2012
error 3146
I have given them a new copy of the switchboard but same startup error.
Thank you for your help.
>
> IOSDSQL 664-964 ENTER SQLSetStmtOption
> HSTMT 0A0B1EC8
> UWORD 0 <SQL_QUERY_TIMEOUT>
> SQLPOINTER 0x0000003C
>
> IOSDSQL 664-964 EXIT SQLSetStmtOption with return code 0
> (SQL_SUCCESS)
> HSTMT 0A0B1EC8
> UWORD 0 <SQL_QUERY_TIMEOUT>
> SQLPOINTER 0x0000003C (BADMEM)
>
> IOSDSQL 664-964 ENTER SQLExecDirect
> HSTMT 0A0B1EC8
> UCHAR * 0x09FB18C0 [ -3] "SELECT
> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int:No" FROM
> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
> SDWORD -3
>
> IOSDSQL 664-964 EXIT SQLExecDirect with return code -1
> (SQL_ERROR)
> HSTMT 0A0B1EC8
> UCHAR * 0x09FB18C0 [ -3] "SELECT
> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int:No" FROM
> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
> SDWORD -3
>
> DIAG [37000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
> Incorrect syntax near '.'. (170)
>Check to make sure QUOTED_IDENTIFIER is ON.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"BrianMultilLanguage" <brian@.clilang.com> wrote in message
news:12kv1p37855g42@.corp.supernews.com...
> Only one user has the problem.
> I have given them a new copy of the switchboard but same startup error.
> Thank you for your help.
>> IOSDSQL 664-964 ENTER SQLSetStmtOption
>> HSTMT 0A0B1EC8
>> UWORD 0 <SQL_QUERY_TIMEOUT>
>> SQLPOINTER 0x0000003C
>> IOSDSQL 664-964 EXIT SQLSetStmtOption with return code 0
>> (SQL_SUCCESS)
>> HSTMT 0A0B1EC8
>> UWORD 0 <SQL_QUERY_TIMEOUT>
>> SQLPOINTER 0x0000003C (BADMEM)
>> IOSDSQL 664-964 ENTER SQLExecDirect
>> HSTMT 0A0B1EC8
>> UCHAR * 0x09FB18C0 [ -3] "SELECT
>> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int:No" FROM
>> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
>> SDWORD -3
>> IOSDSQL 664-964 EXIT SQLExecDirect with return code -1
>> (SQL_ERROR)
>> HSTMT 0A0B1EC8
>> UCHAR * 0x09FB18C0 [ -3] "SELECT
>> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int:No" FROM
>> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
>> SDWORD -3
>> DIAG [37000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
>> Incorrect syntax near '.'. (170)
>|||BINGO~!
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:59C18CE9-04B5-49E1-87AB-4EA2DAD4E977@.microsoft.com...
> Check to make sure QUOTED_IDENTIFIER is ON.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "BrianMultilLanguage" <brian@.clilang.com> wrote in message
> news:12kv1p37855g42@.corp.supernews.com...
>> Only one user has the problem.
>> I have given them a new copy of the switchboard but same startup error.
>> Thank you for your help.
>>
>> IOSDSQL 664-964 ENTER SQLSetStmtOption
>> HSTMT 0A0B1EC8
>> UWORD 0 <SQL_QUERY_TIMEOUT>
>> SQLPOINTER 0x0000003C
>> IOSDSQL 664-964 EXIT SQLSetStmtOption with return code 0
>> (SQL_SUCCESS)
>> HSTMT 0A0B1EC8
>> UWORD 0 <SQL_QUERY_TIMEOUT>
>> SQLPOINTER 0x0000003C (BADMEM)
>> IOSDSQL 664-964 ENTER SQLExecDirect
>> HSTMT 0A0B1EC8
>> UCHAR * 0x09FB18C0 [ -3] "SELECT
>> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int:No" FROM
>> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
>> SDWORD -3
>> IOSDSQL 664-964 EXIT SQLExecDirect with return code -1
>> (SQL_ERROR)
>> HSTMT 0A0B1EC8
>> UCHAR * 0x09FB18C0 [ -3] "SELECT
>> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int:No" FROM
>> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
>> SDWORD -3
>> DIAG [37000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
>> Incorrect syntax near '.'. (170)
>>
>
error 3146
I have given them a new copy of the switchboard but same startup error.
Thank you for your help.
> IOSDSQL 664-964 ENTER SQLSetStmtOption
> HSTMT 0A0B1EC8
> UWORD 0 <SQL_QUERY_TIMEOUT>
> SQLPOINTER 0x0000003C
> IOSDSQL 664-964 EXIT SQLSetStmtOption with return code 0
> (SQL_SUCCESS)
> HSTMT 0A0B1EC8
> UWORD 0 <SQL_QUERY_TIMEOUT>
> SQLPOINTER 0x0000003C (BADMEM)
> IOSDSQL 664-964 ENTER SQLExecDirect
> HSTMT 0A0B1EC8
> UCHAR * 0x09FB18C0 [ -3] "SELECT
> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int: No" FROM
> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
> SDWORD -3
> IOSDSQL 664-964 EXIT SQLExecDirect with return code -1
> (SQL_ERROR)
> HSTMT 0A0B1EC8
> UCHAR * 0x09FB18C0 [ -3] "SELECT
> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int: No" FROM
> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
> SDWORD -3
> DIAG [37000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
> Incorrect syntax near '.'. (170)
>
Check to make sure QUOTED_IDENTIFIER is ON.
Hope this helps.
Dan Guzman
SQL Server MVP
"BrianMultilLanguage" <brian@.clilang.com> wrote in message
news:12kv1p37855g42@.corp.supernews.com...
> Only one user has the problem.
> I have given them a new copy of the switchboard but same startup error.
> Thank you for your help.
>
>
|||BINGO~!
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:59C18CE9-04B5-49E1-87AB-4EA2DAD4E977@.microsoft.com...
> Check to make sure QUOTED_IDENTIFIER is ON.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "BrianMultilLanguage" <brian@.clilang.com> wrote in message
> news:12kv1p37855g42@.corp.supernews.com...
>
error 3146
I have given them a new copy of the switchboard but same startup error.
Thank you for your help.
> IOSDSQL 664-964 ENTER SQLSetStmtOption
> HSTMT 0A0B1EC8
> UWORD 0 <SQL_QUERY_TIMEOUT>
> SQLPOINTER 0x0000003C
> IOSDSQL 664-964 EXIT SQLSetStmtOption with return code 0
> (SQL_SUCCESS)
> HSTMT 0A0B1EC8
> UWORD 0 <SQL_QUERY_TIMEOUT>
> SQLPOINTER 0x0000003C (BADMEM)
> IOSDSQL 664-964 ENTER SQLExecDirect
> HSTMT 0A0B1EC8
> UCHAR * 0x09FB18C0 [ -3] "SELECT
> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int:No" FROM
> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
> SDWORD -3
> IOSDSQL 664-964 EXIT SQLExecDirect with return code -1
> (SQL_ERROR)
> HSTMT 0A0B1EC8
> UCHAR * 0x09FB18C0 [ -3] "SELECT
> "dbo"."New_OnCall"."Lang","dbo"."New_OnCall"."Int:No" FROM
> "dbo"."New_OnCall" ORDER BY "Lang" \ 0"
> SDWORD -3
> DIAG [37000] [Microsoft][ODBC SQL Server Driver][SQL Serv
er]Line 1:
> Incorrect syntax near '.'. (170)
>Check to make sure QUOTED_IDENTIFIER is ON.
Hope this helps.
Dan Guzman
SQL Server MVP
"BrianMultilLanguage" <brian@.clilang.com> wrote in message
news:12kv1p37855g42@.corp.supernews.com...
> Only one user has the problem.
> I have given them a new copy of the switchboard but same startup error.
> Thank you for your help.
>
>|||BINGO~!
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:59C18CE9-04B5-49E1-87AB-4EA2DAD4E977@.microsoft.com...
> Check to make sure QUOTED_IDENTIFIER is ON.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "BrianMultilLanguage" <brian@.clilang.com> wrote in message
> news:12kv1p37855g42@.corp.supernews.com...
>