Monday, August 2, 2010

SQL 2008 R2 Setup Error -'' is not a valid login or you do not have permission.

This time i had face another one issue. When I was trying to install SQL 2008 R2 enterprise edition on my laptop i got below error.

The following error has occured:
'' is not a valid login or you do not have permission.

This error occurs when system name and login names are same. My laptop and login names are same.
This error occurs after adding my login accounts in "Specify SQL Server administrators" on "Database Engine Configuration" tab.


How to get rid this error?

We can achieve this goal using 2 methods.
1. Login in two another windows login account and install.
2. Do not add your account and add another account which name is differ from system. I have used VM.

I have tried both methods and succeeded.

4 comments:

  1. This is a problem I was running into while trying to set up SQL Server 2008 R2 on a customer’s laptop so he could use some goofed up Business Contact plugin. As it took me quite a while to find the proper solution to this problem I thought I’d publish it here with the hopes of someone else benefiting from my wasted time researching it.

    So the scenario is that you go through the installation of SQL server and at the very end it tells you it failed epicly and none of your instance-specific server setup completes. The explanation of the failure? ” is not a valid login or you do not have permission. The cause of said failure? Your computer name and username are the same.

    Solution: Change your computer name and reinstall SQL Server.

    ReplyDelete
  2. I've installed SQL Server 2008 R2 on 6 different PC's over the last year or so. Not a single one has completed without some error first time.

    Just saying...

    ReplyDelete
  3. This error occur because your user name is same as computer name ( ex: QTMK2/QTMK2 (qtmk2) )
    You must change your computer name to another name (ex: QTMK2 -> Ramesh-PC)

    ReplyDelete
    Replies
    1. Or Add another account on your computer. (ex: add account Administrator)

      Delete