＆QUOT;提供者未返回ProviderManifestToken字符串＆QUOT; [英] "The provider did not return a ProviderManifestToken string"

问题描述

我想教自己的.Net MVC 3，和我下面这个教程：的http://www.asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/intro-to-aspnet-mvc-3并达到你创建前面创建的模型控制器步骤(http://www.asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controller).

I'm trying to teach myself .Net MVC 3, and am following this tutorial: http://www.asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/intro-to-aspnet-mvc-3 and have reached the step where you create the controller for the Model you created earlier (http://www.asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controller).

当我试图创建控制器，我得到的提供者未返回ProviderManifestToken字符串错误。谷歌搜索有点让我相信这是由于我的连接字符串错误。

When I try to create the controller, I get the "The provider did not return a ProviderManifestToken string" error. A bit of googling leads me to believe this is due to an error with my connection string.

问题是我没有运行SQL Server在本地，所以我不能复制的例子的ConnectionString。这就是我现在得到：

The thing is I'm not running SQL Server locally, so I can't copy the example connectionString. Here's what I've got now:

connectionString="Data Source=1.2.3.4\MSSQLSERVER;Initial Catalog=myDBname;Integrated Security=False;User ID=myUsername;Password=myPassword"

我使用SSMS使用的用户名和密码登录到数据库的尝试，和它的作品，所以问题不在于用户本身。

I've tried using SSMS to log on to the database using the username and password, and it works, so the problem is not with the user itself.

任何想法？

推荐答案

我想通了：原来，不需要在我的情况\\ MSSQLSERVER。我不知道这是否是因为我通过IP或者如果它是具体到我的服务器设置连接，但删除它解决了这个问题。

I figured it out: turns out that "\MSSQLSERVER" isn't needed in my case. I'm not sure if it's because I'm connecting by IP or if it's specific to my server setup, but removing it solved the problem.

这篇关于＆QUOT;提供者未返回ProviderManifestToken字符串＆QUOT;的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！