does that mean raid will have very minimal failure or SAn will take care...

Why the user connections are at 1500, is it not closed properly and is ther any dormant sessions frequently.

i too agree to it.

Hello,

Frist create the login for domain group like this

CREATE LOGIN [DomainName\GroupName] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

what is this and what do you want?

Note: kindly dont ask for your work help..

Perry Whittle (6/25/2012)

---

durai nagarajan (6/21/2012)[hrIn our environment we have two domain users one for SQL services and another for cluster.

i am planning to revoke the access and configure the same...

our sql server stopped working for some reason when i was on...

mvillegascuellar (6/22/2012)

---

Hi thanks for the response,

But the distribution list is created in the domain, so it is visible from every other computer. I tested it from other computers and works...

is it the group created by you in your outlook then it will be available onely on your out look.

if you send it to group created in mail server it...

Lavanyasri (6/21/2012)

---

HI ,

Thanks for the update .

i run the maintenance plan again with fill factor 90 % , but i did not find any changes in the...

Schadenfreude-Mei (6/21/2012)

---

Our ClusterAdmin account doesnt have any access to SQL. The services are set with our domain credentials for the SQL...

Schadenfreude-Mei (6/21/2012)

---

What was the fill-factor before you stared? I'm guessing 90%.

Youu could try (on a seperate server with a database copy), rerunning your maint plan but changing the per-page fill-factor...

hrr1117 (6/20/2012)

---

Reset sql password by Windows Authentication

If Built-in/Administrator is present in SQL , you can login with an ID which is member of Administrators group and reset password in SQL...

thanks Johan

this helps me start building good security in my system.

hope i'll change cluster user access to public rather than sysadmin.

any points about 3 & 4.