locked
SharePoint Wizard and Technology Configuration RRS feed

  • Question

  • I cannot complete running the sharepoint Technologies and Configuration wizard. After I enter the database name in specify configuration database setting, also set the user name and password error: An exception of type System.Data.SqlClient.SqlException was thrown.  Additional exception information: Login failed for user 'DEVWIN\IntranetAdmin'.
    System.Data.SqlClient.SqlException: Login failed for user 'DEVWIN\IntranetAdmin'.
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
       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.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
       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.SharePoint.PostSetupConfiguration.SqlSession.OpenConnection()
       at Microsoft.SharePoint.PostSetupConfiguration.SqlSession.ExecuteNonQuery(SqlCommand command)
       at Microsoft.SharePoint.PostSetupConfiguration.SqlServerHelper.DatabaseExists(String database)
       at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureDatabase(Parameter parameterDatabase)
    Thursday, February 10, 2011 9:03 PM

Answers

  • I think you would be better off requesting a domain account as opposed to a local admin account on the SharePoint server. Make sure this domain account is a part of the local admin group on both SQL as well as SharePoint servers.

    Looking at the event viewer message, it looks like you alias is not able to find the instance. Can you confirm the SQL browser service is running on the SQL server? Also, is this the default instance of SQL server or a named instance and which port is this running on?

    • Marked as answer by David HM Friday, February 18, 2011 2:42 AM
    Thursday, February 17, 2011 4:48 PM
  • Looks like a rights issue. What are the user rights for the account with which you are running the setup? This account should have atleast DB creator and Security admin rights on SQL and should be local admin on the SharePoint boxes.
    • Marked as answer by David HM Friday, February 18, 2011 2:42 AM
    Thursday, February 10, 2011 9:11 PM

All replies

  • Looks like a rights issue. What are the user rights for the account with which you are running the setup? This account should have atleast DB creator and Security admin rights on SQL and should be local admin on the SharePoint boxes.
    • Marked as answer by David HM Friday, February 18, 2011 2:42 AM
    Thursday, February 10, 2011 9:11 PM
  • > I cannot complete running the sharepoint Technologies and Configuration wizard

    Which SharePoint product are you installing ?

    Moderator pre-2010 forums


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Thursday, February 10, 2011 9:18 PM
  • I am banging my head and this is day 3. I have a domain account called IntranetAdmin, I have used that account to log into the windows server and launch the configuration wizard. I have also created a local admin account on that sharepoint server named IntranetAdmin. In the database server name I defined as MSSQLSERVER which was defined in the sql server configuration manager. Username is defined as devwin\IntranetAdmin and password. I have also created a sql account IntranetAdmin and I have granted all security priviledges. Please advice me, I am also new bee to sharepoint and have never done a small farm install.

    • Edited by Mike Walsh FIN Friday, February 11, 2011 2:52 PM NEVER write things like Thanks in advance for all your help on Friday that put time pressure on forum members. If you are in a hurry pay for support by ringing MS Customer Support services
    Friday, February 11, 2011 2:43 PM
  • I am using sharepoint 2007 and trying to do a small farm install.
    Friday, February 11, 2011 2:44 PM
  • There are two main "sharepoint 2007" products.

    Are you installing WSS 3.0 or MOSS 2007?

    You get quicker answers if you are exact in the information you provide.

    Moderator

    (also note my Edit comment to your earlier post)


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Friday, February 11, 2011 2:53 PM
  • I am installing MOSS 2007. Apologies for my comment this is more frustration rather than anything.
    Friday, February 11, 2011 3:07 PM
  • You need to make sure you use only the domain account throughout. From what I understand, you have created a local admin account using the same name and a SQL account as well. You need to grant rights to Domain\IntranetAdmin in the database and add the same account to the local admin group on the server.
    Friday, February 11, 2011 9:47 PM
  • In response to your suggestion do I have to use the same domain account to login to the server as well as connect to sqlserver 2008 while using the sharepoint configuration wizard?

    In the error log I see the issue is the domain administrator account. I have used the domain administrator account to install sharepoint(csaha )to install sharepoint and I am using the same account to install sharepoint configuration wizard. Error: 'An exception of type System.Data.sqlclient.sqlexception was thrown. Additional  exception information:Login failed for user 'DEVWIN\csaha'.System.Data.SqlClient.SqlException:Login failed for user DEVWIN\csaha' So it looks like it errors out because configuration wizard does not register my credential. I will uninstall sharepoint tomorrow and start from beginning. Part of the informational log looks like it is accepting devwin\intranet admin to login to the the sqlserver 2008. Any thoughts. If I want to send you my error log how will I be able to do that? Does the application server need any sqlclient ?Thanks

    Monday, February 14, 2011 1:20 AM
  • Hi,

     

    I'm sure that list will help:

    Don't use a domain administrator account to install MOSS. Create a single user account in your domain and register it as administrator in administrators group in MOSS Server. In addition, you should register the account in IIS_WPG group in the same server.

    Register the account created below in the SQL Server Management Studio as System Admin. I recommend  to register this user as a administrator in SQL local machine just for the time of install process.

    Configure a database alias on the MOSS Server (start>run>cliconfg)

    Log in on the MOSS Server with the user created to install the product.

     

    Let me know if it helps.

     

    Best Regards


    Omar Matamoros - SharePoint Specialist
    Monday, February 14, 2011 5:01 AM
  • There is some progress, but this is what I have done following your instructions. I am trying to build a small farm where I have a sqlserver and a application/webserver and they are both connected to domain. I have created a local user in devwinapp3(mossserver 2007) IntranetAdmin which also belongs to the administrators group. I have also added IIS_WPG group to IntranetAdmin. So IntranetAdmin is a member of Adminstrators and IIS_WPG group.

    In sqlserver 2008, I have created a login for IntranetAdmin which has also sysadmin privileges. I have also created a user IntranetAdmin which belongs to Administrators group.

    Also created database alias MSSQLSERVER (Named Pipe). I installed sharepoint and configuration using the user IntranetAdmin. I did not create domain account on the AD server. Is this right? I am attaching the log message. Do I have to create the database in the sqlserver before running the configuration wizard. It will not let me proceed after I have entered the server name and the credentials. Do I need any sqlclient on the application server to connect to the database server? I can also telnet from DEVWINAPP3 to SQLSERVER

    2/14/2011 12:06:07  1  ERR                                                                                                                        An exception of type System.Data.SqlClient.SqlException was thrown.  Additional exception information: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
    System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
       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.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
       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.SharePoint.PostSetupConfiguration.SqlSession.OpenConnection()
       at Microsoft.SharePoint.PostSetupConfiguration.SqlSession.ExecuteNonQuery(SqlCommand command)
       at Microsoft.SharePoint.PostSetupConfiguration.SqlServerHelper.DatabaseExists(String database)
       at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureDatabase(Parameter parameterDatabase)
    02/14/2011 12:06:07  1  INF                                                                                                                        Entering function StringResourceManager.GetResourceString
    02/14/2011 12:06:07  1  INF                                                                                                                          Resource id to be retrieved is SqlServerOrDatabaseConnectionFailure for language English (United States)
    02/14/2011 12:06:07  1  INF                                                                                                                          Resource retrieved id SqlServerOrDatabaseConnectionFailure is Failed to connect to the {0} or the {1} does not exist.  Ensure the {2} exists, is a Sql server, and that you have the appropriate permissions to access the {3}.  To diagnose the problem, review the extended error information located at {4}.  Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access.
    02/14/2011 12:06:07  1  INF                                                                                                                        Leaving function StringResourceManager.GetResourceString
    02/14/2011 12:06:07  1  ERR                                                                                                                        Task configdb validation threw an exception
    02/14/2011 12:06:07  1  INF                                                                                                                        Entering function Common.BuildExceptionInformation
    02/14/2011 12:06:07  1  INF                                                                                                                          Entering function Common.BuildExceptionMessage
    02/14/2011 12:06:07  1  INF                                                                                                                            Entering function StringResourceManager.GetResourceString
    02/14/2011 12:06:07  1  INF                                                                                                                              Resource id to be retrieved is ExceptionInfo for language English (United States)
    02/14/2011 12:06:07  1  INF                                                                                                                              Resource retrieved id ExceptionInfo is An exception of type {0} was thrown.  Additional exception information: {1}
    02/14/2011 12:06:07  1  INF                                                                                                                            Leaving function StringResourceManager.GetResourceString
    02/14/2011 12:06:07  1  INF                                                                                                                          Leaving function Common.BuildExceptionMessage
    02/14/2011 12:06:07  1  INF                                                                                                                        Leaving function Common.BuildExceptionInformation
    02/14/2011 12:06:07  1  ERR                                                                                                                        An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown.  Additional exception information: Failed to connect to the database server or the database name does not exist.  Ensure the database server exists, is a Sql server, and that you have the appropriate permissions to access the database server.  To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_2_14_2011_11_23_58_63_2136208686.log.  Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access.
    Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException: Exception of type 'Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException' was thrown.
       at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureDatabase(Parameter parameterDatabase)
       at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureConfigurationDatabaseConnection()
       at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Validate(Int32 nextExecutionOrder)
       at Microsoft.SharePoint.PostSetupConfiguration.TasksQueue.Validate(Boolean useDefaultExecutionOrder)
    02/14/2011 12:06:07  1  ERR                                                                                                                        A PostSetupConfigurationTaskException was thrown: Failed to connect to the database server or the database name does not exist.  Ensure the database server exists, is a Sql server, and that you have the appropriate permissions to access the database server.  To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_2_14_2011_11_23_58_63_2136208686.log.  Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access.
    02/14/2011 12:06:07  1  INF                                                                                                                        Entering function Common.BuildExceptionInformation
    02/14/2011 12:06:07  1  INF                                                                                                                          Entering function Common.BuildExceptionMessage
    02/14/2011 12:06:07  1  INF                                                                                                                            Entering function StringResourceManager.GetResourceString
    02/14/2011 12:06:07  1  INF                                                                                                                              Resource id to be retrieved is ExceptionInfo for language English (United States)
    02/14/2011 12:06:07  1  INF                                                                                                                              Resource retrieved id ExceptionInfo is An exception of type {0} was thrown.  Additional exception information: {1}
    02/14/2011 12:06:07  1  INF                                                                                                                            Leaving function StringResourceManager.GetResourceString
    02/14/2011 12:06:07  1  INF                                                                                                                          Leaving function Common.BuildExceptionMessage
    02/14/2011 12:06:07  1  INF                                                                                                                        Leaving function Common.BuildExceptionInformation
    02/14/2011 12:06:07  1  ERR                                                                                                                        An exception of type Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException was thrown.  Additional exception information: Failed to connect to the database server or the database name does not exist.  Ensure the database server exists, is a Sql server, and that you have the appropriate permissions to access the database server.  To diagnose the problem, review the extended error information located at C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\LOGS\PSCDiagnostics_2_14_2011_11_23_58_63_2136208686.log.  Please consult the SharePoint Products and Technologies Configuration Wizard help for additional information regarding database server security configuration and network access.
    Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException: Exception of type 'Microsoft.SharePoint.PostSetupConfiguration.PostSetupConfigurationTaskException' was thrown.
       at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureDatabase(Parameter parameterDatabase)
       at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.EnsureConfigurationDatabaseConnection()
       at Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Validate(Int32 nextExecutionOrder)
       at Microsoft.SharePoint.PostSetupConfiguration.TasksQueue.Validate(Boolean useDefaultExecutionOrder)
       at Microsoft.SharePoint.PostSetupConfiguration.PsconfigBaseForm.ValidateConfigurationData()
       at Microsoft.SharePoint.PostSetupConfiguration.PsconfigBaseForm.TryValidateConfigurationData()
    02/14/2011 12:06:07  1  INF                                                                                                                        Entering function PsconfigMessageBox.ShowMessageBox
    02/14/2011 12:06:07  1  INF                                                                                                                        Leaving function PsconfigMessageBox.ShowMessageBox
    02/14/2011 12:06:07  1  INF                                                                                                                        Entering function StringResourceManager.GetResourceString
    02/14/2011 12:06:07  1  INF                                                                                                                          Resource id to be retrieved is Branding for language English (United States)
    02/14/2011 12:06:07  1  INF                                                                                                                          Resource retrieved id Branding is SharePoint Products and Technologies Configuration Wizard
    02/14/2011 12:06:07  1  INF                                                                                                                        Leaving function StringResourceManager.GetResourceString

     

     



     

     

    Monday, February 14, 2011 5:10 PM
  • I think you would be better off requesting a domain account as opposed to a local admin account on the SharePoint server. Make sure this domain account is a part of the local admin group on both SQL as well as SharePoint servers.

    Looking at the event viewer message, it looks like you alias is not able to find the instance. Can you confirm the SQL browser service is running on the SQL server? Also, is this the default instance of SQL server or a named instance and which port is this running on?

    • Marked as answer by David HM Friday, February 18, 2011 2:42 AM
    Thursday, February 17, 2011 4:48 PM
  • Yes, this issue has been resolved. All I needed was a domain account in the sqlserver and have windows authentication. Thank you.
    Friday, February 18, 2011 9:05 PM