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 + SSL

Hi!
I had a working Win2003 server with Backup Exec 9.1 and Exchange 2003 OWA.
I installed SP1 for Win2003, WSUS and I created a certificate for OWA with
help from SelfSSL.
After this, I cant start my Backup Exec services, complaining about some SSL
error:
SSL Security error
ConnectionOpen (SECDoHandshake()).
and
[DBNETLIB][ConnectionOpen (SECDoHandshake()).]SSL Security error.
I think all this is a problem with SSL and MSDE.
Veritas says "talk to Microsoft" and gues what MS says...
What does SelfSSL to do with MSDE? Or what shoult I do to make MSDE (8.0)
run nice beside SSL for our OWA access.
Thanks!
Mattias
hi Mattias,
MrM wrote:
> Hi!
> I had a working Win2003 server with Backup Exec 9.1 and Exchange 2003
> OWA. I installed SP1 for Win2003, WSUS and I created a certificate
> for OWA with help from SelfSSL.
> After this, I cant start my Backup Exec services, complaining about
> some SSL error:
> --
> SSL Security error
> ConnectionOpen (SECDoHandshake()).
> and
> [DBNETLIB][ConnectionOpen (SECDoHandshake()).]SSL Security error.
> --
> I think all this is a problem with SSL and MSDE.
> Veritas says "talk to Microsoft" and gues what MS says...
> What does SelfSSL to do with MSDE? Or what shoult I do to make MSDE
> (8.0) run nice beside SSL for our OWA access.
>
please try having a look at
http://support.microsoft.com/default.aspx?id=309398 and
http://www.fftf.org/news/Aug05feed/M...ouble.rss.html
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

msdb.dbo.sp_send_dbmail error

I make PROCEDURE to send email useing db msdb and this PROCEDURE dbo.sp_send_dbmail like this

EXEC msdb.dbo.sp_send_dbmail

@.profile_name = 'saly',

@.recipients = @.email,

@.subject = @.subject,

@.body = @.body;

Go

And when EXEC it gives me mail qeue

and mail don't arrive where it goes i don't know please tell me what error

thankx very much

Check the mail log.

Have you start the smtp service

|||

hi

have the same promlem

and I have tried so many solutions.If u foud how to do so please tell me .

thanks

|||Its very likely an error with your SMTP server setup. Check to make sure that the machine you are sending the message from (sql server) is allowed to send smtp messages on your smtp server.
Tim

msdb.dbo.sp_send_dbmail error

I make PROCEDURE to send email useing db msdb and this PROCEDURE dbo.sp_send_dbmail like this

EXEC msdb.dbo.sp_send_dbmail

@.profile_name = 'saly',

@.recipients = @.email,

@.subject = @.subject,

@.body = @.body;

Go

And when EXEC it gives me mail qeue

and mail don't arrive where it goes i don't know please tell me what error

thankx very much

Check the mail log.

Have you start the smtp service

|||

hi

have the same promlem

and I have tried so many solutions.If u foud how to do so please tell me .

thanks

|||Its very likely an error with your SMTP server setup. Check to make sure that the machine you are sending the message from (sql server) is allowed to send smtp messages on your smtp server.
Tim

msdb.dbo.sp_send_dbmail error

I make PROCEDURE to send email useing db msdb and this PROCEDURE dbo.sp_send_dbmail like this

EXEC msdb.dbo.sp_send_dbmail

@.profile_name = 'saly',

@.recipients = @.email,

@.subject = @.subject,

@.body = @.body;

Go

And when EXEC it gives me mail qeue

and mail don't arrive where it goes i don't know please tell me what error

thankx very much

Check the mail log.

Have you start the smtp service

|||

hi

have the same promlem

and I have tried so many solutions.If u foud how to do so please tell me .

thanks

|||Its very likely an error with your SMTP server setup. Check to make sure that the machine you are sending the message from (sql server) is allowed to send smtp messages on your smtp server.
Tim