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
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
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Without rainers help i would still be looking for a solution..
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