i was thinking to completely un-install the sql instance and not to remove the node from the cluster

ok i can do that, after that will i be able to install the new instance?

have anyone done that?

you mean from the cluster to do a Evict?

or uninstalling SQL Server from that node is better?

its SQL SP1 patch

Thank you all for your kind suggestions and information 🙂

Lowell (2/6/2012)

---

Damian-167372 (2/6/2012)

---

yes I am working with the management team to do this ...

thanks a lot for your information ..

I also hard coded the script with app name something...

yes I am working with the management team to do this ...

thanks a lot for your information ..

I also hard coded the script with app name something like this...

IF...

GilaMonster (2/6/2012)

---

Damian-167372 (2/6/2012)

---

GilaMonster (2/6/2012)

---

That's what I was saying....

Btw, I've been through this, had a couple devs who knew the app's password and thought they were above the rules. I put...

GilaMonster (2/6/2012)

---

That's what I was saying....

Btw, I've been through this, had a couple devs who knew the app's password and thought they were above the rules. I put a login...

WoW... I never thought of this... so all this can be a...

GilaMonster (2/6/2012)

---

Oh, one other added complexity - Maintenance plans have an app name of Microsoft SQL Server Management Studio..., so be careful you don't throw your maint plans out (I...

GilaMonster (2/6/2012)

---

Nothing wrong with login triggers, however a few things to consider...

You block connections from SSMS, now, what about Query Analyser? isql? osql? sqlcmd? Access? Excel? 3rd party tools like...

Gazareth (2/6/2012)

---

I'm with you there Dev - I wouldn't usually recommend logon triggers either but I guessed from what Damian had said that he's in the situation he's in!

Also if...

Dev (2/6/2012)

---

In this particular case Yes.

But I am giving you once scenario. Please answer to it for my better understanding. The application uses a login XYZ to...

Dev (2/6/2012)

---

I am sorry but I am not able to understand your requirements. Why hundreds of users are sitting on the server if you don’t want them to...