System.Data.SqlClient.SqlException in .NET 1.1 and 2.0

I recently had the privelege to explore a SQL 2000 to SQL 2005 upgrade for one of our Web applications, and in the same breath an upgrade from the .NET 1.1 framework to .NET 2.0…


I’ll talk about the specifics that I learned during the SQL upgrade another time, but I ran into only one issue during my 1.1 to 2.0 upgrade process. The issue wasn’t even really an .NET framework issue.


Long story short, my lesson learned was essentially establish that the app works before the upgrade. Duh, can you say BASELINE? What threw me for a loop which led me astray is that the .NET 2.0 led me to believe that I had a SQL 2005 configuration issue:


Error With .NET 2.0
Exception=System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)


To troubleshoot, I rolled back to .NET 1.1 with SQL 2000 and saw:


Error With .NET 1.1
Exception=System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.


Interesting, so I didn’t have a SQL 2005 OR .NET 2.0 problem. The issue? I learned that the above errors occur when:


1. SQL not started (duh, that wasn’t my problem though)
2. IPSEC configured incorrectly (my problem)

The fix:
1. Start SQL Server
2. Configure IPSEC so that the servers  can be pinged successfully in both directions (Web server to SQL and SQL to Web server)


Why am I telling you all of this? Because I have nothing better to do right now. Err… Or…While Googling on my SQL 2005 error I found some great SQL Server 2005 connection troubleshooting links. If you’re stuck with SQL 2005 connection issues here are three some references to check out:


Troubleshoot Connectivity Issue in SQL Server 2005 – Part I

Troubleshoot Connectivity Issue in SQL Server 2005 – Part II

Troubleshoot Connectivity Issue in SQL Server 2005 – Part III


Even Better, just use this site/search

11 Responses to System.Data.SqlClient.SqlException in .NET 1.1 and 2.0

  1. wow gold says:

    Sehr gut gemachter Internetauftritt – gef?llt uns ausgezeichnet. Bei uns finden Sie WOW Gold unter
    Beste Grü?e,

  2. tuzi says:

    [url=http://www.mmostar.com/index.php?cPath=775]Anarchy Online Credits[/url]
    [url=http://www.mmostar.com/index.php?cPath=639]Archlord Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=807]Auto Assault Scrip[/url]
    [url=http://www.mmostar.com/index.php?cPath=642]City of Heroes Influence[/url]
    [url=http://www.mmostar.com/index.php?cPath=643]COV Infamy[/url]
    [url=http://www.mmostar.com/index.php?cPath=834]DAOC Plat[/url]
    [url=http://www.mmostar.com/index.php?cPath=638]Dofus Kamas[/url]
    [url=http://www.mmostar.com/index.php?cPath=645]DDO Plat[/url]
    [url=http://www.mmostar.com/index.php?cPath=598]EVE ISK[/url]
    [url=http://www.mmostar.com/index.php?cPath=714]EQ2 Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=33]FFXI Gil[/url]
    [url=http://www.mmostar.com/index.php?cPath=826]Gaia Online Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=650]Guild Wars Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=829]Kal Online Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=831]Last Chaos Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=764]Lineage 2 Adena[/url]
    [url=http://www.mmostar.com/index.php?cPath=631]Maple Story Mesos[/url]
    [url=http://www.mmostar.com/index.php?cPath=835]matrix online information[/url]
    [url=http://www.mmostar.com/index.php?cPath=21]RF Online CP, Dalant, Disena[/url]
    [url=http://www.mmostar.com/index.php?cPath=641]Rappelz Rupees[/url]
    [url=http://www.mmostar.com/index.php?cPath=833]Rose Online Zulie[/url]
    [url=http://www.mmostar.com/index.php?cPath=647]Runescape Money[/url]
    [url=http://www.mmostar.com/index.php?cPath=830]Scions of Fate Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=648]SilkRoad Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=781]SWG Credits[/url]
    [url=http://www.mmostar.com/index.php?cPath=809]Vanguard Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=145]World of Warcraft Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=647]Runescape Money[/url]
    [url=http://www.mmostar.com/index.php?cPath=647]Runescape Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=821]Voyage Century Silver coin[/url]
    [url=http://www.mmostar.com/index.php?cPath=828]Second Life Linden[/url]
    [url=http://www.mmostar.com/index.php?cPath=832]LOTRO Gold[/url]
    [url=http://www.mmostar.com/index.php?cPath=647]Runescape Gold[/url]
    [url=http://www.akgame.com/anarchy-online-c-33.html]Anarchy Online Credits[/url]
    [url=http://www.akgame.com/archlord-c-48.html]Archlord Gold[/url]
    [url=http://www.akgame.com/auto-assault-c-34.html]Auto Assault Scrip[/url]
    [url=http://www.akgame.com/city-of-heroes-c-35.html]City of Heroes Influence[/url]
    [url=http://www.akgame.com/city-of-villains-c-43.html]COV Infamy[/url]
    [url=http://www.akgame.com/dark-age-of-camelot-c-36.html]DAOC Plat[/url]
    [url=http://www.akgame.com/dofus-c-50.html]Dofus Kamas[/url]
    [url=http://www.akgame.com/dofus-c-50.html]Dofus money[/url]
    [url=http://www.akgame.com/dungeons-and-dragons-c-37.html]DDO Plat[/url]
    [url=http://www.akgame.com/dungeons-and-dragons-c-37.html]DDO gold[/url]
    [url=http://www.akgame.com/eve-online-c-8.html]EVE ISK[/url]
    [url=http://www.akgame.com/everquest-2-c-3.html]EQ2 Gold[/url]
    [url=http://www.akgame.com/everquest-2-c-3.html]EQ2 plat[/url]
    [url=http://www.akgame.com/everquest-2-c-3.html]everquest 2 gold[/url]
    [url=http://www.akgame.com/final-fantasy-xi-c-6.html]FFXI Gil[/url]
    [url=http://www.akgame.com/gaia-online-c-42.html]Gaia Online Gold[/url]
    [url=http://www.akgame.com/guild-wars-c-7.html]Guild Wars Gold[/url]
    [url=http://www.akgame.com/kal-online-c-49.html ]Kal Online Gold[/url]
    [url=http://www.akgame.com/last-chaos-c-47.html]Last Chaos Gold[/url]
    [url=http://www.akgame.com/lineage-2-c-4.html]Lineage 2 Adena[/url]
    [url=http://www.akgame.com/maple-story-c-41.html]Maple Story Mesos[/url]
    [url=http://www.akgame.com/matrix-online-c-44.html]matrix online information[/url]
    [url=http://www.akgame.com/rf-online-c-39.html]RF Online CP, Dalant, Disena[/url]
    [url=http://www.akgame.com/rappelz-online-c-53.html]Rappelz Rupees[/url]
    [url=http://www.akgame.com/rose-online-c-51.html]Rose Online Zulie[/url]
    [url=http://www.akgame.com/runescape-c-52.html]Runescape Money[/url]
    [url=http://www.akgame.com/runescape-c-52.html]Runescape Gold[/url]
    [url=http://www.akgame.com/scions-of-fate-c-46.html]Scions of Fate Gold[/url]
    [url=http://www.akgame.com/silkroad-c-45.html]SilkRoad Gold[/url]
    [url=http://www.akgame.com/star-wars-galaxies-c-5.html]SWG Credits[/url]
    [url=http://www.akgame.com/vanguard-saga-of-heroes-c-40.html]Vanguard Gold[/url]
    [url=http://www.akgame.com]World of Warcraft Gold[/url]
    [[url=http://www.akgame.com/voyage-century-c-55.html]Voyage Century Silver coin[/url]
    [url=http://www.akgame.com/second-life-linden-c-56.html]Second Life Linden[/url]
    [url=http://www.akgame.com/the-lord-of-the-rings-ol-c-57.html]LOTRO Gold[/url]
    [url=http://www.akgame.com/dungeons-and-dragons-c-37.html]DDO gold[/url]
    [url=http://www.akgame.com/everquest-2-c-3.html]Everquest 2 Gold[/url]
    [url=http://www.akgame.com/everquest-2-c-3.html]EQ2 plat[/url]
    [url=http://www.gmtbank.com/]world of warcraft gold[/url]
    [url=http://www.gmtbank.com/index.php?cPath=29]world of warcraft gold[/url]
    [url=http://www.vgamepsp.com/psp-adapter-p-1.html]psp ac adapter[/url]
    [url=http://www.vgamepsp.com/ps2-32m-memory-cards-p-42.html]ps2 memory card[/url]
    [url=http://www.vgamepsp.com]video game accessories[/url]
    [url=http://www.vgamepsp.com/nintendo-wii-accessories-c-9.html]wii accessories[/url]
    [url=http://www.vgamepsp.com/chips-game-c-14.html]chips game[/url]

  3. tuzi says:

    <a href=http://www.mmostar.com/index.php?cPath=775>Anarchy Online Credits</a>
    <a href=http://www.mmostar.com/index.php?cPath=639>Archlord Gold</a>
    <a href=http://www.mmostar.com/index.php?cPath=807>Auto Assault Scrip</a>
    <a href=http://www.mmostar.com/index.php?cPath=642>City of Heroes Influence</a>
    <a href=http://www.mmostar.com/index.php?cPath=643>COV Infamy</a>
    <a href=http://www.mmostar.com/index.php?cPath=834>DAOC Plat</a>
    <a href=http://www.mmostar.com/index.php?cPath=638>Dofus Kamas</a>
    <a href=http://www.mmostar.com/index.php?cPath=645>DDO Plat</a>
    <a href=http://www.mmostar.com/index.php?cPath=598>EVE ISK</a>
    <a href=http://www.mmostar.com/index.php?cPath=714>EQ2 Gold</a>
    <a href=http://www.mmostar.com/index.php?cPath=33>FFXI Gil</a>
    <a href=http://www.mmostar.com/index.php?cPath=826>Gaia Online Gold</a>
    <a href=http://www.mmostar.com/index.php?cPath=650>Guild Wars Gold</a>
    <a href=http://www.mmostar.com/index.php?cPath=829>Kal Online Gold</a>
    <a href=http://www.mmostar.com/index.php?cPath=831>Last Chaos Gold</a>
    <a href=http://www.mmostar.com/index.php?cPath=764>Lineage 2 Adena</a>
    <a href=http://www.mmostar.com/index.php?cPath=631>Maple Story Mesos</a>
    <a href=http://www.mmostar.com/index.php?cPath=835>matrix online information</a>
    <a href=http://www.mmostar.com/index.php?cPath=21>RF Online CP, Dalant, Disena</a>
    <a href=http://www.mmostar.com/index.php?cPath=641>Rappelz Rupees</a>
    <a href=http://www.mmostar.com/index.php?cPath=833>Rose Online Zulie</a>
    <a href=http://www.mmostar.com/index.php?cPath=647>Runescape Money</a>
    <a href=http://www.mmostar.com/index.php?cPath=830>Scions of Fate Gold</a>
    <a href=http://www.mmostar.com/index.php?cPath=648>SilkRoad Gold</a>
    <a href=http://www.mmostar.com/index.php?cPath=781>SWG Credits</a>
    <a href=http://www.mmostar.com/index.php?cPath=809>Vanguard Gold</a>
    <a href=http://www.mmostar.com/index.php?cPath=145>World of Warcraft Gold</a>
    <a href=http://www.mmostar.com/index.php?cPath=647>Runescape Money</a>
    <a href=http://www.mmostar.com/index.php?cPath=647>Runescape Gold</a>
    <a href=http://www.mmostar.com/index.php?cPath=821>Voyage Century Silver coin</a>
    <a href=http://www.mmostar.com/index.php?cPath=828>Second Life Linden</a>
    <a href=http://www.mmostar.com/index.php?cPath=832>LOTRO Gold</a>
    <a href=http://www.mmostar.com>wow power leveling</a>
    <a href=http://www.mmostar.com/wow-power-leveling-quote.php>wow power leveling</a>
    <a href=http://www.mmostar.com/wow-power-leveling-quote.php>world of warcraft power leveling</a>
    <a href=http://www.mmostar.com/index.php?cPath=647>Runescape Gold</a>
    <a href=http://www.wowgoldbank.com>wow gold</a>
    <a href=http://www.wowgoldbank.com>buy wow gold</a>
    <a href=http://www.wowgoldbank.com>cheap wow gold</a>
    <a href=http://www.wowgoldbank.com>buy wow gold</a>
    <a href=http://www.wowgoldbank.com>World of Warcraft Gold</a>
    <a href=http://www.wowgoldbank.com/wow-gold/index.html>wow gold</a>
    <a href=http://www.wowgoldbank.com/wow-gold/index.html>buy wow gold</a>
    <a href=http://www.wowgoldbank.com/wow-gold/index.html>cheap wow gold</a>
    <a href=http://www.wowgoldbank.com/wow-power-leveling/index.htm>wow power leveling</a>
    <a href=http://www.wowgoldbank.com/wow-gold/index.html>cheap wow gold</a>
    <a href=http://www.wowgoldbank.com/wow-gold/index.html>buy wow gold</a>
    <a href=http://www.akgame.com/anarchy-online-c-33.html>Anarchy Online Credits</a>
    <a href=http://www.akgame.com/archlord-c-48.html>Archlord Gold</a>
    <a href=http://www.akgame.com/auto-assault-c-34.html>Auto Assault Scrip</a>
    <a href=http://www.akgame.com/city-of-heroes-c-35.html>City of Heroes Influence</a>
    <a href=http://www.akgame.com/city-of-villains-c-43.html>COV Infamy</a>
    <a href=http://www.akgame.com/dark-age-of-camelot-c-36.html>DAOC Plat</a>
    <a href=http://www.akgame.com/dofus-c-50.html>Dofus Kamas</a>
    <a href=http://www.akgame.com/dofus-c-50.html>Dofus money</a>
    <a href=http://www.akgame.com/dungeons-and-dragons-c-37.html>DDO Plat</a>
    <a href=http://www.akgame.com/dungeons-and-dragons-c-37.html>DDO gold</a>
    <a href=http://www.akgame.com/eve-online-c-8.html>EVE ISK</a>
    <a href=http://www.akgame.com/everquest-2-c-3.html>EQ2 Gold</a>
    <a href=http://www.akgame.com/everquest-2-c-3.html>EQ2 plat</a>
    <a href=http://www.akgame.com/everquest-2-c-3.html>everquest 2 gold</a>
    <a href=http://www.akgame.com/final-fantasy-xi-c-6.html>FFXI Gil</a>
    <a href=http://www.akgame.com/gaia-online-c-42.html>Gaia Online Gold</a>
    <a href=http://www.akgame.com/guild-wars-c-7.html>Guild Wars Gold</a>
    <a href=http://www.akgame.com/kal-online-c-49.html >Kal Online Gold</a>
    <a href=http://www.akgame.com/last-chaos-c-47.html>Last Chaos Gold</a>
    <a href=http://www.akgame.com/lineage-2-c-4.html>Lineage 2 Adena</a>
    <a href=http://www.akgame.com/maple-story-c-41.html>Maple Story Mesos</a>
    <a href=http://www.akgame.com/matrix-online-c-44.html>matrix online information</a>
    <a href=http://www.akgame.com/rf-online-c-39.html>RF Online CP, Dalant, Disena</a>
    <a href=http://www.akgame.com/rappelz-online-c-53.html>Rappelz Rupees</a>
    <a href=http://www.akgame.com/rose-online-c-51.html>Rose Online Zulie</a>
    <a href=http://www.akgame.com/runescape-c-52.html>Runescape Money</a>
    <a href=http://www.akgame.com/runescape-c-52.html>Runescape Gold</a>
    <a href=http://www.akgame.com/scions-of-fate-c-46.html>Scions of Fate Gold</a>
    <a href=http://www.akgame.com/silkroad-c-45.html>SilkRoad Gold</a>
    <a href=http://www.akgame.com/star-wars-galaxies-c-5.html>SWG Credits</a>
    <a href=http://www.akgame.com/vanguard-saga-of-heroes-c-40.html>Vanguard Gold</a>
    <a href=http://www.akgame.com>World of Warcraft Gold</a>
    <a href=http://www.akgame.com>wow gold</a>
    <a href=http://www.akgame.com>best wow gold</a>
    <a href=http://www.akgame.com>buy wow gold</a>
    <a href=http://www.akgame.com>cheap wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-us-c-1.html>wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-us-c-1.html>buy wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-us-c-1.html>cheap wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-eu-c-1.html>wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-eu-c-1.html>buy wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-eu-c-1.html>cheap wow gold</a>
    <a href=http://www.akgame.com/voyage-century-c-55.html>Voyage Century Silver coin</a>
    <a href=http://www.akgame.com/second-life-linden-c-56.html>Second Life Linden</a>
    <a href=http://www.akgame.com/the-lord-of-the-rings-ol-c-57.html>LOTRO Gold</a>
    <a href=http://www.akgame.com/wow-power-leveling-c-9.html>wow power leveling</a>
    <a href=http://www.akgame.com/wow-powerleveling.htm>wow powerleveling</a>
    <a href=http://www.akgame.com>wow gold</a>
    <a href=http://www.akgame.com>best wow gold</a>
    <a href=http://www.akgame.com>buy wow gold</a>
    <a href=http://www.akgame.com>cheap wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-us-c-1.html>wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-us-c-1.html>buy wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-us-c-1.html>cheap wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-eu-c-1.html>wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-eu-c-1.html>buy wow gold</a>
    <a href=http://www.akgame.com/world-of-warcraft-eu-c-1.html>cheap wow gold</a>
    <a href=http://www.akgame.com/dungeons-and-dragons-c-37.html>DDO gold</a>
    <a href=http://www.akgame.com/everquest-2-c-3.html>Everquest 2 Gold</a>
    <a href=http://www.wow-power-leveling.com/buy-wow-gold.php>wow gold</a>
    <a href=http://www.wow-power-leveling.com/buy-wow-gold.php>buy wow gold</a>
    <a href=http://www.wow-power-leveling.com/buy-wow-gold.php>cheap wow gold</a>
    <a href=http://www.akgame.com/everquest-2-c-3.html>EQ2 plat</a>
    <a href=http://www.gmtbank.com/>wow gold</a>
    <a href=http://www.gmtbank.com/>cheap wow gold</a>
    <a href=http://www.gmtbank.com/>world of warcraft gold</a>
    <a href=http://www.gmtbank.com/index.php?cPath=29>wow gold</a>
    <a href=http://www.gmtbank.com/index.php?cPath=29>cheap wow gold</a>
    <a href=http://www.gmtbank.com/index.php?cPath=29>world of warcraft gold</a>
    <a href=http://www.vgamepsp.com/psp-adapter-p-1.html>psp ac adapter</a>
    <a href=http://www.vgamepsp.com/ps2-32m-memory-cards-p-42.html>ps2 memory card</a>
    <a href=http://www.vgamepsp.com>video game accessories</a>
    <a href=http://www.vgamepsp.com/nintendo-wii-accessories-c-9.html>wii accessories</a>
    <a href=http://www.vgamepsp.com/chips-game-c-14.html>chips game</a>

  4. 111 says:

    [url=http:// http://www.dreamous.com/service/hgh_tech.cfm%5Dedmund chein [/url]
    [url=http://www.edmundchein.com.cn] edmund chein [/url]
    [url=http://www.alwaysyoung.com/hgh/clinicals/clinicals.html]edmund chein [/url]
    [url=http://www.dreamconference.com/presenter_bios.htm]edmund chein [/url]
    [url=http://www.clima.org.cn/gq/show.php?id=615151]edmund chein [/url]
    [url=http://www.edmundcheincn.net.cn]edmund chein [/url]
    [url=http://www.edmundcheincn.cn]edmund chein [/url]
    [url=http://www.edmundcheincn.org.cn]edmund chein [/url]

  5. 111 says:

    a href=http://www.edmundchein.cn/>edmund chein</a>
    <a href=http://www.godlin.com/company/syjh/business_info.asp?info_id=67833/>edmund chein</a>
    <a href=http://www.dreamous.com/service/hgh_tech.cfm/>edmund chein</a>
    <a href=http://www.edmundchein.com.cn/>edmund chein</a>
    <a href=http://www.alwaysyoung.com/hgh/clinicals/clinicals.html/>edmund chein</a>
    <a href=http://www.dreamconference.com/presenter_bios.htm/>edmund chein</a>
    <a href=http://www.clima.org.cn/gq/show.php?id=615151/>edmund chein</a>
    <a href=http://www.edmundcheincn.net.cn//>edmund chein</a>
    <a href=http://www.edmundcheincn.cn/>edmund chein</a>
    <a href=http://www.edmundcheincn.org.cn/>edmund chein</a>

  6. viccol says:

    Buy Guild Wars Gold, WOW Gold, World of Warcraftz Gold, Innicc.com, Gaiaonline

    Gold, Runescape gold,Buy Guild Wars gold, Guild Wars money, Buy WOW Gold, World of

    Warcraftz Gold, dofus kamas,Gaia online, Maplestory mesos,Buy Gaiaonline gold,

    Anarchy Online,Lineage 2 Adena,dofus kamas,Silkroad gold,Silkroad money,guild wars

    power
    http://www.innicc.com
    http://www.innicc.com/buy4.asp
    http://www.innicc.com/buy-gw.asp
    http://www.innicc.com/buy-mm.asp
    http://www.innicc.com/buy-ao.asp
    http://www.innicc.com/buy-fg.asp
    http://www.innicc.com/buy-la.asp
    http://www.innicc.com/buy-dofus.asp

Leave a Reply

Your email address will not be published. Required fields are marked *