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.




SQL Server does not exist or access denied.

web-app

Installed manually on a Windows 2000 Server box and pointing to SQL Server 2000 sp4 on another machine.  I've updated web.config to change the connection string, and with that connection string I can connect through query analyzer.  However I'm getting the following error through the web, is there any way to do additional diagnostics?    

Server Error in '/' Application.

SQL Server does not exist or access denied.

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: SQL Server does not exist or access denied.

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: SQL Server does not exist or access denied.]
   CounterSoft.GeminiLib.GeminiHelper.GetImageData(String sql) +307
   CounterSoft.GeminiLib.GeminiHelper.GetIssuePriorityImages() +11
   Gemini.PageUtil.FillCache(HttpContext c) +1213
   Gemini.PageUtil.GetCachedItem(HttpContext c, String key) +105
   Gemini.LogoHeader.Page_Load(Object sender, EventArgs e) +555
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Control.LoadRecursive() +98
   System.Web.UI.Control.LoadRecursive() +98
   System.Web.UI.Page.ProcessRequestMain() +731

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

jeffrey.schoolcraft
· 1 		jeffrey.schoolcraft
Friday, February 10, 2006, 12:57:11 PM
Replies (12)
helpful
0
not helpful

Please share with us your connection string (not including the password).

Are you running a named instance of SQL?

Are you using the default SQL port (1433)?
Harvey Kandola
· 212 		Harvey Kandola
Saturday, February 11, 2006, 4:54:45 PM
helpful
0
not helpful

<!-- The SQL Server database connection string -->
  <add key="hibernate.connection.connection_string" value="data source=sl0979;initial catalog=devbugsGemini;user id=bugUser;password=PASSWORD" />   Will Gemini only work on (local)?
jeffrey.schoolcraft
· 1 		jeffrey.schoolcraft
Monday, February 13, 2006, 12:26:12 PM
helpful
0
not helpful

Gemini does not have to be on the local SQL server box.

Can your web server (where Gemini is installed) connect to the SQL server using the connection details supplied to Gemini?
Mark Wing
· 9108 		Mark Wing
Tuesday, February 14, 2006, 9:17:23 AM
helpful
0
not helpful

Yes, the web server where Gemini is installed can connect to SQL server using the connection details supplied to Gemini through web config.  
C:\>osql -S sl0979 -d devbugsGemini -U bugUser -P PASSWORD -Q "select top 1 issue
Id from issues"
 issueId
 ------------
            1   (1 row affected)   C:\>
jeffrey.schoolcraft
· 1 		jeffrey.schoolcraft
Tuesday, February 14, 2006, 12:41:28 PM
helpful
0
not helpful

What if you try a Trusted connection?

Does it work?
Harvey Kandola
· 212 		Harvey Kandola
Tuesday, February 14, 2006, 8:55:36 PM
helpful
0
not helpful

No, trusted connections aren't working.  I added the machine to logins and granted access, I haven't tried impersonation yet.  I've got Gemini installed on my local machine and it is using named logins in the connection string and works fine.    
jeffrey.schoolcraft
· 1 		jeffrey.schoolcraft
Wednesday, February 15, 2006, 11:51:19 AM
helpful
0
not helpful

My version information:  

C:\>osql -S sl0979 -U bugUser -P PASSWORD -q "select @@version"

-----
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copy
right (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 2)

(1 row affected)
jeffrey.schoolcraft
· 1 		jeffrey.schoolcraft
Wednesday, February 15, 2006, 11:56:12 AM
helpful
0
not helpful

Jeffrey,

Did you run OSQL from your web server?

Also, please confirm if you connected from web server to database server using Query Analyser.
Harvey Kandola
· 212 		Harvey Kandola
Thursday, February 16, 2006, 9:27:31 PM
helpful
0
not helpful

Yes I was running the OSQL command from the web server where Gemini is installed.   I connected to the database from the web server using FoxySQLFree as I didn't have QA installed on that box.
jeffrey.schoolcraft
· 1 		jeffrey.schoolcraft
Friday, February 17, 2006, 11:31:49 AM
helpful
0
not helpful

I have the same issue.  My database used to be on the same server as the web site.  I migrated the data over to another server.  When the data was on the same server everything worked correctly, but after moving I get the exact same error you do.  I've tried many different ways of connecting but cannot.  I tried conneted by command line, and got the same results as you did.

It's been a almost a month since the last reply in this thread, I'm just wondering if you resolved this issue?
evulfun
· 1 		evulfun
Friday, March 10, 2006, 5:34:49 PM
helpful
0
not helpful

I ended up installing sql server on this machine and ran the database locally, everything worked fine.   As far as I know there is no resolution to this issue, that being have the database seperate from your web server.
jeffrey.schoolcraft
· 1 		jeffrey.schoolcraft
Friday, March 10, 2006, 6:40:53 PM
helpful
0
not helpful

Thanks for the reply.  I'll set this all on one machine again.
evulfun
· 1 		evulfun
Friday, March 10, 2006, 7:59:50 PM