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.




Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

web-app

Hello,

I have installed Gemini2.2.6 (automated installation) recently.
Machine configuration:    Win2003 standard (32-bit).
Server:                           SQL-2005
.NET Framework:          2.0

NOTE:
- When I installed Gemini, I was logged into this win-2003 box as administrator.
- I didnt add any user-id/password to the connection-string.
- Since the site-security is @medium-risk, I un-commented the relevant line in the web.config
- I was running into 'no permissions to access Temporary ASP.NET files' earlier, so I added 'Network Service' to the list of permissible-user and inherited the permissions (Security/Advance).
- I looked through FAQs and some of the community-forums, but didn't find much help.

Problem:
1. When I try to view the page (http://localhost/Gemini), I run into the error pertaining to Network Service not able to log-into the DB.
2. How do I control the user-id that Gemini runs with (assuming that Gemini will use the same credential to connect to DB and/or access other resources in the network)?
3. Does 'Anonymous' user-id plays any importance?

Below is the screen-shot of the error I am seeing:

Server Error in '/Gemini' Application.

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) +161
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.getConfig() +74
CounterSoft.Gemini.Default.Page
Load(Object sender, EventArgs e) +276
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

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

Any help/guidance on this will be highly appreciated. Needless to say that this is my first interaction with Gemini and I am not .NET savvy.

Please advice.
Thanks.

was
· 1
was
Replies (4)
helpful
0
not helpful

This is the user which IIS uses to run the website. You can configure it via IIS (security tab).

The Gemini anonymous user is nothing to do with this.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Mark, thanks for the response.

- Do you know as to how to resolve this error-message that I am seeing?
- Also, I have set-up authentication-model in SQL-2005 as 'windows-based authentication' (as opposed to SQL-server based auth.). Would this cause the existing problem?


Thanks.


was
· 1
was
helpful
0
not helpful

Ok, I got it to work.

Basically I did 3 things as my sql-2005 is set to allow 'windows-based auth':
- created a user account on the server (win-2003) and made sure that it had access to sql-server residing on this server.
- in the web.config, switched authentication mode to 'windows' (from 'Forms') and then added an identity-impersonation statement. The user-id/password used here was the one I created in step-1 above.

Thanks.


was
· 1
was
helpful
0
not helpful

The easiest way to solve this is to set SQL to use SQL authentication (user name / password) and amend the connction string accordingly.

Otherwise, you will have to use inetmgr.exe and amend the user which runs the site.


Saar Cohen
· 5000
Saar Cohen