Blog Archives

Active Directory and PHP on Apache on Bash on Ubuntu on Windows

Recently, I wrote about Joining Ubuntu to an Active Directory Domain. That was for an actual Ubuntu box and the plan was that the next post would be about adding Apache to the mix. But then I got distracted by

Posted in Active Directory, Apache, Linux, Security, Windows

Joining Ubuntu to an Active Directory Domain

Back in 2009, I did a whole lot of messing around with Linux and Active Directory integration, primarily for Apache. Now that Linux is coming to Windows, I figured I’d brush up on my Linux and Windows Integrated Authentication skills

Posted in Active Directory, Linux, Security

SQL Server Client Tools, Linux and Integrated Authentication in a Few Easy Steps

Back in 2013, I wrote about “Using Windows Authentication to Connect to SQL Server from Linux“. Considering how convoluted using Linux can get, doing so was surprisingly straightforward then and it’s even easier now. Want to see a webcast about

Posted in Active Directory, Linux, SQL Server

Failed Domain Relationships on SQL Server Cluster Nodes

You know what’s scary as hell? When one node of an important cluster loses its trust relationship with the domain and you see the error “the trust relationship between this workstation and the primary domain failed”. That happened to me

Posted in Active Directory, PowerShell, SQL Server

SQL Server: Cannot Generate SSPI Context and KRB_AP_ERR_MODIFIED Errors

As DBAs, one of the most  common tasks performed is the installation of new SQL Servers.  While I’ve installed hundreds of SQL Server instances over the years, I only recently come across the error described below.  In the past, I’ve seen

Posted in Active Directory, SQL Server

Using Windows Authentication to Connect to SQL Server from Linux

One of the things I love most about SuSE is how well it integrates with Active Directory. Joining a domain is easy when using yast. First I ensured that the Linux server’s DNS server is pointed to my DC, then

Posted in Active Directory, Linux, Security, SQL Server

SQL Server Discovery Tools and Scripts

Each time I start a new contract, the first thing I do is search for all SQL Servers across any network/subnet to which I have access. While the documentation I get is usually paltry or non-existent. When it does exist,

Posted in Active Directory, PowerShell, SQL Server

Patterns and Practices: A Guide to Claims-Based Identity and Access Control – Free ebook.

While I usually like conversation-style technical books (think: Manning’s In Action series and many Wrox books), Microsoft’s Patterns and Practices series is one of my favorite even though they feel so formal. Recently, my buddy Buck Woody posted a link

Posted in Active Directory, Networking, Security

Migrating SQL Server?

dbatools is an awesome PowerShell module that helps you migrate entire instances with a single command.


Available from dbatools.io and github

SqlServer Needs You

SqlServer now has a dedicated engineer and Microsoft is asking for our input!


 
Upvote priorities and cmdlets now

Authors


Chrissy LeMaire


Brandon Abshire
View Brandon Abshire, MCDBA's profile on LinkedIn

Awards

Chrissy has been awarded the Microsoft MVP for her work in the PowerShell community.

Join us!

Belgian PowerShell
User Group

  SQL PASS PowerShell
Virtual User Group

 

Upvotes Needed

Help persuade Microsoft to open source SQL Server's PowerShell module, SQLPS.


 
Upvote now on Microsoft Connect