安装和连接到SQL Server 2008 R2时出错 [英] error in installation and connection to sql server 2008 r2

问题描述

你好

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

推荐答案

这对我有帮助，几天前我也遇到了同样的麻烦:
http://stackoverflow.com/a/3612692/654321

This helped me, I was suffering from the same trouble just a few days ago:
http://stackoverflow.com/a/3612692/654321

MS SQL 2008 Express的命名实例有问题.请参阅有关此说明

MS SQL 2008 Express has an issue with named instances. Please see this note about it
https://connect.microsoft.com/SQLServer/feedback/details/361809/selecting-the-default-instance-option-in-sql-server-2008-express-rtm-has-no-effect[^]

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