How to setup a laptop as a stand alone server

[jeprox69]

What do I need to do to setup a laptop to work as a stand alone sql server, so I do not need to connect to network.
My intention is to able to do a demo or training without actually connecting to a remote server. I have installed SQL 2K. I tried registering the laptop,using the wizard but I get errors connecting to it. Thank you.

 

[mrdenny]

What OS is on the laptop?

What edition of SQL Server did you install? Developer, Personal, Standard, Enterprise, etc?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[SQLBill]

What errors are you getting?

-SQLBill

Posting advice: FAQ481-4875

 

[DrSql]

You can Install Standard and Enterprise SQL server on Windows 2K & Win2K3 SERVERES and Personal and developer edition can install on Win2K and Xp PRO.

Dr. Sql
goEdeveloper@yahoo.com
Good Luck.

 

[MattBeas]

You can also install the MSDE (Microsoft Desktop Engine) on a desktop/laptop running XP / 2000 pro.

This is nice 'cause its license free and can download it for free from microsoft.com. No GUI though, but you can use enterprise manager/query analyzer with it. I think you also have a 2GB database limit, but I've got a 4Gb database on my desktop (don't ask me how!)

 

[nomadicalloy]

MSDE is free but I would go for SQL Standard for xp/2000 OS.


SQL Help Blog

http://www.xpherion.com/blog.asp

 

[jeprox69]

I have WinXp Pro. I tried registering the local server, I get an error saying The server is not known to be running, SQL server does not exist.

Thanks for all the helpful post.

 

[DrSql]

When you installed SQL Server what you named the instance, if you kept the default it would be your PC NAME.

Dr. Sql

 

[SQLBill]

1. Check to see if the services are started (Right click My Computer icon, select Manage, find Services).
2. What did you set as the authentication mode? Windows Only or Mixed Mode?
3. Did you create a login for yourself?
4. Can you connect via Query Analyzer?

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

What edition of SQL Server 2000 did you try to install on your laptop?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[jeprox69]

I have installed the Standard edition. I tried using query analyser without any success. I have assigned id and pswd for myself, and the server name is local.
When I check the services some how I don't see SQL server displayed. I am sure it installed, how can you get this service enabled or added to the services?

Thanks for all your help.

 

[SQLBill]

The services would be:

MSSQLServer and SQLSERVERAGENT.

If you don't find those two services, then you didn't install SQL Server.

(BTW-If you used a named instance the services will be:
MSSQLServer$<instance_name> and SQLSERVERAGENT$<instance_naem>)

-SQLBill

Posting advice: FAQ481-4875

 

[jeprox69]

How would SQL SERVER not be installed? I have it under programs. What seems to be wrong? Thank you.

 

[SQLBill]

AHA?

Look in programs...under the Microsoft SQL Server option, do you see the Server Manager?

If not, then you may have only installed the CLIENT TOOLS.

When you do an install you get the option of:
Server and Client
Client only

You may have chosen the latter.


-SQLBill

Posting advice: FAQ481-4875

 

[SQLBill]

Another thing to try....if it installed properly, you will have a MASTER, MODEL, MSDB, TEMPDB, Northwind, and Pubs database on your computer. Do a search for this:

master.mdf

If you find that, you have the database installed. If it can't be found, you only have the client tools.

-SQLBill

Posting advice: FAQ481-4875

 

[jeprox69]

When I tried reinstalling I got an error stating the SQL Server2000 Standard edition server component is not supported on this OS(win2000pro)only client components will be available for installation.

 

[gmmastros]

Sounds like you found the problem. You could install MSDE instead. It is functionally equivalent to SQL Server with a couple limitations that probably won't affect you on a laptop.

http://www.microsoft.com/sql/msde/downloads/download.mspx

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[mrdenny]

That is correct. Standard Edition can not be installed on Windows XP Pro. You'll need to get the Developer edition (~$50 from Microsoft) to install on Windows XP Pro.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[SQLBill]

Only thing to be aware of with Developer Edition is that it can't be used for production databases.

Glad to find you solved the issue:

SQL Server2000 Standard edition server component is not supported on this OS(win2000pro)

but I do have to point out that DrSQL mentioned this on the 9th (third response to your post).

You can Install Standard and Enterprise SQL server on Windows 2K & Win2K3 SERVERES and Personal and developer edition can install on Win2K and Xp PRO.

-SQLBill

Posting advice: FAQ481-4875