WINDOWS VISTA WITH SQL SERVER 2000

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » WINDOWS VISTA WITH SQL SERVER 2000

WINDOWS VISTA WITH SQL SERVER 2000

Rate Topic

Display Mode

Topic Options

Author

Message

massawa

Posted Sunday, February 03, 2008 7:32 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, February 26, 2008 12:27 AM
Points: 50, Visits: 115

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

Post #450934

SwePeso

Posted Sunday, February 03, 2008 11:43 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 2,133, Visits: 2,478

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

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

Post #450953

Ian Yates

Posted Sunday, February 03, 2008 4:16 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, January 25, 2010 7:33 AM
Points: 1,034, Visits: 375

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 Sad

Hope it doesn't need to run on a Windows Server 2008 machine anytime soon :)

Post #450972

SQL ORACLE

Posted Sunday, February 03, 2008 5:50 PM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, February 03, 2010 8:58 PM
Points: 1,361, Visits: 1,028

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

Post #450979

massawa

Posted Monday, February 04, 2008 12:11 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, February 26, 2008 12:27 AM
Points: 50, Visits: 115

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

Post #451023

EdVassie

Posted Monday, February 04, 2008 4:27 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 9:04 AM
Points: 1,990, Visits: 1,612

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.

Author: SQL Server FineBuild 1-click install and configuration of SQL Server 2005 and 2008.
1 December 2009: now over 8,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Post #451084

Deepak-405225

Posted Tuesday, February 05, 2008 9:14 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, February 02, 2010 3:01 AM
Points: 402, Visits: 558

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

- Deepak

Post #451990

massawa

Posted Wednesday, February 06, 2008 12:40 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, February 26, 2008 12:27 AM
Points: 50, Visits: 115

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

Post #452036

EdVassie

Posted Wednesday, February 06, 2008 3:03 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 9:04 AM
Points: 1,990, Visits: 1,612

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

Author: SQL Server FineBuild 1-click install and configuration of SQL Server 2005 and 2008.
1 December 2009: now over 8,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.

Post #452084

massawa

Posted Wednesday, February 06, 2008 12:12 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, February 26, 2008 12:27 AM
Points: 50, Visits: 115

thanks EdVassie
appreciated

Post #452393

« Prev Topic | Next Topic »

Permissions