其他计算机中的SQL Server问题 [英] Problem with SQL server in other computer

问题描述

你好，



我用cql数据库在c＃中创建了一个windows应用程序。我创建了一个设置文件，在我的计算机上安装没有问题，但在其他计算机上显示这个消息。



未处理的异常发生在你的应用。如果单击继续，应用程序将忽略此emor并尝试继续。如果单击退出，应用程序将立即关闭在建立与SQL Server的连接时出现网络兴趣或特定于实例的emor。服务器未找到或无法访问。验证实例名称是否已来，并且SQL Server配置为允许远程连接提供程序：SQL网络接口，emor：52无法找到本地数据库运行时安装。验证SQL Server Express是否已安装属性并且已启用本地数据库运行时功能。）



我需要做什么？我该怎么办呢？



我的连接字符串是这样的：



< add name = QFD_login.Properties.Settings.UsersDatabaseConnectionStringconnectionstring =Data Source =（LocalDB）\ v11.0; AttachDbFilename = | DataDirectory | \ UsersDatabase.mdf; Integrated Security = Trueprovidername =System.Data.SqlClient> ;



我尝试了什么：



i试图改变v11 .0到v12.0，但是当我这样做时，我无法打开应用程序到我的电脑..

Hello,

i have created a windows application in c# with sql database. i create a set up file, which is installed with no problems in my computer, but in other computer shows this messenge.

Unhandled exception has occumed in your application. lf you click Continue, the application will ignore this emor and attempt to continue. lf you click Quit, the application will close immediately A network-elated or instance-specific emor occumed while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is comect and that SQL Server is configured to allow remote connection provider: SQL Network Interfaces, emor: 52 nable to locate a Local Database Runtime installation. Verify that SQL Server Express is property installed and that the Local Database Runtime feature is enabled.)

What i have to do?? how can i fix it??

my connection string is this:

<add name="QFD_login.Properties.Settings.UsersDatabaseConnectionString" connectionstring="Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\UsersDatabase.mdf;Integrated Security=True" providername="System.Data.SqlClient">

What I have tried:

i have tried to change v11.0 to v12.0 but when i did, i couldnt open the app either to my pc..

推荐答案

确保你的SQL服务器运行时版本与你的DB路径描述和SQL数据库文件相同，在PC上你想运行你的应用程序（版本冲突也可能导致这个）。



如果你有，那么在Windows启动时搜索services.msc。并以管理员身份运行它。找到您的SQL Server服务重启/启动它。

make sure you have SQL server runtime of same version as ur DB path describes and same goes for SQL database files, on the PC u wanna run your application(version conflict can also cause this).

if you have, then search "services.msc" in windows startup. and run it as administrator. locate your SQL Server service restart/start it.

这篇关于其他计算机中的SQL Server问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！