Install Issues (SQL Server install)

[NVenhola]

I've been fighting with the installation for hours now. This is rediculous.

Here is the db.conf:

<?xml version="1.0"?>

<DbConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<ProviderName>sqlserver</ProviderName>

<ConnectionString>Server=localhost\MSSQLSERVER;User=sa;Password=password;DATABASE={0};</ConnectionString>

</DbConfig>

Here are the errors in the server log:

2012-10-05 15:32:48,074 (null) TGO\nvenhola at (null) INFO ChannelCall - recb: 545|rect: 0|sentb: 1496|sendt: 0|prt: 31|th: 3296|dest: 0|mt: 16|sert: 0|zip: 0| 10.2.10.166|CreateRepository

2012-10-05 15:32:48,098 (null) TGO\nvenhola at (null) INFO Channel - conn 0 An existing connection was forcibly closed by the remote host

2012-10-05 15:32:49,766 (null) TGO\nvenhola at (null) ERROR Codice.CM.Server.RepositoryHandler - A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

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 ant.b(String A_0)

at Codice.CM.Data.BaseDataManager.CreateRepositoriesData()

at Codice.CM.Server.RepositoryHandler.InitService()

The connection being closed worries me...

Please note:

• The sa account is fine
  
• The db server is fine
  
• Yes, remote connections are allowed
  
• The Plastic SCM service is running under an admin account
  

It's all local! This should be the easiest install ever! What is going on???

[manu]

Hi NVenHola,

the SQLServer error is clear, it's denying the incoming connections.

Try this db.conf:

<DbConfig>
 <ProviderName>sqlserver</ProviderName>
 <ConnectionString>SERVER=localhost;User Id=sa;Pwd=xxxxx;DATABASE={0};</ConnectionString>
 <DatabasePath></DatabasePath>
 <DatabasePrefix>_TestRead</DatabasePrefix>
</DbConfig>

Instead of using "localhost\MSSQLSERVER" just write "localhost".

[NVenhola]

Aha. Adding the Path and Prefix pieces cleared it up. Thank you.

[manu]

Sure, can you please post you final "db.conf" file? Just to show the rest of the people how it was configured...