January 7, 2008 at 7:09 am
I would like to manage SQL without the need to remote desktop onto the server. What components should I install from the SQL media to allow me to run the Management Studio / Create Reports etc....
Analysis Services
Reporting Services
Notification Services
Intergration Services
Workstation Components, Books Online and development tools
I installed 'Workstation Components, Books Online and development tools'. Installation returned:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Mon Jan 07 13:43:23 2008
Machine : MY-PC
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\SQLSetup0002_MY-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : MY-PC
Product : SQL Native Client
Error : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
--------------------------------------------------------------------------------
Machine : MY-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_MY-PC_SQLNCLI_1.log
Last Action : InstallFinalize
Error String : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
Error Number : 1706
--------------------------------------------------------------------------------
Machine : MY-PC
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\SQLSetup0002_MY-PC_PPESku_1.log
--------------------------------------------------------------------------------
Machine : MY-PC
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\SQLSetup0002_MY-PC_OWC11_1.log
--------------------------------------------------------------------------------
Machine : MY-PC
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_MY-PC_BOL_1.log
--------------------------------------------------------------------------------
Machine : MY-PC
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\SQLSetup0002_MY-PC_BackwardsCompat_1.log
--------------------------------------------------------------------------------
Machine : MY-PC
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_MY-PC_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : MY-PC
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_MY-PC_SQLXML4_1.log
--------------------------------------------------------------------------------
Note: I already had SQL Native Client Installed as part of the application SQL is running.
So how do I install Management Studio etc?
Many Thanks,
Phil.
Update: I see under Advanced there is an option for 'Client Components', I presume this is what I am after?
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
January 7, 2008 at 7:30 am
management studio is installed as part of workstation tools and you should also install SSIS. everything else is a server component
January 7, 2008 at 8:23 am
As mentioned above, just the Workstation stuff, maybe BOL.
IF you need SSIS, install it.
January 7, 2008 at 9:53 am
Thanks guys.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply