Solved

How to change project server database?

Posted on 2006-10-26
3
465 Views
Last Modified: 2013-11-15

Hi experts,

I need to change the database of SQL, that the Project Server 2003 use, that is possible?




Thanks,
Antonio.



0
Comment
Question by:aavila33
[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
3 Comments
 
LVL 10

Accepted Solution

by:
winzig earned 500 total points
ID: 17815545
Backup DB and restore the database on another server.

Create 2 users with SQL authentication  for exampple
ServerUser - in tab database acces click to ProjectServer DB and inPermit in database role select  MSProjectServerRole
DesktopUser-  in tab database acces click to ProjectServer DB and inPermit in database role select  MSProjectRole

On server or servers where is installed Project Webb acces run
C:\Program Files\Microsoft Office Project Server 2003\BIN\1033\CONNINFO.EXE
C:\Program Files\Microsoft Office Project Server 2003\BIN\1029\CONNINFO.EXE (number depends on your language)

and enter there Db Server name, Database name and User which was created in previous step and then click to Save

0
 

Author Comment

by:aavila33
ID: 17819191
Hi,

I mde a backup, but when I try to restore in the new server I recive and error, after that, I tried to migrate the information useing the tool DTSWizard. In this way I can migrate the DB, and the tool work did not mark any error, but now I cann't see my viwers?. How can I check that?

The server 1 has SQL 2000 and the new server has 2005.


 
0
 
LVL 10

Expert Comment

by:winzig
ID: 17820542
backup database http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx#EAMAC
restore database http://www.microsoft.com/technet/community/events/sql2005/sql-02.mspx

in case that you aren't able migrate DB you should open new question in SQL server forum
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

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