This section contains technical notes and tips for troubleshooting the Signature Product Registration Application.Any procedures covered in this section should be performed ONLY by authorized technical personnel, such as IT or WennSoft Consulting./*<![CDATA[*/ div.rbtoc1766181255080 {padding: 0px;} div.rbtoc1766181255080 ul {list-style: disc;margin-left: 0px;} div.rbtoc1766181255080 li {margin-left: 0px;padding-left: 0px;} /*]]>*/ Technical notes About registration key tables About WS SQL database users Troubleshooting Viewing errors in the Web Service Event Viewer Is the SignatureRegistration web service installed and working correctly? Are the registration keys registered? Does the web service location match IIS? Technical notesAbout registration key tablesThe Signature Product Registration Application creates two tables in the system database.WSRegKeyCreated when the product is registered (using the Registration Key Setup application).WSRegistrationSettingsCreated upon initial installation and contains the location of the WSRegistration web service.About WS SQL database usersSignature uses three SQL database users in a system capacity for Service Management and Job Cost.WSRegUser$DynamicsCreated when enabling the registration keys. For more information, see Enable Signature Registration Keys.WSMPUser$DynamicsCreated by Signature during the software installation. This SQL user is used internally for MapPoint integration.WSMiscUser$DynamicsCreated by Signature during the software installation. This SQL user is used internally for document attachments to the SQL database.TroubleshootingViewing errors in the Web Service Event ViewerAny errors relating to the Signature Product Registration Web Service appear in the Internet Information Services (IIS) Event Viewer. To access the Event Viewer.Choose Start > Control Panel > Administrative Tools > Event Viewer.Choose Signature.Is the SignatureRegistration web service installed and working correctly?After installing and enabling the registration key application, if you receive any errors relating to web services when logging into Microsoft Dynamics GP, follow the steps below to troubleshoot the problem.Choose Start > Control Panel > Administrative Tools > Internet Information Services (IIS).Expand the server, then Web Sites, then Default Web Site.Locate the virtual directory called SignatureRegistration, as shown below. Right-click SignatureRegistration and choose Properties.Select the Virtual Directory tab, then choose Configuration.Under Application Mappings, you should see 30 or more .DLL files listed, most referencing the string "2.0.50727." If there are several fewer than this, you need to run the following command from a DOS window:Choose Start > Run, then type "cmd" and choose Open to open a DOS command window.Use the "cd" command to switch to the following folder: C:\windows\microsoft.net\framework\v2.0.50727Run the "aspnet_regiis -i" command.When finished, open IIS again and verify that the additional .DLL files are present with the correct .NET version.Are the registration keys registered?To verify that registration keys are registered, you can query the WSRegKey table:SuiteIDThe suite the key belongs to. There can be many records in this table, but only one per SuiteId.EncryptedKeyThe actual key that gets decrypted.Modified UserThe user who is logged in when registering the key.Modified DateThe system date when the key gets registered.Does the web service location match IIS?To verify that these match, query the WSRegistrationSettings table in the system database to see the value stored in that table, for example,JASONE/WSRegistrationNext, go back into IIS and make sure the WSRegistration web service appears under the correct location (in our example, JASONE).