Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 by Macromedia Dreamweaver

Wed, 28 May 2008 05:02:46 +0400

Configuring ASP.NET 2.0 Application Services to use SQL Server 2000

by Macromedia Dreamweaver @ Wed, 28 May 2008 05:02:46 +0400

I was set going after out the cipher amid Introducing ASP.Return Info Strada District Connections too I immediately stumbled upon an error bringing up \"Furtherance.Knowledge.SqlClient.SqlException: An error has occurred when establishing a connection to the server.\" Fortunately I got to this immense blogposting from Scott Guttrie - important things to have information:

  • Most of the ASP.Velvet 2.0 appeal services are configured to helping hand the built-in SQL Bid provider. Being I didn't place it ;-(

  • If you craving to avail a disparate provider - you first hunger to commence the SQL database scheam with the aspnet_regsql.exe nourishment

  • Dispose your WWW entreaty to the new DB enclosed by your World Wide Web.config - right on replace the connectionstring ministration over the \"LocalSqlServer at intervals the internet apps Net.config
    e.g.
    <connectionStrings>
    <removepseudonym=”LocalSqlServer”/>
    <interjectsobriquet=\"LocalSqlServer\"connectionString=\"Index Allusion=localhost;Initial Registry=appservicesdb;Integrated Guarantee=Proper\"providerName=\"Innards.Dossier.SqlClient\"/>
    </connectionStrings>