积极答复者
WSS3.0配置失败,提示无法连接数据库

问题
-
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
答案
全部回复
-
检查下防火墙, 开放1433端口(默认SQL ServerTCP端口),然后再试一下.一般都是这个问题.
还有就是在SQL Server2005 外围应用配置器(Surface Area Configuration)管理工具中,允许SQL Server使用远程连接.
一般都是这个两个问题.
如果用SQL Server 2008,就没有Surface Area Configuration,自己找下文章开启远程连接把,忘记什么地方了,手头上也没有08,看不了.
-lambert上善若水中文Blog: SharePoint in My Eyes -
顺便说一句,这个不是开发问题,应该发到http://social.microsoft.com/Forums/zh-CN/sharepointportalserverzhchs/threads/
估计回的人会多些, 当然,要是你有一定英文水平,推荐到英文论坛去问 :)
-lambert上善若水中文Blog: SharePoint in My Eyes -
检查下防火墙, 开放1433端口(默认SQL ServerTCP端口),然后再试一下.一般都是这个问题.
还有就是在SQL Server2005 外围应用配置器(Surface Area Configuration)管理工具中,允许SQL Server使用远程连接.
一般都是这个两个问题.
如果用SQL Server 2008,就没有Surface Area Configuration,自己找下文章开启远程连接把,忘记什么地方了,手头上也没有08,看不了.
-lambert
上善若水中文Blog: SharePoint in My Eyes
用SQL2005ExpressAdv不行啊,为什么?
我配置WSS时,选新建数据库,填localhost,之后检查失败
SQL那里我已经允许了以IP或者命名管道访问了,SQL Browser也开了
只是我这台机器没入域,但我SQL和WSS都在同一台机器上啊,1433也开了...