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.




Yep, dip question on initial setup SQL configuration but I give up.

web-app

I'm trying to install and configure the "free" 5 user license for evaluation. I don't really have a clue here but I've tried to follow the instructions and I'm now stuck.

I have SQL Server 2005/Enterprise Edition installed on a machine.

I crated a database of my own name (not the default Gemini)

I ran setup.  When I got to the db config information I got a connection OK dialog after changing the information to use

servername
instead of
servername\MSSQL1 which should have been the instance ID I thought but what do I know.

Install completed normaly.

Now, trying to connect to the admin page I get a Login Failed message and I can't for the life of me figure out what is up.  I checked the web.config file and the information placed there by setup looks "right" to me.

I'm obviously missing something very, very, simple here so would appreciate a pointer.

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

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.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

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:

[SqlException (0x80131904): Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +437
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
CounterSoft.Gemini.Commons.GeminiHelper.LogEx(Exception ex, String strOtherInfo) +104

[ADOException: cannot open connection]
CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xdd71a6c437ce97cd(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +469
CounterSoft.Gemini.DataProvider.x73a34067f4cd229a.xc5a6238415274e6d(Type x86c43ef36e14f2a3, Object[] xdbd7e0681bb13f72) +14
CounterSoft.Gemini.DataProvider.x99c4b1798e19cb2e.x1a95834709519378(String x2335cd6458013014) +89
CounterSoft.Gemini.Business.ApplicationSettings.GetGeminiConfiguration() +3259
CounterSoft.Gemini.Business.ApplicationSettings.get_Config() +74
CounterSoft.Gemini.Business.BasePage.OnPreInit(EventArgs e) +56
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +521

Thanks
Neil

NeilL
· 1
NeilL
Replies (1)
helpful
0
not helpful

It seems that you have setup Gemini to use windows authentication to connect to SQL. If you have a user name and password login for sql then please update the connection strings in the web.config file.

Otherwise you will have to allow access via SQL to the network service.


Saar Cohen
· 5000
Saar Cohen