{"id":104,"date":"2012-08-21T11:41:44","date_gmt":"2012-08-21T11:41:44","guid":{"rendered":"http:\/\/techsupport.relyonsoft.in\/?p=104"},"modified":"2014-06-11T06:56:03","modified_gmt":"2014-06-11T06:56:03","slug":"sql-server-setup-could-not-connect-to-the-database-service-for-server-configuration","status":"publish","type":"post","link":"https:\/\/relyonsoft.in\/techsupport\/sql-server-setup-could-not-connect-to-the-database-service-for-server-configuration\/","title":{"rendered":"SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user ‘sa’. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see “How to View Setup Log Files” in SQL Server Books Online."},"content":{"rendered":"

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

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user ‘sa’. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see “How to View Setup Log Files” in SQL Server Books Online.<\/p>\n

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

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

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

    \n
  1. Due to improper SQL uninstallations, SQL Native client provider might be corrupted.<\/li>\n
  2. This error seems to be linked to missing or incorrect registry\u00a0entries. Uninstall everything related to SQL that might be on your computer.<\/li>\n
  3. Logged on user may not be an administrator. Administrator privileges is required to install SQL Server.<\/li>\n
  4. Due to improper SQL uninstallations, your registry is not clean and might be corrupted.<\/li>\n
  5. Disable password policy.<\/li>\n<\/ol>\n

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

    Make sure that you are running the SQL Server setup as \u201cRun as Administrator\u201d.<\/p>\n

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

    When\u00a0you are at the point of the failure, do not cancel the installation,<\/p>\n

    Run this registry SqlNativeClientRegistryConfiguration.reg<\/p>\n

    Download: SqlNativeClientRegistryConfiguration<\/a><\/p>\n

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

    Remove SQL Server 2005 completely from Control panel<\/p>\n

    Control Panel | Add or Remove Programs | Microsoft SQL Server 2005<\/p>\n

    In the first dialog, make sure to select the “RELYONDB: Database Engine” radio button.<\/p>\n

    If RELYONDB is the only instance, then select all check boxes & Click Next and Finish to proceed with the uninstall.<\/p>\n

    If there is no other SQL instance, I would go on to clean out all SQL components with the following steps.<\/p>\n

    Uninstall Microsoft SQL Server Native client<\/p>\n

    Uninstall Microsoft SQL Server Setup support files<\/p>\n

    Uninstall Microsoft SQL Server VSS writer<\/p>\n","protected":false},"excerpt":{"rendered":"

    Error: SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user ‘sa’. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see “How to View Setup Log Files” in SQL Server Books […]<\/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\/104"}],"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=104"}],"version-history":[{"count":0,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/posts\/104\/revisions"}],"wp:attachment":[{"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/media?parent=104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/categories?post=104"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/relyonsoft.in\/techsupport\/wp-json\/wp\/v2\/tags?post=104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}