February 3, 2009 at 10:29 am
Hello People, this is my first post and i'm completely new to SQL Server 2000.
I have an HP laptop with Vista installed on it. Now under program files in the start, i can find a program folder for Microsoft SQL server 2005. My initial thought was that this could not be the server.
Then when i tried check the components of the software, i found that there was not enterprise manager (to create databases) - just a configuration manager.
I've got 2 questions
1. What kind of tool is this - Is this just a client installation so i can work with a server computer somewhere or is it a server installation?
2. Can I install SQL server 2000 successfully on this computer with the aforementioned programs without conflict.
Thank you
February 4, 2009 at 2:39 am
abdullah.olaniyan (2/3/2009)
Hello People, this is my first post and i'm completely new to SQL Server 2000.I have an HP laptop with Vista installed on it. Now under program files in the start, i can find a program folder for Microsoft SQL server 2005. My initial thought was that this could not be the server.
Then when i tried check the components of the software, i found that there was not enterprise manager (to create databases) - just a configuration manager.
I've got 2 questions
1. What kind of tool is this - Is this just a client installation so i can work with a server computer somewhere or is it a server installation?
2. Can I install SQL server 2000 successfully on this computer with the aforementioned programs without conflict.
Thank you
1) It's probably a SQLExpress instance. I had one on my new notebook as well and it was part of the MS Office install.
2) I'm not sure if SQL 2000 works on Vista, but in general there's no problem having SQL 2000 and 2005 next to each other.
[font="Verdana"]Markus Bohse[/font]
February 4, 2009 at 3:58 am
Thanks for the reply but the instance is not useful without the database right?;)
Do you know what possible purpose it serves then?
February 4, 2009 at 4:46 am
abdullah.olaniyan (2/4/2009)
Thanks for the reply but the instance is not useful without the database right?;)Do you know what possible purpose it serves then?
Because I don't know for which application the instance has been created, I can't tell you if it has a database or not. If you want you can download Management studio for SQLExpress.
[font="Verdana"]Markus Bohse[/font]
February 4, 2009 at 6:31 am
Regarding the second point, despite some claims to the contrary, it is possible to install SQL 2000 on Vista. See Michael Imhoff's blog for details.
The other option is to install Virtual PC and use xp inside that...
Duncan
February 5, 2009 at 6:36 am
You can install it, but the Sync Center will make you nervous
February 5, 2009 at 9:15 am
SQL EXpress is a 2005 edition
2000 is not supported on vista
February 5, 2009 at 9:42 am
The configuration manager you found in the start menu is just a limited client tool. Certainly installed because of an application.
The way to tell if you have SQL Server on the computer is, simply, to check what services are running. SQL Server will be listed as a service, if it's installed, and you can see whether it's running or not from the Windows service manager.
You can't install SQL 2000 on Vista. Not compatible. No real reason I can think of to do so anyway, when you're going to be better off with 2005, and just build databases in compatibility 80 if you need to limit yourself to the 2000 featureset.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 5, 2009 at 11:17 am
i heard thats not supported sql 2000 on windows vista...
there can be tricks and tweaks to install it..
if you are installing the free version of sql
express is 10 times better than msde as per my experience
February 5, 2009 at 4:22 pm
You can install SQL 2000 Dev Edition on Vista Business RTM; I did it. No tricks or tweaks, except for being logged in with an Administrator account and with UAC turned off. Just keep ignoring the "not compatible" complaints from Vista.
February 6, 2009 at 10:02 am
Thank you people.
I got it installed on vista without problems. just the 2 windows popping up on the compatibility as it did when i was installing VS.NET;)
The next thing is this (i hope I'm allowed to do this).
I'm not really into SQL server (i've been used to Access for some time and then i learnt oracle).
The problem is that i want write a program that will have to access SQL server (my boss is on my neck) and i tried connecting 2 PCs (one vista and the other XP) and using ODBC to build a data source name, but i'm having problems.
Please anybody with experience connecting PCs this way should help.
Thank you
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply