Friday, March 23, 2012

MSDE Problem

I have installed MSDE and it seems to have installed okay. I just don't
know how to check to see if it is running.
I also have SQL Server 2000 developer running on this computer.
Any suggestions on how I determine if it is running and how to troubleshoot
if it isn't?
Thanks
LanceYou have multiple instances.
You'll see MSSQLServer and MSSQL$<name> in services. One is SQL developer,
one MSDE.
You need to know the name to connect, you can use SQL query analyzer to
connect to <servername>\instance name (the slash may be the other way) or
osql to connect (osql -E -S<servername>\instance name.
To find the instance name is tricky.
****************************************
***************************
Andy S.
MCSE NT/2000, MCDBA SQL 7/2000
andymcdba1@.NOMORESPAM.yahoo.com
Please remove NOMORESPAM before replying.
Always keep your antivirus and Microsoft software
up to date with the latest definitions and product updates.
Be suspicious of every email attachment, I will never send
or post anything other than the text of a http:// link nor
post the link directly to a file for downloading.
This posting is provided "as is" with no warranties
and confers no rights.
****************************************
***************************
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:DHPWb.15625$IF1.14838@.fed1read01...
> I have installed MSDE and it seems to have installed okay. I just don't
> know how to check to see if it is running.
> I also have SQL Server 2000 developer running on this computer.
> Any suggestions on how I determine if it is running and how to
troubleshoot
> if it isn't?
> Thanks
> Lance
>

No comments:

Post a Comment