Solved

How to change project server database?

Posted on 2006-10-26
3
422 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Easy Project Management (No User Manual Required)

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MS Project Professional 2010 5 384
Microsoft Project 2010 issue 3 302
Issue management 3 87
SharePoint 2013 for Task Tracking 5 47
Re-planning is just as important as planning. MS Project files need to be updated regularly to reflect the current status of the project and to streamline the upcoming tasks. We have seen a lot of issues where project managers have not updated the p…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

762 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now