| Author |
Topic |
|
sharmag
Starting Member
3 Posts |
 Posted - 2007-03-15 : 19:06:52
|
| I am trying to install SQl server 2005 Ent install on Windows 2003 cluster but getting the following error message. I can not install IIS on a database server this is against Security policy of the company and all I am installing is database engine and no books online /client tools etc. but still gets this errorServer Name : There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. The service cannot be started, either because it is disabled or because it has no enabled devices associated with it.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.Did any one encountered this problem and will appreciate if any one can suggest any solution to this problem.Thankssharmag |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-15 : 19:29:33
|
| You are trying to install a SQL Server component that requires IIS to be on the same server. One such component is Reporting Services.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sharmag
Starting Member
3 Posts |
Posted - 2007-03-16 : 12:37:04
|
| All I am installing is data files and shared tools. Also, if I install it locally on the node (without cluster installations option) it gets install successfully so I think there is something cluster related which is causing the problem but do not know what? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-16 : 15:44:47
|
quote:
Originally posted by pareshmotiwala
I have another problem. We have a 2 node Windows 2003/SQL 2005 Active/Passive Cluster.The failover time is the default of 180 seconds. My boss is not ok with it. He feels the whole exercise is a waste of time.I learn Active Active clustering is not supported by SQL 2005 is it true? and also if at all it was true, it would require serious code re-writing?
Do not hijack threads. Start your own thread for a new problem. We have a 4 node cluster in production that is Active/Active/Active/Active and is running 11 SQL Server 2005 instances. You don't code for clustering. MSCS handles everything for you.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2007-03-16 : 15:45:52
|
| oops...sorry... |
|
|
|
plurry
Starting Member
1 Post |
Posted - 2007-06-02 : 05:00:03
|
| Also, something else to note: if the installation fails, check out the logs directory under \Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG.I got an unexpected error today as well, even after installing IIS (on both nodes), ensuring MS-DTC was up and component services was happy. Turns out (wait for it....) TASK SCHEDULER was disabled!! Which is best practice IMHO on prod boxes. Anyhoo, enabled and started TS on both nodes, worked like a charm from then on out. Why this is especailly p*ss poor, is that in the Preinstallation Check, it warns you about just about everything else, so why can't it detect TS being disabled, and start it for you?!Hope that helps. :)-G |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-06-25 : 07:00:53
|
Hi Tara,If you don't mind sharing, why do you have 11 instances on 4 nodes?Does it have anything to do with dependency? Is it more efficient to have 2 or 3 more instances than 1 on each node? Or is it more of an economic issue?TIAquote:
Originally posted by tkizer
quote:
Originally posted by pareshmotiwala
I have another problem. We have a 2 node Windows 2003/SQL 2005 Active/Passive Cluster.The failover time is the default of 180 seconds. My boss is not ok with it. He feels the whole exercise is a waste of time.I learn Active Active clustering is not supported by SQL 2005 is it true? and also if at all it was true, it would require serious code re-writing?
Do not hijack threads. Start your own thread for a new problem. We have a 4 node cluster in production that is Active/Active/Active/Active and is running 11 SQL Server 2005 instances. You don't code for clustering. MSCS handles everything for you.Tara Kizerhttp://weblogs.sqlteam.com/tarad/
--------------------keeping it simple... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-25 : 11:37:04
|
| We have several applications running on the 4-node cluster. We split most applications into their own instances so that we can control the amount of memory and CPU that they use. Only 7 of those instances are in use for production. The other 4 are used to stage new versions of the applications so that we can test them in a production environment.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-06-26 : 08:13:17
|
I see, you must have very powerful machines then to run several sql server instances...And each instance would have n-number of databases as well?I personally am having difficulty verifying memory and cpu consumption when these go berserk... are you using a third party tool to monitor them like Idera perhaps?--I hope this is not considered as hi-jacking a thread  , advance apologies--------------------keeping it simple... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-06-26 : 11:40:43
|
| Yes we have pretty powerful machines. I think they are HP DL 565s with 8 CPUs and 16GB of RAM each. I use Performance Monitor and SQL Profiler. I've now started using the Performance Dashboard reports though.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
SQl server 2005 Ent install on Windows 2003 cluste