I have tried both the platform and the web platform tool. Both fail. Consistently. Uninstall usually fails too ("stopped working" right at the end). I've manually ensured files were deleted (whacked the entire folder too) before re-installing. To no
avail.
I tried the step of just ignoring the failure message. It LOOKED okay, but after everything else installed fine, I couldn't connect to SQL Server at all. I stopped the service, and it refused to start again. I tried a repair install, and it couldn't repair
it because it said the SQL core components had never been successfully configured.
I'm at my wits end here. On a different laptop, everything installed fine. The only difference is that this laptop is Win7-64bit.
And yes, the installer is buggy, given it consistently says that it cannot install becuase a file already exists, when I've verified that file does NOT exist prior to install. And that I'm not the only one having this issue. The system was clean when I
started. It's a brand new laptop that I was just trying to set up a development environment on. Of course, god knows what state it is in now...
I've tried a half dozen times at least. If I use the web platform installer, I get the "file already exists" error, no matter what I do. If I use the platform installer, I get the error "SQL Server 2008 R2 Setup -- '' is not a valid login or you do not
have permission.", followed by the installer crashing. Every time. Nothing I do or try seems to make any difference. I've tried changing the instance name (using the platform installer), I've tried using mixed authentication instead of just windows authentication.
I've uninstalled and reinstalled until I'm pulling my hair out and blue in the face.
Buried in those instructions was a statement that SQL Server 2008 R2 cannot install on a default user. I find this amazing, and consider it a bug, but at least I identified the problem.
I had a stock Dell laptop, configured directly, with just one account. By default that account is the name of the machine. So LAPTOP\LAPTOP was the user everything was installed with. And everything in the world is fine with this except for SQL Server
2008 R2. So yes, I consider it a bug. Not just that it doesn't work,but that it doesn't warn you it doesn't work.
I spent hours creating a new user, and then migrating everything over to that user (email, application settings, reconfiguring everything that didnt' transfer over). I then ran the web platform setup again, and this time it worked flawelessly.
So thank you for your help. I'm up and running again, but not without a lot of pain, and over something that I feel never should have been an issue to begin with. I hope you're able to report this back to the SQL Server 2008 R2 Express install team, because
it's kind of inexecusable that this is the only product under the sun that can't install successfully under LAPTOP\LAPTOP, but can under LAPTOP\MyUser.
HCamper
8048 Posts
Re: Failed to Install SQL Server Express 2008 R2
Sep 05, 2011 07:01 AM|LINK
Hello @ pmAustin,
Have you done all the steps in Richard's Trouble Shooting guide ?
Are you installing SQL Server Express 2008 R2 using the Web Platform Tool or are you installing the stand-alone package ?
Since your installing SQL Server Express 2008 R2 have you posted your questions and issues
at the SQL Server Forums http://social.msdn.microsoft.com/Forums/en/sqlexpress/threads ?
The SQL Server Express 2008 R2 installer is not "buggy" it has been updated and refined from
the logs provided by previous users help with the differences for which Windows type edition and other installed applications.
If the guide by Richard does not resolve the problems you should create a new post / thread
with the logs and information as indicated in Ricahrds Guide along with information about you system.
After you have created the post / thread the forum users will try and help.
Martin
Community Member Award 2011
pmbAustin
3 Posts
Re: Failed to Install SQL Server Express 2008 R2
Sep 05, 2011 08:34 AM|LINK
I have tried both the platform and the web platform tool. Both fail. Consistently. Uninstall usually fails too ("stopped working" right at the end). I've manually ensured files were deleted (whacked the entire folder too) before re-installing. To no avail.
I tried the step of just ignoring the failure message. It LOOKED okay, but after everything else installed fine, I couldn't connect to SQL Server at all. I stopped the service, and it refused to start again. I tried a repair install, and it couldn't repair it because it said the SQL core components had never been successfully configured.
I'm at my wits end here. On a different laptop, everything installed fine. The only difference is that this laptop is Win7-64bit.
And yes, the installer is buggy, given it consistently says that it cannot install becuase a file already exists, when I've verified that file does NOT exist prior to install. And that I'm not the only one having this issue. The system was clean when I started. It's a brand new laptop that I was just trying to set up a development environment on. Of course, god knows what state it is in now...
I've tried a half dozen times at least. If I use the web platform installer, I get the "file already exists" error, no matter what I do. If I use the platform installer, I get the error "SQL Server 2008 R2 Setup -- '' is not a valid login or you do not have permission.", followed by the installer crashing. Every time. Nothing I do or try seems to make any difference. I've tried changing the instance name (using the platform installer), I've tried using mixed authentication instead of just windows authentication. I've uninstalled and reinstalled until I'm pulling my hair out and blue in the face.
Needless to say I'm very frustrated.
HCamper
8048 Posts
Re: Failed to Install SQL Server Express 2008 R2
Sep 05, 2011 09:06 AM|LINK
Hi,
I am sorry you have problems with SQL Server 2008 R2 and installs and repairs and uninstall.
You have done this "I have tried both the platform and the web platform tool." and "Both fail" with problems.
You had problems with the "Uninstall" which fails. Yes your system maybe in an "unknown" state.
To resolve the issues for SQL Server 2008 R2 install you need to create a new post / thread.
In the new post / thread include details and information about your system and post the logs.
After the thread /post has been created members users will try and help.
For this thread the user did resolve the problems and issues using Richards Trouble Shooting guide for their system.
Martin
Community Member Award 2011
pmbAustin
3 Posts
Re: Failed to Install SQL Server Express 2008 R2
Sep 05, 2011 07:38 PM|LINK
Buried in those instructions was a statement that SQL Server 2008 R2 cannot install on a default user. I find this amazing, and consider it a bug, but at least I identified the problem.
I had a stock Dell laptop, configured directly, with just one account. By default that account is the name of the machine. So LAPTOP\LAPTOP was the user everything was installed with. And everything in the world is fine with this except for SQL Server 2008 R2. So yes, I consider it a bug. Not just that it doesn't work,but that it doesn't warn you it doesn't work.
I spent hours creating a new user, and then migrating everything over to that user (email, application settings, reconfiguring everything that didnt' transfer over). I then ran the web platform setup again, and this time it worked flawelessly.
So thank you for your help. I'm up and running again, but not without a lot of pain, and over something that I feel never should have been an issue to begin with. I hope you're able to report this back to the SQL Server 2008 R2 Express install team, because it's kind of inexecusable that this is the only product under the sun that can't install successfully under LAPTOP\LAPTOP, but can under LAPTOP\MyUser.
HCamper
8048 Posts
Re: Failed to Install SQL Server Express 2008 R2
Sep 06, 2011 06:48 AM|LINK
Hi,
Glad you fixed the problems:D
You can post to the Web Matrix Team http://webmatrix.uservoice.com/ .
for your problems & issues the Web Matrix Team can forward the information.
Martin
Community Member Award 2011