2
votes
1answer
124 views

Does changing a Service from Automatic to Manual mean that it is unable to be started by other services/applications?

Morning all. We have a script that checks for services that are set to Automatic, but not running. It alerts us if this is the case. We've got a couple of services, like SQL Server Active Directory ...
0
votes
1answer
306 views

GPO WMI username filter not working over RDP

I'm trying to write a WMI filter to prevent a GPO from applying to certain users SELECT * from Win32_ComputerSystem WHERE NOT UserName LIKE 'domain\\user1_%' AND NOT UserName LIKE 'domain\\user2_%' ...
2
votes
1answer
352 views

How should I configure my Active Directory servers so that if one goes down, users are not kicked off SQL?

Today, we shut down one of our Active Directory servers during office hours to check the loading on a UPS. Since all the server did was provide Active Directory in a separate building incase the main ...
2
votes
1answer
358 views

Active Directory + IIS + SQL + ASP.NET

I have sent the following question to stackoverflow website I have installed Windows server 2008 r2 on a virtual machine, Can I install Active directory with domain controller + IIS + SQL server ...
0
votes
1answer
1k views

what permissions does a user require to query AD from SQL Server?

Have created a linked server to active directory from SQL Server but getting a permission denied error when I try to query anything. Under the security options for the linked server I have specified ...
3
votes
1answer
1k views

SQL Server Windows Authentication NTUSERNAME is different to Windows Login

An employee at a client has just got married and as a result they have changed her details, login name et al., in Active Directory (AD). The problem is SUSER_NAME() in procedures and the NTUSERNAME ...
1
vote
2answers
621 views

Kerberos constrained delegation not working

I have a typical double hop scenario, User ->IIS->SQL. I am using IIS 7.5, which is using Kernal Model Authentication, so I am setting up the IIS server account for delegation. If I set this to ...
0
votes
2answers
1k views

Synchronize SQL with information from Active Directory

I would like to pass information from Active Directory to a Microsoft SQL Server database any time a change is made in Active Directory. In this way the SQL will always have a reliable copy of the AD. ...
2
votes
1answer
307 views

Programmatically add/delete users in Exchange

I've got the following set up: ASP.Net site that allows my internal employees to add in new hire information (no secure data, just stuff like name/address/phone) and when they submit this it goes ...
1
vote
2answers
126 views

Moving server farm into an AD domain

I'm researching the feasibility of moving our small (but not tiny) hosting infrastructure from stand alone servers each with unique local usernames and passwords, to a more intergrated active ...
2
votes
3answers
1k views

Managing SQL Server users via Active directory groups

I'm building SQL Server instance for reporting purposes. My plan is to use AD groups for server and database logins. I have several groups with different roles (admin, developer, user etc.), and I ...
1
vote
1answer
148 views

SQL 2008 network logon

I have a domain controller that I have installed active directory onto and have set up an account that I want to use for my SQL server installation on another computer that is linked onto the domain. ...