数据库名称无效配置数据库 [英] Database name is not valid configuration database
问题描述
嗨
我的SQL服务器上有一个空间问题，它托管我的Sharepoint数据库并决定移动它到另一个驱动器，并在新驱动器上重命名我的新数据库，以便于识别。移动后，我的Sharepoint中心站点和我的网站拒绝打开。
我意识到Sharepoint未能看到我的农场。我决定重新运行Sharepoint产品配置向导以重新连接到我已移动的现有服务器场，并且出现错误 "的无法连接到位于指定的
数据库服务器和数据库名称的现有服务器场。数据库名称不是有效的配置数据库。"
我检查了我的用户配置文件权限，我的数据库在我的SQL服务器上联机
请协助解决问题所在？
提前致谢
Wisani
Wisani
< blockquote>
嗨Queelie，
在您的描述中，您说您更改了新的数据库名称，这可能是失败的原因，
所以再次重命名为旧的数据库名称然后再次尝试处理。
确保步骤：
- 在从SQL Server分离之前备份SQL数据库
- 通过正确断开现有连接从SQL服务器分离内容数据库
- 然后将MDF文件与LDF一起从源移动到目标
- 然后从新位置执行附加内容数据库
- 然后打开sharepoint Management shell并键入mount-spcontentdatabase -databasename -databseserver -webapplication
____________________________
Thivagar SEGAR
[如果回复对您有帮助，请不要忘记将其标记为答案或投票回复]
Hi
I had a space issue on my SQL server that hosts my Sharepoint database and decided to move it to another drive and also rename my new database on the new drive for easy recognition. After the movement my Sharepoint central site and my sites refused to open. I realised that Sharepoint was failing to see my farm. I decided to rerun Sharepoint products configuration wizard to reconnect to my existing farm that i have moved and i get an error of " Failed to connect to the existing farm located at the specified database server and database name. The database name is not a valid configuration database."
I have checked my user profile permissions and my database is online on my SQL server
Please assist on what the problem might be?
Thanks in advance
Wisani
Wisani
Hi Queelie,
In your description itself you said that you changed the new Database name, that might be the reason for failure,
so again rename to old database name and then try to process again.
Be sure with the steps :
- Take a backup of SQL Database before detach from SQL Server
- Detach content database from the SQL server by properly disconnecting the existing connection
- then move MDF file along with LDF from the source to destination
- then perform attach content database from the new location
- then open sharepoint Management shell and type mount-spcontentdatabase -databasename -databseserver -webapplication
____________________________
Thivagar SEGAR
[If the reply helps you, please don't forget mark it as answer or vote the reply ]
这篇关于数据库名称无效配置数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
