Welcome to the TechSpot OpenBoards. Please read the FAQ if you have any questions. Login to participate.
|
|||||||
installing sql server 2000 standard edition in windows xp professional
 |
|
Thread Tools |
|
#1
05-24-2007
|
|||
|
|||
|
installing sql server 2000 standard edition in windows xp professional
Hello
This is my first thread When i install sql server 2000 standard edition i have a message " Microsoft SQL Server 2000 Standard Edition Server Component is not supported on this operating system only client components will be available for installation" Hence I cannot install properly. I installed only the client componets. Thereafter when I went through Enterprise Manager and tried to establish a connection, I failed. It said server does not exist. What to do now? I found out that if one has sql server 2000 standard editon the prerequisties are Microsoft Windows NT Server 4.0 with Service Pack 5 or later, Windows NT Server 4.0 Enterprise Edition with Service Pack 5 or later, Windows 2000 Server, Windows 2000 Advanced Server, or Windows 2000 Datacenter Server. I have windows xp professional version on which i am installing sql server. But i have seen many persons who have installed sql server standard edition in windows xp pro. They downloaded something(probably a service pack) and went into regedit Kindly let me know what do download and what to do after going inside regedit. Thanks cmrhema 
|
|
#2
05-24-2007
|
||||
|
||||
|
Do these "many persons" actually run the SQL Server engine on their computers or did they just install the client tools to be able to connect to another SQL Server machine?
|
| You can remove this banner by registering, join the TS Community for free. |
|
|
|
|
#4
05-25-2007
|
||||
|
||||
|
And it was SQL Server 2000 Standard, and not something like SQL Server 2005 Express or SQL Server 2000 developer version?
|
|
#5
05-26-2007
|
|||
|
|||
|
I got SQL Server 2000 Standard version installed
I formatted my drive initially. Before doing so I copied my database file stud.mdf and its corresponding log file. Now I have installed sql server 2000. How do I copy these files back to enterprise manager. Thanks Last edited by cmrhema; 05-26-2007 at 09:49 AM.
|
|
#6
05-28-2007
|
||||
|
||||
|
How did you get it installed? It would be very helpful if you told us how to do it..
You use Attach Database to import mdf+ldf files.
|
|
#7
05-28-2007
|
|||
|
|||
|
1.) install client tools using sql server 2000
2.)http://www.functionx.com/msde/installation.htm This works
|
| You can remove this banner by registering, join the TS Community for free. |
|
|
|
|
#8
05-28-2007
|
||||
|
||||
|
So, you actually didn't install SQL Server 2000, but MSDE..
|
|
#9
06-08-2007
|
|||
|
|||
|
I should have replied this long ago.
Yes I did install MSDE. Is there a vast difference between MSDE and SQL SERVER 2000? I am learning vb tutorials with backend as sql server 2000. All the commands and connections works well
|
|
| Thread Tools | |
|
| Similar Topics | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Problem in installing SQL server 2000 enterprise edition. | gaurav_7070 | Misc. Software & Utilities | 11 | 02-08-2008 02:32 AM |
| Server 2000/2003 Setup with XP home edition client | maffpunton | Windows OS | 0 | 08-09-2006 07:30 AM |
| how i can install driver of Client SQL Server on Windows server 2003 Web edition? | babyna | Windows OS | 3 | 05-23-2005 10:38 AM |
| Where do you get Windows XP Professional x64 Edition ? | ComputerTeen | Windows OS | 1 | 05-01-2005 06:15 PM |
| Problem in installing MS SQL server 2000 Personal in Windows XP Pro with SP2 | therock | Misc. Software & Utilities | 1 | 11-18-2004 02:13 PM |
All times are GMT -4. The time now is 07:29 AM.
