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 中强制解析计算机。

12 条评论:

Lin Huang 说...

caihuanglin20150520
prada outlet
oakley sunglasses
true religion jeans
chanel handbags
coach outlet online
burberry outlet online
true religion sale
cheap jordans
coach factory outlet
abercrombie
michael kors outlet
air max 90
coach factory outlet
gucci outlet online
ray ban sunglasses
ray ban sunglasses
michael kors outlet online
oakley sunglasses sale
burberry scarf
pandora jewelry
ray bans
fitflops outlet
ralph lauren outlet
christian louboutin outlet
rolex watches
michael kors bag
pandora outlet
caoch outlet
gucci outlet
chanel online shop
chanel bags
hollister clothing
kate spade handbags
coach outlet
ralph lauren
coach outlet store online
oakley sunglasses wholesale
ray ban glasses
polo ralph lauren
tory burch outlet online

One J 说...

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

One J 说...

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

John 说...

longchamp soldes
adidas running shoes
tory burch outlet
fitflops
abercrombie and fitch
abercrombie kids
michael kors
longchamp handbags
louis vuitton outlet
louis vuitton handbags
fitflop sale
michael kors outlet online
pandora charms
tory burch handbags
michael kors handbags
michael kors outlet online
louis vuitton outlet
michael kors outlet
lv outlet
ed hardy clothing
gucci bags
louis vuitton handbags
red timberland boots
abercrombie and fitch outlet
oakley vault
chi flat irons
coach outlet store online
polo ralph lauren
201576yuanyuan

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

huangqing 说...

polo ralph lauren
ralph lauren shirts
coach outlet
ralph lauren outlet
michael kors outlet
nike tn pas cher
nike air force 1
cheap mlb jerseys
ralph lauren uk
ferragamo shoes
kate spade uk
mulberry outlet
timberland boots
ferragamo shoes
oakley sunglasses
kobe bryant shoes
adidas trainers
michael kors outlet
calvin klein underwear
coach outlet online
coach outlet online
nike air max
michael kors sale
michael kors outlet sale
coach outlet store
babyliss flat iron
mulberry sale
toms outlet store
michael kors factory outlet
cazal outlet
cheap snapbacks
oakley canada
ralph lauren outlet
cheap jordan shoes
cheap oakley sunglasses
16.5.28qqqqqing

chenlina 说...

ugg boots outlet
gucci outlet
louis vuitton outlet stores
tommy hilfiger outlet
north face jackets
ray ban sunglasses
louis vuitton outlet
louis vuitton outlet
true religion uk
louis vuitton handbags
miami heat jerseys
nike nfl jerseys
oakley sunglasses
fitflop sandals
ralph lauren
coach canada
kate spade outlet
chaussures christian louboutin
timberland boots
replica watches for sale
canada goose outlet
cheap air jordans
rolex watches
ray ban sunglasses
oakley sunglasses
michael kors outlet
coach outlet store online clearances
canada goose outlet
gucci handbags
toms shoes
louis vuitton
uggs for cheap
toms shoes
michael kors outlet
pandora jewelry
seattle seahawks jerseys
uggs canada
replica watches
san antonio spurs jerseys
louis vuitton
chenlina20161105

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

chenmeinv0 说...

adidas originals shoes
christian louboutin sale
nike roshe run
ray ban clubmaster
michael kors outlet clearance
ray ban wayfarer
michael kors handbags
nike air max 90
cheap nba jerseys
vans outlet
hzx20170410

happy 123 说...

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

ninest123 说...

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