Hi David
Great News!!
It didnt work for me until i applied CU7
CU7 gets applied atop of SP1 to deal with bugs and / or software issues...

Hi perry

So when you say secured I’m guessing I need to follow the CIS benchmarks and security guidelines / checklists from MS.

Anything I need to follow?

I’ll discuss the port...

So what would be your recommended approach?

By the way I kept shared memory enabled because I didn’t use aliases and the agent runs with it enabled

Kal

Hi David

I ran into an issue when applying SP1 today it seems one column of the sysmail_server table. One column called timeout gets removed but it gets reinserted if you...

I can convince our ciso to keep the default port instead of 1433 but I need justification

You guys are the experts so is what I’m doing considered secure or...

Hi Sue

The link you sent me states at the bottom:

Program the client to connect using a custom connection string.

So we will have all applications using custom connection strings and...

Is that a must? I didnt read anywhere that you should use the browser service with non-default ports.

Kal

So i reapplied SP1 and CU8 again and with no luck so i removed CU8 and applied CU7 and voila it works

Anyone face the same issue?

Hi David
Which version of SQL Server are you running and did you apply any CU lately?
Kal

Hi Sue / Jasona
I am only mentioning extended SPs so arent we not supposed to modify those SPs?

KY

DEfault instance

1433 to 7771

No browser

Hi Sue
So i cant encrypt extended SPs? Unless i go through each one manually and drop and recreate them using the clause WITH ENCRYPTION?

Also for TDE...

TCP protocol is enabled and the agent is on the same server as the engine and for client protocols only tcp is enabled.

Test it and see what you get

I...

Our CISO wants us to do the following:

April 9, 2018 at 7:13 am

#1985950