Skip to content

Sql Server 2008 Express Setup Woes

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.

sql-install-error

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.

VN:F [1.9.1_1087]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.1_1087]
Rating: 0 (from 0 votes)
Bookmark and Share
kick it on DotNetKicks.com
Shout it

NOW, FOR A WORD FROM OUR SPONSORS

Post a Comment

Your email is never published nor shared. Required fields are marked *
*
*
My name is Graham O'Neale and I'm a software architect from Gold Coast, Australia. I am an overtime thinker, full time coder and awake part time in the real world. I have a keen interest in software development, particularly in the realm of programming (C#, ASP.NET, ASP.NET MVC, LINQ (2 SQL), Entity Framework, Silverlight, Blend, WCF, WPF) and a keen interest in the cutting edge and innovation. I have a new found love for design patterns, ALT.NET practices and well crafted software architecture. The purpose of this blog is to express any thoughts, findings, tips and gripes along my travels in the wonderful world of coding and technology...