June 16, 2009 at 4:20 pm
I’m instaling SQL Server 2005 on production server on Advanced options page:
1.I have selected D:\Microsfot SQL Server for database engine
2.Can I select the D:\Microsoft SQL Server for Client componets, Integration services and Reporting services OR Do I need to keep the default path C:\program files
3.On which drive you guys install database engine, clien components, Integration services, Reporting Services and why?
4.Even Unselecting work station components and books online, they are installed?
Why this is happening?
Please clarify me above?
June 16, 2009 at 4:42 pm
Here is the Microsoft defined locations of each SQL Server component you need to look at it and know that each component listed as not configurable must be installed in your C drive.
http://msdn.microsoft.com/en-us/library/ms143547(SQL.90).aspx
Kind regards,
Gift Peddie
June 16, 2009 at 5:00 pm
I went through the link, but just clarify the above four points.
June 16, 2009 at 5:11 pm
You can put any component that is configurable in your D drive but all fixed path components that is SSIS and SSRS must be installed in your C drive. If you have read that link you will know it answered number two and three.
So go and actually read what is in it.
Kind regards,
Gift Peddie
June 16, 2009 at 9:02 pm
2. Can I select the D:\Microsoft SQL Server for Client componets, Integration services and Reporting services OR Do I need to keep the default path C:\program files
Abhay: you can only select database services , RS , AS on a different drive.
3. On which drive you guys install database engine, clien components, Integration services, Reporting Services and why?
Abhay : use any drive other than C as we use it only for binaries and OS files and do not stress Data files and log files as these binaris are used a lot by OS and applications .Hence the performance increases and risk is reduced.
4. Even Unselecting work station components and books online, they are installed? Why this is happening?
Its not possible .Can you show us some proof .You will see the setup logs in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG . Check the summary .txt file.
Regards
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply