MSDE 8 and MSDE 2000

Hello,
I have MSDE 8 installed on my Win2k server as it is is required by Veritas
Backup Exec.I would also likw to use this server for WSUS, which requires
MSDE 2000. Can these co-exist on the same server?
Thanks
hi,
mpapier wrote:
> Hello,
> I have MSDE 8 installed on my Win2k server as it is is required by
> Veritas Backup Exec.I would also likw to use this server for WSUS,
> which requires MSDE 2000. Can these co-exist on the same server?
>
actually MSDE 8 should be MSDE 2000, as no MSDE 8 is available, but 8.0 is
the internal version of the current SQL Server product...
MSDE (1.0) is based on SQL Server 7.0, where MSDE 2000 is based on SQL
Server 2000
another MSDE version, WMSDE has been made available for SharePoint, based on
MSDE 2000 with some restrictions on database size left out, as SharePoint
could need a database size beyond the actual 2gb limit of traditional
MSDE...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||So, you are saying I already MSDE 2000?
When I try to install WSUS it stops to tell me I do not have the proper
database software installed.
"Andrea Montanari" wrote:

> hi,
> mpapier wrote:
> actually MSDE 8 should be MSDE 2000, as no MSDE 8 is available, but 8.0 is
> the internal version of the current SQL Server product...
> MSDE (1.0) is based on SQL Server 7.0, where MSDE 2000 is based on SQL
> Server 2000
> another MSDE version, WMSDE has been made available for SharePoint, based on
> MSDE 2000 with some restrictions on database size left out, as SharePoint
> could need a database size beyond the actual 2gb limit of traditional
> MSDE...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi,
mpapier wrote:
> So, you are saying I already MSDE 2000?
> When I try to install WSUS it stops to tell me I do not have the
> proper database software installed.
I think you have WMSDE installed... based on MSDE 2000, but "branded" to
allow more then 2gb of data per data file...
AFAIK still there's no sp4 for that piece of software, but you could ask in
SharePoint or Win2003 NG...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE 2000a

What is going on with this program?

When I try to install it I get the error message:

"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."

Runing Win2k server, logged in as Administration.
Readme file says nothing about this
As usual, you can't find anything on M$ KB site.

I also tried the MSDE SP3 version - got the same results.I finally got it to install...had to edit the setup.ini file.

The server is running, the service is running but...

there is no enterprise manager...how are you suppose to manage your databases?|||There are a few things to manage your database. First of all there's the command-line tool called osql.exe that can be used to execute commands on your database. The second option is to use Access projects (supported on Access 2000 and higher if I'm not mistaken). Projects are a way to connect to a SQL Server or MSDE instance from within the Access product (pretty powerful). Last but not least there is the Web Data Administrator that can be downloaded fromhttp://www.microsoft.com/downloads/details.aspx?FamilyId=C039A798-C57A-419E-ACBC-2A332CB7F959&displaylang=en.

Hope this can help?|||Hi if anyone is still reading this thread this is very helpfull. I was trying to use MSDE via MATRIX but there seems to be only an option to create tables but not relationships between them so I am wondering how to actually access MSDE directly , which of above 3 ways do you suggest and where do I find more about command line and projects?sql

MSDE 2000

I downloaded MSDE from microsoft. When I click on Setup.exe I get this message:-

A SA password is required for security reasons. Use SAPWD switch to supply the same.

What does this mean and how can I sort it out?

Many thanks

Jim::I downloaded MSDE from microsoft. When I click on Setup.exe I get this message:-

lets see.

::A SA password is required for security reasons.

You need to provide a password for the user SA in the database. The SA user is the Administrator of the database server.

::Use SAPWD switch to supply the same.

You need to speficy this password using - a command line parameter, called a switch.|||How do I do that?

Cheers

Jim|||Look at the bottom of this page...

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1|||just run setup.exe SAPWD="passwd" in the cmd line