Home > Sql Server > Sql Sql Server Error 10048

Sql Sql Server Error 10048

Contents

Report Abuse. N dimensional cubes Remnants of the dual number Difficulties interpreting this complex sentence Stockholm public transport on 26th December Why my home PC wallpaper updates to my office wallpaper VT-x is 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 All rights reserved.Terms of Use|Trademarks|Privacy Statement|Site Feedback RSS Home Downloads Exchange Exchange 2003 Exchange 2007 Exchange 2010 Exchange 2013 Links Misc Twitter MS-Office Office-2010 Office-2013 News Office-365 Server-OS SBS 2008 Server Source

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 You cannot upload attachments. Stop the SQL Server. If that works, then you can either choose to connect with that or add a SQL alias to the client machine.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ asp__developer Posting Yak Master 108 http://serverfault.com/questions/442841/unable-to-start-sql-service-when-tcp-ip-is-enabled-under-sscm-ss-network-confi

Server Tcp Provider Failed To Listen On [ 'any' 1433]. Tcp Port Is Already In Use.

You cannot post topic replies. Regards, Alberto Morillo SQLCoffee.com Monday, January 21, 2013 6:31 PM Reply | Quote Moderator 1 Sign in to vote Hi, thanks for responding. Why is bench pressing your bodyweight harder than doing a pushup? No issues.You can't use the same port for both instances.

This is an informational message only. All rights reserved. Copyright 1997-2013 Charles M. You cannot post or upload images. Edited by - asp__developer on 11/07/2013 13:05:17 asp__developer Posting Yak Master 108 Posts Posted-11/07/2013: 13:04:03 2012 instance and connection from over computers on same network working fine - YES2008

How to reward good players, in order to teach other players by example more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising For more information, review the System Event log. No user action is required. 2013-01-21 10:56:43.29 Server Database mirroring has been enabled on this instance of SQL Server. 2013-01-21 10:56:43.32 spid5s Starting up database 'master'. 2013-01-21 10:56:43.46 spid5s 1 transactions Get More Info Kozierok.

Tcp port is already in use." Looks like the TCP port 3136 which SQL is listening is on is already being used by some other process. 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 6114 3 Do you have other instances You cannot delete other events. Windows Wiki Menu Skip to content Home Sql Sql Server Error 10048 Reckoned ForceView ReckonedForceLLC's profile on FacebookView ReckonedF's profile on TwitterView reckonedforce's profile on LinkedInView dbandbi's profile on

Windows Could Not Start The Sql Server (mssqlserver) Service On Local Computer

You cannot post IFCode. http://www.pcguide.com/vb/showthread.php?22863-SQL-Server-error-10048 It is as though I am looseing the connection with the SQL server for some reason. Server Tcp Provider Failed To Listen On [ 'any' 1433]. Tcp Port Is Already In Use. 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. Sql Server Could Not Spawn Fruncm Thread Are there too few Supernova Remnants to support the Milky Way being billions of years old?

VIA does not need to be disabled, just TCP/IP. this contact form Home | Weblogs | Forums | SQL Server Links Search: Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About Please start any new No user action is required. 2013-01-21 10:56:43.96 spid8s Starting up database 'model'. 2013-01-21 10:56:43.96 Server Virtual Interface Architecture protocol is not supported for this particular edition of SQL Server. 2013-01-21 10:56:43.98 Privacy Policy. Only One Usage Of Each Socket Address Protocol Network Address Port Is Normally Permitted

Is there another process using port 1433? Email check failed, please try again Sorry, your blog cannot share posts by email. Thank you in advance for any help. have a peek here Like a huge report.

Is it a coincidence that the first 4 bytes of a PGP/GPG file are ellipsis, smile, female sign and a heart? 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 Then from a command prompt run netstat -a -b This will show you all the TCP ports which are in use and the name of the application which is using it.

Terms of Use.

asked 4 years ago viewed 10103 times active 2 years ago Related 0SQL Server instance service doesn't start0MS SQL Server wont start when listening for VPN IP1Unable to authenticate proxy when 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 Of course you know this issue came up when I attempted to change the Listen Port / IP address. This is an informational message only.

Windows 8.1 /2012 R2: How... Monday, January 21, 2013 6:18 PM Reply | Quote Answers 1 Sign in to vote "Server TCP provider failed to listen on [ 'any' 3136]. Username: Password: Save Password Forgot your Password? Check This Out 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

I have researched this issue extensively and what I come up with are fixes for checkpoints on clustered instances. You cannot post HTML code. You cannot vote within polls. We've got lots of great SQL Server experts to answer whatever question you can come up with.

You cannot delete your own topics. Run netstat -a -n -o from a command prompt and look for port 1433. 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.

tkizer Almighty SQL Goddess USA 38200 Posts Posted-11/07/2013: 14:15:05 On the machine you are getting that error, instead of using ServerName\InstanceName, use ServerName,PortNumber. You cannot post replies to polls. 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 finally i suppose SQL 7.0 pretty old now, there are plenty of reasonsto maybe look at upgrading as well to a newer version?

not a solution but something you maybe should look at ?some more information would help us to help you though beni sts ------------------------------Life is far too important to be taken seriously You may have to register before you can post: click the register link above to proceed. Email check failed, please try again Sorry, your blog cannot share posts by email. %d bloggers like this: Log in :: Register :: Not logged in Home Tags Any idea howto fix this ?

Monday, January 21, 2013 9:29 PM Reply | Quote 1 Sign in to vote "Server TCP provider failed to listen on [ 'any' 3136]. tkizer Almighty SQL Goddess USA 38200 Posts Posted-11/07/2013: 19:07:58 All of the info is in my last reply.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ Edited by - tkizer on You cannot delete other posts. Visa/MC/Paypal accepted. If this is your first visit, be sure to check out the FAQ by clicking the link above.

Our new SQL Server Forums are live! Browse other questions tagged sql-server windows-server-2008-r2 sql-server-2008-r2 or ask your own question. 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