{"id":124,"date":"2012-08-21T12:04:23","date_gmt":"2012-08-21T12:04:23","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=124"},"modified":"2013-12-28T06:47:26","modified_gmt":"2013-12-28T06:47:26","slug":"windows-could-not-start-sql-server-sqlexpress-on-local-computer","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/windows-could-not-start-sql-server-sqlexpress-on-local-computer\/","title":{"rendered":"Windows could not start SQL Server (SQLEXPRESS) on local computer. For more information, review the system log."},"content":{"rendered":"

Error:<\/strong><\/p>\n

Windows could not start SQL Server (RELYONDB) on local computer. For more information, review the system log.<\/p>\n

Error Message:<\/strong><\/p>\n

\"\"<\/a><\/p>\n

Causes:<\/strong><\/p>\n

    \n
  1. Give correct system name and instance name.<\/li>\n
  2. VIA protocol might be enabled and it may be using port 1433.<\/li>\n
  3. SQL Browser service might be stopped\/disabled.<\/li>\n
  4. SQL Server service might be stopped or disabled.<\/li>\n
  5. SQL Server might be corrupted need to reinstall and attach the data files.<\/li>\n<\/ol>\n

    Workaround 1:<\/strong><\/p>\n

    Enable Using both TCP\/IP and Named Pipes:<\/p>\n

    All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Configuration Manager| SQL Server Network configuration| Right Click “Named Pipes” & Click Enable > Right Click “TCP\\IP” & Click Enable<\/p>\n

    Restart SQL Server RELYONDB and SQL Server Browser service.<\/p>\n

    Workaround<\/strong>\u00a02:<\/strong><\/p>\n

    Enable Using both TCP\/IP and Named Pipes:<\/p>\n

    All programs | Microsoft SQL Server 2005| Configuration Tools | SQL Server Surface Area Configuration | Configuration for Services and Connections | Remote Connections, choose Local and Remote Connections |Enable Using both TCP\/IP and Named Pipes.<\/p>\n

    Restart SQL Server RELYONDB & SQL Server Browser service.<\/p>\n

    Workaround<\/strong>\u00a03:<\/strong><\/p>\n

    Click Start | Run | type firewall.cpl | Switch Off | Click OK.<\/p>\n

    or<\/p>\n

    Create an exception in windows firewall.<\/p>\n

    Add TCP port or sqlservr.exe to Firewall exception list, either add “..\\Binn\\sqlsevr.exe” or add port.<\/p>\n

    Add Sql Browser service to Firewall exception list, you can either add program ” C:\\Program Files\\Microsoft SQL Server\\90\\Shared\\sqlbrowser.exe” or add UDP port 1434.<\/p>\n","protected":false},"excerpt":{"rendered":"

    Error: Windows could not start SQL Server (RELYONDB) on local computer. For more information, review the system log. Error Message: Causes: Give correct system name and instance name. VIA protocol might be enabled and it may be using port 1433. SQL Browser service might be stopped\/disabled. SQL Server service might be stopped or disabled. SQL […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/124"}],"collection":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/comments?post=124"}],"version-history":[{"count":0,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/124\/revisions"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=124"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=124"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}