Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

500 Points --- Sharepoint Database Connection

Posted on 2004-07-31
2
Medium Priority
?
291 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
2 Comments
 
LVL 8

Accepted Solution

by:
jodypeet earned 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The HP utility "HP Lights-Out Online Configuration Utility for Windows Server 2003/2008" could be of great use when it comes to remotely configure a HP servers ILO WITHOUT rebooting the server. We would only need to create and run scripts using thi…
On July 14th 2015, Windows Server 2003 will become End of Support, leaving hundreds of thousands of servers around the world that still run this 12 year old operating system vulnerable and potentially out of compliance in many organisations around t…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

926 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