本文介绍了安装和连接到SQL Server 2008 R2时出错的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

你好

当我尝试在Windows 7 32位旗舰版上安装Sql Server 2008 R2时,出现此错误. http://www.img4up.com/up2/77005471169527712970.jpg [ ^ ]

我单击继续.在安装后,当我想从Visual Studio连接它时,出现此错误:

未处理SQLException建立与SQL Server的连接时发生与网络相关或特定于实例的错误.服务器未找到或无法访问.验证实例名称正确并且已将SQL Server配置为允许远程连接.(提供者:命名管道提供程序,错误:40-无法打开与SQL Server的连接)

在安装向导中,我看到实例名称不适用.

如何解决这些问题并从vs2010连接到sql server 2008 r2?

这是我的sql配置的屏幕截图: http://www.img4up.com/up2/47950084566701531201.jpg [< ^ ]

Hello

When I try to install Sql server 2008 r2 on my windows 7 32 bit ultimate I get this error. http://www.img4up.com/up2/77005471169527712970.jpg[^]

I click continue. and after installing when I want to connect it from visual studio I get this error:

SQLException was unhandled 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:Named Pipes Provider,error:40-could not open a connection to SQL Server)

In installation wizard I saw that the instance name is not applicable.

How I can solve these problems and connect to sql server 2008 r2 from vs2010?

This is a screen shot from my sql configuration: http://www.img4up.com/up2/47950084566701531201.jpg[^]

推荐答案



这篇关于安装和连接到SQL Server 2008 R2时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-05 09:39