Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: Target Principle Name Is Incorrect

Microsoft Dynamics GPAs errors with a scale-out deployment of the Microsoft Dynamics GP 2013 Web Client go, the one covered in this post is not one that you are likely to encounter.

When I tried logging into the web client I received an unexpected error and went to the Windows Event Viewer on the Session Central for more details:

Event Viewer

Show/Hide Error Message

System.Data.SqlClient.SqlException (0x80131904): The target principal name is incorrect. Cannot generate SSPI context.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TdsLogin(SqlLogin rec)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user)
at System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe()
at System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode()
at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
at System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable.GetEnumerator()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Microsoft.Dynamics.GP.Web.Services.Session.Service.SessionCentralBaseHandler.GetServiceSecurityGroups(String serviceName, ILinqDataContextProvider dataContext)
at Microsoft.Dynamics.GP.Web.Services.Session.Service.SessionCentralDatabaseHandler.GetServiceSecurityGroups(String serviceName)
at Microsoft.Dynamics.GP.Web.Services.Session.Service.SessionCentralService.InitializePrincipalManager()
ClientConnectionId:52267e4f-774d-452b-9361-00a407058a3a

Continue reading “Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: Target Principle Name Is Incorrect”

Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: Could Not Establish Trust Relationship

Microsoft Dynamics GPIf you do a scale-out deployment of the Microsoft Dynamics GP 2013 Web Client you may encounter trust relationship problems if you do not have the SSL certificates correctly installed:

Event Viewer

Show/Hide Error Message

An error occurred during session monitoring 'System.ServiceModel.Security.SecurityNegotiationException: Could not establish trust relationship for the SSL/TLS secure channel with authority 'sc1.domain.azurecurve.co.uk:48650'. ---> System.Net.WebException: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. ---> System.Security.AuthenticationException: The remote certificate is invalid according to the validation procedure.

Continue reading “Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: Could Not Establish Trust Relationship”

Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: No Endpoint Listening

Microsoft Dynamics GPWhile installing the scale-out deployment of the Microsoft Dynamics GP 2013 Web Client, I encountered an error which took me a lot longer than I liked to resolve:

IE - Unexpected error

Show/Hide Error Message

There was no endpoint listening at https://sc1.domain.azurecurve.co.uk:48650/SessioNCentralService that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---? Syste.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not propoerly respond after a period of time, or established connection failed because connected host has failed to respond: 198.252.71.316:48650

Continue reading “Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: No Endpoint Listening”

Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: Unauthorized attempt to call the GetSessionHostWithMostAvailability Operation On Session Central

Microsoft Dynamics GPI recently completed a series of posts on a scale-out deployment the Microsoft Dynamics GP 2013 Web Client; during the course of writing that series I encountered a few problems, which I thought it might be useful to post.

This first post takes a look at an error I received after installation. When I tried to log into the Web Client I received the below error message:

IE - Unexpected error

Show/Hide Error Message

Unexpected Error
An unexpected error has occurred. Press the Sign-in button to reconnect to the application.
Correlation ID: 66a9ddaa-4288-4535-affb-2a3ec0b072d3

Continue reading “Troubleshooting The Microsoft Dynamics GP 2013 SP2 Web Client: Unauthorized attempt to call the GetSessionHostWithMostAvailability Operation On Session Central”

2,000th Book Published; Join Packt In Their Celebration With A “Buy One, Get One Free” Offer

Microsoft Dynamics GPPackt Publishing celebrates their 2000th title with an exclusive offer – We’ve got IT covered!

Known for their extensive range of pragmatic IT ebooks, Packt Publishing are celebrating their 2000th book title ‘Learning Dart’ and they want their customers to celebrate too.

To mark this milestone Packt Publishing has launched a ‘Buy One Get One Free’ offer across all eBooks until 26th March.

2,000th Book Published; Join Packt In Their Celebration With A "Buy One, Get One Free" Offer

Packt is one of the most prolific and fast-growing tech book publishers in the world. Originally focused on open source software, Packt contributes back into the community paying a royalty on relevant books directly to open source projects. These projects have received over $400,000 as part of Packt’s Open Source Royalty Scheme to date.

Their books focus on practicality, recognising that readers are ultimately concerned with getting the job done. Packt’s digitally-focused business model allows them to quickly publish up-to-date books in very specific areas across a range of key categories — web development, game development, big data, application development, and more. Their commitment to providing a comprehensive range of titles has seen Packt publish 1054% more titles in 2013 than in 2006.

Click the banner above or this link to browse Packt’s collection of books and take advantage of this buy on, get one free offer.

Don’t forget there are a number of Microsoft Dynamics GP books available including my own book Microsoft Dynamics GP 2013 Financial Management and the Microsoft Dynamics GP 2013 Cookbook co-authored with Mark Polino.

MS Connect Suggestion: Add Voided Column To SOP Transaction Excel Report

Microsoft Dynamics GPBelinda Allen has a suggestion on MS Connect which she would like our votes for.

The suggestion is as follows:

If the Excel Refreshable Report for SOP Line Items is used, it includes voids. The Data Connection properties have to be edited to exclude voids, rendering this refreshable report useless; unless you are not keeping voided transactions in History. I would like a column for voids added. Pretty much line item detail Excel Refreshable Reports will need this.

This would be a very useful feature to have and I would encourage you to go to MS Connect and vote.

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Series Index

Microsoft Dynamics GPI’ve been working on a series of posts on a Microsoft DynamicsGP 2013 web client scale-out deployment and it has turned out to be a very long series of posts.

Each post has contained an index at the bottom, but I thought it might be useful to follow up the series with a special Index post Continue reading “Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Series Index”

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Using The Web Management Console

Microsoft Dynamics GPAlong with the web client which gives access to the normal functionality of Microsoft Dynamics GP there is also a Web Management Console which can be used by administrators to manage the web client.

The Web Management Console is accessed via the web browser by replacing the GP part of the address wit WebManagementConsole and logging in with a Domain Account which is part of the Domain Group assigned to the Web Management Console:

Windows Security

Continue reading “Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Using The Web Management Console”

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Navigation Differences Between Desktop & Web Clients

Microsoft Dynamics GPThe Microsoft Dynamics GP Web Client is very similar in form and function to the desktop client, but there are some differences between the two.

The first of the differences is with the menu bar. The first image below shows the menu bar in the desktop client; the second shows that of the web client. As you can see the main difference is in the absence of the drop down menus from the web client:

Web Client Menu BarDesktop Client Menu Bar

Continue reading “Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Navigation Differences Between Desktop & Web Clients”

Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Verifying The Web Client Install

Microsoft Dynamics GPWith all components of the web client installed and configured, it’s time to verify that the web client is actually working correctly.

The way of doing this is quite simple; log in and check if data can be loaded, updated and saved. Open Internet Explorer and navigate to the log in page; enter your Domain user name and password:

Microsoft Dynamics GP Web Client - Sign In

Continue reading “Microsoft Dynamics GP 2013 SP2 Web Client Scale-Out Deployment: Verifying The Web Client Install”