Search This Blog

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.

18 comments:

GrahamS said...

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

Orlin said...

You saved me! Thank you very much!

Pronojit said...

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

ZEA said...

Thanks so much!!!!

Anonymous said...

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

askaline said...

thank youuuuuuuuuuuuu !

alpha777 said...

Thank you so much youre a life saver !!!

RGranada said...

Thank you very much!

Anonymous said...

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

Manja Kucen said...

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.

Anonymous said...

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

Martin said...

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. :)

Sarah said...

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

Eric March said...

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

Selva said...

Grt info, helped me a lot.

scheffer said...

Muitos Thank you pra vc

Trịnh Hữu Tình said...

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

Unknown said...

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