SQL Server 2008 和 SQL Server 2008 Visual Web Developer 2008 Express 版本:与数据库的连接失败!
所以我看到了这个问题/评论...
如何将 SQL Server 2005 Express Edition 集成到 Visual Web Developer 2008 Express Edition
这正是我遇到的问题,仅使用 SQL Server 2008 Express Edition 和 Visual Web开发2008快递。每次我尝试单击添加新数据库时,都会收到完全相同的错误代码。
我尝试了另一个问题的回答,但这并没有解决我的问题。
请嘻嘻!!!谢谢
编辑:
我应该注意,这些安装在我的家用笔记本电脑上用于学习目的。
该实例必须是命名实例,尽管我不确定那是什么。当我加载它并选择连接时:“服务器名称”显示为“JUSTIN-PC\SQLEXPRESS”,尽管我不确定这就是所谓的实例名称。
我确实在 Visual Studio 数据连接字段中尝试过此操作,但它不起作用,所以我认为这是不对的。所以我正在阅读有关它的帮助,但真的迷失了......虽然看起来它可能为我分配了一个命名实例,但我不知道那是什么。
谢谢各位帮助菜鸟学习!!
So I saw this question/comment...
How to integrate SQL Server 2005 Express Edition to Visual Web Developer 2008 Express Edition
And this is EXACTLY what I am having trouble with, only using SQL Server 2008 express edition and Visual Web Dev 2008 express. Everytime I try to click to add a new database I get the exact same error code.
I tried the response on the other question, and this did not solve the problem for me.
PLEASE HEEEEEELLLPP!!! Thanks
EDIT:
I should note that these are installed on my home laptop for learning purposes.
The instance must have been a named instance, though I am not sure of what that is. When I load it up, and select the connect: the "server name" appear as 'JUSTIN-PC\SQLEXPRESS' though I am not sure this is what is referred to as the instance name.
I did try this though in the visual studio data connection field, and it did not work, so I am assuming this is not right. So I am reading help on it but really lost...although it looks like it probably assigned a named instance for me, though I do not know what that was.
Thanks for helping the rookies learn!!
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
如果将数据库添加到 App_Data 文件夹(而不是在 SQL Management Studio 中创建数据库),则可能会遇到已安装的 SQL 版本与 Visual Studio 期望的 SQL 版本之间的冲突。这是我目前的工作情况,我有 Visual Studio 2008 Team 和 SQL Server 2008 - 因为我不使用 App_Data 进行开发,所以它并没有真正困扰我。
可以尝试以下几件事:
If you adding a database to the App_Data folder (rather than creating the database in SQL Management Studio), you are probably getting a conflict between the version of SQL you have installed and the one that Visual Studio expects. This is my current situation at work where I have Visual Studio 2008 Team and SQL Server 2008 - because I do not develop using App_Data, it doesn't really bother me.
Couple of things to try:
您是否尝试在 VS 数据库设置中仅添加
SQLEXPRESS
?我不确定前面的主机名是否可以正常工作。我家里的只是说SQLEXPRESS
。Did you try putting just
SQLEXPRESS
in the VS database settings? I'm not sure if it works properly with the host name in front. Mine at home just saysSQLEXPRESS
.