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.




Problem with SQL 2000

web-app

Hi

I have seen similar issues to this one in the forum but I didnt see a resolution as yet. 

I am in the process of upgrading to 2.1.1 (from 2.0.1) 

I am using Widnows 2000 Server , SQL Server 2000

The problem I am getting is the followign error :

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

This occurs when I try to list the issue in any project.

NOTE: all other functionality seem to work - i.e. I can login to the front page, list the projects and view the error log.  All administration seems to work too.

Any Ideas ???

 

 
Hacth
· 1 		Hacth
Wednesday, August 29, 2007, 4:56:45 AM
Replies (4)
helpful
0
not helpful

Did you set the connection string for the profile database?
Mark Wing
· 9108 		Mark Wing
Wednesday, August 29, 2007, 10:09:56 AM
helpful
0
not helpful

Hi Mark

Thanks for your response.

I dont understand your question

what is the profile database and what do i need to point it to ?

I have set my gemini connection string
Hacth
· 1 		Hacth
Wednesday, August 29, 2007, 10:43:38 AM
helpful
0
not helpful

The profile database is an ASP.NET database that stores user info.

If you did not run the scripts you should do so (InstallCommon.sql and InstallProfile.sql). It can be run in the same database as Gemini.

After that amend the web.config and set profile connection string:

  <connectionStrings>
    <add name="ProfilesServer" connectionString="data source=YOUR SERVER NAME;initial catalog=DATABASE;user id=USER;password=PASSWORD" providerName="System.Data.SqlClient"/>
  </connectionStrings>
Mark Wing
· 9108 		Mark Wing
Wednesday, August 29, 2007, 12:21:05 PM
helpful
0
not helpful

Excellent

It appears that was exactly the problem... Thanks Mark!!!

 

 
Hacth
· 1 		Hacth
Monday, September 3, 2007, 2:53:02 AM