(untagged)

Configuring SQL Server

ASP.NET Community

0.00/5 (No votes)

4 Feb 2008

Most ASP.NET sites talk to SQL Server or a backend SQL Database and there's a number of ways to manage that configuration.I always start with the

This articles was originally at wiki.asp.net but has now been given a new home on CodeProject. Editing rights for this article has been set at Bronze or above, so please go in and edit and update this article to keep it fresh and relevant.

Most ASP.NET sites talk to SQL Server or a backend SQL Database and there's a number of ways to manage that configuration.

I always start with the Management Studio Express when dealing with SQL Server. It's fast and lightweight.
If you're using the full version SQL Server Management Studio, consider installing the SQL Server 2005 Performance Dashboard Reports to help identify common problems.
It's too bad the SQL Server Web Data Administrator was never updated. It's still a great tool for talking to SQL 2000 even if it's not appropriate for production.
Configuring ASP.NET 2.0 Application Services to Use SQL Server 2000 or SQL Server 2005

Enjoy!

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here