我可以检查哪个数据库正在运行 WSS 3.0 站点的配置和内容吗?

发布于 2024-10-08 03:05:59 字数 222 浏览 1 评论 0原文

问题是我可以完全访问托管 Sharepoint 站点的服务器等,但是我所做的只是维护该站点。我没有设置它。

现在存在 Sharepoint 无法连接到配置或内容数据库的问题。我不知道我们的哪些服务器运行这些,所以我是否可以找到,也许从配置文件或任何我需要检查的服务器/数据库。

网络服务器上的其他网站仍然运行良好,我知道数据库不在同一台服务器上,因为我已经检查过了。

有什么想法吗?

The problem is I have full access to the server where the Sharepoint site is hosted etc, however all i've ever done is maintained the site. I didn't set it up.

There is now an issue where Sharepoint can't connect to the Config or Content databases. I don't know which of our servers run these, so is there anyway I can find out, maybe from a config file or anything which server/database I need to check.

Other websites on the web server are still running fine, I know the database isn't on that same server because i've checked.

Any ideas?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

小梨窩很甜 2024-10-15 03:05:59

我通常发现最简单的方法是查看管理中心中的网站集设置(如果您对运行 WSS 3.0 的服务器具有 root 访问权限,则应该能够访问该设置)。

以下步骤:

  • 在管理中心网站中执行 进入应用程序管理
  • 进入内容数据库
  • 使用页面主要内容右上角的橙色选择器选择您的 Web 应用程序
  • 单击显示的数据库名称

到达最后一点后,您应该会在顶部看到以下信息: 数据库服务器SQL Server 数据库名称。希望这能为您指明数据库存储位置的正确方向。

如果您对数据库内容数据库的访问由于 SQL 服务器的登录详细信息不正确(即 SA 帐户的密码已更改)而被切断,则也可以在此处更新所选内容数据库的 SQL 凭据。

希望这有帮助。

I normally find the easiest way is to look at the site collections settings in Central Administration (which you should be able to access if you have root access to the server WSS 3.0 runs on)

Take the following steps once in the Central Administration site:

  • Go into Application Management
  • Go into Content Databases
  • Select your web application using the selector which is orange in the top right of the main content of the page
  • Click the name of the database displayed

Once you are at the final point you should see at the top information for Database Server and SQL Server Database Name. Hopefully this should point you in the right direction of where your database is being stored.

If your access to the database content database is cut due to incorrect login details to the SQL server (i.e. the SA account's password has changed), the SQL credentials can be updated here too for the selected content database.

Hope this helps.

彼岸花似海 2024-10-15 03:05:59

查看事件查看器日志。会有一个类似这样的条目:

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database 
Event ID: 3760
Date:  4/16/2009
Time:  11:51:07 AM
User:  N/A
Computer: IMIAPP03
Description:
SQL database  **'STS_Config'** on SQL Server instance 'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query' not found. Additional error  information from SQL Server is included below.

Cannot open database "STS_Config" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Check out the Event Viewer Log. There would be an entry similar like this:

Event Type: Error
Event Source: Windows SharePoint Services 3
Event Category: Database 
Event ID: 3760
Date:  4/16/2009
Time:  11:51:07 AM
User:  N/A
Computer: IMIAPP03
Description:
SQL database  **'STS_Config'** on SQL Server instance 'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query' not found. Additional error  information from SQL Server is included below.

Cannot open database "STS_Config" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文