March 26, 2008 at 12:17 am
I want to install a MSSQL on a windows vista PC. When i tried to insatll MSSQL 2000, i got the compatibility error. Please suggest me how to install the MSSQL server for the standalone use.
March 27, 2008 at 3:26 am
You cannot install SQL Server 2000 on Vista.
You can install some editions of SQL Server 2005 on Vista - Express, Workgroup, Developer.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
March 27, 2008 at 7:25 am
I run Vista on a laptop with 2GB memory and dual hard drives. I installed SQL Server Express 2005 and the available management tools with no problems. You'll want a lot of RAM as Vista alone uses a lot, and SQL Server loves its memory.
With the admin tools, I can manage my other SQL instances (2000/2005) on "real" servers and still have a local instance for testing, development, etc when not connected to the office LAN.
If you have a 2005 license available, it should work on Vista just fine. If not, check out the options at:
http://msdn2.microsoft.com/en-us/express/aa718379.aspx
I've installed both the "Advanced Services" and "Toolkit" together and have lot's of SQL Server functionality locally available.
Will
But boss, why must the urgent always take precedence over the important?
March 27, 2008 at 7:36 am
EdVassie (3/27/2008)
You cannot install SQL Server 2000 on Vista.You can install some editions of SQL Server 2005 on Vista - Express, Workgroup, Developer.
MSDE 2000 can be installed and run in Vista - just patch it immediately up to the latest SP. It seems to run better if you set it to run in Xp compatibility, with local admin access (I know - not great all of the time, but sill).
Just don't expect any support on it. If it gives you trouble, the "official channels" will dust you off due to the "not supported" byline.
--------------------
As to 2005 - keep in mind that you need to update to SP2 immediately. Just ignore the "this software has compatibility issues" messages, install the base product, and patch immediately upon finishing the install.
Also - be aware that a lot of the Vista version will give you headaches (read - won't let you) when you try to install SSRS, due to the missing Windows Authentication components. AFAIK, the only versions where it will install are Ultimate and Business.
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
March 27, 2008 at 10:09 am
sathyendrav,
You CAN install SS2000 Developer on Vista, there was a thread about that here:
http://www.sqlservercentral.com/Forums/Topic367417-5-1.aspx
You basically ignore the warnings and apply the latest service packs. The Vista Sync Center doesn't like it, but the thread mentions how to disable that.
It does work, but you are better off in the long run to get the 2005 Developer version.
March 27, 2008 at 4:53 pm
If you don't have a license for the developer edition of SQL Server 2005, Express is free, and you can always go the route of the time-limited evaluation copies. But if you go SQL Server 2005 on Vista, you'll need to have SP2 available as well and ensure you run the Vista provisioning tool as well (make sure the SQL Server service is running at the time).
K. Brian Kelley
@kbriankelley
March 28, 2008 at 9:50 am
Another option would be to setup a Server 2003 on a Virtual PC. they usually run better from an external drive, but since you have 2 HDs on your laptop, your can probably run it okay from your secondary HD.
March 28, 2008 at 11:35 am
Tom Garth (3/28/2008)
Another option would be to setup a Server 2003 on a Virtual PC. they usually run better from an external drive, but since you have 2 HDs on your laptop, your can probably run it okay from your secondary HD.
Very good point. In the case of Windows Server 2003 on a virtual, be ready to apply SQL Server 2000 SP4 once you get SQL Server 2000 installed.
K. Brian Kelley
@kbriankelley
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply