MSDE 2000 Issues

Installing MSDE 2000 is bit complicated thing, unlike in MS SQL Server 2000. There is no user interface and no installation wizard, but you have to use TSQL to all of tasks in the Command Prompt. (Its like going back to the DOS era)

You get MSDE in your Office CD free. I had Microsoft Office XP with me and this is the way I installed it.

Insert your Office CD in, and type the following in your Command Prompt:

C:\>D:\MSDE2000\Setup.Exe SAPWD="" SECURITYMODE=SQL DISABLENETWORKPROTOCOL S=0/L*v C:\MSDELOG.TXT

And to Attach a Database to MSDE, I used the following way:

Again nothing will help you instead of Command Prompt.

Here, first you have to login to MSDE, and this is the way its done (provide your SA password):

C:\>osql/U sa/P

Once logged in, type the following in the command prompt:

EXEC sp_attach_db @dbname='pubs' @filename1='C:\Program Files\Microsoft Sql Server\MSSQL\Data\pubs.mdf' @filename2=''C:\Program Files\Microsoft Sql Server\MSSQL\Data\pubs_log.ldf' GO

Its arent easy with out a proper GUI, yet I was able to surf the internet and get help.