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
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
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
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'
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.
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'
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'
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