Microsoft Sql Server Error 10048
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: SQL Server
Server Tcp Provider Failed To Listen On [ 'any' 1433]. Tcp Port Is Already In Use.
Service failed to start Error code 10048 SQL Server > windows could not start the sql server (mssqlserver) service on local computer SQL Server Setup & Upgrade Question 0 Sign in to vote Hello. I am experiencing the sql server could not spawn fruncommunicationsmanager thread issue with SQL Server 2005 service not able to start when TCP/IP is enabled. I have researched this issue extensively and what I come up with
How To: Configure A Server To Listen On A Specific Tcp Port (sql Server Configuration Manager)
are fixes for checkpoints on clustered instances. ISSUE: I am running a machine with XP Pro and not Server 2003, so I CANNOT have clustered instances. ALL the fixes out there refer to commands such as "cluster res" which do not exist in Win XP Pro. Here is the error log which looks
Change Sql Server Port
exactly like everyone else's (when they are dealing with clusters on Server 2003). Can anyone shed ANY light on how to deal with this on a Win XP machine? I'm going totally crazy here. I can get the local server to load by disabling TCP/IP in SSCM. VIA does not need to be disabled, just TCP/IP. Of course you know this issue came up when I attempted to change the Listen Port / IP address. I was starting and restarting and stopping and starting the SQL service in order to apply changes within SSCM and must have attempted to apply a change while the SQL server wasn't running. Thank you in advance for any help. FYI, I attempted to run the GUI clusterrecovery.com but it failed miserably. The "browse" function gave me an ActiveX error and I couldn't locate my Cluster because I don't think I have one. Please, someone, any one... HELP. 2013-01-21 10:56:42.12 Server
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar only one usage of each socket address protocol network address port is normally permitted Who's On Home » Microsoft Access » Microsoft Access » Application Error (SQL Server Error: 10048 ) Application Error (SQL Server Error: 10048 ) Rate Topic Display Mode Topic Options Author Message Beni_STSBeni_STS Posted Tuesday, October 19, 2004 12:21 AM SSC Rookie Group: General Forum Members Last Login: Monday, April 27, 2009 7:32 PM https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0b598f12-0178-46a4-8d30-a3c7e7c9cdb9/sql-server-service-failed-to-start-error-code-10048?forum=sqlsetupandupgrade Points: 31, Visits: 3 For Client Aplication (Build with VBA MS Access 2000 with DAO) whenconnect toDatabase MS SQL 7.0 sometime happend:
Connection Failed: SQLState: '01000' SQL Server Error: 10048 [Microsoft][ODBC SQL Server Driver][TCP/IP Socket]ConnectionOpen (Connect()). What wrong with the application, is the SQL, the Network, the Firewall or something.I need the suggestion for fixed http://www.sqlservercentral.com/Forums/Topic142300-131-1.aspx this problem.Thank's for your help. Post #142300 Site OwnersSite Owners Posted Friday, October 22, 2004 8:00 AM SSChampion Group: General Forum Members Last Login: Friday, May 18, 2007 3:36 PM Points: 10,041, Visits: 1 No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have! Post #142997 Jimmy CrackcornJimmy Crackcorn Posted Tuesday, March 29, 2005 11:27 AM Forum Newbie Group: General Forum Members Last Login: Wednesday, December 5, 2012 1:06 PM Points: 1, Visits: 18 I get the same error but mine also has a SQLState: '08001'SQL Server Error: 17[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.I only get this error when I run a very large time consuming function. Like a huge report. It is as though I am looseing the connection with the SQL server for some reason. Post #170638 adamcrvadamcrv Posted Monday, April 11, 2005 6:26 PM SSC Veteran Group: General FSoftware Troubleshooting and Assistance Internet Security and Malware Help SQL Server error 10048 Custom Search Join the PC homebuilding revolution! Read the all-new, FREE 200-page online guide: How to Build Your Own PC! NOTE: http://www.pcguide.com/vb/showthread.php?22863-SQL-Server-error-10048 Using robot software to mass-download the site degrades the server and is prohibited. See here for more. Find The PC Guide helpful? Please consider a donation to The PC Guide Tip Jar. Visa/MC/Paypal accepted. https://www.experts-exchange.com/questions/24166622/SQL-service-won't-start.html If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to sql server proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: SQL Server error 10048 Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… 06-03-2003,08:20 AM #1 Roady View Profile View Forum Posts View Blog Entries View Articles Computer Analyst Join Date Jan 2002 Location Lancashire UK Posts 291 SQL Server error 10048 Anybody to listen on help with this isssue where the PC is on a domain and can see the network ok but when I setup ODBC SQL Server it comes with the error of 10048. [TCP/IP sockets] connection open (connect) Connection failed SQL State 08001 SQL server error 11 General network error Advise please Thanks Roady!! Spec: Zalman GT1000 Case Quad core Q6600 4Gig OCZ 1000Mhz DDR2 Memory OCZ 780W ModXtream PSU 2 RaptorX SATA 150 Gig in RAID0 500Gig Data SATA HD 32MB Cache Nexus LXM-8200 Intel 775 CPU Cooler Asus en8800 Extreme nVidia GTX768MB Scythe Kama-Meter Multifunction Fan Controller LG GGW-H20L Blu-ray Disc Rewriter & HD DVD ROM ASUS P5N-T Deluxe nForce 780i Socket 775 Motherboard Dual boot XP64Bit\Vista64Bit Reply With Quote 06-03-2003,10:28 AM #2 Ghost_Hacker View Profile View Forum Posts View Blog Entries View Articles Net-Tech-Fu Sensei Join Date Jan 2001 Location Unimatrix Zero-one Posts 2,273 Have you checked that your server is listening on port 1433 TCP? (Use Telnet and telnet to that port on your server) If TCP/IP is not working switch the net-library your client uses to the named pipes or Multiprotocol one. (this link should help : http://msdn.microsoft.com/library/de...lient_7v03.asp) Hope this helps Ferengi Rules of Acquistion: Rule # 47 Don't trust a man wearing a bette
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > SQL service won't start Want to Advertise Here? Solved SQL service won't start Posted on 2009-02-22 MS Server Apps 1 Verified Solution 9 Comments 6,899 Views Last Modified: 2012-05-06 Hello, I have a small..... or HUGE problem. I cannot get my mssmlbiz SQL server to start. Nothing has changed in the environment, except a QB update, and a reboot. I am running 2003 SBS, with a shared BCM database. It worked fine for the last month, and then died. I am getting the error code 10048 (0x2740) in the event log. Any advise from some of you really smart people would be greatly appreciated. Thanks. Rob 0 Question by:rn0rd0 Facebook Twitter LinkedIn Google LVL 26 Best Solution bytigin44 try incrementing the port number by one... Go to Solution 9 Comments Message Author Comment by:rn0rd02009-02-22 Just found another interesting log entry.... Server TCP provider failed to listen on [ 'any'