mvillegascuellar (7/27/2012)

---

I have a Web server in my DMZ, I have a SQL Server 2008 R2 server inside the LAN, this database server has named instance with a NO dinamic...

Everest

allmhuran (7/27/2012)

---

However, the suggested solution is this:

To correct the problem that this scenario presents, the stand-alone instance, Instance3, must reside on another node in the same WSFC cluster as NODE01...

allmhuran (7/26/2012)

---

Certainly looking forward to that article.

I haven't explained the situation clearly enough. Imagine the following:

Cluster = C1

Servers = S1, S2.

SQL Server instances = SQL1 (clustered), SQL2 (not clustered).

Database =...

It's a windows 7 OS feature go inti control panel and turn features on/off

Is this a spinning platter array (I.e, physical hard drives)?

sixthzenz (7/25/2012)

---

I read a lot about...

You're using a windows administrative share and unless the SQL server agent account is a local admin on server \\xxxxxxxxxxx the r$...

Yes, both instances must reside on separate nodes and do not use shared storage, they use local disks which you would configure with the...

If running from the active node with no switches it will update all nodes

No problem, you're welcome

yes, open a command prompt and change to the directory where the hotfix exists then execute the hotfix EXE passing in the PASSIVE parameter as i have shown

Benki Chendu (7/25/2012)

---

Customer wants me to install SQL Server 2005 SP4 on passive node using passive switch to minimize the downtime.

How do I do it?

I had done it long time...

yes, this link provides info.

Installing a 2nd failover instance requires exactly the same process and resources as installing...

You can either create an application\group or allow the installer to do this for you. You will also need shared disks, an IP address and a unique virtual network name

sixthzenz (7/24/2012)

---

Good point(s). The reason I asked these questions is because I've heard people talk about having to do certain tweaks/configs when using SSDs. So are you implying I won't...