問題描述
在解決 RIA 安裝問題后這里，我仍然收到以下錯誤.沒什么特別的 - 我嘗試基于完整 SQL 2005 實例中現有數據庫的數據源創建一個新屏幕
After resolving issues with RIA installation here, I'm still getting this following error. Not much special - I tried to create a new screen based off of data sources from an existing database in a full SQL 2005 instance
建立一個錯誤連接到 SQL Server 實例'.\SQLEXPRESS'.與網絡相關的或特定于實例的錯誤發生時建立到 SQL 的連接服務器.未找到服務器或無法訪問.驗證實例名稱正確且該 SQL服務器配置為允許遠程連接.(提供者:SQL 網絡接口，錯誤:26 - 錯誤定位服務器/實例指定)
An error occurred while establishing a connection to SQL Server instance '.\SQLEXPRESS'. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
我想更正自動生成的配置文件中的連接字符串.盡管 Visual Studio 似乎不認為該文件在重建時被覆蓋，但錯誤仍會繼續出現.
I've tried to correct the connection string in the, I guess, autogen'd config file. Even though Visual Studio doesn't seem to think that the file is overwritten on rebuild, the error continues to appear.
如何將 LightSwitch 與完整的 SQL 2005 而不是 SQL Express 一起使用?
How can I use LightSwitch with full SQL 2005 rather than SQL Express?
推薦答案
似乎在本地工作時，LightSwitch 使用 SQL Server Express.它將成員身份、角色和其他身份驗證信息放在這里.我不知道有什么方法可以在本地解決這個問題，但是當您發布"您的項目時，您可以使用不同的數據庫/服務器.您也可以使用任何您喜歡的服務器/數據庫作為您的數據源.
It seems when working Locally, LightSwitch uses SQL Server Express. It puts it's Membership, Roles, and other authentication information here. I don't know any way to get around this locally, but when you go to "Publish" your project, you're given the ability to use a different database/server. You can also use whatever server/database you'd like for your data sources as well.
希望在 V1 之前，他們將允許您更改它.但是我還沒有找到方法，不會不斷覆蓋配置.
Hopefully, before V1, they'll allow you to change that. But I haven't found a way yet, without the config being overwritten constantly.
這篇關于LightSwitch Beta 1 尋找 SQL Express 而不是完整的 SQL 實例的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！