Error accepting connection request via Net-Library 'SSNETLIB'

Hi,
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

Error 8152

Hi,
I have the following problem. I create a small request to truncate a column
(see below). When I run it, I get an error 8152. I don't understand why.
I have no null value into the table.
I would appreciate any help
tia
Samuel
ALTER TABLE [dbo].[ArticleNumber] ALTER COLUMN [Number] [varchar] (35)
COLLATE Latin1_General_CI_AS NOT NULLError 8152 ("String or binary data would be truncated.") indicates that you
have data in the column that is longer than the length you are trying to set
it to, i.e. longer than 35 characters.
Do
SELECT MAX(LEN(Number)) FROM ArticleNumber
to find out how long the values in that column are.
Jacco Schalkwijk
SQL Server MVP
"Samuel Bernard" <SamuelBernard@.discussions.microsoft.com> wrote in message
news:0F9B9A47-B83C-43B0-A6C1-F6D4EE61C56E@.microsoft.com...
> Hi,
> I have the following problem. I create a small request to truncate a
> column
> (see below). When I run it, I get an error 8152. I don't understand why.
> I have no null value into the table.
> I would appreciate any help
> tia
> Samuel
> ALTER TABLE [dbo].[ArticleNumber] ALTER COLUMN [Number] [varchar] (35)
> COLLATE Latin1_General_CI_AS NOT NULL|||Hi
What data type is the column now?
The error message indicates that there is data, with lergth exceeding 35, in
the column and SQL Server will not just throw the extra data away.
Run something like this frist to remove the extra characters (NOTE: You
loose data by doing this, so only run it after careful consideration and
testing)
Update ArticleNumber
SET Number = SUBSTRING(Number, 1, 35)
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Samuel Bernard" wrote:

> Hi,
> I have the following problem. I create a small request to truncate a colum
n
> (see below). When I run it, I get an error 8152. I don't understand why.
> I have no null value into the table.
> I would appreciate any help
> tia
> Samuel
> ALTER TABLE [dbo].[ArticleNumber] ALTER COLUMN [Number] [varchar] (35)
> COLLATE Latin1_General_CI_AS NOT NULL|||Hi Jacco,
Thanks you for your quick and GOOD answer.
"Jacco Schalkwijk" wrote:

> Error 8152 ("String or binary data would be truncated.") indicates that yo
u
> have data in the column that is longer than the length you are trying to s
et
> it to, i.e. longer than 35 characters.
> Do
> SELECT MAX(LEN(Number)) FROM ArticleNumber
> to find out how long the values in that column are.
>
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Samuel Bernard" <SamuelBernard@.discussions.microsoft.com> wrote in messag
e
> news:0F9B9A47-B83C-43B0-A6C1-F6D4EE61C56E@.microsoft.com...
>
>

Error 400 Bad Request in Reporting Services

Hi,
I get this strange error when I try to acess my SQL Reporting Services application.
I'm using SQL 2005 Beta 2. The installation was OK and the server is working fine. That is the only problem.
I checked the logs and a traced the database, but couldn't find someful usefull (at leat for me).
Here's the SQL2005 Report Server WebApp log:

w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing InstanceName to default value of '' because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException' because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!25/08/2005-12:57:13:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!1!25/8/2005-12:57:15:: e ERROR: The request failed with HTTP status 400: Bad Request.
w3wp!ui!1!25/8/2005-12:57:15:: e ERROR: HTTP status code --> 500
---Details---
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!1!25/8/2005-12:57:20:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
w3wp!ui!5!25/8/2005-12:57:44:: e ERROR: The request failed with HTTP status 400: Bad Request.
w3wp!ui!5!25/8/2005-12:57:44:: e ERROR: HTTP status code --> 500

Thanks in advance,

Anderson

Good Evening Anderson!
I had some "weird" problems immediately after I installed the SQL2005 JUNE CTP when initially launching RS. I do not know for cetain what your problems relates to above - but for some strange reason with my problem which I getting similar issues to your post was that the Virtual Directories (Reports and ReportServer) within IIS were somehow messed up!
So I deleted the two virtual directories and recreated and ensured I was not using 'Enable Anonymous Access' and I specified Integrated Windows Authentication.
Restarted IIS and everything was ok after that.
What version of Visual Studio are you using -? I had similar problems with bad requests without registering RS after install to .Net as well.
Best Regards,
Joe|||

Hi, Joe

Thanks for your interest.

I was having some trouble with the RS db. I've followed the steps below and now everything's ok:

1. Unistall RS;
2. Ensure RS database is deleted;
3. Reinstall RS;
4. Use RS Configuration Tool to setup everything.
Actually, I'm using SQL2K5April CTP and VS2K5 Beta 2.

Best regards,

Anderson

|||Hello Anderson!
these little things you have to go through to make things work sometimes!
Did you know the August SQL 2005 CTP is now available as well?
Best regards,
joe