10048 Error Sql Server
Contents |
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about error 10048 sql server 2008 Stack Overflow the company Business Learn more about hiring developers or posting ads with
Sql Server Error 17
us Server Fault Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system 10048 error origin and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Unable bind 10048 error 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 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
Sqlserver 10048
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 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. Find the application which is using TCP port 1433 and change that application to use a different port number. share|improve this answer answered Oct 27 '12 at 22:44 mrdenny 25.4k33163 add a comment| up
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar sql server port change Who's On Home » Microsoft Access » Microsoft Access » Application server tcp provider failed to listen on [ 'any'
Windows Could Not Start The Sql Server (mssqlserver) Service On Local Computer
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: http://serverfault.com/questions/442841/unable-to-start-sql-service-when-tcp-ip-is-enabled-under-sscm-ss-network-confi 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 wrong with the application, is the SQL, the Network, the Firewall or something.I need the suggestion for fixed this problem.Thank's http://www.sqlservercentral.com/Forums/Topic142300-131-1.aspx 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 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 LoginSoftware Troubleshooting and Assistance Internet Security and Malware Help SQL Server error 10048 Custom Search Join the PC homebuilding revolution! Read the all-new, FREE 200-page online guide: How to Build Your Own PC! http://www.pcguide.com/vb/showthread.php?22863-SQL-Server-error-10048 NOTE: Using robot software to mass-download the site degrades the server and is prohibited. See here for more. Find The PC Guide helpful? Please consider a donation to The PC Guide Tip Jar. Visa/MC/Paypal http://heelpbook.altervista.org/2013/could-not-start-the-sql-server-on-local-computer-error-code-10048/ accepted. If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link sql server above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: SQL Server error 10048 Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… 06-03-2003,08:20 AM #1 Roady View Profile View Forum Posts View Blog Entries View Articles Computer Analyst Join Date Jan 2002 Location Lancashire UK Posts 291 SQL Server 10048 error sql error 10048 Anybody help with this isssue where the PC is on a domain and can see the network ok but when I setup ODBC SQL Server it comes with the error of 10048. [TCP/IP sockets] connection open (connect) Connection failed SQL State 08001 SQL server error 11 General network error Advise please Thanks Roady!! 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 Intel 775 CPU Cooler Asus en8800 Extreme nVidia GTX768MB Scythe Kama-Meter Multifunction Fan Controller LG GGW-H20L Blu-ray Disc Rewriter & HD DVD ROM ASUS P5N-T Deluxe nForce 780i Socket 775 Motherboard Dual boot XP64Bit\Vista64Bit Reply With Quote 06-03-2003,10:28 AM #2 Ghost_Hacker View Profile View Forum Posts View Blog Entries View Articles Net-Tech-Fu Sensei Join Date Jan 2001 Location Unimatrix Zero-one Posts 2,273 Have you checked that your server is listening on port 1433 TCP? (Use Telnet and telnet to that port on your server) If TCP/IP is not working switch the net-library your client uses to the named pipes or Multiprotocol one. (this link should help : http://msdn.microsoft.com/library/de...lient_7v03.asp) Hope this helps Ferengi Rules of Acquistion: Rule # 47 Don't