From the OS'es point of view, SQL Server is a service; only local admin privs are enough to restart a service.

I had a similar problem with another product, and I...

Hi Edtraviles,

Several months ago I was in exactly the same situation that you're now in, I needed to deploy an SQL Server without knowning it at all. To get prepared...

To agonzal2:

Thank you for confirmation.

By the way, Grasshopper isn't my name, it's just status on the forum. 🙂

To rudy komacsar:

TCP/445 was initially opened, it's File and Print Sharing.

I added UDP/445...

Simon,

CAL licensing model implies licensing client devices/users (depending on server product), i.e. endpoints; the number of target servers doesn't matter. That is, simultaneous connection of 1 client to several servers...

Greg,

Thank you for the valuable answer.

Greg,

Microsoft doesn't recommend using Network Service and, moreover, Local System for SQL Server accounts, as stated in BOL and corresponding articles @ MSDN. (That actually was my start point in...

Steve,

I understand your idea. Excluding the accounts from Domain Users group would make them really rightless.

I know that SQL Server setup or Conf Mgr assign all appropriate rights, so it's...

My opinion is that while AV software is the must on a file server, it is useless on a "well-configured" SQL Server, since the treatment goes to be worse than...

Alright guys, I've learnt your advises, and I will try to implement them.

Thank you very much for the discussion.

Thank you for your answers.

So far, you enumerate 2 reasons (besides convenience) to use domain accounts instead of local ones:

- backup/restore using remote file share (not my case);

- ability to...

Thank you for the very certain answers.

This is what I'm asking for.

Michael Valentine Jones, do you mean account for Agent service, right?

Andrew, do you mean all 3 services (Server, Agent,...

If a domain account is compromised, the domain is affected; if a local account is compromised, only a single machine is affected. Moreover, if the account is used only by...

Thank you, Perry Whittle.

The answer is simple for those pros who knows it. 🙂

If a newbie would just follow the answer, he/she will always be newbie. To become a pro,...

Thank you Andrew, I know it, and alerady configured 3 separate RAIDs - for OS and programs, for database data files, and for database logs. Everything's ready, except for unresolved...

Thank you.

I do know that the accounts should be low permission ones, and that setup assign necessary permissions for them, and this is exactly what I did, and wrote about...