Did you update the connection string setting in the web.config file?

I'm having a similar problem.  I've updated the connection string in web.config and I can connect through query analyzer and like tools to the database in question.  I'm getting the same error message (is there a way to get more diagnostic information?):    

Server Error in '/' Application.

SQL Server does not exist or access denied.

[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.Global.Application_Start(Object sender, EventArgs e) +12

Hi,

Are you using named instances of SQL?

Are you using a non standard port number (not 1433)?

Please paste your web.config connection string setting eher and we will look at it.

<!-- 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)?

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?

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:\>

What if you try a Trusted connection?

instead of duplicating this in two threads like I have been doing, lets just stick with my original: http://community.countersoft.com/forums/thread/351.aspx

Was there ever a resolution to this problem?  We are a brand new install and we are seeing the exact same problem.  Except our error is "Login failed for user".  How do you diagnose this problem?  The other isue is that it is not passing the correct username.  It is passing the machine name rather than the username.f

Please check your connection string in the web.config file.

Hi Saar

I have a question regarding Windows authentication. The application is  not working and the following error was displayed:

Server Error in '/TicketSystem' Application

Login failed for user 'BRENCOURT\NYIISQA$'

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 'BRENCOURT\NYIISQA$'.

The connection string is "Data Source=WORKSTATION71;Initial Catalog=TicketSystem;Integrated Security=True"

Ticket System is the name of my virtual directory. SQL Server is on the remote machine.

I have set impersonate = true in the web.config file.

I would appreciate your help in this regard. Also, I am not sure how to create a user before turning on the windows authentication.

Thanks

Meg

I think you are confusing SQL authentication and Web windows authentication.

Do you want to connect to SQL using a single user name / id?

At the moment, as you have it setup, every user will have to be given permissions on SQL server.

To create a Gemini user before moving to windows authentication in Gemini, the user name must be DOMAIN\User