Project Server 2003 Change database and connection information

All replies

• 

  

  0

  Sign in to vote

  Hello,

  You can do this with the edit site tool. See the following Kb for full details:

  http://support.microsoft.com/kb/905386

  Paul

  ---

  Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

  Sunday, March 16, 2014 9:30 PM
• 

  

  0

  Sign in to vote

  Thanks a lot Paul for your response. Perhaps I could not explain my question properly. I want to change to a differenr projectserver database on the same sql server to associate the project server to different data. Can I change information on  CONNINFO.EXE modifying the database name and accounts for projectserver and project user. Will it have any impact of the structure.

  Sunday, March 16, 2014 11:37 PM
• 

  

  1

  Sign in to vote

  Hello, you can use the edit site tool to point to a different project server database on the same SQL server. Paul

  ---

  Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

  • Proposed as answer by Hrishi.Deshpande Monday, March 17, 2014 4:10 PM

  Monday, March 17, 2014 7:11 AM
• 

  

  0

  Sign in to vote

  Your suggestions are very helpful Pual in our upgrade process. we used this tool to change the database. What is the place in Project Server 2003 to know which database it is connected to and whether our change worked. We are still not getting the data.

  Tuesday, March 18, 2014 1:17 AM
• 

  

  0

  Sign in to vote

  Edit site is also the tool to use to check your project server 2003 instance is using the correct database. Use the test connection to ensure you can connect to the Database. Paul

  ---

  Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

  Tuesday, March 18, 2014 7:40 AM
• 

  

  0

  Sign in to vote

  Thanks. With the link you provided Edit tool for 2002 was downloaded. Is there some separate tool for Project server 2003.

  Tuesday, March 18, 2014 11:21 AM
• 

  

  0

  Sign in to vote

  Try this link:

  http://www.microsoft.com/en-us/download/details.aspx?id=4584

  Paul

  ---

  Paul Mather | Twitter | http://pwmather.wordpress.com | CPS

  • Marked as answer by geeam Wednesday, March 19, 2014 8:08 AM

  Tuesday, March 18, 2014 11:23 AM