Active Directory is a special-purpose database which stores network, user and printer data in a hierarchical, replicated, and extensible form.

learn more… | top users | synonyms

1
vote
1answer
20 views

Managing Security for a Log Shipped db across two (unconnected) domains

SQL Server 2008 (soon to be 2012). We have a vendor that is providing us with log shipped backups of our production database. We use this log shipped database for BI staging, reporting, etc. I've ...
2
votes
1answer
28 views

Windows Authentication fails with “Cannot generate SSPI context”

We have a Windows Server 2012 with SQL Server 2012 instance. Its services used to run under an Active Directory account from an old domain, from Windows 2000 Server. A few years ago we replaced our ...
3
votes
1answer
30 views

Unknown Windows SID Mapped to Proxy During SSIS Package Execution

I'm running SSIS packages stored in a SQL Server 2014 catalog via scheduled SSA jobs. I'm reviewing my SQL Audit capture and noting calls to SSISDB are coming from the proxy I created when looking at ...
0
votes
1answer
31 views

TSQL LDAP query via Linked Server

I have strange problem, I have 3 SQL Server 2012 with Sp1 instances, and on all of them, the versions are identical. I am trying to query Active Directory services, on 2 of them this is working ...
3
votes
2answers
107 views

Grant Admin to an Active Directory account in SQL Server

I have a SQL Server 2012 instance, and an Active Directory group, which I can add Active Directory users to. I have my personal AD account (MyAccount) and a service account (ServiceAccount) in that ...
3
votes
1answer
71 views

Effective SQL Server permissions when user is in several AD groups

Using Window Authentication via Active Directory Groups, if an Active Directory user exists in two different Active Directory Groups with different permissions to a database, which Active Directory ...
1
vote
0answers
43 views

Change login name for all objects on server

Example, I have a create a windows login DOMAIN\GROUP01, and mapped that login to a database DATABASE01 with lets say DB_OWNER permissions I want to change the login name, I went into Active ...
10
votes
1answer
164 views

Why would suser_name() not reflect an AD account name change?

One of our users' names was legally changed, so we changed their Active Directory username to match - from domain\oldname to domain\newname. However, when suser_sname() is called by this user in a ...
7
votes
3answers
452 views

what AD groups logins my user belongs to?

I am not sure if I have chosen the right title for this question. what I am really after is, given a individual windows AD user, I would like to find out the list of the windows AD groups ...
2
votes
1answer
54 views

Error: 18456, Severity: 14, State: 5; SSMS > Network sever from PC

I just completed my first install of SQL as a server based, Enterprise Edition. I wanted to check it out using SSMS on PC using my Admin Access. But could not connect. For security reasons my ...
1
vote
1answer
157 views

How to pass credentials to a linked server in another domain?

I am trying to link two SQL Servers (2008R2 and 2014) which are running in two separate (!) Active Directory domains. The problem is that I can login into the remote server only with a Windows ...
0
votes
2answers
34 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 ...
2
votes
0answers
129 views

PostgreSQL 9.3 running on Linux - need to authenticate vs. Windows Active Directory

Database server is Ubuntu Linux 3.13.0-68-generic Database is PostgreSQL 9.3.10 LDAP set up according to https://cdc.iseage.org/tutorial-pam-ldap-authentication-active-directory-debianubuntu/ ...
1
vote
1answer
202 views

Is it possible to run Oracle 12c and AD-Server on Windows Server 2012 R2?

I have tried to install Oracle 12c Enterprise Edition on a computer also running as AD Server. Including the October 2015 patch. Operation system is Windows Server 2012 R2 A managed service account ...
1
vote
1answer
44 views

Active Directory group as a schema in SQL Server

In SQL Server 2008 R2 we have a database that is being maintained by a team of developers. Each of them should have permissions to perform DDL operations such as adding a column or creating a table. ...
3
votes
2answers
125 views

Cannot register SPN, error 0x80090350, state 4

This is my first time trying to configure kerberos. I need it for SQL. I'm running SQL Server 2008 R2 on Windows 2008 R2 server. I have an Active Directory account for SQL Server 2008 R2. The ...
1
vote
1answer
56 views

SQL Server login not working

I have a user who was added with windows authentication to a SQL Server 2008 R2 machine. He had left the company a few months ago, at which point his AD user was disabled and moved to a different OU. ...
1
vote
0answers
45 views

SASL won't auth against LDAP

So I am running into a whirlwind of issues with my cyrus install. I am setting up a multi-domain kolab groupware solution. I am on centos 6.7 I am getting this flooding my error logs when I try to ...
2
votes
1answer
53 views

How to find out ALL the users that can connect to SSAS?

I have an user called mycompany\aives that is not listed in the list of administrators in the SSAS, not belong to any of the AD (active directory) groups listed there, however, he can connect to ...
3
votes
1answer
45 views

How to get the AD account associated to a Proxy?

on the picture below, you can see, I have a sql server job called "Backup SSAS DBS_" that Run as: PowerShell_Proxy How can I find out the AD (active directory) account associated with that Proxy ...
1
vote
0answers
565 views

Postgres and Windows AD using windows authentication

I am working with SQL SERVER 2012 and postgres 9.4.x version on windows OS. The service-x on this machine is running under user-1 and user-1 is member of AD group ADG1. during the installation of our ...
0
votes
1answer
105 views

Create an AD user from a SQL Server trigger

Running SQL Server 2008 (10.0.5520) - I have a trigger that is executed when a new record is added to the security table. I would like to extend this trigger, and create an entry in the AD system with ...
2
votes
1answer
37 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 ...
1
vote
4answers
112 views

SQL Server : auditing AD Users - how can we identity AD User account from AD Groups

I would like to identity which accounts on our servers belong to AD Users. Currently, I find a plethora of accounts from users that should in fact be part of AD Groups registered on the same SQL ...
2
votes
1answer
183 views

Should I delete disabled windows Active Directory accounts from SQL 2008?

Is there a risk of not deleting unused Windows logins that have been disabled in AD or is it simply a housekeeping issue? e.g. Windows authentication is used to provide database access. A user leaves ...
5
votes
3answers
11k views

I need the reason why we should not install SQL server on the domain controller

I am a system administrator for a small firm. Now we consider to rollout Windows Server 2008 R2 for the firm. We plan to implement Active Directory. We would also like to upgrade RDMS, from SQL server ...
0
votes
1answer
326 views

jdbc connection string ORACLE , integrated security

we are trying to configure Spotfire to use JDBC connection to ORACLE. We would like it to use integrated security (I call it Active Directory, TIBCO seems to like integrated security). Here is the ...
0
votes
1answer
3k views

Excel Data Connection to SQL Server using Windows Auth from untrusted machine

We have an Excel spreadsheet that uses a Data Connection to a SQL Server database. The database server is joined to our domain, and Windows Authentication is enabled. Here is a sample of the ...
1
vote
1answer
40 views

Is it possible to target a specific instance in a clustered environment with group policy?

Not sure where to ask this, but here goes: I'm in a clustered environment, not the primary DBA (and he's not very AD/GP savvy either) and I'm being asked to set security permissions for an AD Service ...
0
votes
3answers
331 views

SQL Server Replication with 2 systems in different locations

I have 2 Servers with static public IP Addresses located one in UK and another in US. Can I implement SQL Replication on these 2 servers located in 2 different locations accessible via public IP ...
4
votes
1answer
475 views

ADSI Linked Server: Why can I query AD in VBA, but not as a Linked Server?

After all the reading and research I've done, this seems like the most logical place to post this question: Why can I query Active Directory using VBA, but not a Linked Server in SQL Management ...
1
vote
0answers
157 views

When does SQL Server follow the Minimum Password Age policy?

According to this SQL Server 2008 whitepaper, SQL Server should only pay attention to the Minimum Password Age policy when the Check_Expiration (Enforce Password Expiration) option is turned on. Page ...
2
votes
2answers
2k views

List Active Directory Users

My boss sent to request me that: I want to a SQL query, that lists all domain users of a specific group. I began to search query. I found several solutions using Linked Server. EXEC ...
0
votes
0answers
254 views

SSIS cannot access the file

I have a SSIS package which performs a few tasks using SQL Server Agent. First it executes a script task, then accesses Excel files, executes a SQL query and moves files to another directory. The ...
0
votes
2answers
352 views

Is it possible to convert existing users from SQL Server authentication to Windows (AD) authentication? (SQL Server 2008 R2)

We have just undergone a bare-metal restore of an SBS 2003 server running our SQL database and are in the final stages of configuration before going live again. Previously, we had 20 users accessing ...
0
votes
1answer
256 views

Connect Oracle database using AD account via OID

We have configured Oracle Internet Directory. We have integrated OID with AD. We have also registered Oracle database with OID. And we are now trying to configure authentication to the database with ...
3
votes
1answer
7k views

Connection AlwaysOn AG Listener Problem

I'm a newbie for microsoft technologies and I'm having problems in connectivity part for SQL Server 2014. This is probably an easy issue but I'm stuck. I've 4 servers. One of them is the Active ...
0
votes
0answers
330 views

Login failed for a user in a Domain Local Group

I have recently been considering moving from using SQL Logins in my applications, to a model using Windows Authentication using Active Directory groups My intention is to allow users access to ...
3
votes
2answers
5k views

SysAdmin server role and Active Directory Groups

I've been struggling to find best practices information or any advice regarding Active Directory Groups that provide group members with the SysAdmin server role. I'm at a new job where I'm the only ...
2
votes
1answer
762 views

SQL Server - Service User Accounts and Licensing? [closed]

Maybe this is the wrong place to post, since its not necessarily sql server related, but here goes. If I want to setup some service user accounts in the domain to use to run sql services like the sql ...
1
vote
1answer
560 views

Active directory automatic login to SSRS

I have a server running SSRS 2012 at address server1.olddomain.com. This is working fine. My users will be accessing this server from another address (the server is not physically moving). The new ...
6
votes
1answer
5k views

How to clear an Error 15404 after a DB restart (besides rebooting)

Every so often (e.g. ~months) a SQL Server Agent hourly Job will begin reporting an Error 15404 and continue to do so until intervened with. [298] SQLServer Error: 15404, Could not obtain ...
1
vote
1answer
254 views

User switching accounts, can't log into MS SQL Server anymore [closed]

First a bit of background, for good or bad, we don't keep one user account attached to one person. The user accounts are matched to their position. For instance the CEO would have a userid of CEO. ...
1
vote
1answer
315 views

Creating domain user login from another domain?

I have two domains named "Domain1" and "Domain2". I have SQL server 2005 in Domain2, and users in Domain1. How can I create a login in SQL Server 2005 (in Domain2) for the user that is present in ...
1
vote
0answers
222 views

Oracle 10g and Active Directory not behaving as expeted

I'm trying to connect to our Oracle 10g 64bit database running on a Windows 2003 server authenticating with an Active Directory user. I found this weird results on our Development environment which I ...
0
votes
1answer
657 views

Which databases can have row and column level security based upon Active Directory? [closed]

I have various database types, Oracle 11g, MySQL 5, Sql Server 2012. I have direct access. I can have other databases if I need them such as PostgreSQL. What I'm doing is protecting data at the ...
1
vote
2answers
3k views

Active Directory group permissions not being applied to user [duplicate]

I have an odd situation. An Active Directory group was recently created for the sole purpose of being a securable in SQL Server. I created a login based on the AD group, a user based on the login, and ...
2
votes
4answers
3k views

SQL Server grant permissions to STANDBY database

So, first: the setup. We have SQL Server 2012 (ServerA) running in domain A. We have SQL Server 2012 (ServerB) running in domain B, separate subnet, no trusts. These are completely separate domains ...
0
votes
2answers
1k views

SQL Server AD groups membership seems cached - how to flush to test? [duplicate]

I am configuring a new, fully AD group based security scheme on an existing SQL Server 2008. When I change the group to which I belong to test my configs, it seems that there is quite a delay between ...
3
votes
1answer
10k views

LDAP in SQL Server 2012

In our current system, we query the LDAP using SQL Server 2008R2 but are moving to SQL Server 2012 where we have hit a snag. According to http://msdn.microsoft.com/en-us/library/cc707782.aspx one of ...