Solved

How to change project server database?

Posted on 2006-10-26
3
450 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
  • 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
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.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

828 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