Dynamics GP Web Service Install Error: The security ID structure is invalid (Exception from HRESULT: 0x80070539)

 

Goal 

You are installing GP Web Services and keep getting  an error that rolls back the install. You get an error saying: The security ID structure is invalid (Exception from HRESULT: 0x80070539). 

You need to fix the error and get it installed.  

Environment

SQL 2008 or later, Windows 2008 or later, GP Dynamics 2010 or 2013.

Issue

            The issue of all things is that there is a user in the model database that is not windows authentication based.

Resolution                                             

            Just Delete the user from the Database:
1) Goto Enterprise Manager
2) Drill down to the system databases and then the model database
3) Find the user that is not windows based (NOT THE dbo User!)
4) Delete the user from the database

Then restart the install process.
 

Conclusion 

Web Service Configuration for GP requires that the model database NOT have a user in it that is sql authentication based (login is sql not windows).