Solved

500 Points --- Sharepoint Database Connection

Posted on 2004-07-31
2
284 Views
Last Modified: 2010-04-19
Hi,

I want to disconnect and reconnect the Sharepoint with the SQL Server. Infact, want to disconnect from the local Sql Server and reconnect to a remote SQL Server. How can I do it?

As the question is urgent.. I am issuing 500 globes for it...

Thanks,

Khurram.
0
Comment
Question by:khurram007
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 8

Accepted Solution

by:
jodypeet earned 500 total points
ID: 11683761
I would try this .
if you want to preserve the current data.
backup the sql database using the maintenance task in sql. then restore that backup to the new sql server.
if you simply want to change sharepoint .
On the Server Administration page, under Virtual Servers, click Administration  next to the virtual server you want to modify.
Under Administration, click Change database connection.
Do one of the following:   To specify the SQL Server database to use  
In the Database server name box, type the server name that the SQL Server database is on.
In the Database name box, type the name to use for the database, if necessary.
In the Database administrator user name box, type the administrator name for the database.
In the Database administrator password box, type the administrator password.
0
 
LVL 2

Author Comment

by:khurram007
ID: 11687512
Well,

I have already tried this and it wasn't disconnecting due to some errors... i went before them and found that there was error in SQL Server name_collisions... So according to MS I have to reinstall it. So I have done it and its fine now...

As your suggesion was in the right direction, I am issuing you the points...

Cheers...

Khurram.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Setting up a Microsoft WSUS update system is free relatively speaking if you have hard disk space and processor capacity.   However, WSUS can be a blessing and a curse. For example, there is nothing worse than approving updates and they just have…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

630 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question