Home > Sql Server > 10048 Sql Server Error

10048 Sql Server Error


Monday, January 21, 2013 9:29 PM Reply | Quote 1 Sign in to vote "Server TCP provider failed to listen on [ 'any' 3136]. Now to figure out why having TCP/IP enabled prevented my primary instance from starting after SQL2014 SP1 update. I am running 2003 SBS, with a shared BCM database. Get 1:1 Help Now Advertise Here Enjoyed your answer? have a peek here

Blog Sign in Join ASP.NET Home Get Started Learn Hosting Downloads Community Overview Community Spotlight Articles of the Day What's new Community Blogs ASP.NET Team Events Hall Of Fame MSDN Samples Is there another firewall between this system and the remote machine? So I resorted to Goo… MS Server Apps How to create custom scanning profiles in PaperPort - Part 2 Video by: Joe This video Micro Tutorial is the second in a You cannot edit HTML code. http://serverfault.com/questions/442841/unable-to-start-sql-service-when-tcp-ip-is-enabled-under-sscm-ss-network-confi

Sql Server Error 17

You need to find the process which is using this port or change SQL Server TCP port to some thing else which is available to use Marked as answer by Maggie It is as though I am looseing the connection with the SQL server for some reason. All I can think is that since 2012 is using port 1433, may be 2008 is not able to use same post at same time ? Check the SQL Server error log and the Windows event logs for information about possible related problems.) Reply jeffcarter Member 79 Points 1406 Posts Re: SQLServer 2008R2 install but SQLService wont

Only one usage of each socket (protcol/network address/port) is normall permitted. What I think at this point is you are going to need to perform a repair on the SQL 2008 R2. Privacy Statement| Terms of Use| Contact Us| Advertise With Us| CMS by Umbraco| Hosted on Microsoft Azure Feedback on ASP.NET| File Bugs| Support Lifecycle MenuExperts Exchange Browse BackBrowse Topics Open Questions Windows Could Not Start The Sql Server (mssqlserver) Service On Local Computer Now the SQL Server (Instance 2008) in the services won't start.

Tcp port is already in use. Sqlserver 10048 It doesn't appear as if this is a BCM specific issue, but rather a SQL express issue. You cannot delete your own topics. https://social.msdn.microsoft.com/Forums/en-US/0b598f12-0178-46a4-8d30-a3c7e7c9cdb9/sql-server-service-failed-to-start-error-code-10048?forum=sqlsetupandupgrade This is Experts Exchange customer support.

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 Sql Server Could Not Spawn Fruncm Thread Compute the Mertens function Donald Trump's Tax Return Why does multiplication lead to incompleteness where addition does not? Reply jeffcarter Member 79 Points 1406 Posts Re: SQLServer 2008R2 install but SQLService wont start Nov 07, 2013 12:14 PM|jeffcarter|LINK Done- what should I do next ? You’ll be auto redirected in 1 second.

Sqlserver 10048

No user action is required. 2013-01-21 10:56:44.12 spid8s Clearing tempdb database. 2013-01-21 10:56:44.28 spid8s Starting up database 'tempdb'. 2013-01-21 10:56:44.43 spid11s The Service Broker protocol transport is disabled or not configured. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=189484 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 other machine over the same network, I Sql Server Error 17 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 Sql Server Port Change Did you configure the instance to listen on 1435 (probably did :) )?

Any idea howto fix this ? http://rlegsoftware.com/sql-server/207-error-sql-server.php Covered by US Patent. McAfee does this pain in the butt port blocking on non-standard ports. Mark as answer posts that helped you. Server Tcp Provider Failed To Listen On [ 'any' 1433]. Tcp Port Is Already In Use.

Reply jeffcarter Member 79 Points 1406 Posts Re: SQLServer 2008R2 install but SQLService wont start Nov 08, 2013 03:40 PM|jeffcarter|LINK I have done the repair successfully but still not able to 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. You cannot edit your own topics. Check This Out Add the following key to both locationsString value: ServerName\InstanceNameValue data: DBMSSOCN,ServerName,1435HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectToHKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSSQLServer\Client\ConnectToYou will likely need to add the ConnectTo key to both locations.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ asp__developer Posting Yak Master

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 How To: Configure A Server To Listen On A Specific Tcp Port (sql Server Configuration Manager) You cannot vote within polls. I have done this config many times on other servers with no problem.

No user action is required. 2013-01-21 10:56:43.67 spid5s SQL Trace ID 1 was started by login "sa". 2013-01-21 10:56:43.68 spid5s Starting up database 'mssqlsystemresource'. 2013-01-21 10:56:43.74 spid5s The resource database build

Mark as answer posts that helped you. Mark as answer posts that helped you. asked 3 years ago viewed 9249 times active 1 year ago Related 0SQL Server instance service doesn't start0MS SQL Server wont start when listening for VPN IP1Unable to authenticate proxy when Only One Usage Of Each Socket Address Protocol Network Address Port Is Normally Permitted Reply jeffcarter Member 79 Points 1406 Posts Re: SQLServer 2008R2 install but SQLService wont start Nov 07, 2013 11:00 AM|jeffcarter|LINK Yes, even I don't think port should create any problem.

Question 2)- Is it possible to run sql server 2012 and 2008 r2 on same computer at the first place ? Start Regedit Go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters Create or edit the key ReservedPorts In my error in the beginning of this post you'll see the error was in IP6 and port 49330 So You cannot post events. this contact form If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate?

Please, someone, any one... If you had delete the installation media, you can download from the following link again: http://www.microsoft.com/en-us/download/details.aspx?id=25174 Regards, Fanny Liu Fanny Liu TechNet Community Support http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a6277893-0031-4818-b36f-7b1981d49299/repair-sql-server-2008-r2-sp2?forum=sqlsetupandupgrade Mark as answer posts that helped Catch 22. Mark as answer posts that helped you.

I am experiencing the issue with SQL Server 2005 service not able to start when TCP/IP is enabled. I have to admit that since you have gone through all these steps, have you taken a look at this thread? Dot message on a Star Wars frisbee team When was this language released?