Me and My friends at JB
My Boarland Delphi 5 Enterprise Edition While loading
Thursday, December 14, 2006
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.
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="
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.
Subscribe to:
Posts (Atom)