Error creating new farm configuration database

Topics: General Questions, Support
Aug 8, 2014 at 9:43 AM
Hello gays,

I am trying to create a farm by AutoSPInstaller script, but it fail for New-SPConfigurationDatabase.
I check and try everything...
  • increase Start-Sleep before New-SPConfigurationDatabase comand to 120 (not successfull)
  • run New-SPConfigurationDatabase alone (without script) and farm was created successfully, but it fails on next command, which create other database (web application)
  • create farm by SPConfiguration Wizard - also created successfully
So the network connectivity is OK and Setup Acount has correct permissions.
But I need to create farm by script - Could you help me please?
Thant you a lot!

My server config.:
Server: OS 2012 R2
SQL: 2008 R2 with SP2
  • SQL Server version is: 10.50.4000.0
  • This instance of SQL Server is clustered
Script messages:
  • Attempting to join farm on "moss2013t_Config"...
  • No existing farm found.
  • Creating config database "moss2013t_Config"...
    New-SPConfigurationDatabase : Cannot connect to database master at SQL server at "SP2013T\SP2013T,1443". The database
    might not exist, or the current user does not have permission to connect to it.
    At C:\Install\SP\AutoSPInstaller\AutoSPInstallerFunctions.ps1:1647 char:13
  • New-SPConfigurationDatabase -DatabaseName "$configDB" -DatabaseServe ...
  • ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    • CategoryInfo : InvalidData: (Microsoft.Share...urationDatabase:SPCmdletNewSPConfigurationDatabase) [New
      -SPConfigurationDatabase], SPException
    • FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletNewSPConfigurationDatabase

  • Script halted!
  • Error creating new farm configuration database
SharePoint Log:
Provisioning the configuration database.
Provisioning the database moss2013t_Config on the server "SP2013T\SP2013T,1443" with the sql file ConfigurationDatabase.
Ensuring that the moss2013t_Config database exists . . .
Could not determine SQL engine edition
System.Data.SqlClient.SqlException (0x80131904): 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) ---> System.ComponentModel.Win32Exception (0x80004005): The parameter is incorrect at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SharePoint.Utilities.SqlSession.get_IsSqlAzure() ClientConnectionId:00000000-0000-0000-0000-000000000000
Aug 11, 2014 at 7:49 AM
It is SharePoint 2013 with SP1