Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Problem opening a project in SSIS BIDS

Answered Problem opening a project in SSIS BIDS

  • Friday, February 15, 2013 2:51 PM
     
     
    Sign In to Vote
    0

    I am on BIDS 2008 on a W indows 2008 server. I have been working on BIDS 2008 for several days without problem. Now when open an existing project,  project does not fully open, most of the screen is blank.

    Looking aat Windows event log, I see following:

    The application-specific permission settings do not grant Local Launch permission for the COM Server application with CLSID

    {46063B1E-BE4A-4014-8755-5B377CD462FC}

    and APPID

    {FAAFC69C-F4ED-4CCA-8849-7B882279EDBE}

    to the user NA\admin_PMehrotr SID (S-1-5-21-1614895754-2146847981-1606980848-377533) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

    I serached google and verified all premissons are present.

    Apperciate any insght how to fix the problem.

    Where  are BIDS logs written which can provide more information. I need to get this problem resolved ASAP.

     

All Replies

  • Friday, February 15, 2013 3:12 PM
    Moderator
     
     
    Sign In to Vote
    1

    I believe this must fix the issue:

    1. Click Start -> Run -> Type -> dcomcnfg, expand Component Services -> Computers -> My Computer -> DCOM Config.
    2. Click View -> Detail -> Now you will get Application Name and Application ID in right side.
    3. Scroll down and find the application ID {FAAFC69C-F4ED-4CCA-8849-7B882279EDBE} -> Right Click -> Properties and select the Security tab.
    3. Click Customize under "Launch & Activation Permission" -> click Edit -> Add in the account NA\admin_PMehrotr and set local launch and local activation.
    4. Restart the application Service linked to this Application ID or restart the server and monitor

    Reference: TechNet thread http://bit.ly/WMN3t9

    Arthur My Blog

     
  • Friday, February 15, 2013 4:29 PM
     
     
    Sign In to Vote
    0

    Problem I have is once I grant an application ID above permssions, I reboot server, I logon, I get the same problem but application ID changes in the error message, so it is not working.

     
  • Friday, February 15, 2013 6:10 PM
    Moderator
     
     
    Sign In to Vote
    0

    This is ODD.Perhaps you need to review your account permissions with your admin.

    You appear to have fewer rights than a developer typically needs.

    I would also refrain from running BIDS (or any dev tools) on a Server OS.

    Arthur My Blog

     
  • Friday, February 15, 2013 7:38 PM
     
     
    Sign In to Vote
    0
    I am not 100% sure it is a security issue. I was trying BIDS on another machine. Things were working fine and then I makde copy of a package to make another package. When I tried to open new pacakage, it failed because i can understand; but then my original package also does not work. SOmehow package load i failing, but how  can UI dbeug what is cauaging package load to fail. Where are more detailed logs for bids are bing written.
     
  • Friday, February 15, 2013 9:44 PM
     
     Answered
    Sign In to Vote
    0
    Ny fluke I found the solution. Ib BIDS I open a project. It does not open the package. While project is open, I go and open a file and select Pacakage.dstx file for that roject; then things start working for that project.