none
WSS3.0配置失败,提示无法连接数据库 RRS feed

  • 问题

  • WSS3.0安装完成后,进行配置,配置过程中提示连接数据库失败,日志内容如下,WSS和数据库服务器均为子域,配置时连接到数据库使用的用户名已赋予数据库管理员权限。
    02/19/2009 13:00:42  8  INF                        friendlyMessage for task configdb is 已引发类型为 Microsoft.SharePoint.SPException 的异常。其他异常信息: 无法连接到数据库。请检查数据库连接信息,并确保数据库服务器正在运行。
    02/19/2009 13:00:42  8  INF                        debugMessage for task configdb is 已引发类型为 Microsoft.SharePoint.SPException 的异常。其他异常信息: 无法连接到数据库。请检查数据库连接信息,并确保数据库服务器正在运行。
    Microsoft.SharePoint.SPException: 无法连接到数据库。请检查数据库连接信息,并确保数据库服务器正在运行。 ---> System.Runtime.InteropServices.COMException (0x81020024): 无法连接到数据库。请检查数据库连接信息,并确保数据库服务器正在运行。
       在 Microsoft.SharePoint.Library.SPRequestInternalClass.CreateSite(Guid gApplicationId, String bstrUrl, Int32 lZone, Guid gSiteId, Guid gDatabaseId, String bstrDatabaseServer, String bstrDatabaseName, String bstrDatabaseUsername, String bstrDatabasePassword, String bstrTitle, String bstrDescription, UInt32 nLCID, String bstrWebTemplate, String bstrOwnerLogin, String bstrOwnerName, String bstrOwnerEmail, String bstrSecondaryContactLogin, String bstrSecondaryContactName, String bstrSecondaryContactEmail, Boolean bADAccountMode, Boolean bHostHeaderIsSiteName)
       在 Microsoft.SharePoint.Library.SPRequest.CreateSite(Guid gApplicationId, String bstrUrl, Int32 lZone, Guid gSiteId, Guid gDatabaseId, String bstrDatabaseServer, String bstrDatabaseName, String bstrDatabaseUsername, String bstrDatabasePassword, String bstrTitle, String bstrDescription, UInt32 nLCID, String bstrWebTemplate, String bstrOwnerLogin, String bstrOwnerName, String bstrOwnerEmail, String bstrSecondaryContactLogin, String bstrSecondaryContactName, String bstrSecondaryContactEmail, Boolean bADAccountMode, Boolean bHostHeaderIsSiteName)
       --- 内部异常堆栈跟踪的结尾 ---
       在 Microsoft.SharePoint.Library.SPRequest.CreateSite(Guid gApplicationId, String bstrUrl, Int32 lZone, Guid gSiteId, Guid gDatabaseId, String bstrDatabaseServer, String bstrDatabaseName, String bstrDatabaseUsername, String bstrDatabasePassword, String bstrTitle, String bstrDescription, UInt32 nLCID, String bstrWebTemplate, String bstrOwnerLogin, String bstrOwnerName, String bstrOwnerEmail, String bstrSecondaryContactLogin, String bstrSecondaryContactName, String bstrSecondaryContactEmail, Boolean bADAccountMode, Boolean bHostHeaderIsSiteName)
       在 Microsoft.SharePoint.Administration.SPSiteCollection.Add(SPContentDatabase database, String siteUrl, String title, String description, UInt32 nLCID, String webTemplate, String ownerLogin, String ownerName, String ownerEmail, String secondaryContactLogin, String secondaryContactName, String secondaryContactEmail, String quotaTemplate, String sscRootWebUrl, Boolean useHostHeaderAsSiteName)
       在 Microsoft.SharePoint.Administration.SPSiteCollection.Add(String siteUrl, String title, String description, UInt32 nLCID, String webTemplate, String ownerLogin, String ownerName, String ownerEmail, String secondaryContactLogin, String secondaryContactName, String secondaryContactEmail, Boolean useHostHeaderAsSiteName)
       在 Microsoft.SharePoint.Administration.SPSiteCollection.Add(String siteUrl, String title, String description, UInt32 nLCID, String webTemplate, String ownerLogin, String ownerName, String ownerEmail, String secondaryContactLogin, String secondaryContactName, String secondaryContactEmail)
       在 Microsoft.SharePoint.Administration.SPAdministrationWebApplication.CreateDefaultInstance(SqlConnectionStringBuilder administrationContentDatabase, SPWebService adminService, IdentityType identityType, String farmUser, SecureString farmPassword)
       在 Microsoft.SharePoint.Administration.SPFarm.CreateAdministrationWebService(SqlConnectionStringBuilder administrationContentDatabase, IdentityType identityType, String farmUser, SecureString farmPassword)
       在 Microsoft.SharePoint.Administration.SPFarm.CreateBasicServices(SqlConnectionStringBuilder administrationContentDatabase, IdentityType identityType, String farmUser, SecureString farmPassword)
       在 Microsoft.SharePoint.Administration.SPFarm.Create(SqlConnectionStringBuilder configurationDatabase, SqlConnectionStringBuilder administrationContentDatabase, IdentityType identityType, String farmUser, SecureString farmPassword)
       在 Microsoft.SharePoint.Administration.SPFarm.Create(SqlConnectionStringBuilder configurationDatabase, SqlConnectionStringBuilder administrationContentDatabase, String farmUser, SecureString farmPassword)
       在 Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.CreateOrConnectConfigDb()
       在 Microsoft.SharePoint.PostSetupConfiguration.ConfigurationDatabaseTask.Run()
       在 Microsoft.SharePoint.PostSetupConfiguration.TaskThread.ExecuteTask()
    02/19/2009 13:00:42  8  INF                        Entering function TaskBase.FireTaskStateChanged
    02/19/2009 13:00:42  8  INF                          Firing the OnTaskStateChanged event for task configdb
    02/19/2009 13:00:42  8  INF                          Entering function TaskDriver.TaskStateEventHandler
    02/19/2009 13:00:42  8  INF                            Entering function StringResourceManager.GetResourceString
    02/19/2009 13:00:42  8  INF                              Resource id to be retrieved is ConfigurationDatabaseTaskDisplayName for language Chinese (People's Republic of China)
    02/19/2009 13:00:42  8  INF                              Resource retrieved id ConfigurationDatabaseTaskDisplayName is 配置数据库
    02/19/2009 13:00:42  8  INF                            Leaving function StringResourceManager.GetResourceString
    02/19/2009 13:00:42  8  INF                            Received an TaskStateEventHandler event.  task:configdb TaskBase.State:stopped
    02/19/2009 13:00:42  8  INF                            Entering function TasksQueue.IncrementTaskFailed
    02/19/2009 13:00:42  8  INF                              Incremented the number of tasks failed to 1
    02/19/2009 13:00:42  8  INF                            Leaving function TasksQueue.IncrementTaskFailed
    02/19/2009 13:00:42  8  INF                            Task configdb has stopped and failed.  Total failed is now 1
    02/19/2009 13:00:42  8  INF                          Leaving function TaskDriver.TaskStateEventHandler
    02/19/2009 13:00:42  8  INF                          Entering function PsconfigBaseForm.TaskStateEventHandler
    02/19/2009 13:00:42  8  INF                            Invoking the UI thread with the task state chagne event
    02/19/2009 13:00:42  1  INF                            Entering function ConfigurationProgressForm.InvokeTaskStateEventHandler
    02/19/2009 13:00:42  1  INF                              Received an TaskStateEventHandler event.  task:configdb TaskBase.State:stopped TaskBase.TaskResultconfigdb
    02/19/2009 13:00:42  1  INF                              Acquiring the reader lock to retrieve the state
    02/19/2009 13:00:42  1  INF                              Releasing the reader lock to retrieve the state
    02/19/2009 13:00:42  1  INF                              Acquiring the reader lock to retrieve the state
    02/19/2009 13:00:42  1  INF                              Releasing the reader lock to retrieve the state
    02/19/2009 13:00:42  1  ERR                              Task configdb has stopped and failed.  Total failed is now 1
    02/19/2009 13:00:42  1  INF                              Entering function Command.this[string key]
    02/19/2009 13:00:42  1  INF                                Entering function CommandCollectionBase.Get
    02/19/2009 13:00:42  1  INF                                  Found value in collection for key disconnect
    02/19/2009 13:00:42  1  INF                                Leaving function CommandCollectionBase.Get
    02/19/2009 13:00:42  1  INF                                Found parameter disconnect in collection
    02/19/2009 13:00:42  1  INF                              Leaving function Command.this[string key]
    02/19/2009 13:00:42  1  INF                              Entering function Command.this[string key]
    02/19/2009 13:00:42  1  INF                                Entering function CommandCollectionBase.Get
    02/19/2009 13:00:42  1  INF                                  Found value in collection for key connect
    02/19/2009 13:00:42  1  INF                                Leaving function CommandCollectionBase.Get
    02/19/2009 13:00:42  1  INF                                Found parameter connect in collection
    02/19/2009 13:00:42  1  INF                              Leaving function Command.this[string key]
    02/19/2009 13:00:42  1  INF                              Entering function Command.this[string key]
    02/19/2009 13:00:42  1  INF                                Entering function CommandCollectionBase.Get
    02/19/2009 13:00:42  1  INF                                  Found value in collection for key create
    02/19/2009 13:00:42  1  INF                                Leaving function CommandCollectionBase.Get
    02/19/2009 13:00:42  1  INF                                Found parameter create in collection
    02/19/2009 13:00:42  1  INF                              Leaving function Command.this[string key]
    02/19/2009 13:00:42  1  INF                              Entering function StringResourceManager.GetResourceString
    02/19/2009 13:00:42  1  INF                                Resource id to be retrieved is ConfigurationDatabaseTaskCreateFailConfigDisplayLabel for language Chinese (People's Republic of China)
    02/19/2009 13:00:42  1  INF                                Resource retrieved id ConfigurationDatabaseTaskCreateFailConfigDisplayLabel is 未能创建配置数据库。
    02/19/2009 13:00:42  1  INF                              Leaving function StringResourceManager.GetResourceString
    02/19/2009 13:00:42  1  INF                              Updating the task label below the progress bar 未能创建配置数据库。
    02/19/2009 13:00:42  1  INF                              Entering function FormParameterCollection.Add
    02/19/2009 13:00:42  1  INF                              Leaving function FormParameterCollection.Add
    02/19/2009 13:00:42  1  INF                              Last message from task configdb is 已引发类型为 Microsoft.SharePoint.SPException 的异常。其他异常信息: 无法连接到数据库。请检查数据库连接信息,并确保数据库服务器正在运行。
    02/19/2009 13:00:42  1  INF                              Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:42  1  INF                              Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:42  1  INF                              Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:42  1  INF                              Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:42  1  INF                              Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:42  1  INF                              Updating the task additional notification information below the progress bar 已引发类型为 Microsoft.SharePoint.SPException 的异常。其他异常信息: 无法连接到数据库。请检查数据库连接信息,并确保数据库服务器正在运行。
    02/19/2009 13:00:43  1  INF                            Leaving function ConfigurationProgressForm.InvokeTaskStateEventHandler
    02/19/2009 13:00:43  8  INF                            Sleeping an extra 1000 ms so things don't go too fast for the user for this task
    02/19/2009 13:00:43  1  INF                            Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:43  1  INF                            Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:43  1  INF                            Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:43  1  INF                            Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:43  1  INF                            Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:43  1  INF                            Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:43  1  INF                            Not running in high contrast, so we will paint the background with our trademarked image
    02/19/2009 13:00:44  8  INF                          Leaving function PsconfigBaseForm.TaskStateEventHandler
    02/19/2009 13:00:44  8  INF                        Leaving function TaskBase.FireTaskStateChanged
    02/19/2009 13:00:44  8  INF                      Leaving function TaskBase.OnTaskStop
    s
    2009年2月20日 2:24

答案

  • 如果你是EXPRESS版本的SQL的话,我记得安装后默认是有实例名的,要指定实例名是EXPRESS的实例数据库,不然验证过不去的。
    • 已标记为答案 sss.shar 2009年4月29日 3:40
    2009年4月26日 15:50

全部回复

  • 检查下防火墙, 开放1433端口(默认SQL ServerTCP端口),然后再试一下.一般都是这个问题.

    还有就是在SQL Server2005 外围应用配置器(Surface Area Configuration)管理工具中,允许SQL Server使用远程连接.

    一般都是这个两个问题.

    如果用SQL Server 2008,就没有Surface Area Configuration,自己找下文章开启远程连接把,忘记什么地方了,手头上也没有08,看不了.


    -lambert
    上善若水
    2009年3月3日 14:20
  • 顺便说一句,这个不是开发问题,应该发到http://social.microsoft.com/Forums/zh-CN/sharepointportalserverzhchs/threads/

    估计回的人会多些, 当然,要是你有一定英文水平,推荐到英文论坛去问 :)

    -lambert


    上善若水
    2009年3月3日 14:25
  • 检查下防火墙, 开放1433端口(默认SQL ServerTCP端口),然后再试一下.一般都是这个问题.

    还有就是在SQL Server2005 外围应用配置器(Surface Area Configuration)管理工具中,允许SQL Server使用远程连接.

    一般都是这个两个问题.

    如果用SQL Server 2008,就没有Surface Area Configuration,自己找下文章开启远程连接把,忘记什么地方了,手头上也没有08,看不了.


    -lambert
    上善若水

    用SQL2005ExpressAdv不行啊,为什么?

    我配置WSS时,选新建数据库,填localhost,之后检查失败

    SQL那里我已经允许了以IP或者命名管道访问了,SQL Browser也开了

    只是我这台机器没入域,但我SQL和WSS都在同一台机器上啊,1433也开了...

    2009年4月11日 6:42
  • 如果你是EXPRESS版本的SQL的话,我记得安装后默认是有实例名的,要指定实例名是EXPRESS的实例数据库,不然验证过不去的。
    • 已标记为答案 sss.shar 2009年4月29日 3:40
    2009年4月26日 15:50