SQL 2K Entrprise Manager w/ Win 98?

[MichaelRed]

I have installed SQL Server 2K under Win 98 and it appears to be "O.K." as a db server. HOWEVER, (is there ALWAYS a "HOWEVER,"?) Enterprise manager doesn't run. I get the MsgBox "MMC cannot open the selected file", however query analyser appears to be able to "open" and use the db.

I was "told" that ALL of SQL Server 2K would run under ANY '32 bit' win O.S. - so IT MUST be me, but what don't I know about the me? (or at least the part of me that needs to deal w/ SQL Server/Entrprise Manager?).

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[tlbroadbent]

Hi Michael,

I run MSDE (SQL 2K) on a Windows 98 OS and also have Enterprise Manager installed. It runs fine. My guess is that the EM shortcut is pointing to the wrong path or file name for the MSC file.

It should read something like the following.

C:\WINDOWS\system32\mmc.exe /s "C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC" Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm

 

[MichaelRed]

Terry,

Thanks. This gets me somewhere ... just not sure (yet) where that is (means I'm still lost?).

The shortcut DOES point to 'valid' files on my system. If I just start mmc.exe (from WinExplorer), it will start, but has NO db info and I either do not know how to properly add the dbs or it is not able to do that. If I start "SQL Server Enterprise Manager.MSC" (again from windows explorer, I get a snap in failed to initalize error, and open up to a "Console" with a database in the treeview, but -again- either I do not know how to add the db's or the system does not have that capability enabled.

Something I have (recently) accomplished is to have the query analyzer fail to recognize the installes dbs, giving me the errs:

Unable to Connect to ...
Specified SQL server not found ...
Specified SQL Server does not exist or access denied.

The course I took was on PROGRAMMING -NOT- the setup/administration. While some of these topics were MENTIONED, they were NOT covered in the detail necessary to wend my way through this quagmire. I GUESS that I'll need to get another *^&%@#*(&^%@#(! third party text to understand how to get this all set up.

Also, none of the help systems appear to be connected. I can find the individual help files and use them -but only if I can figure out which .hlp goes with which executable. WHAT a pain!



[tab][tab][tab]OR
MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[fluteplr]

I have probaly installed Sql2000 on dozens of machines without any problems. I would recommend unistalling everything and reinstalling from scratch. Ether something got hosed in the install, or something was hosed after the install..

D:\WINDOWS\system32\mmc.exe /s "D:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC"