Solved

How to change project server database?

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

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.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

810 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