Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Database error creating issue

web-app

I recieved the following error when trying to create an issue:

==========================================

        <span><h1>Server Error in '/Gemini' Application.<hr color="silver" size="1" width="100%"></h1>

        <h2> <i>An

error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) 

        <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

        <b> Description: </b>An

unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

        <b> Exception Details: </b>System.Data.SqlClient.SqlException:

An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

        <b>Source Error:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code>

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

              </td>
           </tr>
        </tbody></table>

        <br>

        <b>Stack Trace:</b> <br><br>

        <table bgcolor="#ffffcc" width="100%">
           <tbody><tr>
              <td>
                  <code></code><pre>[SqlException (0x80131904): An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)]<br>   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437<br>   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82<br>   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105<br>   System.Data.SqlClient.SqlConnection.Open() +111<br>   System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84<br>   System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197<br>   System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) +782<br>   System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties) +428<br>   System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) +410<br>   System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) +117<br>   System.Configuration.SettingsBase.get_Item(String propertyName) +89<br>   System.Web.Profile.ProfileBase.GetInternal(String propertyName) +36<br>   System.Web.Profile.ProfileBase.get_Item(String propertyName) +68<br>   System.Web.Profile.ProfileBase.GetPropertyValue(String propertyName) +4<br>   CounterSoft.Gemini.Business.Profile.get_AfterIssueCreation() +62<br>   CounterSoft.Gemini.CreateIssue.btnCreate_Click(Object sender, EventArgs e) +137<br>   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105<br>   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107<br>   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7<br>   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11<br>   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33<br>   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5104<br></pre>

              </td>
           </tr>
        </tbody></table>

        <br>

        <hr color="silver" size="1" width="100%">

        <b>Version Information:</b>&nbsp;Microsoft .NET Framework Version:2.0.50727.1318; ASP.NET Version:2.0.50727.1318

        </font>

<!--

[SqlException]: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties) at System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider) at System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName) at System.Configuration.SettingsBase.getItem(String propertyName) at System.Web.Profile.ProfileBase.GetInternal(String propertyName) at System.Web.Profile.ProfileBase.getItem(String propertyName) at System.Web.Profile.ProfileBase.GetPropertyValue(String propertyName) at CounterSoft.Gemini.Business.BasePage.Profile.getAfterIssueCreation() at CounterSoft.Gemini.CreateIssue.btnCreateClick(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) [HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown. at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.issuecreateissueaspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) -->
Minear
· 1 		Minear
Thursday, May 17, 2007, 5:48:33 AM
Replies (11)
helpful
0
not helpful

Interesting... when I go to the project roadmap, the issue is there (however the reporter is set as John Smith... not me).  I cannot edit the reporter (I don't remember the dialogue asking me who reported the problem).

So the issue is acutally added to the database, what does the sql error refer to?

Thanks, Kenn
Minear
· 1 		Minear
Thursday, May 17, 2007, 6:33:16 AM
helpful
0
not helpful

Suspecting it might have something to do with my web config file, following is the contents:
==============================================================

<?xml version="1.0" encoding="utf-8"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
  <configSections>
    <sectionGroup name="GeminiPlugins">
      <section name="MailPlugin" type="System.Configuration.NameValueFileSectionHandler,System,Version=1.0.3300.0,Culture=neutral,PublicKeyToken=b77a5c561934e089"/>
    </sectionGroup>
    <section name="nhibernate" type="System.Configuration.NameValueSectionHandler, System, Version=1.0.5000.0,Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

    <sectionGroup name="GeminiLocalisation">
      <section name="GeminiLocalisation" type="CounterSoft.Gemini.Business.LocalisationConfigurationHandler, CounterSoft.Gemini.Business"/>
    </sectionGroup>
    <section name="microsoft.web.services3" type="Microsoft.Web.Services3.Configuration.WebServicesConfiguration, Microsoft.Web.Services3, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
  </configSections>
  <!-- **************-->
  <!-- **************-->
  <!-- Gemini application settings go here -->
  <!-- **************-->
  <!-- **************-->
  <GeminiPlugins>
    <MailPlugin>
      <!-- SMTPServer - specify IP number or machine name -->
      <add key="SMTPServer" value="127.0.0.1"/>
      <!-- SMTP authentication values: OFF, BASIC, NTLM. -->
      <add key="SMTPAuthentication" value="OFF"/>
      <add key="SMTPUserName" value=""/>
      <add key="SMTPPassword" value=""/>
      <!-- Global email alert type on/off settings -->
      <add key="IssueCreateAlert" value="true"/>
      <add key="IssueUpdateAlert" value="true"/>
      <add key="IssueCommentAlert" value="true"/>
      <add key="IssueStatusChangeAlert" value="true"/>
      <add key="IssueResolutionChangeAlert" value="true"/>
      <add key="IssueDeleteAlert" value="true"/>
      <add key="IssueAssignedAlert" value="true"/>
      <add key="IssueClosedAlert" value="true"/>
      <add key="IssueResolvedAlert" value="true"/>
      <add key="IssueWatcherAlert" value="true"/>
      <!-- Options -->
      <add key="FromEmailAddress" value="gemini@abc.com"/>
      <add key="Debug" value="false"/>
      <add key="SendAlerts" value="true"/>
      <!-- Email encoding values: ASCII, DEFAULT, UNICODE, UTF7, UTF8. -->
      <add key="Encoding" value="UTF8"/>
      <!-- TemplateEngine values: NVELOCITY, STRINGTEMPLATE -->
      <add key="TemplateEngine" value="NVELOCITY"/>
      <!-- TemplatesPath: Optional setting that can contain absolute path to "templates\mail" folder
                    - leave empty to let Gemini work it out
                    - or, specify full path , e.g. "c:\inetpub\wwwroot\gemini\templates\mail\"
            -->
      <add key="TemplatesPath" value=""/>
    </MailPlugin>
  </GeminiPlugins>
  <nhibernate>
      <!-- The SQL Server dialect (Gemini supports "MsSql2005Dialect" or "MsSql2000Dialect" or "MsSql7Dialect") -->
      <add key="hibernate.dialect" value="NHibernate.Dialect.MsSql2000Dialect"/>
      <!-- The SQL Server database connection string -->
      <add key="hibernate.connection.connectionstring" value="data source=KennWare\SqlExpress;initial catalog=GEMINI;TrustedConnection=true"/>
      <!-- Misc -->
      <add key="hibernate.connection.provider" value="NHibernate.Connection.DriverConnectionProvider"/>
      <add key="hibernate.connection.driverclass" value="NHibernate.Driver.SqlClientDriver"/>
  </nhibernate>
  <GeminiLocalisation>
    <GeminiLocalisation defaultCulture="en-GB" languageFilePath="Language"/>
  </GeminiLocalisation>
  <connectionStrings>
   <!-- <add name="ProfilesServer" connectionString="data source=KennWare\SqlExpress;initial catalog=GEMINIASPNETDB;Trusted_Connection=true" providerName="System.Data.SqlClient"/> -->
    <add name="ProfilesServer" connectionString="data source=127.0.0.1;"/>
  </connectionStrings>
  <system.web>
    <compilation defaultLanguage="c#" debug="false"/>

    <!--  CUSTOM ERROR MESSAGES
          Set customError mode values to control the display of user-friendly
          error messages to users instead of error details (including a stack trace):

          "On" Always display custom (friendly) messages 
          "Off" Always display detailed ASP.NET error information.
          "RemoteOnly" Display custom (friendly) messages only to users not running
          on the local Web server. This setting is recommended for security purposes, so
          that you do not display application detail information to remote clients.
    -->
<!--    <customErrors mode="On" defaultRedirect="Error.aspx"/> -->
    <customErrors mode="RemoteOnly" defaultRedirect="Error.aspx"/>

    <anonymousIdentification enabled="true" />
    <profile defaultProvider="SqlProvider">
      <providers>
        <clear />
        <add name="SqlProvider"
          type="System.Web.Profile.SqlProfileProvider"
          connectionStringName="ProfilesServer"
          applicationName="Gemini"
          description="SqlProfileProvider for Gemini" />
      </providers>

      <properties>
        <!-- How many issues to show on one page -->
        <add name="MaxIssuesPerPage" type="int" allowAnonymous="true" defaultValue="20" />
        <!-- The font size of the issue page -->
        <!-- XXS - XXSmall -->
        <!-- XS - XSmall -->
        <!-- SR - Smaller -->
        <!-- S - Small -->
        <!-- M - Medium -->
        <!-- L - Large -->
        <!-- LR - Larger -->
        <!-- XL - XLarge -->
        <!-- XXL - XXLarge -->
        <add name="IssuesFont" type="string" allowAnonymous="true"  defaultValue="SR" />
        <!-- Where to jump after creating issues -->
        <!-- I = View issue -->
        <!-- IL = Issues list -->
        <add name="AfterIssueCreation" type="string" allowAnonymous="true" defaultValue="I" />
        <!-- Where to jump after editing issues -->
        <!-- I = View issue -->
        <!-- IL = Issues list -->
        <add name="AfterIssueEdit" type="string" allowAnonymous="true" defaultValue="I" />
        <!-- Where to jump after switching project via the combo -->
        <!-- P = Project home -->
        <!-- IL = Issues list -->
        <add name="SwitchProjectPage" type="string" allowAnonymous="true" defaultValue="P" />
        <!-- Email format -->
        <!-- H = HTML -->
        <!-- T = Text -->
        <add name="EmailFormat" type="string" allowAnonymous="true" defaultValue="H" />
        <add name="ReceiveEmailAlerts" type="string" allowAnonymous="false" defaultValue="Y" />
        <add name="EmailMyChanges" type="string" allowAnonymous="false" defaultValue="Y" />
        <add name="Theme" type="string" allowAnonymous="false" />
        <add name="Language" type="string" allowAnonymous="false" />
        <add name="MyWorkSortProp" type="string" allowAnonymous="false" />
        <add name="MyWorkSortDir" type="int" allowAnonymous="false" />
      </properties>
    </profile>

    <!--  AUTHENTICATION  (Gemini possible modes are "Windows", "Forms") -->
    <authentication mode="Forms">
      <forms name="Gemini21" loginUrl="Default.aspx" timeout="60" path="/">
      </forms>
    </authentication>
    <authorization>
      <deny users="?"></deny>
    </authorization>
    <!--  APPLICATION-LEVEL TRACE LOGGING
          Application-level tracing enables trace log output for every page within an application.
          Set trace enabled="true" to enable application trace logging.  If pageOutput="true", the
          trace information will be displayed at the bottom of each page.  Otherwise, you can view the
          application trace log by browsing the "trace.axd" page from your web application
          root.
    -->
    <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>
    <!--  SESSION STATE SETTINGS
          By default ASP .NET uses cookies to identify which requests belong to a particular session.
          If cookies are not available, a session can be tracked by adding a session identifier to the URL.
          To disable cookies, set sessionState cookieless="true".
         
          InProc
          SQLServer (http://support.microsoft.com/default.aspx?kbid=317604)
          StateServer
    -->
    <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;user id=sa;password=sa" cookieless="false" timeout="60"/>
    <!--  GLOBALIZATION - This section sets the globalization settings of the application. -->
    <globalization culture="en-GB" uiCulture="en-GB" requestEncoding="utf-8" responseEncoding="utf-8"/>
    <!-- File Upload Settings -->
    <httpRuntime executionTimeout="90" maxRequestLength="44096" useFullyQualifiedRedirectUrl="false"/>
    <!-- The following blockers only come into affect if IIS is also configured
            http://support.microsoft.com/?kbid=815152
    -->
    <httpHandlers>
      <add type="System.Web.HttpForbiddenHandler" path=".xsl" verb=""/>
      <add type="System.Web.HttpForbiddenHandler" path=".vm" verb=""/>
      <add type="System.Web.HttpForbiddenHandler" path=".log" verb=""/>
      <add type="System.Web.HttpForbiddenHandler" path=".config" verb=""/>
      <add type="FreeTextBoxControls.AssemblyResourceHandler, FreeTextBox" path="FtbWebResource.axd" verb="GET"/>
    </httpHandlers>
    <httpModules>
      <add name="GeminiHttpModule" type="CounterSoft.Gemini.Business.GeminiHttpModule, CounterSoft.Gemini.Business"/>
    </httpModules>
    <!-- This allows HTML text to be entered into Gemini -->
    <pages validateRequest="true" enableSessionState="true" enableViewState="true" enableViewStateMac="true" enableEventValidation="false">
      <controls>
        <!-- User Controls -->
        <add tagPrefix="gem" src="~/controls/AdministrationMenu.ascx" tagName="AdministrationMenu"/>
        <add tagPrefix="gem" src="~/controls/NavBarBlank.ascx" tagName="NavBarBlank"/>
        <add tagPrefix="gem" src="~/controls/NavBarMain.ascx" tagName="NavBarMain"/>
        <add tagPrefix="gem" src="~/controls/NavBarProject.ascx" tagName="NavBarProject"/>
        <add tagPrefix="gem" src="~/controls/Gantt.ascx" tagName="Gantt"/>
        <add tagPrefix="gem" src="~/controls/LoginControl.ascx" tagName="LoginControl"/>
        <add tagPrefix="gem" src="~/controls/Footer.ascx" tagName="Footer"/>
        <add tagPrefix="gem" src="~/controls/HeaderBar.ascx" tagName="HeaderBar"/>
        <add tagPrefix="gem" src="~/controls/ExternalHeader.ascx" tagName="ExternalHeader"/>
        <add tagPrefix="gem" src="~/controls/Copyright.ascx" tagName="Copyright"/>
        <add tagPrefix="gem" src="~/project/ProjectHeader.ascx" tagName="ProjectHeader"/>
        <add tagPrefix="gem" src="~/controls/ProjectMenu.ascx" tagName="ProjectMenu"/>
        <add tagPrefix="gem" src="~/controls/RichText.ascx" tagName="RichTextBox"/>
        <add tagPrefix="gem" src="~/issue/customfields/CreateStage.ascx" tagName="CustomFieldCreate"/>
        <add tagPrefix="gem" src="~/issue/customfields/ViewStage.ascx" tagName="CustomFieldView"/>
        <add tagPrefix="gem" src="~/controls/DataPager.ascx" tagName="DataPager"/>
        <!-- Custom Controls -->
        <add tagPrefix="gem" namespace="CounterSoft.Gemini.Controls" assembly="CounterSoft.Gemini.Controls" />
        <add tagPrefix="gem2" namespace="CounterSoft.Web.UI" assembly="CounterSoft.Gemini.Controls" />
        <add tagPrefix="radG" namespace="Telerik.WebControls" assembly="RadGrid.Net2" />
        <add tagPrefix="radE" namespace="Telerik.WebControls" assembly="RadEditor.Net2" />
        <add tagPrefix="radA" namespace="Telerik.WebControls" assembly="RadAjax.Net2" />
        <add tagPrefix="radW" namespace="Telerik.WebControls" assembly="RadWindow.Net2" />
        <add tagPrefix="radSpl" namespace="Telerik.WebControls" assembly="RadSplitter.NET2" />
        <add tagPrefix="radP" namespace="Telerik.WebControls" assembly="RadPanelbar.Net2" />
        <add tagPrefix="radCln" namespace="Telerik.WebControls" assembly="RadCalendar.Net2" />
        <add tagPrefix="ftb" namespace="FreeTextBoxControls" assembly="FreeTextBox" />
        <add tagPrefix="dbwc" namespace="DBauer.Web.UI.WebControls" assembly="DBauer.Web.UI.WebControls.DynamicControlsPlaceholder" />
      </controls>
    </pages>
    <webServices>
      <soapExtensionTypes>
      </soapExtensionTypes>
      <soapServerProtocolFactory type="Microsoft.Web.Services3.WseProtocolFactory, Microsoft.Web.Services3, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
      <soapExtensionImporterTypes>
        <add type="Microsoft.Web.Services3.Description.WseExtensionImporter, Microsoft.Web.Services3, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"/>
      </soapExtensionImporterTypes>
    </webServices>
    <xhtmlConformance mode="Legacy"/>
  </system.web>
  <location path="user/Register.aspx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="user/ForgotPassword.aspx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="user/ResetPassword.aspx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="Installer/Default.aspx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="Error.aspx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="webservices/Gemini.asmx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="IssuesExcel.aspx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
   <location path="admin">
    <system.web>
      <authorization>
        <deny users="?"></deny>
      </authorization>
    </system.web>
  </location>
  <location path="webservices/LinkSourceControlFile.aspx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="issue/StopWatch.aspx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="security/SSO.aspx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="webservices/CustomFieldsWS.asmx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="webservices/VersionsWS.asmx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="webservices/ComponentsWS.asmx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="webservices/AuthWS.asmx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="webservices/GeminiLookUpsWS.asmx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="webservices/IssuesWS.asmx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="webservices/ProjectsWS.asmx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="webservices/GeminiWSE.asmx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="webservices/TimeTracking.asmx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <location path="utility/Refresher.aspx">
    <system.web>
      <authorization>
        <allow users=""></allow>
      </authorization>
    </system.web>
  </location>
  <microsoft.web.services3>
    <diagnostics/>
    <security>
      <securityTokenManager>
        <add type="CounterSoft.Gemini.Business.GeminiUsernameTokenManager, CounterSoft.Gemini.Business" namespace="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" localName="UsernameToken"/>
      </securityTokenManager>
    </security>
  </microsoft.web.services3>
</configuration>

==============================================================
Minear
· 1 		Minear
Thursday, May 17, 2007, 6:58:14 AM
helpful
0
not helpful

This error refers to the profile database (GEMINI_ASPNETDB in your case).

Please make sure that it has been created and that you have given SQL permissions on it to the user.
Mark Wing
· 9108 		Mark Wing
Thursday, May 17, 2007, 10:37:32 AM
helpful
0
not helpful

Alas,

I did what you suggested,  still get the same error.  Can't use the desktop app... invalid login.  Seems to work with project info... but I get this error on any solution info.

Ready to give up on your app and write my own (it just does not work).

Kenn
Minear
· 1 		Minear
Friday, May 18, 2007, 5:45:31 AM
helpful
0
not helpful

I did create the database GEMINI_ASPNETDB and granted dbo permissions on it.  Did not solve the problem.

I ran  the installcommon.sql and installprofile.sql scripts against it.
Minear
· 1 		Minear
Friday, May 18, 2007, 5:58:08 AM
helpful
0
not helpful

I did download and installed WSE 3.0, it didn't seem to make any diffrence, I still get an invalid signon error when using the desktop app.
Minear
· 1 		Minear
Friday, May 18, 2007, 6:09:25 AM
helpful
0
not helpful

Please run the app with the -dc switch: CounterSoft.Gemini.Desktop.exe -dc.

This will give the details of the exception.

 
Mark Wing
· 9108 		Mark Wing
Friday, May 18, 2007, 10:25:44 AM
helpful
0
not helpful

Ran with the -dc switch, got the following error:

WSE594:  Initialize Security Context call failed with the following error message: A specified logon session does not exits.  It may already have been terminated.

Thanks for your help.

Kenn
Minear
· 1 		Minear
Friday, May 18, 2007, 11:00:21 AM
helpful
0
not helpful

Can you please try it not using Windows authentication?
Mark Wing
· 9108 		Mark Wing
Friday, May 18, 2007, 12:47:52 PM
helpful
0
not helpful

Mark,

Very good.  Used admin/admin and it worked,.  Was able to add an issue also (something I can't do with the web version).

Thanks for your help.

Kenn
Minear
· 1 		Minear
Friday, May 18, 2007, 1:19:56 PM
helpful
0
not helpful

FYI

This is a setting within SQL2005. It is part of the new security. If you are using the Express version, you will need to install the admin tools found at Microsoft's site. If I remember correctly, you can open the admin console and right click on the properties of the SQL Server and somewhere in there is a allow remote connections.

 

If you need more help, let me know and I will find it exactly.
ecold
· 1 		ecold
Wednesday, May 23, 2007, 5:40:53 PM