Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [service-accounts]

64 questions
15
votes
1 answer

SQL Server service account Windows privileges and rights

My question is, if you create a new domain user account for each of the SQL Server processes, what permissions should be set for each account? Or does the SQL configuration manager actually take care of this, and I just had an unforeseen issue? I…
plumdog
  • 253
  • 1
  • 2
  • 5
8
votes
3 answers

Single service account running all SQL Servers

Is there any negative performance impact for using the same service account and agent account to run SQL Server and SQL Agent respectively for all SQL server instances running at a small company of say 35 servers? The biggest database is 0.5 GB. any…
Pol
  • 392
  • 1
  • 7
  • 18
7
votes
3 answers

Find which account SQL Server service is running BACKUP under

Our DBA is out and I'm trying to back up our (remote) dev database to a UNC path. I'm running the back up operation while logged into Management Studio as a particular Windows domain account (e.g. CORP\myUser). I've checked that this domain account…
T. Webster
  • 319
  • 1
  • 3
  • 8
6
votes
2 answers

SQL Service Using Group Managed Service Account does not start after reboot

We are using group managed service accounts for our SQL Server 2016 servers. For some reason, when we reboot the server, the service does not start and we see this in the event viewer: The MSSQLSERVER service was unable to log on as…
kaitlyn
  • 593
  • 2
  • 7
  • 15
5
votes
2 answers

SQL query or method to list all sql services running

This might be a simple one, but i searched a lot and unable to find one. Is there a sql query or a way i can run on registered server to find the list of all sql related services running like, ssis , ssas, ssrs, sql, agent, broswer, etc... Tried…
BeginnerDBA
  • 2,230
  • 3
  • 27
  • 55
5
votes
2 answers

Service Credentials to use in AlwaysOn Availability Groups?

When using AlwaysOn Availability Groups does each SQL Instance need to use the same service credentials? We are setting up a new SQL2014 deployment and will be using AlwaysOn. If I have 2 SQL servers (call them ServerA and ServerB) then can I use 2…
Greg
  • 3,292
  • 5
  • 33
  • 57
4
votes
1 answer

Refresh SQL Server's service account security group membership

Consider a SQL Server whose service account is a Managed Service Account in Active Directory. When this MSA is added to a security group, this group membership is not immediately going to take effect if SQL Server is already running as the MSA.…
NReilingh
  • 785
  • 2
  • 9
  • 27
4
votes
1 answer

Availability Group Endpoints Windows Authentication Error

I have a two-node SQL Server 2016 Standard Always-On environment and when I create a new availability group, I receive the error message below: The Endpoints tab lists at least one endpoint that uses only Windows Authentication. However, the server…
WadeH
  • 540
  • 4
  • 20
4
votes
1 answer

InfluxDB - How can I limit the measures that a user can read by their tags?

I have some data that is collected by several sensors. Some users may own many of these sensors. I want to keep all the measures in a single database in InfluxDB. To differentiate the sensors I pretend to add some tags (such as 'sensor_id=aaa',…
David Mendez
  • 43
  • 6
3
votes
2 answers

Changing SQL Server service account passwords enterprise-wide

In the event of a DBA leaving an organization, what options can the surviving team members pursue to change passwords for service accounts portfolio-wide? While using Configuration Manager appears to be the de-facto method, can PowerShell or another…
MattyZDBA
  • 1,955
  • 3
  • 20
  • 32
3
votes
2 answers

Why SQL Server Service Account connects to the DAC?

We started getting Alerts: Could not connect because the maximum number of '1' dedicated administrator connections already exists. Before a new connection can be made, the existing dedicated administrator connection must be dropped, either by…
VitalicJJ
  • 55
  • 1
  • 8
3
votes
2 answers

What are points to consider when replacing the SQL Server service account?

In What are the implications of changing the SQL Server Service Logon Account? it mentions that when replacing the SQL Server service account, the service will need to be restarted. But there is more to it than that. According to Configure Windows…
Marcello Miorelli
  • 17,274
  • 53
  • 180
  • 320
3
votes
1 answer

SQL Server 2012 Always On AG - DBEngine Service account locking

I am having a strange issue and am hoping you guys might be able to help! Problem: I have a 2 node SQL Server 2012 Availability Group Cluster utilising a FSW. Both nodes are using the same DBEngine Service account (as is normal in these…
Sam Partridge
  • 200
  • 2
  • 9
2
votes
1 answer

Can I grant multiple remote LocalService accounts access to a SQL Server database?

I am designing a multi-environment Windows-based software product that will extensively employ Windows services running as LocalService to perform data access operations. All of the data access endpoints are .NET applications that use Entity…
AdamStone
  • 23
  • 2
2
votes
1 answer

Securing Functional/Service ID for MSSQL with Windows Authentication

I'm currently assessing a setup of Data warehouse implementation in our environment, based on the requirements: A functional/service ID to be setup to access multiple DB servers of other applications in the company for replication purpose. Password…
nlks
  • 21
  • 1
1
2 3 4 5