MIgration of MS Performance Point objects to Sharepoint 2010

Greetings from the UK, can anyone give me a steer with an issue I have in trying to follow the MSDN blog

Upgrading PerformancePoint Server 2007 to PPS 2010

http://blogs.msdn.com/b/performancepoint/archive/2010/02/25/upgrading-performancepoint-server-2007-to-pps-2010.aspx
 
when I get to the "connect to performancepoint 2007 content database" my database is not in the dropdown list. The account credentials I am using in the wizard either through windows or SQL server authentification has permisions to view and edit the DB directly in SQL server but my DB (PPSMonitoring) is not in the dropdown list of available DBs whilst lots of others are from teh same SQL server..
 
Do I need to run a special script file or need any particular permisions to enable me to see my content DB?
 
Running Sharepoint 2010 Enterprise on one box with SQL 2008 r2 on another.

This Q has been posted to technet for 2 weeks without response.
 

TIA
Grid_HeadAsked:
Who is Participating?
 
Rainer JeschorCommented:
Hi,
I have tried it on my test environment (just starting the wizard) and you are right, the call is impersonate running a simple
Select name FROM sys.sysdatabases where sid != 0x01 ORDER BY name

Open in new window


Could you try to run the same utilizing SQL Management studio with the account you want to configure?

HTH
Rainer
0
 
Rainer JeschorCommented:
Hi,
I have not done this before (PPS Migration), but could you verify that the account of the IIS application pool who runs the central administration has access to that database?
I assume that the migration wizard would not impersonate the call.
To check you might also use SQL Server Profiler to get all the SQL commands against your SQL server, hence you should see the credentials of that connection.

HTH
Rainer
0
 
Grid_HeadAuthor Commented:
Rainer, thank for the response.

I dont think this is an impersonation issue as the wizard specifically asks for the credentials you wish to use to access the SQL server and using either windows credentials or SQL server logins that can see the DB when connected through SQL management console do not result in the DB appearing in the dropdown list yet other DBs from the server do appear.

I will try the profiler and see what I get

Regards

Kevin
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Grid_HeadAuthor Commented:
Rainer, if I log onto the domain using the credentials used by central admin and open SQL management studio again using windows credentials I can see the Db and drill to tables and down to rows.

However if still logged on as the central admin account I try the PPS migration utility and specify windows credentials of the central admin account I still cannot see the DB in the drop down list.

regards
0
 
Grid_HeadAuthor Commented:
Rainer - I have resolved the issue by using the SQL profiler but not, as suggested, for the identity being used but to find the query being used by the wizard and I confirmed the query that was being used as:

"select select Name from sys.sysdatabases
 where sid != 0x01 Order By Name"
 
On checking the sid of my PPSMonitoring DB in master it was 0x01 so was not being picked up.
 
I ran sp_changedbowner to change the sid of PPSMonitoring away from 0x01, and the db is now in my list and I have imported the objects into a 2010 doc library.
 
Regards
 
Kevin
0
 
Grid_HeadAuthor Commented:
Without rainers help i would still be looking for a solution..
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.