Cannot open database "WWALMDB" requested by the login.The login failed Login failed for user sa

Cannot open database "WWALMDB" requested by the login.The login failed Login failed for user sa

Wonderware Historian Configurator ArchestrA Reporting 中设置 Alarm Data Source for Sample Reports 时， 会出现的异常，百度误解，google 搜到了对应解决方案。

 

 

Unable to create WWALMDB with the Alarm DB Logger, says the login failed.

Problem

Trying to create a new Alarm Database on a new system, but the test connection and create databases fail saying that the login failed.

Product Version: 10.5

OS: Win 2008 32 bit

Solution

The SQL Server had been installed using the default settings. As such it was setup to only allow Windows Authentication, and not SQL Authentication (aka Mixed mode) as required by the Wonderware products. To fix this, logged into SQL MAnagement Studio using Windows Authentication, then right clicked on the server name in the tree and went to properties. Under security we set the server to use SQL Authentication and Windows Authentication. Then hit OK. Then under the Security> Logins section, we right clicked on the sa account and first entered a new password. We then went to the Security section on it and under Login set it to enabled. Once this was done, we right clicked on the server name at the top of the tree and selected Restart. Once this finished the Alarm DB Logger wa able to connect and create the database correctly.

Close Date: 2012-07-27 10:50:54

处理之后， 开始 - Wonderware - Intouch - Alarm DB Logger Manager  中 新建并测试对应的数据库。 即可。

form:

https://insource.mindtouch.us/Support_Tickets/InTouch/Installation%2F%2FConfiguration/044776_-_Unable_to_create_WWALMDB_with_the_Alarm_DB_Logger,_says_the_login_failed.