error while installing sql server database engine

  • login failed for user ('laasya/laasya')(microsoftsqlservererror:18456) and I am trying to install sql server 2008 r2 in windows 8 32-bit

    Overall summary:

    Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

    Exit code (Decimal): 956696909

    Exit message: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.

    Start time: 2014-06-12 06:31:59

    End time: 2014-06-12 07:31:13

    Requested action: Install

    Machine Properties:

    Machine name: LAASYA

    Machine processor count: 2

    OS version: Future Windows Version

    OS service pack:

    OS region: United States

    OS language: English (United States)

    OS architecture: x86

    Process architecture: 32 Bit

    OS clustered: No

    Product features discovered:

    Product Instance Instance ID Feature Language Edition Version Clustered

    Package properties:

    Description: SQL Server Database Services 2008 R2

    ProductName: SQL Server 2008 R2

    Type: RTM

    Version: 10

    SPLevel: 0

    Installation location: D:\SQL Server 2008 R2 Dev\en_sql_server_2008_r2_developer_x86_x64_ia64_dvd_522665\x86\setup\

    Installation edition: DEVELOPER

    User Input Settings:

    ACTION: Install

    ADDCURRENTUSERASSQLADMIN: False

    AGTSVCACCOUNT: NT AUTHORITY\SYSTEM

    AGTSVCPASSWORD: *****

    AGTSVCSTARTUPTYPE: Disabled

    ASBACKUPDIR: C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Backup

    ASCOLLATION: Latin1_General_CI_AI

    ASCONFIGDIR: C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Config

    ASDATADIR: C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data

    ASDOMAINGROUP: <empty>

    ASLOGDIR: C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Log

    ASPROVIDERMSOLAP: 1

    ASSVCACCOUNT: NT AUTHORITY\SYSTEM

    ASSVCPASSWORD: *****

    ASSVCSTARTUPTYPE: Disabled

    ASSYSADMINACCOUNTS: LAASYA\Laasya

    ASTEMPDIR: C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Temp

    BROWSERSVCSTARTUPTYPE: Automatic

    CONFIGURATIONFILE: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140612_062946\ConfigurationFile.ini

    CUSOURCE:

    ENABLERANU: False

    ENU: True

    ERRORREPORTING: False

    FARMACCOUNT: <empty>

  • Are you an administrator on the machine?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • I faced the login failed for user error while installation and it was because of password for log on account I used to start services was expired.

    Check whether the password for user ('laasya/laasya') is expired during installation.

  • yes

  • my I know how to check password expire... please

  • Look it up in Active Directory

  • The SQL Server install will fail if both the account running the install and domain name are the same.

    Create a different account on your machine and rerun the install using the new account.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • That is an interesting 'esoteric' fact - WOW !

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • EdVassie (6/17/2014)


    The SQL Server install will fail if both the account running the install and domain name are the same.

    Create a different account on your machine and rerun the install using the new account.

    Do you have any resources on this interesting behaviour?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Sorry, I should have said the install will fail if the account running the install and the machine name (not the domain name) are the same.

    I have not been able to find many references to this today, I am sure I got this information from a Microsoft posting. However, this shows the same problem: http://dotnetfish.blogspot.co.uk/2009/02/error-is-not-valid-login-or-you-do-not.html

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • EdVassie (6/18/2014)


    Sorry, I should have said the install will fail if the account running the install and the machine name (not the domain name) are the same.

    I have not been able to find many references to this today, I am sure I got this information from a Microsoft posting. However, this shows the same problem: http://dotnetfish.blogspot.co.uk/2009/02/error-is-not-valid-login-or-you-do-not.html

    Ok thanks!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply