Installation of local database

cjayp

I have installed SQL Sever 2000 on my Windows XP Pro machine from the
Enterprise Edition setup and it prompts you that only the client tools
can be installed. I wanted to have a local database as well So what
install should I have used to do so. Any information would greatly be
appreciated.

Aug 28 '06 #1

Subscribe Post Reply

1873

Erland Sommarskog

(cj***@yahoo.com) writes:

I have installed SQL Sever 2000 on my Windows XP Pro machine from the
Enterprise Edition setup and it prompts you that only the client tools
can be installed. I wanted to have a local database as well So what
install should I have used to do so. Any information would greatly be
appreciated.

Enterprise Edition runs on server operating systems only. That is,
Windows 2003 or Windows 2000 Server.

To have a local database on your workstation, you need to install either
Developer Edition or Personal Edition. Of these Developer Edition is
surely the better choice, as it has all the features of Enterprise
Edition. It's just the licensing which is different.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Aug 28 '06 #2

cjayp

Thanks, I ended up installing Personal Edition, due to inability to get
DE to install correctly from only copy I had.
Erland Sommarskog wrote:

(cj***@yahoo.com) writes:
I have installed SQL Sever 2000 on my Windows XP Pro machine from the
Enterprise Edition setup and it prompts you that only the client tools
can be installed. I wanted to have a local database as well So what
install should I have used to do so. Any information would greatly be
appreciated.

Enterprise Edition runs on server operating systems only. That is,
Windows 2003 or Windows 2000 Server.

To have a local database on your workstation, you need to install either
Developer Edition or Personal Edition. Of these Developer Edition is
surely the better choice, as it has all the features of Enterprise
Edition. It's just the licensing which is different.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Aug 30 '06 #3

by: Captain Obvious | last post by:

I'm posting this in hopes that it will help a few folks out when the search Google Groups. I was having the following problems with Oracle 10G: 1. When installing the database, the net config...

Oracle Database

post installation problem

by: Nick Keeling | last post by:

--=_48167406.4627091C Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit I am a MySQL newbie with a post installation problem. I have Linux Red Hat 9 with MySQL 4.0....

MySQL Database

Installation of IBM DB2 Enterprise server edition on Linux

by: srihari | last post by:

Hai, I am trying to install IBM DB2 8.1 on Red Hat linux 8.0. My machine is Intel XEON 64bit. The installation went well except for the creation of tools catalog. When I tried to install the tools...

DB2 Database

Post installation tasks in db2

by: srihari | last post by:

Hai I have installed db2 8.1 on linux machine. The current db2 users are instance user(db2inst1), fenced user(db2fenc1) and db2as(administration server). To start using the database do I have to...

DB2 Database

DB2 8.1 ESE Win32 installation problem

by: news.symantec.com | last post by:

Hi All, I'm trying to install DB2 Enterprise Edition 8.1 (partitioned installation) onto a clean Win 2k SP4 advanced server box. The problem is the partitioned installation requires a "Domain...

DB2 Database

Installation error with DB@ Personal Edition v8.1

by: azgoddess1 | last post by:

During the installation I get these error messages: ***** SQL1390C The environment variable DB2Instance is not defined or is invalid An error ocured while loading the command "C:\Program...

DB2 Database

DB2 Installation Error

by: cboccio | last post by:

Hi everybody !! I am new in DB2 database word, and I am trying to install a DB2 Personal Edition in my notebook to study it, but I have some problems during the installation. I have the...

DB2 Database

SQL Server 2000 Installation error

by: coosa | last post by:

Hi, I was installing SQL Server on my machine and during installation my PC freezed. It happens frequently on my machine. So i tried after restarting to install it again and since then i always...

Microsoft SQL Server

Recovering from a failed installation

by: Will Honea | last post by:

Wanting to look at V9, I attempted to install Db2 Express-C on a Suse Linux box I use as a sandbox. Since I was less that thorough when removing previous installations of V8 and V7, the...

DB2 Database

Return info about PHP installation mySQL compatibility

by: Robin S. | last post by:

I've used phpinfo() to confirm settings for mySQL on our host server, and it's not returning accurate info. phpinfo() returns a mySQL client API version of 3.23.54 (uselss for me), where as a...

PHP

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Similar topics