发布到Intranet时出错 [英] Error when publishing to Intranet

问题描述

我在VS2012中仅使用内部数据库创建了一个非常小的LS项目.

I created a very small LS project in VS2012 using only the intrinsic database.

我想将此应用程序发布到我们Intranet中的IIS服务器(2008)上. SQL Server 2008 R2在另一台物理服务器上.

I want to publish this app on an IIS server (2008) in our intranet. The SQL Server 2008 R2 is on another physical server.

应用程序将使用SQL登录名来访问数据库.

The application will use a SQL login to access the database.

我在服务器上创建了一个空白数据库(我具有管理员权限)，并希望LS发布向导为我创建结构.

I created a blank database on the server (I have admin rights) and want LS publish wizard to create the structure for me.

我启动了向导，回答所有问题，然后单击执行".我收到此错误:

I started the wizard, answer all the questions and click go. I get this error:

.Net SqlClient Data Provider: Msg 1934, Level 16, State 1, 
Procedure trgMonitorChangeSrv, Line 14 SELECT failed because the 
following SET options have incorrect settings: 
'CONCAT_NULL_YIELDS_NULL, ANSI_WARNINGS'. 
Verify that SET options are correct for use with indexed 
views and/or indexes on computed columns and/or 
filtered indexes and/or query notifications and/or 
XML data type methods and/or spatial index operations.

我尝试将这些选项设置为ON和OFF，结果相同.

I try setting these options to both ON and OFF with the same results.

有什么想法可以克服这个障碍吗?

Any ideas how to get over this hurdle?

推荐答案

嗨

您的解决方案在调试模式下工作正常吗?

Is your solution working fine in debug mode?

第一次发布应用程序时，请不要在sql server中创建新数据库. LightSwitch足够聪明，可以执行此活动.首次发布应用程序时，LightSwitch会自动为您创建一个新的数据库架构. 在连接属性"窗口中，写下新的数据库名称.

Please do not create a new database in sql server when you are publishing the application first time. LightSwitch is smart enough to do this activity. LightSwitch automatically create a new database schema for you when you publish the application first time. In the Connection Properties window just write down the new database name.

如果您当时想更新现有的应用程序，则必须选择现有的数据库并发布该应用程序.

If you want to update an existing application at that time you have to select the existing database and publish the application.

希望获得帮助...

致谢

这篇关于发布到Intranet时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！