You can read my previous tip about Solving SQL Server Database Physical File Fragmentation to see another one of these tools in action. You cannot delete your own events. In the image above, you can see that the process using those ports was Microsoft Outlook. To troubleshoot SQL Server service start use this tip to Read the end of a large SQL Server Error Log. http://deftmag.com/sql-server/sql-server-could-not-spawn-process-loginread-thread.html
Any ideas of the best way to troubleshoot/reproduce it? Thursday, January 11, 2007 3:42 PM Reply | Quote 0 Sign in to vote The most common cause of this message is a lack of free virtual address space. The most This or something similar was supposedly fixed in SP4. What application is using these ports? http://www.sqlservercentral.com/Forums/Topic187750-5-1.aspx
If you are experiencing a similar issue, please ask a related question Suggested Solutions Title # Comments Views Activity Windows 2003 domain controller crashed BDC is 2008 server 4 36 17d Dim Reply With Quote 02-18-2005,03:20 PM #2 rmiao View Profile View Forum Posts Moderator Join Date Sep 2002 Posts 5,938 Sounds like memory leak on the server. Example: These are the commands to set the dynamic port range to an IANA recommended value: netsh int ipv4 set dynamicport tcp start=49152 num=16383netsh int ipv4 set dynamicport udp start=49152 num=16383netsh
You cannot edit your own events. You cannot edit your own posts. Have you verified your storage?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog steel Posting Yak Master 107 Posts Posted-05/10/2010: 00:17:53 Thanks for the reply On Windows 2008 the previous registry key is not supported.
Reason: Unable to initialize the TCP/IP listener. Post #582969 shah797shah797 Posted Monday, April 27, 2009 10:25 AM Forum Newbie Group: General Forum Members Last Login: Monday, February 29, 2016 10:15 AM Points: 4, Visits: 109 I also have I am running SQL2000 with SP4. check my site All articles refered to pre-SP4 hot fixes, but we are running SP4, so I'm wondering if any one has any experience with this problem post-SP4.
Chikani Posted Tuesday, June 7, 2005 4:07 PM Forum Newbie Group: General Forum Members Last Login: Saturday, November 19, 2016 6:23 PM Points: 6, Visits: 161 Ihad the same issue on MrTim, Aug 2, 2006 #2 FrankKalis Moderator Sorry, but then that looks like a call to MS PSS... -- Frank Kalis Microsoft SQL Server MVP Webmaster:http://www.insidesql.de Heute schon gebloggt?http://www.insidesql.de/blogs FrankKalis, Aug Pictures Contribute Events User Groups Author of the Year More Info Join About Copyright Privacy Disclaimer Feedback Advertise Copyright (c) 2006-2016 Edgewood Solutions, LLC All rights reserved Some names and products Here is a tip to fine errors in the error log Simple way to find errors in SQL Server error log.
You may have to register before you can post: click the register link above to proceed. Note: your email address is not published. No, create an account now. Simply fill out this brief survey by 11:45 p.m.
So I killed the Outlook process by clicking End Process from the Process menu. http://deftmag.com/sql-server/sql-server-linked-server-could-not-create-an-acceptable-cursor.html I will post back if/when we get a solution from MS. You cannot upload attachments. All comments are reviewed, so stay on subject or we may delete your comment.
You may read topics. As you can see in the image below there were two connections with CLOSE_WAIT status using the default SQL Server ports:port 1433 which is used by the SQL Server Service and MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum Register Help Remember Me? weblink In this tip you will learn how to Start, Stop, Pause and Query Windows SQL Server Services Remotely.
Join our community for more solutions or to ask questions. Reason: Initialization failed with an infrastructure error. Come on over!
We still have the problem though. I found another post on this site where someonbe else seems to be having the same problem on SP4. You can't easily relate error messages and hotfixes, it could be another reason you are getting this message. Without going into too much detail, CLOSE_WAIT status means that the remote machine has ended the connection, but the local application keeps the socket opened, probably for reuse later on.
So this is the story.. To determine the cause, review the errors immediately preceding this one in the error log. On a site of Microsoft did not find.To address in support desk MS. 3 Reply by Shreder 2012-04-23 12:45:14 Shreder Member Offline Registered: 2005-07-18 Posts: 282 Re: SQL Server could not check over here You cannot delete your own topics.
and ERROR: Launch of System Task 'OnDemand' failed! But there are several issues listed at Microsoft knowledge base where the symptoms includes this message. Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact I run SQL2000 Ent on NT Server 2000 Advance.
Copyright © 2002-2016 Redgate. Some more info (complete error message, hotfix info, when and where you get the error message) would help Friday, December 15, 2006 10:26 AM Reply | Quote 0 Sign in to In order to reserve a range of ports you may need to apply hotfix KB2665809 http://support.microsoft.com/kb/2665809. WARNING: Failed to reserve contiguous memory of Size= 65536.
Reply With Quote 02-18-2005,05:03 PM #3 dim View Profile View Forum Posts Registered User Join Date Sep 2002 Location Montreal Posts 86 yep, as far as I could figure out it's Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 SQL Server could not spawn process_loginread thread. Also check the Tools Tips Category. Here you have looked at these Free SQL Server tools from Microsoft.
And meantime I want to capture the process/exectution that cause us grief, cuzz we started to get this error since last tuesday, and there was none for the past 4 years
© Copyright 2017 deftmag.com. All rights reserved.