{"id":2461,"date":"2019-05-09T10:52:47","date_gmt":"2019-05-09T05:22:47","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=2461"},"modified":"2019-12-24T12:41:49","modified_gmt":"2019-12-24T07:11:49","slug":"windows-could-not-start-the-sql-server-relyondb-on-local-computer-for-more-information-review-the-system-event-log-if-this-is-a-non-microsoft-service-contact-the-service-vendor-and-refer-to-ser","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/windows-could-not-start-the-sql-server-relyondb-on-local-computer-for-more-information-review-the-system-event-log-if-this-is-a-non-microsoft-service-contact-the-service-vendor-and-refer-to-ser\/","title":{"rendered":"Windows could not start the SQL Server (RELYONDB) on local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417."},"content":{"rendered":"

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

Windows could not start the SQL Server (RELYONDB) on local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417.<\/p>\n

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

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

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

    \n
  1. This usually occurs when the master.mdf or the mastlog.ldf gets corrupt.<\/li>\n
  2. SQL Files may be compressed.<\/li>\n
  3. Permission Denied to DATA folder of SQL server.<\/li>\n<\/ol>\n

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

    Check event viewer for error log, based on the log recorded; perform the suitable work around mentioned below<\/p>\n

    WORKAROUND 2:<\/strong><\/p>\n

    If\u00a0 files in data folder are compressed<\/p>\n

    Go to the data folder selected all of the mdf files right clicked, advanced and unselect compression.<\/p>\n

    The file “C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\modellog.ldf” is compressed but does not reside in a read-only database or filegroup. The file must be decompressed.<\/strong><\/p>\n

    Steps:<\/strong><\/em><\/p>\n

    Go to the\u00a0folder\u00a0C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA\\ and select all the files<\/em><\/p>\n

    and right click<\/em>\u00a0advanced, uncheck, \u201cCompress contents to save disk space<\/strong>\u201d.<\/p>\n

    WORKAROUND 3:<\/strong><\/p>\n

      \n
    1. Open the SQL Server Configuration Manager<\/li>\n
    2. Open SQL Server 2005 Network Configuration<\/li>\n
    3. Right click on Protocols for RELYONDB and selected Properties<\/li>\n
    4. Set Force Encryption to No<\/li>\n
    5. Open SQL Server 2005 Services<\/li>\n
    6. Start SQL Server (RELYONDB)<\/li>\n<\/ol>\n

      WORKAROUND 4:<\/strong><\/p>\n

      Once you have that, check out the Security properties on the folder at C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\DATA to verify that the user has permissions to the folder. If they do not, you will either need to give the user permissions, or run SQL Express as a different user.<\/p>\n

      WORKAROUND 5:<\/strong><\/p>\n

      Before performing this work around make sure u have all you data base backup [copy of mdf and ldf files.<\/p>\n

      Identify the path from where SQl server service is referring to MASTER.MDF & MastLog.LDF, normally it will be from DATA folder; this can be identified from error logs, in LOG folder<\/p>\n

      Rename master.mdf and mastlog.ldf in DATA directory of SQL service, By doing this all the DATABASES which were attached to that particular SQl instance will be detached, we have to attach\/Restore all the\u00a0 DATABASES again.<\/strong><\/p>\n

      Go to \u00a0the path where SQL service \u00a0is installed , there you will find a folder \u201dTemplate Data\u201d , copy the master.mdf and mastlog.ldf and replace it in \u201cData\u201d folder Now start the MS SQL service and you are done, reattach all you data files from the required path.<\/p>\n

      In my case SQl service installed path was<\/p>\n

      \u201cC:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\\u201d<\/p>\n","protected":false},"excerpt":{"rendered":"

      Error: Windows could not start the SQL Server (RELYONDB) on local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417. Snapshot: Cause: This usually occurs when the master.mdf or the mastlog.ldf gets corrupt. SQL Files may be compressed. […]<\/p>\n","protected":false},"author":4,"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\/2461"}],"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\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/comments?post=2461"}],"version-history":[{"count":3,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/2461\/revisions"}],"predecessor-version":[{"id":2547,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/2461\/revisions\/2547"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=2461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=2461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=2461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}