Configuring ASP.NET 2.0 apps to SQL Server 2005 databases

The topic of configuring ASP.NET 2.0 applications to work with SQL Server 2005 first came up, naturally, in the weeks before both products were released to the world. Since different enterprises migrate to new technologies at different speeds, though, we thought it wise to revisit this topic by pointing to a couple very thorough tutorials.

The first tutorial, Configuring an ASP.NET 2.0 Application to Work with Microsoft SQL Server 2000 or SQL Server 2005 by Imar Spaanjaars, begins with a quick look at the two types of authentication that can be used to access a SQL Server database. From there, the author offers quick hints for attaching the appropriate databases to SQL Server.

The bulk of Sp

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT ASP.NET Development How to use jQuery to solve Javascript browser compatibility problems How to write an out-of-browser Silverlight 3 application in 3 steps Silverlight 3 beta SDK download lets developers try new RIA features Visual Studio's IntelliSense for jQuery doesn't autocomplete correctly Dundas Map for .NET kicks up geographic visualization Return to CodePlex: Into the Sandcastle… VBScript Tutorial Use PHP with Visual Studio to create Web sites Visual Studio Team System Add-ins: Conchango Scrum for Team System and Scrum Dashboard Visual Studio 2008 and .NET Framework 3.5 SP1 introduces ADO .NET Entity Designer Microsoft SQL Server Using the Visual Studio 2005 DataSet Designer to build a data access layer The CTE, the hierarchical query and SQL Server 2005 SQL Server 2005 recursive functions and the CTE Choose the right .NET data provider, optimize application performance The fallacy of the data layer -- or, a new architectural model for software designs Book excerpt: ADO.NET and SQL Server 2005 Addressing common SQL Server questions Book Excerpt: The .NET Framework and SQL Server 2005 WinForms development using SQL Server 2005 and Visual Basic 2005 Book excerpt: Retrieve data from a SQL Server 2005 table ASP.NET development best practices Introduction to ASP.NET's Model View Controller (MVC) Design Pattern Silverlight, Ajax components require different approach to UI LINQ Learning Guide: LINQ and Web applications VB code download home page VB code: File manipulation downloads Localization practices for .NET 2.0: It's still about the architecture Creating custom ASP.NET 2.0 profile providers .NET development in the trenches Microsoft developers balancing age-old issues, barrage of new technology SearchVB.com's Podcast Page

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary 136 browser colors with names  (SearchWinDevelopment.com) ASP.NET  (SearchWinDevelopment.com) browser  (SearchWinDevelopment.com) Document Object Model  (SearchWinDevelopment.com) domain name  (SearchWinDevelopment.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

aanjaars's piece, though, centers on the three main scenarios for configuring the database and application:

The second tutorial, Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL Server 2005, comes from Scott Guthrie. ASP.NET 2.0 comes with several application services, which are APIs governing membership, roles, personalization and other "super common scenarios with Web applications today," Guthrie notes.

Out of the box, these application services are configured to use the free SQL Express database, so Guthrie provides a quick walkthrough of the process of connecting the services to a regular old SQL Server database. Fortunately, there is a wizard to lead developers along.

Once the application is configured to its database, development can begin in earnest. Questions will undoubtedly emerge along the way, and in that regard, one should visit the ASP.NET 2.0 Learning Guide or the SQL Server 2005 Learning Guide for assistance.

Rate this Tip To rate tips, you must be a member of SearchWinDevelopment.com. Register now to start rating these tips. Log in if you are already a member. DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.