9/11/2011

Multiple SQL Servers on same box

I recently installed a clean instance of SQL-Server Denali.

While poking around through the install I found something that displays all the SQL-Server related items installed on the box.

It's called "Installed SQL Server features Discover Report".

At this time, I have  flavors of 2005, 2008 R2 & Denali installed on the same machine.


Microsoft SQL Server "Denali" Community Technology Preview 3 Setup Discovery Report
ProductInstanceInstance IDFeatureLanguageEditionVersionClustered
Microsoft SQL Server 2011BCBIDENALIMSSQL11.BCBIDENALIDatabase Engine Services1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011BCBIDENALIMSSQL11.BCBIDENALISQL Server Replication1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011BCBIDENALIMSSQL11.BCBIDENALIFull-Text and Semantic Extractions for Search1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011BCBIDENALIMSSQL11.BCBIDENALIData Quality Services1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011BCBIDENALIMSAS11.BCBIDENALIAnalysis Services1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011BCBIDENALIMSRS11.BCBIDENALIReporting Services - Native1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011

Management Tools - Basic1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011

Management Tools - Complete1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011

Client Tools Connectivity1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011

Client Tools Backwards Compatibility1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011

Client Tools SDK1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011

Integration Services1033Enterprise Evaluation Edition11.0.1440.19No
Microsoft SQL Server 2011

Reporting Services - SharePoint

11.0.1440.19No
Microsoft SQL Server 2008 R2MSSQLSERVERMSSQL10_50.MSSQLSERVERDatabase Engine Services1033Standard Edition10.50.1617.0No
Microsoft SQL Server 2008 R2MSSQLSERVERMSSQL10_50.MSSQLSERVERSQL Server Replication1033Standard Edition10.50.1617.0No
Microsoft SQL Server 2008 R2MSSQLSERVERMSSQL10_50.MSSQLSERVERFull-Text and Semantic Extractions for Search1033Standard Edition10.50.1600.1No
Microsoft SQL Server 2008 R2MSSQLSERVERMSAS10_50.MSSQLSERVERAnalysis Services1033Standard Edition10.50.1617.0No
Microsoft SQL Server 2008 R2MSSQLSERVERMSRS10_50.MSSQLSERVERReporting Services - Native1033Standard Edition10.50.1617.0No
Microsoft SQL Server 2008 R2

Management Tools - Basic1033Standard Edition10.50.1617.0No
Microsoft SQL Server 2008 R2

Management Tools - Complete1033Standard Edition10.50.1617.0No
Microsoft SQL Server 2008 R2

Client Tools Connectivity1033Standard Edition10.50.1617.0No
Microsoft SQL Server 2008 R2

Client Tools Backwards Compatibility1033Standard Edition10.50.1617.0No
Microsoft SQL Server 2008 R2

Client Tools SDK1033Standard Edition10.50.1617.0No
Microsoft SQL Server 2008 R2

Integration Services1033Standard Edition10.50.1617.0No
Microsoft SQL Server 2005SQLEXPRESSMSSQL.1Database Engine Services1033Express Edition9.4.5000No
Microsoft SQL Server 2005SQLEXPRESSMSSQL.1SQL Server Replication1033Express Edition9.4.5000No
Microsoft SQL Server 2005SQLEXPRESSMSSQL.1SharedTools1033Express Edition9.4.5000No
Microsoft SQL Server 2005

Tools1033Express Edition9.4.5000No
Microsoft SQL Server 2005

ToolsClient1033Express Edition9.4.5000No
Microsoft SQL Server 2005

ToolsClient\Connectivity1033Express Edition9.4.5000No

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Thoughts to Ponder