I am currently downloading the mega-sized files for SQL Server 2005 Express Edition and was wondering if I was going to be able to install it onto my workstation alongside the SQL Server 2005 Developer Edition Was hoping someone could advise. I did browse for an answer, but have not come across it yet. I know I'll find out once my download is complete, but that could be awhile :)
Thanks,
-Neil
SQL Server 2005 Developer Edition and SQL Server 2005 Express Edition on same machine?
esteth
You can install both engines but the management tools will not install on the same machine. At the moment I am running the team system version of the IDEs as well as the express versions.
The good thing about the Express IDES is that they install an instance of the database under ".\SQLEXPRESS" by default, and generally the Dev edition of SQL installs as a default instance on the system. I have found that on my main desktop I have the SQL Management studio for the Dev version installed, and can not install the express management tools. But on my laptop I have the same Dev Ides installed and no SQL Dev Install... But I do have the express management tools.
With the 1406 Error I would make sure that you are running with full admin permissions on the box, if that does not work, adjust the permissions so that the user you have can write to the registry and the system folders on the machine.
sladoid
You should be able to install the express engine although there might be a problem with reporting and tools.
Is there an error
awm129
Well, I downloaded SQL Server 2005 Express and tried to install it, but no-go. Is there something basic I am missing here in my understanding I have SQL Server 2005 Developer Edition installed on my machine for web development. I wanted to install SQL Server Express edition because I am contemplating a desktop application for which I would need a freely distributable data store mechanism.
Do I need both of them installed because SL Server 2005 is giving out some strange errors when I try to install it (no, I didn't capture the errors, figured I'd do it again and write them down). I am on SQL Server 2005 SP1, and am tryign to install the download of SQL Server 2005 Express, which I believe is not SP1.
Thank you for any advice you can provide,
-Neil
vbmon
I may be having similar problems. I have had SS2005 DevEd installed on my machine and am now trying to install Visual Web Developer 2005 Express (and Visual C# 2005 Express, along with the MSDN libs) and SS 2005 Express on the same box.
I am working over in the Express Editions Installation forum to get a handle on why I cannot successfully install VWD (or, for that matter, VC# Express). The issue is a registry issue (Error 1406) and so far, we cannot seem to pin the problem on any of the usual suspects. I wondered if having two versions of SS2005 on the same box was part of the problem.
My suspicion is that this is not the issue/cause, since the VCD install seemed to blow up on the very first registry attempt and we never got around to installing the SS 2005 Express. However, the installation failure might have something to do with the version of VS 2005 that comes with SS 2005 DevEd (for Reporting Services and BI work).
Seems pretty much bolluxed up from this end. I hope all of the trolls on the anti-MS blogs don't get wind of this - I was championing the wisdom of MS in bringing out these Express versions. Now this emporor has run out of clothes.