Pages

▼

Monday, February 9, 2009

Installation SQL 2008 Express Error: '' is not a valid login or you do not have permission

This is a very strange error. I've received error message "'' is not a valid login or you do not have permission" when trying to install Microsoft SQL Server 2008 Express Edition in my Microsoft XP Pro SP3 Machine.

To know more on installation guide, please check Install and Configure SQL Server 2008 Express by CondorMan.

I've followed the steps and got error message "'' is not a valid login or you do not have permission." and print screen as below.



I have no idea why is this. I've tried few suggestion stated in some of the forum:


  1. I've tried to change my user name and try to install.
  2. Create a new user "sa" with strong password. Login to window using this account and do installation.
Both methods fail.

Finally, i try to rename my machine/computer name and try to install and the installation completed successfully.




Conclusion:
This may be a bug from microsoft but i'm not sure.

My scenario: computer name = my user account

My Solution: change computer name to != user account then do installation.

p/s: Change user account won't help.

Hope this can help you. Share your solution if you have different one.
at

18 comments:

  1. AnonymousFebruary 9, 2009 at 2:40 PM

    That sounds frustrating!

    If you're looking for a hybrid reporting software that is easy to use yet powerful check out Windward Reports' at www.WindwardReports.com

    ReplyDelete
  2. OrlinMarch 16, 2009 at 9:56 AM

    You saved me! Thank you very much!

    ReplyDelete
  3. PronojitMarch 2, 2010 at 6:51 AM

    Thank you very much .... You save the day...

    ReplyDelete
  4. ZEAMarch 4, 2010 at 9:38 PM

    Thanks so much!!!!

    ReplyDelete
  5. AnonymousMarch 22, 2010 at 6:43 AM

    gr8...working finally in my virtual server.Thanks alot....

    ReplyDelete
  6. askalineApril 8, 2010 at 7:45 AM

    thank youuuuuuuuuuuuu !

    ReplyDelete
  7. UnknownMay 18, 2010 at 1:08 PM

    Thank you so much youre a life saver !!!

    ReplyDelete
  8. RGranadaJune 3, 2010 at 7:39 AM

    Thank you very much!

    ReplyDelete
  9. AnonymousJuly 29, 2010 at 10:13 PM

    I am saved by you too.
    Thank you so much!!

    ReplyDelete
  10. UnknownAugust 10, 2010 at 8:19 PM

    thank you thank you thank you thank you thank you thank you thank you thank you..

    never thought the solution is like this. but thank you so much.

    ReplyDelete
  11. AnonymousAugust 15, 2010 at 4:00 AM

    I tried for hours before i read your tip. You saved me !
    Gerhard

    ReplyDelete
  12. MartinAugust 31, 2010 at 4:23 AM

    Thank you, for the information. I have had trouble with this for some time, but now it works. Well, I can get it to work - I guess it is not correct to say it works, when the SQL installer behaves like that. :)

    ReplyDelete
  13. UnknownOctober 19, 2010 at 6:10 PM

    Eric March Adelaide
    Computer Name and User name must not be the same. Changed computer name all is well. Thankyou heaps

    ReplyDelete
  14. Eric MarchOctober 19, 2010 at 6:12 PM

    Computer name and user name cannot be the same.
    Changed computer name
    All is good. Thanks heaps.

    ReplyDelete
  15. UnknownMay 8, 2011 at 5:32 AM

    Grt info, helped me a lot.

    ReplyDelete
  16. schefferAugust 29, 2011 at 6:45 AM

    Muitos Thank you pra vc

    ReplyDelete
  17. Trịnh Hữu TìnhNovember 4, 2011 at 1:57 AM

    thanks you alot. You save our times. thanks.s.s.s.

    ReplyDelete
  18. UnknownMarch 19, 2014 at 8:12 AM

    Wow, it worked! Thanks a lot sir! I will definitely click the ad :P

    ReplyDelete

Please don't spam!