Questions tagged [service-accounts]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
54 views

Unable to backup to a UNC path with a gMSA

I'm trying to automate backups using Ola Hallengren's backup scripts. I'm testing this out on a SQL express instance 2008 R2 (I know it's EOL today). I've setup the jobs and I created a scheduled ...
-1
votes
1answer
27 views

Raid Reconfiguration of SQL Server 2016 Box

I did raid reconfiguration of SQL Server 2016 box. All my systems databases files (mdf and ldf) are in D drive and SQL Server installation also is in D drive and i have them intact. I have lost user ...
2
votes
1answer
40 views

Does the SQL Server Service Account have to have access to a network share to perform a backup?

I've been provided a specific domain account to handle backups from my sysadmins. I am slightly confused as I've never been provided a separate domain account to handle backups in the past. I still ...
4
votes
1answer
146 views

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 ...
3
votes
2answers
213 views

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 ...
0
votes
2answers
53 views

How to find out the service accounts for each of my instances in the current server?

I have the following query that gives me one line for each sql server instance installed in the current server: --list the instances in the current server --marcello miorelli --16-sep-2016 ...
1
vote
0answers
25 views

Restrict Source Access to SQL Server Service Account

I have an Audit requirement to ensure that the service accounts (that connect to SQL Server) are not used by anyone but the by the APPLICATION SERVER itself. All other connections attempts must be ...
0
votes
0answers
37 views

NT SERVICE accounts should be sysadmins? [duplicate]

I have the following query to get me a list of sysadmins in the current server: select 'ServerRole' = SUSER_NAME(rm.role_principal_id), 'MemberName' = lgn.name , 'Status'= Case when ...
0
votes
0answers
111 views

Revert to using local account for SQL Server services

We have changed the login/startup account of our SQL Server service, to use a domain service account. However, we are experiencing issues with this account, and need to revert back to using the local ...
1
vote
1answer
730 views

gMSAs and SQL Server 2017

I am setting up a brand new SQL 2017 installation. I want to set up and use gMSA(s) for the Service Accounts. What are the best practices for SQL Server? Should I use individual gMSAs for each service?...
1
vote
3answers
4k views

SQL Server Agent Server Login Account

What SQL Server login does the SQL server agent use to log in to the database instance? I am running the SQL server agent as the built in local system account. I have created a SQL agent job which ...
1
vote
1answer
176 views

Granting permission to the service account

I am currently granting permissions to a service account on a database. I want to ensure if the granting db_datareader and db_datawriter database roles is the same as my grant command. Adding service ...
0
votes
1answer
73 views

Sql clustering sql server account

Does both the sql cluster nodes needs to use the same service account ? In my environment I saw one one was using a service account and another was using a local account although the sql agent was ...
2
votes
2answers
1k views

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 , ...
3
votes
2answers
1k views

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 ...
1
vote
1answer
41 views

Oracle Installation Account

Is there any scenario where it is the best choice to make the Oracle installation/service account (oracle) an LDAP/AD account versus a local-only account? More generally, is creating the Oracle ...
3
votes
2answers
421 views

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 ...
0
votes
0answers
32 views

AD Service Account Changes

Are there any ways that can seamlessly enable the operational continuity of the Application upon a Service Account Password Change at Active Directory Level? Any Ways? Any Tools?
0
votes
0answers
515 views

Why did the “Bypass Traverse Checking” permission fix my issue?

I was having an issue getting SQL Server Reporting Services 2008R2 SP3 working under a domain service account on Windows Server 2008R2. It started with this What am I missing for my SSRS Service ...
1
vote
1answer
2k views

What am I missing for my SSRS Service account local server permissions?

I have a relatively new instance on SSRS 2008R2 SP3 running on Windows Server 2008 R2. I am trying to set up separate domain service accounts for the separate SQL Services i.e. agent, engine, ...
0
votes
1answer
89 views

Merge Replication: Service Account Password Change

Is it possible to change the password of a SQL Server service account that is used for not only on the publisher server but the 6 subscriber servers as well without seriously affecting merge ...
1
vote
2answers
1k views

SQL Server - login failure every day at same time with the service account

I have dozens of SQL Servers, on many different versions. Many of them have an error in the SQL Server error log EVERY DAY at just about 2 am. Login failed for user 'TheDomain\...
1
vote
1answer
672 views

Changing startup accounts on alwayson setup

I have a 2 node Always On Availability Group cluster where we are planning to take backups to a file share which will then be moved to Azure cloud. We have a service account from the Windows team for ...
1
vote
1answer
156 views

Sid's for service accounts in alwayson

When creating new maintenance jobs for an alwayson setup with new service accounts, should we ensure that the sid's on both the nodes should be the same? I created a new login with the new domain ...
1
vote
2answers
486 views

SQL Server Service Account Configuration - one account per Server? [duplicate]

Planning to re-create new service accounts for our Sql-Servers, I wondered if - from a security perspective - it maybe better to have one domain account per Service and per Server or to create one ...
7
votes
3answers
7k views

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. ...
9
votes
3answers
2k views

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 ...
0
votes
1answer
552 views

Sql service account password change for environment on Availability groups 2012

My current environment is on Availability groups sql 2012 with 1 Synchronous and 1 Asynchronous replica. Soon we need to change the sql service account passwords. Can any one suggest to me do I need ...
0
votes
1answer
495 views

should I give dbo permissions to NT AUTHORITY\NETWORK SERVICE?

We're in the process of assessing a new application that will require access to our MSSQL database I've set up a user that is a member of a role only giving it readonly access to certain views in the ...
4
votes
1answer
859 views

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 ...
1
vote
2answers
84 views

SQL Service Account creation in AD using PowerShell [closed]

I'm wondering if it's possible to create a service account remotely from the SQL box using PowerShell, and put the service accounts created in the OU (folder) they belong in AD as part of a unattended ...
0
votes
1answer
1k views

SQL server Virtual account and folder permissions

How does SQL server 2012 still work after changing the Service account to a domain account or even a local account. For example: as mentioned in MSDN https://msdn.microsoft.com/en-us/library/...
1
vote
2answers
515 views

My Backups Broken

Our SQL server was running with a Domain Admin user for the SQL Service account. Our backups are accomplished with a script: DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) --...
2
votes
1answer
602 views

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 ...
2
votes
1answer
65 views

Managing the Service accounts in large environment

I wanted to know if there's a best practice in regards to secure a large environment of SQL Server instances (version 2000-2012). Currently the SQL services are running with many users and I'm trying ...
4
votes
2answers
3k views

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 ...
0
votes
0answers
548 views

Security for SSIS packages in SQL Server - use a domain account?

I have an SSIS package that I want to deploy to SQL Server A. This package needs to access tables on SQL Server A, and another SQL Server, B. What is the best way to set this up? Should I create a ...
12
votes
1answer
42k views

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 ...
0
votes
0answers
215 views

SSRS 2008R2 SQL Service Account Connection Issue

In our SSRS report manager page we get the below error on the Datasources. This all worked fine previously and seems to suddenly have stopped working. I have no idea what the issue could be. All SPN ...
2
votes
1answer
263 views

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 ...
2
votes
2answers
727 views

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 ...