Error installed AEM
- Hi all, i try to installa AEM into a windows 2003 server with sql 2005 but at the end i receive this error message:
ERROR 1001. ERROR EXECUTING SQL SCRIPT -> MUST DECLARE THE SCALAR VARIABLE @MACHINEID.
Into SQL i set SQL 2000 COMPATIBILITY.
Can you help me?
Many thanks- Changed Typegianfelice Thursday, October 01, 2009 10:25 AMAEM INSTALLATION
Answers
Hi,
Thank you for posting.
As far as I know, AEM does not support SQL Server 2005. If you run SQL Server 2005, you must select the Express install mode (MSDE) option during the AEM setup process. AEM can use SQL Server 2000 Desktop Engine (MSDE), or an existing local or remote SQL Server 2000.
Description of Antigen Enterprise Manager (AEM) 9.0 and of steps to troubleshoot issues
http://support.microsoft.com/kb/934007/en-us
Regards,
Nick Gu - MSFT- Proposed As Answer byNick Gu - MSFTMSFT, ModeratorFriday, October 02, 2009 2:23 AM
- Marked As Answer byNick Gu - MSFTMSFT, ModeratorFriday, October 09, 2009 1:44 AM
- In addition to Nick's comments, it's worth noting that FSSMC (Forefront Server Security Management Console) does support SQL Server 2005 and can manage both Antigen 9 and Forefront for Exchange/Sharepoint 10 installations.
I would install FSSMC instead of AEM, if possible.
Kind Regards, Andy Day | CSS Security, Sr. Support Engineer (Antigen/Forefront Server Security)- Marked As Answer byNick Gu - MSFTMSFT, ModeratorFriday, October 09, 2009 1:44 AM
- Proposed As Answer byNick Gu - MSFTMSFT, ModeratorTuesday, October 06, 2009 7:31 AM
All Replies
Hi,
Thank you for posting.
As far as I know, AEM does not support SQL Server 2005. If you run SQL Server 2005, you must select the Express install mode (MSDE) option during the AEM setup process. AEM can use SQL Server 2000 Desktop Engine (MSDE), or an existing local or remote SQL Server 2000.
Description of Antigen Enterprise Manager (AEM) 9.0 and of steps to troubleshoot issues
http://support.microsoft.com/kb/934007/en-us
Regards,
Nick Gu - MSFT- Proposed As Answer byNick Gu - MSFTMSFT, ModeratorFriday, October 02, 2009 2:23 AM
- Marked As Answer byNick Gu - MSFTMSFT, ModeratorFriday, October 09, 2009 1:44 AM
- In addition to Nick's comments, it's worth noting that FSSMC (Forefront Server Security Management Console) does support SQL Server 2005 and can manage both Antigen 9 and Forefront for Exchange/Sharepoint 10 installations.
I would install FSSMC instead of AEM, if possible.
Kind Regards, Andy Day | CSS Security, Sr. Support Engineer (Antigen/Forefront Server Security)- Marked As Answer byNick Gu - MSFTMSFT, ModeratorFriday, October 09, 2009 1:44 AM
- Proposed As Answer byNick Gu - MSFTMSFT, ModeratorTuesday, October 06, 2009 7:31 AM
