Configuring SQL Server





0/5 (0 vote)
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
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!