Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 487
  • Last Modified:

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
0
Grid_Head
Asked:
Grid_Head
  • 4
  • 2
2 Solutions
 
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
 
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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now