2006/08/15

Get rid of the SQL-Server-2005-error in ASP.NET 2.0

ASP.NET 2.0 开发者经常会遇到这么一个奇怪的问题:明明没有安装 SQL Server 2005, 却在应用程序启动时得到错误信息,说连不上 SQL Server 2005, 提示如下:

An error has occurred while establishing a connection to the server. Whenconnecting to SQL Server 2005, this failure may be caused by the fact that underthe default settings SQL Server does not allow remote connections.

这个现象仅出现在通过 IIS 访问的情况下,而通过 File System 方式启动却没问题。

我的办法是,在 [connectionstrings] 后面紧接着加上 [clear], 删除所有内置的连接串,然后写上自己的 connectionstring.

另外,有时候远程 SQL Server 机器如果无法获取 IP 地址,也可能会出现这个问题,在使用 VPN Connection 无法解析计算机名时比较多见。解决办法是 Data Source 的值使用 IP 地址,或者在 hosts 中强制解析计算机。

7 条评论:

Unknown 说...

michael kors
ralph lauren outlet
louis vuitton handbags
coach outlet online
retro 11
oakley sunglasses wholesale
coach outlet online
cheap oakley sunglasses
kd shoes
coach factory outlet
jordan 5
abercrombie store
true religion jeans
jordan 8 playoffs
coach outlet online
retro jordans
oakley sunglasses wholesale
burberry scarf
red timberland boots
tods outlet
football jerseys
michael kors
cheap oakley sunglasses
louis vuitton
oakley sunglasses
20150603yuanyuan

mmjiaxin 说...

mac cosmetics
phone cases
toms outlet
prada outlet
ray ban outlet
chanel handbags outlet
cheap jordans
toms outlet store
nike running shoes
atlanta falcons
cheap nba jerseys
michael kors handbags
discount oakley sunglasses
north face outlet
nike free
ghd uk
new orleans saints
coach outlet online
michael kors canada
louis vuitton outlet store
mm1031

chenmeinv0 说...

stivali ugg
louis vuitton handbags
ralph lauren outlet
nike roshe run
true religion outlet
true religion jeans
ugg outlet online
cheap ugg boots
adidas nmd runner
michael kors
20172.6chenjinyan

Unknown 说...

ralph lauren polo
christian louboutin
cheap jordans for sale
longchamp handbags
nike trainers
adidas nmd runner
kobe bryant shoes
michael kors outlet online
cazal sunglasses
instyler ionic styler
chanyuan2017.03.17

Unknown 说...

retro jordans
nike mercurial
jordan shoes
hermes belt
nike air max
pandora charms
nike roshe run
true religion
adidas tubular
pandora charms sale

匿名 说...

cheap jordans
coach outlet
supra shoes
cheap jordans
polo ralph lauren
burberry outlet canada
michael kors outlet store
mulberry handbags
sac longchamp pas cher
nike free 5.0
mt0726

匿名 说...

coach outlet
canada goose jackets uk
coach outlet store
canada goose uk
pandora charms sale
ugg outlet
adidas yeezy boost
ray ban sunglasses discount
gucci handbags
doudoune moncler
mt0314