How to change project server database?

Posted on 2006-10-26
Medium Priority
Last Modified: 2013-11-15

Hi experts,

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


Question by:aavila33
  • 2
LVL 10

Accepted Solution

winzig earned 2000 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


Author Comment

ID: 17819191

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.

LVL 10

Expert Comment

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

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

622 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