Configuring SQL Server

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!

You must Login to comment.