Translate this site using Windows Live Translator:
Using a SQL Cname on WS08, when provisioning RMS - RMS: Protecting Your Assets. - Site Home - TechNet Blogs

RMS: Protecting Your Assets.

The Protecting 'My' Asset Disclaimer: This is my 'un-official', 'in my spare time', 'use at your own risk', all things RMS (Rights Management Services), IRM (Information Rights Management), IPP (Information Protection Pla

Using a SQL Cname on WS08, when provisioning RMS

Using a SQL Cname on WS08, when provisioning RMS

  • Comments 1
  • Likes

I thought (and a few other people as well) this particular subject warranted a blog post, instead of just a comment I made a while back to a poster.

As a matter of best business practices, I have preached over and over again the importance of using cname records for your RMS cluster url and your SQL server name when provisioning RMS, for disaster recovery purposes. In fact this weekend I beat a guy up that didn't believe me...errr..no wait..that was Chuck Liddell who did that on UFC 79. Me and Chuck kept telling Wanderlei, 'Dude..you need to use a cname record', but he said you didn't, so Chuck helped show him why, by giving a demonstration of why disaster recovery is so important. :)

Anyways, with WS08 someone threw a monkey wrench into the works that requires a little 'redneck engineering' to overcome for the time being.

If you try to use a cname record for your SQL server instance (assuming everything is on WS08..UPDATE: Actually you need to do this if it is SQL on WS03 as well), you will find that your SQL server will promptly ignore your request to call it by anything other than its proper given name. To force your SQL server to play nice with the peasants, and accept whatever name *you*, oh master, decide to call it by, you need to set the following registry key on the SQL server (which may also be your RMS server) before provisioning:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\lanmanserver\parameters
DWORD: DisableStrictNameChecking
Value: 1 (Peasant/Play Nice) 0 ('Big Jerk' Mode)

NOTICE: You *must* bounce the machine after setting this value. (Thanks Andy!)

Hope this add more life to the hair you may still have!

-Jason 

 

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment