Hi Perry,

I was able to create certificate and restore DB in my local PC as password is available.

Below are certificate backup created by some earlier DBA, but named wrongly.

master_key.dat =...

Thanks for the clarification Gila.

I may try to restore the DBs in Test server. Thanks.

Thanks Gila and Perry.

So since SQL 2008 doesn't have option to encrypt only DB its both the DB and Backups are encrypted I assume.

I can see following files saved in...

Hi,

I try from both active and passive nodes and from some remote other machines also.

Thanks.

It was NOT. But now I got it done "Trust this use for delegation to any service (Kerberos only)".

I rebooted both the...

Hi Perry,

The issue is still not resolved it seems. Yesterday it was showing KERBEROS.

But today when checked, again back to NTLM. I connected using windows account from active node SSMS.

SetSPN...

Hi Perry,

Yes, connected from a remote machine and confirmed. Thanks a lot for your support.

San.

Perry Whittle (6/29/2015)

---

the account sql server runs under will attempt to register and deregister the SPN each time it starts and stops. If the account hasn't been provided with the...

Joie Andrew (6/26/2015)

---

Sounds like it could be a couple of things. You responded earlier that you can ping the cluster IP but never stated whether or not you could ping...

Hi All,

Team informed DNS entry is correct.

I checked again and found it works fine when I put FQDN instead of just SQL cluster name.

Is it the expected behavior ? Is...

Thanks Perry.

Installed cluster first time, that too for both IPs ,hence this confusion.

Thanks again.

Hi All,

Thanks for the responses.

I will check with network team on this.

These are all new servers, so trying first time only.

I was able to ping the IP and telnet port...

Need to check with AD team

Another thing you can try is running setspn -X to see if there are any duplicate SPNs registered. That...

free_mascot (6/24/2015)

---

I guess you need to first understand requirement in your environment whether to go with IPV4 or newer version IPV6. you also need to understand what is the difference...

No Joie.

setspn -S MSSQLSvc/[sqlinstance] [domain]\[svcaccount]

I was running exactly the same command. Then it gave the message "Updated SPN...." but still logging this error in errorlog and was using NTLM...