You should change this in the config manager. Not sure why it is grayed out. Do you have sysadmin/administrator permissions?

Change

That should work OK. I might ensure the account doing the restores has access to the certificate, but others are not granted permissions. Not sure it's a great help since...

sayli 5771 (1/10/2017)

---

Hi All,

I want to migrate data from SQL server 2005 to Company owned database.

I created csv files but some columns have special characters and it causes non alignment...

SSMS works from Win to a SSoL. It doesn't run (yet) on anything other than Windows. Native Linux tooling is...

jasona.work (1/11/2017)

---

Coming at this from more a production DBA and less a developer DBA point-of-view, I'm rather ambivalent about SQL on Linux. To a large extent, I don't really...

Snow last week and had to take my wife to the doctor (unreleated). slipped in the x5, with summer tires.

Had to go buy some winter versions, and new wheels.

Was going...

Brandie Tarvin (1/11/2017)

---

So someone tell me who those "Steve Jones" and "Grant Fritchey" characters...

Do this. Do not try to set these yourself.

Create a domain account,...

The question was "... What can I do? (choose 2)."

Not must, or should, but can. You don't need View Server State to kill the jobs. This is required to view...

I'm in the both camp. I use SQLCMD to do lots of simple stuff, it's easy to work with and I'm comfortable.

However, when I want to do more scripting that's...

Beatrix Kiddo (1/9/2017)

---

Quick random question that isn't really worthy of its own thread. Given that the log redo process in an AlwaysOn Availability Group secondary can be likened to a...

aalberyo (1/9/2017)

---

Hi friend,

Compile talks about Store Procedure for the DB. Basicaly is modify and optimize of tables and indexes incorporated a one field of a table, compile an SP it...