When running the SQL Server 2008 Express installer I go through all the steps and then the installation begins, then just before completion I receive:
'' is not a valid login or you do not have permission.
So I was tearing my hair out on this one. I’m running Windows Vista SP1 and using the latest SQL Server 2008 Express installer, after scouring the net for hours and not really finding anything at all, except for a ton of diagnosis’ for this problem which weren’t even applicable I came across this article which discussed a little more closely that it could be related to account privileges and permissions. The issue isn’t actually about ensuring you are “logged in” as an Administrator, running the installer with administrative privileges will do just fine, but you just need to make sure you have clicked “Add” and select or type “Administrator” and click “OK” within the “Database Engine Configuration” area in the SQL Installer Dialog! See here.

I couldn’t believe this!!!! I tried a combination of my own login, administrator login with my login, but not administrator by itself. Sigh. So I guess having my own account in there stuffed it. Oh well, thank god this issue is fixed and what the hell is with the ambigious, vague and untested process in that installer.
Post a Comment