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.




GEMINI_ASPNETDB missing

web-app

I've installed Gemini 2.1, and used an existing and already upgraded 2.0 database.

Primarily Gemini is running and shows all projects, but if I try to access any issues I get database access errors, that GEMINI_ASPNETDB does not allow me to login. In fact, there is no such database elsewhere.

Please help,

Joerg

My System:
Windows 2003 Server WebEdition
SQL Server 2005 Express
IIS 6, ASP.NET 2.0

Error Stack Trace:
SOURCE: .Net SqlClient Data Provider TARGETSITE: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) STACKTRACE: at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc) at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties)

JoergKrause
· 1 		JoergKrause
Friday, March 30, 2007, 1:29:26 AM
Replies (5)
helpful
0
not helpful

You need to install the profile database.

The database should be created by you or you could use the existing Gemini database.

To install the profile run InstallCommon.sql and InstallProfile.sql on the database. After that you will have to amend the web.config file (ProfilesServer).
Saar Cohen
· 5000 		Saar Cohen
Friday, March 30, 2007, 10:54:54 AM
helpful
0
not helpful

Thanks a lot, this just does the trick...

However, I had to change the GEMINI_ASPNETDB string to the name of the Gemini database I run the scripts against. Probably this renaming has to be done by installer?

-joerg
JoergKrause
· 1 		JoergKrause
Friday, March 30, 2007, 5:03:15 PM
helpful
0
not helpful

Yes, the EXE installer should have done this for you. Did you specify the database name when installed?
Saar Cohen
· 5000 		Saar Cohen
Friday, March 30, 2007, 7:25:59 PM
helpful
0
not helpful 

<p>I am still getting "Cannot open database "GEMINI_ASPNETDB" requested by the login. The login failed. " (When I save an Issue)<br></p><p>I ran the scripts above on the Gemini database and changed all connection strings in web.config to point to Gemini</p><p>-&nbsp; MLynch<br></p><br><p><br></p><p><br></p><table class="webForm" id="_ctl0_Main_gridData" style="border-style: solid; border-width: 1px;" border="0" cellpadding="2" cellspacing="2" height="56" width="602"><tbody><tr class="background1" nowrap="nowrap" style="font-weight: bold;"><td><br></td><td><br></td><td><br></td></tr><tr><td valign="top"><br></td></tr></tbody></table>

MauriceLynch
· 1 		MauriceLynch
Friday, April 6, 2007, 12:23:15 PM
helpful
0
not helpful

Please make sure that you gave permissions to the SQL user to access the profile database.
Saar Cohen
· 5000 		Saar Cohen
Friday, April 6, 2007, 12:24:36 PM