Project Server 2003 migration to ProjectServer 2007 error

Asked By catlin bred 60 points N/A Posted on - 08/15/2012

Hello TehyV buddies!

I am having some problem with project server. I have tried to import a project that I have created from project server 2003 to project server 2010. When I was about to use P12 an error suddenly pops out in a command prompt window. The error is this:

PWA Migration: Setup views to Project Server 2003 – Failed

Here are the log file details of this error:

Err1 = 37000 Err2 = [Microsoft][ODBC SQL Server Drive][SQL Server] could not find server ‘server name’ in sys.servers. Verify that the correct server name was specified. If necessary, execute the sp_addlinkedserver to add the server. Migration finished with an error return code 80004005. Running the –verify switch completed successfully but running the actual migration failed.

I think the problem is due to FQDN or DNS which is alias for SQL server in the P12 configuration. Can anyone help me solve this problem? I am troubled by the error prompted to me by this program. Thank you!

Status: Open
Question Views: 728
Answer Count: 1
Vote Up 0 Vote Down

Answer Accepted: No
Question Category: Microsoft Others

Answered By Carl Jack 10 points N/A #148379