also @ TechSpot: Nortel's internal network "owned" by hackers for almost a decade
Welcome to the TechSpot OpenBoards. Please read the FAQ if you have any questions. Sign up or Login to participate.
Go Back   TechSpot OpenBoards > Software > Software Apps
Reload this Page installing sql server 2000 standard edition in windows xp professional

Download Now:

installing sql server 2000 standard edition in windows xp professional
Thread Tools Search this Thread
  #1  
Old 05-24-2007
Newcomer, in training
  
Member since: May 2007, 5 posts
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  
Old 05-24-2007
Nodsu's Avatar
TechSpot Evangelist
  
Location: Estonia
Member since: Feb 2002, 9,431 posts
System specs
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?
  #3  
Old 05-24-2007
Newcomer, in training
  
Member since: May 2007, 5 posts
Yes with server
  #4  
Old 05-25-2007
Nodsu's Avatar
TechSpot Evangelist
  
Location: Estonia
Member since: Feb 2002, 9,431 posts
System specs
And it was SQL Server 2000 Standard, and not something like SQL Server 2005 Express or SQL Server 2000 developer version?
  #5  
Old 05-26-2007
Newcomer, in training
  
Member since: May 2007, 5 posts
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  
Old 05-28-2007
Nodsu's Avatar
TechSpot Evangelist
  
Location: Estonia
Member since: Feb 2002, 9,431 posts
System specs
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  
Old 05-28-2007
Newcomer, in training
  
Member since: May 2007, 5 posts
1.) install client tools using sql server 2000


2.)http://www.functionx.com/msde/installation.htm

This works
  #8  
Old 05-28-2007
Nodsu's Avatar
TechSpot Evangelist
  
Location: Estonia
Member since: Feb 2002, 9,431 posts
System specs
So, you actually didn't install SQL Server 2000, but MSDE..
  #9  
Old 06-08-2007
Newcomer, in training
  
Member since: May 2007, 5 posts
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