Errow during sql server 2008 installation

shyamraoo
shyamraoo Member Posts: 38
edited 2010-07-30 in SQL General
please solve this error.......
Regards,

N.Shyam Kumar

Comments

  • aavio
    aavio Member Posts: 143
    It occurs when you computer name is same as your username.
    aav!o
  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Resolution is quite simple - use different account name, if you must use the same name for both machine and account use different account for installation and then change account name under which SQL is supposed to run later after installation.

    As for me reason seems to be simple - however it is just a wild guess: Most probably if your logon name is the same computer name most probably internal code trying to login recognises account name as a computer name followed by empty name.

    So CompAndAccountName is translated to CompAndAccountName\"", instead of
    CompAndAccountName\CompAndAccountName

    Any other name entered as AccountName without domain or computer name would be interpreted as ComputerName\AccountName

    Bear in mind that using the same name for both computer and account on the computer might be misleading as by default the computer name (with $ character added) is used for NETWORK SERVICE account.

    Regards,
    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

Categories