Posts

Showing posts from 2015

ADP workforce not working with IE11

Image
This week we decided to upgrade our ADP to the workforce version and we found that Internet Explorer 11 wouldn't work even though it was supported.   We were getting a compatibility error screen as if we were running IE7.  Turns out that we had added adp.com to the IE 11 Enterprise mode sites.xml file and we had to remove it from Enterprise mode before anything would work.
To get the clients to update IE as soon as possible, I had everyone pull up the sites.xml file and refresh the page until the new version showed up. (v.5 for us)

Reversing or disabling Contained Databases in Microsoft SQL Server 2012

I'm no SQL MVP, so I'm not here to tell you the correct way to recover from a failed attempt at enabling SQL Server Contained Databases, but I will tell you about what I experienced.

I started by looking for a way to use this with AlwaysOn and my Infor Visual Manufacturing database on SQL 2012 Enterprise Edition (Required for AlwaysOn) so that my users would show up in the secondary database servers without having to copy their profiles from server to server using tools that export the Hash and SID, like sp_help_revlogin (Look into this! It works great and is a safer alternative).

Turns out that this was a bad idea.  I tested it in a lab and it worked fine, but I didn't test every function and I found that Info Visual Manufacturing ERP has a collation error in the Audit Maintenance window.  This was the error:

Android Play Store Privacy Statement

Privacy Policy Applications written by Ed Hammond do not collect information. I do not have access to any information on your phone and my apps do not send information to any other parties or sites. I do not use in-app purchasing features or ads. If Google or some government want more information that that, then I will just delete my app from the Play market. It's not worth the trouble since I make no money from "Beer Goggles" or "Auto Text message".

Ebates - Who doesn't like cash?

Image
If you look at my blog you will see that I really don't endource anything, and I really don't make any money on this blog either..
That being said, if I helped you in some way you can show your gratitude by signing up for ebates with my referal code:

http://www.ebates.com/rf.do?referrerid=vpPT%2BYiBUnQa9sVBzbenIw%3D%3D&eeid=28187

(You get $10 for signing up too, so better than free!)
I shop online all the time (Love ebay and Amazon) and it saves me lots of Money. Usually 1%, but sometimes up to 10%.  Free to sign up and easy to use.

Thanks for the support!


Solved: Moving Users to a SQL Contained database stops with an error

I decided to convert my ERP Database to a Contained Database so that I could have the logins move between servers with AlwaysOn on Microsoft SQL Server 2012.
https://msdn.microsoft.com/en-us/library/ff929071.aspx
SQL wouldn't let me convert the database while in use, so I had to make the change at night.

This is the script I used for migrating all the user accounts from the server to the DB:
----------------------------------------------------------------

DECLARE @username sysname;

DECLARE user_cursor CURSOR

FOR

SELECT dp.name

FROMsys.database_principalsAS dp

JOINsys.server_principalsAS sp

Add your Office 2016 KMS Keys to your Volume Activation Server

Image
It's that time again!  Time to add your Office 2016 KMS Keys to your Volume Activation Server!
Yes, I forgot how to do it too.. so here are my notes for doing it.

If you are missing the KMS keys from the MVLSC for office 2016 then you need to contact Microsoft at KMSADD@microsoft.com to get your MAK key converted to KMS.
If you want to call them, use this number: (866) 230-0560
Here is the format of my email to them:

------------  Start email Template  ------------
Hi,
I need KMS keys generated for Office 2016 please.

Here is my Office 2016 with SA License agreement:
License ID: XXX
Parent Program: XXX
------------  End email Template  ------------

When you add your Office 2016 KMS keys it will cover everything office including Visio and Project.

When you get your KMS keys, then you are ready to download the update from the Microsoft Volume Licensing Service Center (VLSC) that will allow you to activate the KMS on your Server.
Look for "Office Professional Plus 2016 Key Management Servi…