Free sql 2005 software for windows

The SQL 2005 Service Manager was designed to be a replacement for the SQL Server Service Manager that came with SQL Server 2000 but is no longer shipped as part of SQL Server.
It allows the management and monitoring of all local SQL Server related services from a convenient system tray application for all editions of SQL Server 2000, 2005 and 2008.
To use SQL2005 Service Manager simply unzip the downloaded file into a folder and double click on SQL2005 Service Manager Setup.msi to install. For the Windows Vista version, please read the Install Instructions in the zip file and ensure the SQLServiceManager service is started before using the application.
The behaviour of SQL2005 Service Manager is very similar to that of the SQL Server Service Manager that is part of Microsoft SQL Server 2000, one exception being that it will always start minimized in the system tray. Another is that the tool only manages local instances.
The system tray icon has a right click menu allowing service and instance selection and control of the currently selected service. Double clicking on the icon or choosing Open SQL2005 Service Manager from the menu will bring up the familiar user interface allowing instance and service selection and control of the selected service. The installer adds a shortcut to your Startup folder so if you dont want it to start automatically simply delete the shortcut.
Main features:
- Manage SQL Server, SQL Agent, Analysis Services, Full Text Search, MSDTC,SSIS and Reporting Services
- Supports all SQL2008, SQL2005 and SQL2000 Editions
- Manage and monitor local services from the system tray
System requirements:
- .NET Framework 2.0.50727

Enhancements:
- Added compatability for SQL 2008 RC0 and filtered SQL 2008 Express SQL Agent service

The SQL Nexus was designed to be a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQLDiag and PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.
Main features:
- Fast, easy data loading: You can quickly and easily load SQL Trace files; T-SQL script output, including SQL DMV queries; and Performance Monitor logs into a SQL Server database for analysis. All three facilities use bulk load APIs to insert data quickly. You can also create your own importer for a custom file type.
- Visualize loaded data via reports: Once the data is loaded, you can fire up several different charts and reports to analyze it.
- Trace aggregation to show the TOP N most expensive queries (using ReadTrace).
- Wait stats analysis for visualizing blocking and other resource contention issues (based on the new SQL 2005 Perf Stats Script).
- Full-featured reporting engine: SQL Nexus uses the SQL Server Reporting Services client-side report viewer (it does not require an RS instance). You can create reports for Nexus from either the RS report designer or the Visual Studio report designer. You can also modify the reports that ship with Nexus using either facility. Zoom in/Zoom out to view server performance during a particular time window. Expand/collapse report regions (subreports) for easier navigation of complex data. Export or email reports directly from SQL Nexus. Nexus supports exporting in Excel, PDF, and several other formats.
- Extensibility: You can use the existing importers to load the output from any DMV query into a table, and any RS reports you drop in the Reports folder will automatically show up in the reports task pane. If you want, you can even add a new data importer for a new data type. SQL Nexus will automatically "fix up" the database references in your reports to reference the current server and database, and it will provide generic parameter prompting for any parameters your reports support.
System requirements:
- SQL Server installed

Enhancements:
- readtrace intergration issue (finding readtrace on x64 system)
- error "Some or all identity references could not be translated. "
- error "you have provided an illegal table name (likely in your TextRowsetsCustom.xml). consider deleting that file from %appdata%sqlnexus directory"