ports were open.

We restarted the mirroring endpoints and the issue got fixed.

We have noticed the following error in SQL Server error logs:

The Database Mirroring protocol transport could not listen for connections due to the following error: '10013(An attempt was made to...

You are right about both

Old instance - yes default

New instance - yes named

Issue resolved now.

the service account running SQL Server didn't have permissions on the clustered Disk "S"(in our case) to create temp mdf and ldf files.

After we have full permission to...

You mean the Cu3 too?

Benki Chendu (7/25/2012)

---

I have another quick question.

If am doing the SP4 upgrade using the active node only, if the task scheduler is enabled, the binaries will be pushed onto the...

I have another quick question.

If am doing the SP4 upgrade using the active node only, if the task scheduler is enabled, the binaries will be pushed onto the passive node...

Thanks...

Perry Whittle (7/25/2012)

---

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

Perry Whittle (7/25/2012)

---

yes, this link provides info.

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

Can I get an official Microsoft link which describes these prerequisites?

Some of my team mates had accidentally given the sysadmin for the user.:-D

Now, I revoked it.

Now, its so confusing here. When RDP rights are revoked, sqlcmd is not working...

no..it doesnt work with SSMS also..

But when RDP access is given for that windows user, he is able to use sqlcmd but dangerous thing is, he gets access to all...

ok got the point..

Now, if the customer doesn't need any more logs to be restored, will it work for him with the new username?

Lynn Pettis (3/22/2012)

---

Just so you know, you probably won't be able to restore any log files to that database if there is a source a database from which tlog backups...