opc.three (7/10/2012)

---

you can change the port that instance sql01\sql01 listens on to 1433, the default port for SQL Server. If you do that then users will be able to access...

durai nagarajan (7/10/2012)

---

Hello,

As a part of security, we are planning to change sql server default port.

what the precations we need to take care and how can we connect using management...

That depends.

Do you want to shrink or grow the file?

Is there any data in it?

Assuming the database is empty and the space allocation was a mistake, go to propertries of...

Thanks Perry.

We had at the same moment come up with a slightly different solution which tests ok.

We have created multiple Access-Points per SQL cluster bound to the different pairs of...

How are you sending the mail fromn SQL? Is it automated through the job agent or using sp_send_mail or something like that?

Try this:

1. ensure database mail is enabled.

2. ensure youu...

Ok thanks John,

Will ensure to put it on the checklist for post-build config changes.:-)

John Mitchell-245523 (6/21/2012)

---

Happy to help, Adam. I've done a bit more digging, and, by default, the "Is Alive" check runs every 60 seconds when the cluster service connects to SQL...

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...

What...

John Mitchell-245523 (6/21/2012)

---

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 service account..... Why would you need anything...

durai nagarajan (6/21/2012)

---

Schadenfreude-Mei (6/21/2012)

---

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

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

Try this, pick...

durai nagarajan (6/21/2012)

---

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...

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 to...