Solved

500 Points --- Sharepoint Database Connection

Posted on 2004-07-31
2
282 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 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

680 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