使 Silverlight 业务应用程序模板正常工作需要什么数据库？
我一直在尝试运行 Silverlight 业务应用程序模板，但在尝试注册时失败。我有带有 MSSQLSERVER 实例的 SQL Express，并且定义了创建的标准 aspnetdb。
错误是：
Submit operation failed. Unable to connect to SQL server database.
at System.Web.DomainServices.ReflectionDomainServiceDescriptionProvider.ReflectionDomainOperationEntry.Invoke(DomainService domainService, Object[] parameters)
at System.Web.DomainServices.DomainService.InvokeDomainOperationEntry(DomainOperationEntry domainOperationEntry, Object[] parameters, ChangeSetEntry operation)
at System.Web.DomainServices.DomainService.InvokeCudOperations(ChangeSet changeSet)
at System.Web.DomainServices.DomainService.ExecuteChangeSet(ChangeSet changeSet)
at System.Web.DomainServices.DomainService.Submit(ChangeSet changeSet)
at System.Web.Ria.Services.ChangeSetProcessor.Process(DomainService domainService, IEnumerable`1 changeSetEntries)
at System.Web.Ria.Services.SubmitOperationBehavior.SubmitOperationInvoker.InvokeCore(Object instance, Object[] inputs, Object[]& outputs)
I've been trying to run the Silverlight Business Application template but it fails when I try to register. I have SQL Express with an MSSQLSERVER instance and I've defined the standard aspnetdb created.
The error is:
Submit operation failed. Unable to connect to SQL server database.
at System.Web.DomainServices.ReflectionDomainServiceDescriptionProvider.ReflectionDomainOperationEntry.Invoke(DomainService domainService, Object[] parameters)
at System.Web.DomainServices.DomainService.InvokeDomainOperationEntry(DomainOperationEntry domainOperationEntry, Object[] parameters, ChangeSetEntry operation)
at System.Web.DomainServices.DomainService.InvokeCudOperations(ChangeSet changeSet)
at System.Web.DomainServices.DomainService.ExecuteChangeSet(ChangeSet changeSet)
at System.Web.DomainServices.DomainService.Submit(ChangeSet changeSet)
at System.Web.Ria.Services.ChangeSetProcessor.Process(DomainService domainService, IEnumerable`1 changeSetEntries)
at System.Web.Ria.Services.SubmitOperationBehavior.SubmitOperationInvoker.InvokeCore(Object instance, Object[] inputs, Object[]& outputs)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您需要通过对名为 SQLExpress 的 SQL Server 实例运行 aspnet_regsql.exe 创建的 aspnetdb 数据库 - 这可以在 machine.config 的 LocalSqlServer 连接字符串中找到。或者将 LocalSqlServer 连接字符串替换为指向 SQL 实例的字符串。像这样的东西：
You need the aspnetdb database created by running aspnet_regsql.exe against a SQL Server instance called SQLExpress - this can be found in the LocalSqlServer connection string in machine.config. Or by replacing the LocalSqlServer connection string with something that points to your SQL instance. Something like this:
不要搞乱 machine.config
前往
Silverlight-TV-51-调试-and-Deploying-WCF-RIA-Services
然后执行以下操作：
在 Windows 7 下的 IIS 中，选择应用程序池，然后选择“高级设置”。在“流程模型”下找到“加载用户配置文件”并将其设置为 true。
SQL 现在应该在默认应用程序池帐户下加载。
Don't mess with machine.config
Go to
Silverlight-TV-51-Debugging-and-Deploying-WCF-RIA-Services
then do this:
In IIS under Windows 7, Select the application pool and then "advanced settings." Under "process model" find "Load User Profile" and set it to true.
SQL should now load under the default app pool account.