SNAC was introduced all the way back in SQL Server 2005. "SQL Server Native Client combines the SQL OLE DB provider and the SQL ODBC driver into one native dynamic-link...

To put a slightly different view on this topic - Steve was upgrading a Client operating system. Windows Services should run fine, but they are hardly typical on Windows 8.

We...

Maybe not relevant, but.... the column [LID] has datatype [int] with IDENTITY(1,1).

The table contains 2,163,568,622 rows.

Max size of an integer is 2,147,483,647.

I guess it's possible that negative numbers have been...

+1 Thanks Steve, good question on an important topic..... and I got it wrong 🙁

Good to hear the certificate request finally worked for you.

I think the steps you defined in your first post are a good guide to follow, and will hopefully help...

Thanks for clarifying the issue, and I'm sure your correct. I was just kinda hoping that embedding the Instance Name in the SPN would be a work-around for dynamic TCP...

Sorry, I meant to say a nice key symbol, not a padlock! Thanks Joie.

The process you've followed seems correct. Unfortunately the Enrollment Wizard is a strange mix of additional windows,...

I can't help with your specific Certificate Enrollment process, but if we assume you've managed to generate a valid certificate, which includes the private key, then:

The certificate needs to be...

You've got a long memory! I think the last time I used the IPX/SPX protocol was playing Red Alert on a small private network.

I don't have a particular server I...

I've been a bit confused on this point! The guidance...

There is no way that a single SQLIO exe, running on a single server, should be able to bring down your SAN!

If you know that you are not allowed to...

Difficult to say if, performance wise, it would be better to split the mdf/ndf files from the ldf files. It would depend on how the database is used (eg. mainly...

I would start by reading Brent:

http://www.brentozar.com/archive/2014/01/whats-the-smallest-sql-server-you-should-build/

Hi,

You have Tiered Storage - what process decides which storage is used? Does the SAN automatically move frequently-accessed data to SSDs, or do you have 3 classes of LUN...

Good, thoughtful question and, even better, step-by-step discussion of each possible answer.

Thanks!