Home > Sql Server > Sql Server Error Code 10048

Sql Server Error Code 10048

Contents

Join 15 other subscribers Email Address Social SQLEXPRESS : Windows could not start the SQL Server (SQLExpress) on local Computer. any advise ? You cannot edit other posts. Can anyone shed ANY light on how to deal with this on a Win XP machine? have a peek at this web-site

Reply bbcompent1 All-Star 33866 Points 9480 Posts Moderator Re: SQLServer 2008R2 install but SQLService wont start Nov 07, 2013 10:33 AM|bbcompent1|LINK Now, if you require it to be a Domain user, Mark as answer posts that helped you. Recent posts Unable to Sync > FederatedUser.UserPrincipalName is not valid Convert Shared mailbox to regular AADConnect > Azure Active Directory did not register a synchronization attempt > No Synchronization Management Log ALL the fixes out there refer to commands such as "cluster res" which do not exist in Win XP Pro. 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.

Post #170638 adamcrvadamcrv Posted Monday, April 11, 2005 6:26 PM SSC Veteran Group: General Forum Members Last Login: Monday, September 3, 2007 10:17 PM Points: 210, Visits: 1 HI,Ive seen the Removing brace from the left of dcases Who is spreading the rumour that Santa isn't real? ¿Cuál es la razón por la que se corrije "yo y tú" a "tú y Now to figure out why having TCP/IP enabled prevented my primary instance from starting after SQL2014 SP1 update.

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 Please, someone, any one... SIGH. 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

SERVERNAME, 1435 - working Now any idea why instance name is not working like this ? Windows Could Not Start The Sql Server (mssqlserver) Service On Local Computer Browse other questions tagged sql-server windows-server-2008-r2 sql-server-2008-r2 or ask your own question. 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. I'm going totally crazy here.

Why are there no toilets on the starship 'Exciting Undertaking'? I have some test servers with 2005, 2008 R2 and 2012. VIA does not need to be disabled, just TCP/IP. You cannot post replies to polls.

  1. 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.
  2. When starting the service I received the error : Windows could not start the SQL Server (SQLExpress) on local Computer.
  3. Monday, January 21, 2013 7:40 PM Reply | Quote 0 Sign in to vote Well, I'm going to simply reinstall the SQL database since I can't do any of the fixes
  4. Just an idea: Option 1: Do you thinkconnecting with ServerName,PortNumber can work ?
  5. Solution: First check the event log for the correct error So this port is already in use by another application Start your command prompt Execute : netstat -ab > netstartport.txt
  6. for more, windows could not start the sql server reporting services (mssqlserver) service on local computer, windows could not start the sql server reporting services error 1053, windows could not start
  7. FYI, I attempted to run the GUI clusterrecovery.com but it failed miserably.

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

Make text field readonly Lagrange multiplier on unit sphere Rebus: Guess this movie Disease that requires regular medicine Stockholm public transport on 26th December Eating Skittles Like a Normal Person Steam http://heelpbook.altervista.org/2013/could-not-start-the-sql-server-on-local-computer-error-code-10048/ Servername\instance2008 ? Server Tcp Provider Failed To Listen On [ 'any' 1433]. Tcp Port Is Already In Use. I don't see any option that says about remote connections Update: I have already done this http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx but still not able to connect via other machine on same server (but I Sql Server Could Not Spawn Fruncm Thread I can get the local server to load by disabling TCP/IP in SSCM.

Too much time wasted. http://cpresourcesllc.com/sql-server/sql-server-raiserror.php You cannot edit other topics. All Rights Reserved. current community blog chat Server Fault Meta Server Fault your communities Sign up or log in to customize your list. Only One Usage Of Each Socket Address Protocol Network Address Port Is Normally Permitted

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 Reply jeffcarter Member 81 Points 1439 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 ? Source I just ran the command and I don't see 1435: ms-sql-s 1433/tcp #Microsoft-SQL-Server ms-sql-s 1433/udp #Microsoft-SQL-Server ms-sql-m 1434/tcp #Microsoft-SQL-Monitor ms-sql-m 1434/udp #Microsoft-SQL-Monitor ms-sna-server 1477/tcp ms-sna-server 1477/udp any way to make 1435

Reply jeffcarter Member 81 Points 1439 Posts Re: SQLServer 2008R2 install but SQLService wont start Nov 07, 2013 11:26 AM|jeffcarter|LINK Where in sql server configuration I can do this ? Right clicking the TCP/IP option there is an option to set 'Listeners' to all. Does this machine have a built-in firewall?

Error 1068 To solve this problem go to Control Panel -> Local Services the right click on the service name and select Properties.

Could you do/have you donea repair on the SQL 2008 R2? Find The PC Guide helpful? Privacy Policy. Click Start > Run > Notepadc:\windows\system32\drivers\etc\services Inside there, find out if port 1434 is listed.

You may download attachments. that user must meet the requirements I gave you for it to be in charge of the service. Reply jeffcarter Member 81 Points 1439 Posts Re: SQLServer 2008R2 install but SQLService wont start Nov 07, 2013 12:02 PM|jeffcarter|LINK Just an update..when I looked into the rule in firewall for have a peek here Server 2012 IE error : Yo...

SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! increasing these does seem to help somewhat, however you should probobly be looking at your report first. I just changed the port from 1433 to 1434 for 2008 instance and it worked. I am experiencing the issue with SQL Server 2005 service not able to start when TCP/IP is enabled.

Visa/MC/Paypal accepted. If this is your first visit, be sure to check out the FAQ by clicking the link above. Reckoned ForceView ReckonedForceLLC's profile on FacebookView ReckonedF's profile on TwitterView reckonedforce's profile on LinkedInView dbandbi's profile on YouTubeView 108698554687166471705's profile on Google+Home Blog Analysis Services Big Data Cloud SQL Azure Content We've restricted the ability to create new threads on these forums. Now click on the Log On tab and switch from This Account to Local System account then click on OK to close the dialog.

and I do development on my computer at desk. I have done this config many times on other servers with no problem. Change syntax of macro, to go inside braces more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Have you tried connecting to the server from a machine that is on the same subnet?

No user action is required. 2013-01-21 10:56:43.54 spid5s Recovery is writing a checkpoint in database 'master' (1). Mark as answer posts that helped you. However, the VIA is not the issue. All rights reserved.

But this 2008 is causing this whole issue and I need to work with 2008 database. or adding a SQL alias to the client machine ? Not the answer you're looking for?