Databases not getting created

Aug 1, 2007 at 4:09 PM
Edited Aug 1, 2007 at 4:12 PM
My installations are going through without any issues (All the three components), but when I try to access the connector admin home page I get an error. I realized that neither the ConnectorDB nor the PS2007ProviderDB are getting created. Here is the event log

NOTE: This is a two server configuration.

I can notice that this message says Login Failed - I checked again to make sure that the login is correct. Login is failing because the Database is not getting created.

I can manually login to the SQL Server and create DBs with the same Login.

I spent quite sometime on this and any help will be appreciated.

I manually created the DBs and installed the connector again (by selecting the relevant options), then it said stored procedure not found.
____________________________________________________________________________________
Timestamp: 8/1/2007 3:47:39 PM
Message: HandlingInstanceID: 7021c09f-b5f3-48d9-bc0c-dc5cb67a677d
An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.
----------------------------------------------------------------------------------
08/01/2007 21:17:39
Type : System.Data.SqlClient.SqlException, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
Message : Cannot open database "PS2007ProvidersDb" requested by the login. The login failed.
Login failed for user 'SILICUS\Administrator'.
Source : .Net SqlClient Data Provider
Help link :
Errors : System.Data.SqlClient.SqlErrorCollection
Class : 11
LineNumber : 65536
Number : 4060
Procedure :
Server : silpundb1\
State : 1
ErrorCode : -2146232060
Data : System.Collections.ListDictionaryInternal
TargetSite : Void OnError(System.Data.SqlClient.SqlException, Boolean)
Stack Trace : 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 Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection()
at Microsoft.Practices.EnterpriseLibrary.Data.Database.DiscoverParameters(DbCommand command)
at Microsoft.Practices.EnterpriseLibrary.Data.ParameterCache.SetParameters(DbCommand command, Database database)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.GetStoredProcCommand(String storedProcedureName, Object[] parameterValues)
at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteReader(String storedProcedureName, Object[] parameterValues)
at Microsoft.Vsts.Ranger.Connector.PS2007Providers.Data.ProjectAssociationsData.get_ProjectAssociations()
at Microsoft.Vsts.Ranger.Connector.WebServices.PS2007ProviderAdministration.ActiveProjectAssociations()

Additional Info:

MachineName : SILICUS15
TimeStamp : 8/1/2007 3:47:39 PM
FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=3.1.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
AppDomainName : /LM/W3SVC/3/Root/Connector Web Service-2-128304567106969918
ThreadIdentity : SILICUS\administrator
WindowsIdentity : SILICUS\administrator

Category: General
Priority: 0
EventId: 100
Severity: Error
Title:Enterprise Library Exception Handling
Machine: SILICUS15
Application Domain: /LM/W3SVC/3/Root/Connector Web Service-2-128304567106969918
Process Id: 1832
Process Name: c:\windows\system32\inetsrv\w3wp.exe
Win32 Thread Id: 2932
Thread Name:
Extended Properties: HelpLink.ProdName - Microsoft SQL Server
HelpLink.EvtSrc - MSSQLServer
HelpLink.EvtID - 4060
HelpLink.BaseHelpUrl - http://go.microsoft.com/fwlink
HelpLink.LinkId - 20476


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
__________________________________________________________________________________________________________________________

Regards
Ravindra
Coordinator
Aug 2, 2007 at 7:30 PM
Edited Aug 2, 2007 at 7:32 PM
Thanks for posting this Ravisat. We just posted a note about this on the upgrade steps page and included the database scripts there in case other folks run into this:

Thanks,
Graham