Ms 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 Service failed to start Error code
Server Tcp Provider Failed To Listen On [ 'any' 1433]. Tcp Port Is Already In Use.
10048 SQL Server > SQL Server Setup & Upgrade Question 0 Sign windows could not start the sql server (mssqlserver) service on local computer in to vote Hello. I am experiencing the issue with SQL Server 2005 service not able to start sql server could not spawn fruncommunicationsmanager thread when TCP/IP is enabled. I have researched this issue extensively and what I come up with are fixes for checkpoints on clustered instances. ISSUE: I am running a machine
How To: Configure A Server To Listen On A Specific Tcp Port (sql Server Configuration Manager)
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 exactly like everyone else's (when they are dealing with clusters on Server 2003). Can anyone shed ANY light on how
Change Sql Server Port
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 Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29 Copyright (c) 1988-2005 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 3) 2013-01-21 10:56:42.23 Server (c) 2005 Micro
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » Microsoft Access » Microsoft Access » Application Error (SQL Server Error: 10048 ) only one usage of each socket address protocol network address port is normally permitted 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 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 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 wrong with the application, is the SQL, the Network, the Firewall or something.I need the suggestion for fixed 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 http://www.sqlservercentral.com/Forums/Topic142300-131-1.aspx 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 Forum Members Last Login: Monday, September 3, 2007 10:17 PM Points: 210, Visits: 1 HI,Ive seen the error from jimmy crackcorn before, you are right it does occur when running a large time consuming function, ive found it happens because of time outs that are set in SQL server. increasing these does seem to help somewhat, however you should probobly be looking at your report first. Ive found sometimes it doesn't seem to matter how much you extend the timeout, the error still occurs, but altering the report execution or structure, fixes this issue.finally mdacs etc should also be looked at as well.Not a fix but hopefully a step in the right direction ?CheersAdam ------------------------SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums General SQL Server Forums New to SQL Server Administration SQLServer 2008R2 install but SQLService wont start Reply to Topic Printer Friendly Author Topic asp__developer Posting Yak Master 108 Posts Posted-11/07/2013: 08:31:07 I already have SQL Server 2012 running on my computer without any problem (Instance 1)Now I wanted to have 2008 version to so I installed SQL Server 2008 R2 also (named it: Instance2008).Now the SQL Server (Instance 2008) in the services won't start.I get error saying:windows could not start the sql server (Instance2008) service on local computer - code 10048I looked everywhere online and it seems like it has something to do with the login user.Question 1) - what is the password for log on (NT Service\ Instance 2008) as I see in my case the domain/user so I guess I need to change it to NT Service but I don't know the password ?Question 2) - Is it possible to run sql server 2012 and 2008 r2 on same computer at the first place ? as both are using 1433 port in TCP/IP settings. ? Edited by - asp__developer on 11/07/2013 10:12:42 tkizer Almighty SQL Goddess USA 38200 Posts Posted-11/07/2013: 12:20:42 Using a domain user is fine. Have you looked in the application log for the error for why the service won't start?Yes you can run both on the same server. I have some test servers with 2005, 2008 R2 and 2012. No issues.You can't use the same port for both instances. Switch the 2008 instance to a different port. Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ asp__developer Posting Yak Master 108 Posts Posted-11/07/2013: 13:03:41 I just changed the port from 1433 to 1435 for 2008 instance and it worked. But now the problem is..I am able to open sql server but when I try to connect to this sql server 2008 instance from othe