10048 Sql Server Error
Contents |
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the sql server error 17 workings and policies of this site About Us Learn more about Stack sqlserver 10048 Overflow the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags sql server port change Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how
Server Tcp Provider Failed To Listen On [ 'any' 1433]. Tcp Port Is Already In Use.
it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Unable to start sql service when TCP/IP is enabled under SSCM - SS Network Configuration up vote 1 down vote favorite 1 in the Console , SQL Server Configuration Manager I get error 10048 when start sql service and this windows could not start the sql server (mssqlserver) service on local computer in event history: The SQL server service terminated with server-specific error. Only one usage of each socket (protcol/network address/port) is normall permitted. Any idea howto fix this ? Port set is the default 1433... If this is turned off, which is default of course, SQL service starts like a champ. I have done this config many times on other servers with no problem. sql-server windows-server-2008-r2 sql-server-2008-r2 share|improve this question edited Oct 27 '12 at 8:05 saber tabatabaee yazdi 189313 asked Oct 26 '12 at 21:24 ebel 614 3 Do you have other instances of SQL installed on this server? Is there another process using port 1433? Run netstat -a -n -o from a command prompt and look for port 1433. If you find it then match up the PID listed with Task Manager and see what process is using port 1433. –joeqwerty Oct 26 '12 at 21:33 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Sounds like there's something else already running on TCP port 1433. Stop the SQL Server. Then f
SQL Server 2014 Express resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Tech Advisors Channel 9 Documentation APIs sql server could not spawn fruncm thread and reference Dev centers Retired content Samples We’re sorry. The content you
How To: Configure A Server To Listen On A Specific Tcp Port (sql Server Configuration Manager)
requested has been removed. You’ll be auto redirected in 1 second. Ask a question Quick access Forums home Browse
Only One Usage Of Each Socket Address Protocol Network Address Port Is Normally Permitted
forums users FAQ Search related threads Remove From My Forums Answered by: SQL Server Service failed to start Error code 10048 SQL Server > SQL Server Setup & Upgrade Question 0 http://serverfault.com/questions/442841/unable-to-start-sql-service-when-tcp-ip-is-enabled-under-sscm-ss-network-confi Sign in to vote Hello. I am experiencing the 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 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 https://social.msdn.microsoft.com/Forums/en-US/0b598f12-0178-46a4-8d30-a3c7e7c9cdb9/sql-server-service-failed-to-start-error-code-10048?forum=sqlsetupandupgrade 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 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.500
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 http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=189484 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 sql server 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 sql server error 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