Sql Connection String Problems

web-app

I am having trouble connecting initially after installation. I have changed the nhibernate connection string to point to my Gemini database. I can log in with my sql user login fine via Sql Mgmt. Studio. However, I get the following error when I run the app (and after perusing the forums, I see other people have received this as well.)

Server Error in '/GeminiTest' Application.

        <h2> <i>Login failed for user 'sa'.</i> </h2></span>

        <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: Login failed for user 'sa'.<br><br>

        <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): Login failed for user 'sa'.]<br>   CounterSoft.GeminiLib.GeminiHelper.GetImageData(String sql) +280<br>   CounterSoft.GeminiLib.GeminiHelper.GetIssuePriorityImages() +11<br>   Gemini.PageUtil.FillCache(HttpContext c) +66<br>   Gemini.GeminiHttpModule.Init(HttpApplication application) +244<br>   System.Web.HttpApplication.InitModules() +267<br>   System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1251<br>   System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +243<br>   System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +106<br>   System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +214<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.42; ASP.NET Version:2.0.50727.42<br><br></font>What is really strange is that I am not using the sa accout.&nbsp; Why am I getting a message saying it is looking for the sa user?&nbsp; I am about to move to Bugzilla...<br><br>Shane<br>

shaned · 1
Thursday, September 21, 2006, 8:19:19 PM

Replies (6)

Did you restart the web app? What is your connection string?

Saar Cohen · 5000
Thursday, September 21, 2006, 9:36:06 PM

My connection string is:

Server=qssfflp15;Database=GeminiTest;uid=GeminiAdmin;pwd=otisotis;

And, yes, I did restart the web app. Is it doing any caching that may cause this problem in the business logic?

Shane

shaned · 1
Thursday, September 21, 2006, 11:09:50 PM

No, it's not caching it.

Seems odd. Try and run it under .NET 1.1 if you can.

Mark Wing · 9108
Friday, September 22, 2006, 10:54:19 AM

Not sure what was going on but I tried it again and the app is now running correctly. Looks good too! Must be the ghosts in my machine...

Shane

shaned · 1
Friday, September 29, 2006, 10:18:34 PM

have similar problem:

General network error. Check your network documentation.

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: General network error. Check your network documentation.

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: General network error.  Check your network documentation.]
   CounterSoft.GeminiLib.GeminiHelper.GetImageData(String sql) +307
   CounterSoft.GeminiLib.GeminiHelper.GetIssuePriorityImages() +11
   Gemini.PageUtil.FillCache(HttpContext c) +67
   Gemini.GeminiHttpModule.Init(HttpApplication application) +186
   System.Web.HttpApplication.InitModules() +100
   System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1330
   System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +392
   System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +256
   System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414

I did iisreset - did not helped

dovid · 1
Friday, October 13, 2006, 12:18:21 AM

Is this error permanent? What is your connection string?

Mark Wing · 9108
Friday, October 13, 2006, 10:29:57 AM

Gemini Community Support Site

Sql Connection String Problems

Server Error in '/GeminiTest' Application.

General network error. Check your network documentation.