Web 平台安装程序和 sql Express 数据库设置
我今天尝试使用 Web 平台安装程序安装 Amplifeeder。
当我到达数据库设置时，我必须填写一些信息，例如“数据库管理员用户/密码”和用户用户名/密码。
使用 SQL Express 我没有任何用户名/密码（无论是管理员还是用户）。我应该如何使用 WPI 和 SQL Express 2008 安装应用程序？
基本上我在尝试在日志中安装时遇到了这个错误：
DownloadManager Error: 0 : MS Deploy exception: Microsoft.Web.Deployment.DeploymentClientServerException: The database 'AmpliFeederDB' could not be created. ---> System.Data.SqlClient.SqlException: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
I tried to install Amplifeeder today with the Web Platform Installer.
When I arrived at the database setup I had to fill out some informations like "db admin user/password" and user username/password.
Using SQL Express I do not have any username/password (neither admin or user). How should I be able to install applications with the WPI and SQL Express 2008 ?
Basically I had this error while trying to install in the logs :
DownloadManager Error: 0 : MS Deploy exception: Microsoft.Web.Deployment.DeploymentClientServerException: The database 'AmpliFeederDB' could not be created. ---> System.Data.SqlClient.SqlException: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我终于通过命令行和注册表修复实现了这一点。
LoginMode必须为 2重新启动 SQL Server Express 服务。
然后 ：
在命令行中：
之后安装应用程序应该可以解决问题。
I finally achieved this by command line and reg fixes.
LoginModemust be 2restart SQL Server Express service.
Then :
In command line :
It should do the trick to install the applications after.
据我所知，使其工作的唯一方法是使用位于应用程序文件夹中的命令行实用程序“WebPICmd.exe”。
您确实需要一个强密码，因为它使用正则表达式进行验证。
一切似乎都正常，我能够通过 OSQL 和 Management Studio 访问数据库，登录没有问题，启用了身份验证、TCP/IP 和命名管道。但没有任何效果...这似乎是某种错误....
像他一样尝试：
WebPICmd.exe /Install /Application:"Joomla"
As far as I know the only way I could make it work was by using the command line utility 'WebPICmd.exe' located in the application folder.
You do need a strong password because it uses a regular expression to verify.
All seemed OK, I was able to access the DB thru OSQL and also Management Studio, had no problems with logons, had both authentications enabled, TCP/IP and named pipes. yet nothing worked... It seems to be some kind of a bug....
Thry it like his:
WebPICmd.exe /Install /Application:"Joomla"
当您第一次安装 SQL Server Express 时，您可以选择身份验证模式，其中您可以选择混合模式身份验证并提供管理员身份验证详细信息。
When you install SQL Server Express for the first time, you would have had option to select authentication mode, where you would select MIXED mode authentication and provide admin authentication details.
那么，SQL Server Management Studio Express 提供了更可持续的解决方案。请参阅此链接，而无需摆弄注册表项和运行命令：
http:// /www.knowledgesutra.com/forums/topic/61695-resolving-cant-login-to-sqlexpress-using-sa-account/
Well, the SQL Server Management Studio Express provides a more sustainable solution. See this link, without having to fiddle with registry keys & running commands:
http://www.knowledgesutra.com/forums/topic/61695-resolving-cant-login-to-sqlexpress-using-sa-account/