Post reply

WINDOWS VISTA WITH SQL SERVER 2000

  • February 3, 2008 at 7:32 am

    #186253

    Hello, guys how are you doing?

    I am trying to install SQL server 2000 in windows Vista Ultimate but it gives me error and says -

    "SQL SERVER 2000 IS INCOMPATILBE WITH THIS VERSION OF WINDOWS"

    please guys i need help? :unsure:

    thanks

  • February 3, 2008 at 11:43 am

    #774594

    Install Microsoft SQL Server 2005 or Microsoft SQL Server 2008 instead.

    N 56°04'39.16"
    E 12°55'05.25"

  • February 3, 2008 at 4:16 pm

    #774609

    Pretty much that's your only option. Most DBs that were written for 2000 will work without problems in 2005, especially since the compatibility setting on the database will automatically be set to 80 (ie v2000 behaviour on some commands).

    Note that if your database(s) use some newly reserved words, such as having a user called sys with tables in the sys schema then you'll be in trouble 🙂 A 3rd party app I work with has just that problem. It was picked up in early 2005 and, now in 2008, it still hasn't been fixed 🙁 Hope it doesn't need to run on a Windows Server 2008 machine anytime soon 🙂

  • February 3, 2008 at 5:50 pm

    #774615

    SQL 2000 desktop version may not be accepted to be installed on Vista. Try SQL 2005 express edition.

  • February 4, 2008 at 12:11 am

    #774647

    Thank you very much guys

    I will install the SQL server 2005 but I am not familiar with this 2005 and i will try it

  • February 4, 2008 at 4:27 am

    #774686

    You cannot install SQL Server 2000 on Vista or Windows 2008.

    If somehow you do get it to work, you will have no support from Microsoft.

    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

  • February 5, 2008 at 9:14 pm

    #775412

    Refer these links for installing SQL 2005 and SQL 2008 which might help you in a great deal 🙂 also as mentioned earlier you cannot install SQL 2000 or MSDE in Vista. However you can install Virtual PC in your VISTA and then install SQL 2000 or MSDE. Better option is to go for latest version of SQL Server.

    http://sql-articles.com/index.php?page=articles/install/insql.htm

    http://sql-articles.com/index.php?page=articles/SQL2008/ins_2008.html

    [font="Verdana"]- Deepak[/font]

  • February 6, 2008 at 12:40 am

    #775449

    thanks guys

    I have installed SQL server 2005 but i am not familiar with SQL 2005 and i will try it. because unlike SQL 2000, SQL 2005 is not easy to use.

    thank you very much guys

  • February 6, 2008 at 3:03 am

    #775492

    If you are installing Developer Edition on Vista (or Std or EE on a server), take a look at http://www.codeplex.com/SQLServerFineBuild It is something I published that helps you get a 1-click deployment of SQL Server 2005.

    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

  • February 6, 2008 at 12:12 pm

    #775738

    thanks EdVassie

    appreciated

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply