SSMS 2005 x64 on Windows Server 2008 R2

Question

Hello,

I have had to install SQL Server 2005 (x64) on a server running Windows Server 2008 R2. The install succeeds apart from the client tools (BIDS and SSMS). Are the client tools compatible with the operating system?

Regards,

Andrew

Answer 1

Yes, it should get installed on Windows 2008R2 server, please verify if you there any other versions of client tools on that server, if not, please check error log details of the failure, log file should have more details around the failure. Hope this helps!

---

Thanks, Sohail ~Please mark answered if your question is completely answered; vote it as helpful to help others find a solution quicker. This posting is provided AS IS with no warranties.

Answer 2

Hello,

Services Pack 3 (SP3) for SQL Server 2005 is required to make SQL compatible with Windows Server 2008 R2.

Please share with us the summary.txt log file. The following article may help you find this log on the disk drive:

http://technet.microsoft.com/en-us/library/ms143702(v=sql.90)

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 3

Hello Alberto,

I've installed the 32-bit version of the software on the server with no issues. The summary file did not have any record of the failure of the client tools, just the succeeded records of the other components.

When you say that SP3 is needed, does this need to be installed immediately after the SQL installation?

Here's the summary file:-

Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version      : Server 4.0 Service Pack 1 (Build 7601)
Time            : Tue Feb 26 14:01:13 2013 
 
: Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features.  Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
 : Failed to find the ASP.Net Version Registration with Microsoft Internet Information Services (IIS).
Machine         : 
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_PRD-DJSQL01_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine         : 
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_PRD-DJSQL01_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine         : 
Product         : Microsoft Visual Studio 2005 Premier Partner Edition - ENU
Product Version : 8.0.50727.42
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_PRD-DJSQL01_PPESku_1.log
--------------------------------------------------------------------------------
Machine         : 
Product         : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_PRD-DJSQL01_OWC11_1.log
--------------------------------------------------------------------------------
Machine         :
Product         : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_PRD-DJSQL01_BackwardsCompat_1.log
--------------------------------------------------------------------------------
Machine         :
Product         : SQLXML4
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_PRD-DJSQL01_SQLXML4_1.log
--------------------------------------------------------------------------------
Machine         : 
Product         : Microsoft SQL Server 2005 Tools
Product Version : 9.00.1399.06
Install         : Successful
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0016_PRD-DJSQL01_Tools.log
--------------------------------------------------------------------------------
 
 Setup succeeded with the installation, inspect the log file completely for status on all the components.

Time            : Tue Feb 26 14:10:11 2013

Answer 4

Hello,

As long as I remember, client tools are 32-bit only. This means you have it already installed.   

Hope this helps.

Regards,

Alberto Morillo

SQLCoffee.com

Answer 5

Hello,

It is confirmed. Client Tools are 32-bit only. Please read the following link that confirms this fact.

http://itknowledgeexchange.techtarget.com/itanswers/hard-ware-requirement-for-64-bit/

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 6

Thank you Alberto

Answer 7

Hello,

Thank you for visiting MSDN forums!

Have a great day!

Regards,

Alberto Morillo
SQLCoffee.com