Purpose: a relatively fast and economical solution to administer SQL Server 2005 over the web. Ever heard of php myAdmin?
Main components needed in the host server:
- SQL Native Client
- Microsoft SQL Server 2005 Management Objects Collection* (optional)
- Microsoft SQL Server 2005 Backward Compatibility Components
- SQL Web Data Administrator (For my case I am using SQL Server 2005)
Both SQL Native Client and Microsoft SQL Server 2005 Management Objects Collection can be found from Microsoft Downloads: http://www.microsoft.com/downloads/en/details.aspx?familyid=DF0BA5AA-B4BD-4705-AA0A-B477BA72A9CB&displaylang=en
SQL Web Data Administrator is an open source project as of now; it is not officially supported by Microsoft. Use at your own risk!
Steps:
1. Download the required executables from Microsoft Library.
2. Download SqlWebAdmin source code from codeplex. Codeplex is an open source repository for .NET code. http://sqlwebadmin.codeplex.com/. Setup instructions can be found in the project site so I'm not going to elaborate.
3. Compile the source code locally if needed.
4. Install SQL Native Client (sqlncli.msi) and Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi). For the latter, it is sufficient to pick SQL Distributed Management Objects (SQL-DMO) feature and disable all other features.
Alternatively, you can download the free lite version of myLittleAdmin at http://www.mylittletools.net/en/welcome.aspx
No comments:
Post a Comment