| Author |
Message |
Don
Guest
|
 Posted:
Thu Nov 10, 2005 1:51 am Post subject:
MOM 2005 and Microsoft SQL Server 2005 Express Edition |
|
|
Is it possible to use SQL 2005 Express (9.00.1399.06) and MOM2005?
This would be on the same Server 2003 server
I am trying it out for the first time and getting the failure:
==================================
Failures
Minimum Requirement
The SQL Server and SQL Server Agent services must be in automatic startup
mode, for clusters they can be manual startup.
Required For
MOM Database
Detected Value
The SQL Server and/or SQL Server Agent services are not set to automatic
startup mode, for clusters they are not set to manual or automatic mode.
=====================================================
The SQL Server 2005 Express Service registers as:
SQL Server (SQLEXPRESS)
and not:
MSSQLSERVER and SQLSERVERAGENT
as in SQL2000. |
|
| Back to top |
|
 |
David Tyra
Guest
|
| Posted:
Thu Nov 10, 2005 9:07 am Post subject:
Re: MOM 2005 and Microsoft SQL Server 2005 Express Edition |
|
|
Don,
SQL Server 2005 is not supported currently by MOM 2005. I believe that
support for SQL 2005 will be added in SP2 for MOM 2005.
Regards,
David Tyra
"Don" <Don@discussions.microsoft.com> wrote in message
news:FD47F9A1-D82F-42A9-9FE7-282909BEC7CC@microsoft.com...
| Quote: | Is it possible to use SQL 2005 Express (9.00.1399.06) and MOM2005?
This would be on the same Server 2003 server
I am trying it out for the first time and getting the failure:
==================================
Failures
Minimum Requirement
The SQL Server and SQL Server Agent services must be in automatic startup
mode, for clusters they can be manual startup.
Required For
MOM Database
Detected Value
The SQL Server and/or SQL Server Agent services are not set to automatic
startup mode, for clusters they are not set to manual or automatic mode.
=====================================================
The SQL Server 2005 Express Service registers as:
SQL Server (SQLEXPRESS)
and not:
MSSQLSERVER and SQLSERVERAGENT
as in SQL2000.
|
|
|
| Back to top |
|
|
jeremiah johnson
Guest
|
| Posted:
Fri Nov 11, 2005 9:51 am Post subject:
Re: MOM 2005 and Microsoft SQL Server 2005 Express Edition |
|
|
David Tyra wrote:
| Quote: | Don,
SQL Server 2005 is not supported currently by MOM 2005. I believe that
support for SQL 2005 will be added in SP2 for MOM 2005.
Regards,
David Tyra
|
David is correct, but the error you're seeing is exactly the same you'd
see with SQL 2000. The services mentioned (SQL Server & SQL Agent) are
not set to startup automatically. So set them to startup automatically
and you'll find the real reason you can't use SQL2005 with MOM2005 -
another, more cryptic, error. |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in