Upgrading project Server 2003 DB from SQL 2000 to Sql 2005

[Talyor]

The DBA's at my office have upgraded from SQL2000 to SQL 2005. We are now
about to upgrade the Project Server 2003 DB from 2000 to 2005. I am trying
to figure out what connections or files need to be updated on the Project
server to be able to communicate with the upgraded DB.

The DB is being moved to a new server with a new name as well.

I have found conninfo.exe which I am believing will help. Anyone have any
suggestions or articles they could share.

 

[projectserverdragon]

You will also need the use the edit site tool so you can allow your virtual
directory (defalt = ProjectServer) to speak with the database
1. Define your database partition
2. define the new DB server
3. define the new database name
4. Define your 2 service account profiles
A. msprojectuser -- service account used to let the MS Project client
talk to the database.
B. msprojectserveruser -- service account used to let PWA talk to the
database


The conninfo tool is only for defining service accounts for WSS and the OLAP
Cube

Good luck.

 

[Talyor]

Thanks for the info.

After a meeting this morning there is an update.

The DB name is staying the same and is just being upgraded and moved to a
new server. So the database is staying the same, just being upgraded and
moved to a new server.

 

[projectserverdragon]

still need to get the new DB servername in there

Thanks for the info.

After a meeting this morning there is an update.

The DB name is staying the same and is just being upgraded and moved to a
new server. So the database is staying the same, just being upgraded and
moved to a new server.

 

[John Foster]

You may want to look into some pitfalls related to the versioning of the database on 2k5. I have read that there are some compatibility problems in this scenario.

They can be mitigated by setting the compatibility of the database on SQL2k5 to SQL2k.

 

[Noynoy]

Hi All,

We are also planning to upgrade our DBs for Project Server (ProjectSErver)
and WSS (WSSContent) from SQL 2000 and SQL 2005. Any recommendations or best
approach to perform this upgrade?

thanks in advance.

best rgds,

Noynoy

 

[Stephen Sanderlin]

At a minimum, you need to:

1. Set the DB Compatibility Level to 80.

2. Install WSS (or SPS) SP2.

3. Install PS03 SP2a.



You will also need to go through a not insignificant amount of work to
get the Cube Build to work.



I would seriously consider installing PS03 and WSS (or SPS) SP3. While
I'm not sure about WSS (or SPS) SP3, I know for sure that PS03 SP3
contains numerous SQL2005-related fixes.



As always, you should perform the changeover in a dev environment prior
to implementing in production.

--

Stephen Sanderlin

Principal Consultant

MSProjectExperts



For Project Server Consulting: http://www.msprojectexperts.com

For Project Server Training: http://www.projectservertraining.com



Read my blog at: http://www.projectserverhelp.com/

Join the community at: http://forums.epmfaq.com