MSDE and Enterprise Manager?

I am a complete sql newbie! For the life of me I can't figure out how to get Enterprise Manager to connect with MSDE. Something about mixed mode or tcp/ip settings? But no one's ever really clear on how to do these things. I've uninstalled MSDE until I can get more info.

I just need a quick walk-through on how to install msde to work with EM. This is what I used when MSDE requested a strong password:

setup INSTANCENAME="InstanceName" SECURITYMODE=SQL SAPWD="AStrongSAPwd"

Is this correct? Any help would be appreciated.

Thanks.

You access it by address or servername + \ + Instance name:

Server\MSDEInstanceName

|||

What part are you having a problem with?

Tell EM to connect to the server\instancename using sql authentication login sa, password AStrongPWD.

|||If you have the full SQL Server installed then you install the MSDE as a named instance and right click at the top of the Enterprise manager of the full version to register the MSDE and you can manage it directly. If you have the MSDE installed then you install the full version as a named instance and repeat the above. I have registered 68 SQL Server 7/2000 in one XP box so if you have more questions post again. Hope this helps.|||

Thanks to everyone for their help.

I had the eval version of 2000 installed but it's expired. I would now like to use EM with MSDE to connect to the database on my website. I re-installed MSDE but it's only showing the local database.

When I try to register my online domain (ip address) it fails. Says sql may not be running. But it is running. I know it's something basic and silly I'm not doing, but I'm still very new to sql. Is there any other very basic step I may be missing?

Again, thanks for everyone's help...sorry for all the newbie questions.

|||

Which is probably correct because your SQL Server service maybe off, the developer edition is $40 in the link below but you could get it for less because when you are using hosting company you need Enterprise manager. Hope this helps.

http://www.provantage.com/buy-22053391-microsoft-backoffice-sql-server-2000-developer-edition-shopping.htm

msde 2000 install failes on xp

Hi
I cant install MSDE 2000 on one XP machine
Cant figure out whats wrong
Because log file too large
Download it here
www.deltmar.ee/logfile.zip
Regards;
Mex
hi Mex,
Meelis Lilbok wrote:
> Hi
> I cant install MSDE 2000 on one XP machine
> Cant figure out whats wrong
> Because log file too large
> Download it here
> www.deltmar.ee/logfile.zip
>
the relevant part of the log is
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
Action ended 14:59:46: InstallFinalize. Return value 3.
usually depending on re-intallation on partially cleaned machines..
please have a look at
http://support.microsoft.com/default...99&Product=sql
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE 1 => msde 2 => MSDE 2 SP3a

I'm able to successfully upgrade my MSDE 1 installation from Office 2k to
MSDE 2, using any of the versions 1 thru 3a. However, I can't figure out
the command-line parameters to upgrade MSDE 2 to a newer version of MSDE 2,
at least not retaining my Office Server Extensions database. Considering
that SP 4 for MSDE 2 will probably be out soon, what's the proper method to
upgrade MSDE 2 when it was used to upgrade MSDE 1?
Well, I figured out the easy way to do things. First, you install MSDE 2.
Then you install office server extensions using the /nd switch to avoid
installing an older version of MSDE. Had a lot of registry cleaning to do,
had to unregister ows.dll, and a few other problems to fix before I could
get a successful install of OSE. Works fine, though. I was even able to
apply the OSE SP3 patch.
"Ellen Langton" <elangton@.wctc.net> wrote in message
news:emnXe$XCFHA.3688@.TK2MSFTNGP14.phx.gbl...
> I'm able to successfully upgrade my MSDE 1 installation from Office 2k to
> MSDE 2, using any of the versions 1 thru 3a. However, I can't figure out
> the command-line parameters to upgrade MSDE 2 to a newer version of MSDE
2,
> at least not retaining my Office Server Extensions database. Considering
> that SP 4 for MSDE 2 will probably be out soon, what's the proper method
to
> upgrade MSDE 2 when it was used to upgrade MSDE 1?
>
|||Well, I figured out the easy way to do things. First, you install MSDE 2.
Then you install office server extensions using the /nd switch to avoid
installing an older version of MSDE. Had a lot of registry cleaning to do,
had to unregister ows.dll, and a few other problems to fix before I could
get a successful install of OSE. Works fine, though. I was even able to
apply the OSE SP3 patch.
"Ellen Langton" <elangton@.wctc.net> wrote in message
news:emnXe$XCFHA.3688@.TK2MSFTNGP14.phx.gbl...
> I'm able to successfully upgrade my MSDE 1 installation from Office 2k to
> MSDE 2, using any of the versions 1 thru 3a. However, I can't figure out
> the command-line parameters to upgrade MSDE 2 to a newer version of MSDE
2,
> at least not retaining my Office Server Extensions database. Considering
> that SP 4 for MSDE 2 will probably be out soon, what's the proper method
to
> upgrade MSDE 2 when it was used to upgrade MSDE 1?
>

MSDE

Can some one tell me how to figure out which version MSDE I have loaded? It
is part of some non-Microsoft software, and MBSA suggests installing paths,
but I don't know what version of MSDE to select the patch for. Thank you fo
r
any help you can provide.http://www.aspfaq.com/show.asp?id=2160
Andrew J. Kelly SQL MVP
"Glen_in_Spokane" <Glen_in_Spokane@.discussions.microsoft.com> wrote in
message news:9C03AF5C-1FA3-4B90-AFCB-8CE2D7E1546D@.microsoft.com...
> Can some one tell me how to figure out which version MSDE I have loaded?
> It
> is part of some non-Microsoft software, and MBSA suggests installing
> paths,
> but I don't know what version of MSDE to select the patch for. Thank you
> for
> any help you can provide.

MSDE

Can some one tell me how to figure out which version MSDE I have loaded? It
is part of some non-Microsoft software, and MBSA suggests installing paths,
but I don't know what version of MSDE to select the patch for. Thank you for
any help you can provide.
http://www.aspfaq.com/show.asp?id=2160
Andrew J. Kelly SQL MVP
"Glen_in_Spokane" <Glen_in_Spokane@.discussions.microsoft.com> wrote in
message news:9C03AF5C-1FA3-4B90-AFCB-8CE2D7E1546D@.microsoft.com...
> Can some one tell me how to figure out which version MSDE I have loaded?
> It
> is part of some non-Microsoft software, and MBSA suggests installing
> paths,
> but I don't know what version of MSDE to select the patch for. Thank you
> for
> any help you can provide.

MSDE

Can some one tell me how to figure out which version MSDE I have loaded? It
is part of some non-Microsoft software, and MBSA suggests installing paths,
but I don't know what version of MSDE to select the patch for. Thank you for
any help you can provide.http://www.aspfaq.com/show.asp?id=2160
Andrew J. Kelly SQL MVP
"Glen_in_Spokane" <Glen_in_Spokane@.discussions.microsoft.com> wrote in
message news:9C03AF5C-1FA3-4B90-AFCB-8CE2D7E1546D@.microsoft.com...
> Can some one tell me how to figure out which version MSDE I have loaded?
> It
> is part of some non-Microsoft software, and MBSA suggests installing
> paths,
> but I don't know what version of MSDE to select the patch for. Thank you
> for
> any help you can provide.