web.config中localdb的问题 [英] Problem with localdb in web.config

问题描述

< connectionstrings>

< add connectionString =Data Source =（local）; Initial Catalog = SalesERPDB; Integrated Security = True

name =SalesERPDAL

providerName =System.Data.SqlClient/>





此代码来自在7天内学习MVC项目教程正在收到服务器未找到或无法访问的错误。从我读到的是因为我通过Visual Studio使用的SQL Server实例没有配置为远程访问。有没有办法纠正这个。



我尝试过：



Sql Server配置管理器不起作用。它得到一个错误'无法连接到WMI提供程序。'

解决方案

您好，首先检查您的sqlserver服务是否正在运行，不应该停止，谢谢

请检查SQL实例是否正在运行&它的港口。此外，您正在使用集成安全性，这意味着应用程序（Visual Studio或IIS）启动的帐户应该可以访问SQL Server。如果SQL服务正在运行，请检查它是否配置为Windows身份验证

<connectionstrings>
<add connectionString="Data Source=(local);Initial Catalog=SalesERPDB;Integrated Security=True"
name="SalesERPDAL"
providerName="System.Data.SqlClient"/>


This code from your "Learn MVC Project in 7 days" tutorial is getting an error that the server is not found or is not accessible. From what I have read it is because the instance of SQL Server I am using through Visual studio is not configured for remote access. Is there a way to correct this.

What I have tried:

Sql Server configuration manager does not work. It gets an error 'cannot connect to WMI provider.'

解决方案

Hi, first check if your sqlserver services are running, it should not be stopped, thanks

Please check SQL instance is running & its port. Also you are using Integrated security, which means account from which application (Visual studio or IIS) is getting started should have access to SQL server. If SQL service is running, please check if it is configured for windows authentication

这篇关于web.config中localdb的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！