The Author Online Book Forums are Moving

The Author Online Book Forums will soon redirect to Manning's liveBook and liveVideo. All book forum content will migrate to liveBook's discussion forum and all video forum content will migrate to liveVideo. Log in to liveBook or liveVideo with your Manning credentials to join the discussion!

Thank you for your engagement in the AoF over the years! We look forward to offering you a more enhanced forum experience.

import-bot (20211) [Avatar] Offline
#1
[Originally posted by awiggans]

I finally got MSDE installed and working. From memory, I
wrote down all of my steps that I did and compiled the
information from the various helps from the message
board. This is a basic install that I am using to run
tutorials from a book.

Hope this helps.

1) Download SQL2KDESKSP3.exe from Microsoft
http://www.microsoft.com/downloads/details.aspx?
FamilyId=9032F608-160A-4537-A2B6-
4CB265B80766&displaylang=en

2) Unpack the above into another directory on my C:

3) enter the following on the run line to install:
C:MSDE2000>setup.exe BLANKSAPWD=1

if this does not work, change the C:MSDE2000 to wherever
the files were unpacked. Also, you may have to enter
setup vs. setup.exe

4) reboot the computer

5) Your system adminstrator logon should be sa and your
password should be blank.

6) Next, change the Login Authentication Mode. This
helped eliminate some of the trusted user errors

follow the instructions at:
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;285097

7) You should be able to connect to a default instance
of MSDE 2000 on your computer if you open a command prompt window, and on
the command prompt specify:

osql -E

osql will give you a > prompt. You can then enter any
Transact-SQL statement, followed by GO to execute that statement. For
example:

To check that your instance is running SP3, you could execute:

> SELECT SERVERPROPERTY('ProductLevel')
> GO

When you want to exit osql:

> EXIT

For more infomation about osql.exe go to
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/coprompt/cp_osql_1wxl.asp?frame=true



.