Results of further research have almost provided a solution but a new problem has appeared as a result (perhaps a new thread).
First a solution (of sorts).
Based on the suggestion in the above KB article, I decided to delve a bit further into the issue of setting up SQLServer-based session-state management in a shared hosting environment (specifically a shared SQLServer environment). After much querying of the almighty Google, I found the following posting which directly addressed the issue of not being able to use aspnet_regiis.exe to set up the session-state db due to permission issues related to the setting up of "Jobs" on a shared SQLServer instance. See particularly the section titled "Installing Session State with SQLServer mode on shared web hosting" at this URL.
http://www.beansoftware....Session-SQL-Server.aspx
IT IS IMPORTANT TO NOTE that the above link does not provide complete instruction for editing the SQL script generated in the solution. You don't just need to remove sections related to setting up Jobs but any other calls to the "Master" database as well. Once modified, the script in this solution generated the necessary database object for managing session state on a shared SQL server. All that was required in this case was to set up a CRON job (which my hosting company makes easy to do) to run the clean-up procedures on a regular basis and everything is hunky-dory except...
Now when accessing the gallery after authentication, I get the following error (it should be noted that the gallery works fine when I'm not logged in).
Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session state objects, and as a result non-serializable objects or MarshalByRef objects are not permitted. The same restriction applies if similar serialization is done by the custom session state store in 'Custom' mode.
Stack Trace:
[SerializationException: Type 'GalleryServerPro.Web.Entity.ProfileEntity' in Assembly 'GalleryServerPro.Web, Version=2.3.3848.40189, Culture=neutral, PublicKeyToken=null' is not marked as serializable.]
System.Runtime.Serialization.FormatterServices.InternalGetSerializableMembers(RuntimeType type) +7733643
System.Runtime.Serialization.FormatterServices.GetSerializableMembers(Type type, StreamingContext context) +258
System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitMemberInfo() +111
System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.InitSerialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter) +161
System.Runtime.Serialization.Formatters.Binary.WriteObjectInfo.Serialize(Object obj, ISurrogateSelector surrogateSelector, StreamingContext context, SerObjectInfoInit serObjectInfoInit, IFormatterConverter converter, ObjectWriter objectWriter) +51
System.Runtime.Serialization.Formatters.Binary.ObjectWriter.Serialize(Object graph, Header[] inHeaders, __BinaryWriter serWriter, Boolean fCheck) +410
System.Runtime.Serialization.Formatters.Binary.BinaryFormatter.Serialize(Stream serializationStream, Object graph, Header[] headers, Boolean fCheck) +134
System.Web.Util.AltSerialization.WriteValueToStream(Object value, BinaryWriter writer) +1577
[HttpException (0x80004005): Unable to serialize the session state. In 'StateServer' and 'SQLServer' mode, ASP.NET will serialize the session state objects, and as a result non-serializable objects or MarshalByRef objects are not permitted. The same restriction applies if similar serialization is done by the custom session state store in 'Custom' mode.]
System.Web.Util.AltSerialization.WriteValueToStream(Object value, BinaryWriter writer) +1662
System.Web.SessionState.SessionStateItemCollection.WriteValueToStreamWithAssert(Object value, BinaryWriter writer) +34
System.Web.SessionState.SessionStateItemCollection.Serialize(BinaryWriter writer) +606
System.Web.SessionState.SessionStateUtility.Serialize(SessionStateStoreData item, Stream stream) +239
System.Web.SessionState.SessionStateUtility.SerializeStoreData(SessionStateStoreData item, Int32 initialStreamSize, Byte[]& buf, Int32& length) +72
System.Web.SessionState.SqlSessionStateStore.SetAndReleaseItemExclusive(HttpContext context, String id, SessionStateStoreData item, Object lockId, Boolean newItem) +116
System.Web.SessionState.SessionStateModule.OnReleaseState(Object source, EventArgs eventArgs) +560
System.Web.SessionState.SessionStateModule.OnEndRequest(Object source, EventArgs eventArgs) +160
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75