Kwisatz78 (8/1/2012)

---

OK thanks Gail, we have fired something off to our account manager but I sometimes find different companies get different answers, was just after some real world experiences which...

shah.smit (8/1/2012)

---

one more thing i want to know that... after failover mirror(srvr2) will be principal and principal(srvr1) will be mirror so at that time witness(srvr2) will be on principal... so...

Never ever ever be afraid of saying that you dont know something. There is nothing worse that a self proclaimed know it all who pretends to know everything, and...

"The witness server instance can run on the same computer as the principal or mirror server instance, but this substantially reduces the robustness of automatic failover. "

http://msdn.microsoft.com/en-us/library/ms190430(v=sql.105).aspx

Yes, you can install Just reporting services on one pc and point it to a reportingServices Database on another PC. its all configurable via Reporting Services Configuration manager, in the...

ksrikanth77 (7/17/2012)

---

If you made a Force failover and if mirroring is active then there will be enough log on the Old principle server. However if you have a force filover...

I found out that a large update caused the issue. there was a code drop that modified a lot of data. nobody was notified of this, hence i thought this...

Thomas Stringer (6/10/2012)

---

Out of curiousity, what does the following return?

select @@max_connections as max_connections;

And you say CPU isn't high. Is that the overall "_Total" CPU? If so, you could...

thanks for the clarification gail. does that mean that if i have 20 core server, and 20 individual drives attached to my server, i create a filegroup with a file...

Apologies forgot to respond on this. Resolved the issue. although I disabled windows firewall, norton was running ( dont ask!) . on disabling ( actually uninstalling) norton, everything worked fine.

Thanks!

One thing to add here, which strikes me like peculiar behavior.

When you enable kerberos, you dont need to restart the service, kerberos simply takes over.

but to disable kerberos, after removing...

all attempts were run from the actual server.

When I say I remote in, I meant I'm now at home and so had to remote into the servers, as opposed...

Perry Whittle (4/16/2012)

---

winston Smith (4/16/2012)

---

I ran setspn -l server.domain and got a list of all SPN's for the server.

I then ran setspn -d MSSQLSvc/server.domain domain\serviceAccount to remove the MSSqlServer SPN.

I...

I was logged in as my own domain account, which...

opc.three (4/16/2012)

---

Not sure which order you were doing what, but for the record the SQL Server service will re-register an SPN if it has rights to Active Directory (LocalSystem, NETWORK...