locked
SQL Login failed for user 'domain\Administrator' during CRM 4.0 installation RRS feed

  • Question

  • Hi

    I am Trying to install CRM 4.0 on a windows server 2008 and on the last page when everything is installing I am getting Login failed for user 'domain\Administrator' CRM under SQL Server, I am logged it as the built-in adminstrator account. Do you have any suggestions?

    Regards

    Mahesh

    Monday, October 25, 2010 11:26 AM

Answers

  • Hi Mvaghji,

     

    Based on the error message "Error: 18456, Severity: 14, State: 11.", the reason mostly is the account Domain\Administrator is not a login yet for your SQL Server.

     

    To fix this issue, we need to add Domain\Administrator to your SQL Server, please follow these steps:

     

    1.       Log in SQL Server Management Studio with a login which has appropriate permission such as Create Login.

    2.       Expand Security, right click on Logins, select New Login, Select Windows Authentication.

    3.       On the General panel, enter the name Domain\Administrator in the Login Name box..

    4.       In the Server Roles panel, we could grant this login sysadmin role temporary.

    5.       Click OK.

     

     

    Please refer to this link http://msdn.microsoft.com/en-us/library/dd207004.aspx about how to create a SQL Server Login.

     

    Please feel free to ask if you have any more questions.

     

    Thanks,
    Weilin Qiao

    • Marked as answer by Tom Li - MSFT Monday, November 8, 2010 2:56 AM
    Friday, October 29, 2010 6:49 AM

All replies

  • whats the error in SQL ERRORLOG?
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Monday, October 25, 2010 11:49 AM
  • Windows Server 2008 has user access control (UAC). If you wish to use your administrator credentials you must start the program with the "Run as Administrator" option. Try that. If it works, add your domain login as a SQL Server login so you don't have to run as administrator on a routine basis.


    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
    Monday, October 25, 2010 3:22 PM
  • Hi

    This is the error that is shown in the SQL Log:

    2010-10-21 17:53:44.29 Logon       Login failed for user 'Domain\Administrator'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]
    2010-10-21 17:57:05.25 Logon       Error: 18456, Severity: 14, State: 11.

    And Rick I tried your suggestion but it did not help.

    Regards

    Mahesh

    Tuesday, October 26, 2010 2:36 PM
  • First thing I would ask to try is that if you can use SQL Authentication, try that. its the easiest way.

    Coming back to error, account which is being used is not a "direct" sysadmin. I would suggest to add 'Domain\Administrator' account as sysadmin in SQL as login. Well, to be very frank, this error has a lot of reasons. If you can get the output of ring buffer, it can help in troubleshooting. But I would suggest to add logged on account as sysadmin directly to fix.


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    • Proposed as answer by WeiLin Qiao Thursday, October 28, 2010 7:22 AM
    Tuesday, October 26, 2010 2:48 PM
  • Hi Balmukund

    I have tried to login as sa but I cannot, I have tried logging in as sa/blank and sa/sa still doesn't work is there any other defaults.

    Regards

    Mahesh

    Tuesday, October 26, 2010 3:32 PM
  • this would help in making youself as sysadmin and reset sa password
    http://msdn.microsoft.com/en-us/library/dd207004.aspx

    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    • Proposed as answer by WeiLin Qiao Thursday, October 28, 2010 7:22 AM
    Tuesday, October 26, 2010 3:37 PM
  • It may be time for you to login this way, and see what logins exist in SQL Server: Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out http://msdn.microsoft.com/en-us/library/dd207004.aspx
    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
    Tuesday, October 26, 2010 3:38 PM
  • I tried -m switch however when I put this infront of the startup parameters it doesn't startup after the restart until I delete the -m switch

    Tuesday, October 26, 2010 7:56 PM
  • mostly switch was not added properly. When you add the switch and SQL is not starting, have a look at errorlog and it should give you some pointers.
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Wednesday, October 27, 2010 12:10 AM
  • Hi Mvaghji,

     

    Based on the error message "Error: 18456, Severity: 14, State: 11.", the reason mostly is the account Domain\Administrator is not a login yet for your SQL Server.

     

    To fix this issue, we need to add Domain\Administrator to your SQL Server, please follow these steps:

     

    1.       Log in SQL Server Management Studio with a login which has appropriate permission such as Create Login.

    2.       Expand Security, right click on Logins, select New Login, Select Windows Authentication.

    3.       On the General panel, enter the name Domain\Administrator in the Login Name box..

    4.       In the Server Roles panel, we could grant this login sysadmin role temporary.

    5.       Click OK.

     

     

    Please refer to this link http://msdn.microsoft.com/en-us/library/dd207004.aspx about how to create a SQL Server Login.

     

    Please feel free to ask if you have any more questions.

     

    Thanks,
    Weilin Qiao

    • Marked as answer by Tom Li - MSFT Monday, November 8, 2010 2:56 AM
    Friday, October 29, 2010 6:49 AM
  • Thank you so much. This solved my issue. Appreciate it.
    Friday, February 24, 2017 3:30 AM