問(wèn)題描述

在解決 RIA 安裝問(wèn)題后這里，我仍然收到以下錯(cuò)誤.沒(méi)什么特別的 - 我嘗試基于完整 SQL 2005 實(shí)例中現(xiàn)有數(shù)據(jù)庫(kù)的數(shù)據(jù)源創(chuàng)建一個(gè)新屏幕

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

建立一個(gè)錯(cuò)誤連接到 SQL Server 實(shí)例'.\SQLEXPRESS'.與網(wǎng)絡(luò)相關(guān)的或特定于實(shí)例的錯(cuò)誤發(fā)生時(shí)建立到 SQL 的連接服務(wù)器.未找到服務(wù)器或無(wú)法訪問(wèn).驗(yàn)證實(shí)例名稱正確且該 SQL服務(wù)器配置為允許遠(yuǎn)程連接.(提供者:SQL 網(wǎng)絡(luò)接口，錯(cuò)誤:26 - 錯(cuò)誤定位服務(wù)器/實(shí)例指定)

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)

我想更正自動(dòng)生成的配置文件中的連接字符串.盡管 Visual Studio 似乎不認(rèn)為該文件在重建時(shí)被覆蓋，但錯(cuò)誤仍會(huì)繼續(xù)出現(xiàn).

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?

推薦答案

似乎在本地工作時(shí)，LightSwitch 使用 SQL Server Express.它將成員身份、角色和其他身份驗(yàn)證信息放在這里.我不知道有什么方法可以在本地解決這個(gè)問(wèn)題，但是當(dāng)您發(fā)布"您的項(xiàng)目時(shí)，您可以使用不同的數(shù)據(jù)庫(kù)/服務(wù)器.您也可以使用任何您喜歡的服務(wù)器/數(shù)據(jù)庫(kù)作為您的數(shù)據(jù)源.

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 之前，他們將允許您更改它.但是我還沒(méi)有找到方法，不會(huì)不斷覆蓋配置.

Hopefully, before V1, they'll allow you to change that. But I haven't found a way yet, without the config being overwritten constantly.

這篇關(guān)于LightSwitch Beta 1 尋找 SQL Express 而不是完整的 SQL 實(shí)例的文章就介紹到這了，希望我們推薦的答案對(duì)大家有所幫助，也希望大家多多支持html5模板網(wǎng)！