Archive for June 14th, 2012
Unexpected Error has occurred. Error is ‘SetParent failed for Database ‘AR633564737049916886′.’
When I was installing the Application Definition Designer, I have got the following wired error message! 😦
The text format of this error message is:
Unexpected Error has occurred. Error is 'SetParent failed for Database 'AR633564737049916886'.' --> SetParent failed for Database '<em>AR633564737049916886'.' --> Failed to connect to server. \BDC. --> An error has occurred while establishing a connection to the server. When connecting to SQL Server..
This is not even a brief message to understand no? After spending few minutes, I have found the possible causes for this error.
1. Not enough permissions to configure BDC (Business Data Catalog) instance
2. There is no BDC instance on our SQL Server, this means the installation expects the BDC instance to continue.
In my case, I have adequate permissions for BDC, so the problem is 2nd one. If we run the BDCStudioSetup.msi file directly, Instead of running the setup.exe on the “BDC Definition Editor” directory then we get this error! 😦
You can see the complete installation and configuration of Application Definition Designer here.
Happy configuring..! Thanks. R./
Installing and configuring the “Application Definition Designer” tool – BDC
Everyone knows about the usage of Application Definition Designer, this is a Microsoft tool that comes with the SharePoint Server SDK. You can see the overview and the system requirements here. While installing this tool I have faced few problems, so I just wanted to keep the steps in my bolg.
Step 1: Download the tool and double click the “OfficeServerSDK.exe”, You will be getting this screen.
Step 2: Click Next 😦
Step 3: The Office SharePoint Server 2007 SDK has been successfully installed. Great!
Step 4: Navigate to SDK installation path\Tools\BDC Definition Editor\. The default installation path for the MOSS SDK is <%Program Files%>\2007 Office System Developer Resources\. For me this is the path..
C:\Program Files \2007 Office System Developer Resources\Tools\BDC Definition Editor
Step 5: In this directory, double click the setup.exe
Please Note: If you double click the BDCStudioSetup.msi file directly, Instead of clicking setup.exe then you will get this error. This happened to me when I installed! 🙂
Step 6: Click Accept and continue, this will configure the SQL client.
Step 7: Click Next and close! 🙂
Step 8: That’s all, you can run the “ApplicationDefinitionDesigner.exe” in the “All Programs”
Step 9: We are ready to create the ADF (Application Definition File) to configure the BDC (Business Data Catalog) now.