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.




gemini and SQL 2000 problem (Could not open a connection to SQL Server)

web-app

Hi,

I got a problem with Gemini installation. It is running on SQL 2000 server, this server has enabled remote connections and so on. But I got following error. I am little confused as I am on 2000 not 2005.

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)

thanks for your help!

m.

mnq
· 1
mnq
Replies (6)
helpful
0
not helpful

Are you running under a named instance? Did you change the web.config's connection string?


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Yes connection string is changed into correct one. All details are correct.
Maybe this issue can be coz this database was first SQL 2005 and then it was converted into 2000 and restored on this SQL 2000 server? Or this doesn't matter?

thx!


mnq
· 1
mnq
helpful
0
not helpful

This should not make a difference, although you should amend the NHibernate dialect to SQL 2000.

Did you change the connection string in the web.config file? Can you try and connect from the web server to the database?


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Yes I can connect to database with connection string and no errors.
So connection between server and MSSQL server is existing.
I didn't convert this database, I was just restoring it into SQL 2000. So maybe wrong coversion is the problem here?


mnq
· 1
mnq
helpful
0
not helpful

Oh I got new error now, what it can be:

Specified cast is not valid.

Description: 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.

Exception Details: System.InvalidCastException: Specified cast is not valid.

Source Error:

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.
Stack Trace:

[InvalidCastException: Specified cast is not valid.]
CounterSoft.Gemini.Business.ApplicationSettings.GetGeminiConfiguration() +1071
CounterSoft.Gemini.Business.ApplicationSettings.getConfig() +74
CounterSoft.Gemini.Default.Page
Load(Object sender, EventArgs e) +328
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061


mnq
· 1
mnq
helpful
0
not helpful

Seems like an issue with your geminiappsettings table contents.

Please check against the install / upgrade scripts.


Mark Wing
· 9108
Mark Wing